The Payroll template for Excel tracks employee hours and calculates their pay based on the hours worked. The Payroll template for Excel is a Workbook which employee names are entered into one time only. Corresponding employee hourly rates can then be entered and their total hours worked for each day.
The Payroll template also has the option to add two different overtime rates and the hours after which these rates apply. All calculations are done automatically. Two different rates for both Saturday and Sunday may also be optionally entered. If your employees work Public holidays, there is another option for Public holiday rates.
Key Features of the Payroll template for Excel include:
Allows up to 50 employees.
Simple step-by-step instructions.
Specification of public holidays rates (optional).
Allows for 2 levels of overtime payments (optional).
Specification of Saturday and Sunday hourly pay as well as 2 levels of Saturday and Sunday overtime payments (optional).
Specification of public holiday hourly pay as well as 2 levels of public holiday overtime payments (optional).
Setting of pay period range from 1 day to 2 weeks.
Automatic pay calculations based on employee details entered.
Display of days, weekdays, Saturdays, Sundays and public holidays in pay period set.
Facility for 'Additional' pays each day.
Grand total of all pays for pay period.
Grand total of all hours for pay period.
Total pay by employee for pay period.
Total hours by employee for pay period.
The Payroll template for Excel contains no VBA at all as calculations are done via Worksheet Functions. This makes the Workbook extremely user friendly and data entry very simple. The Payroll template for Excel is also universal and can be used in any country.