Time and Wage
Template for Excel
Review
The Time and Wage
Workbook for Excel is a handy tool to help you track staff, workers
and employees hours and assist you in calculating their pay based on
the number of hours worked by each person.
This template is an
Excel Workbook which you input your employee names and hourly pay
data only one time. After that, all you need to enter is the
hours worked each day by each employee.
You can also add
overtime pay rates. You have the choice to build in 2
different overtime pay rates and the hours after which these rates
take effect. Every one of calculations are completed by the
program. In addition, you have the choice to add Saturday and
Sunday rates in the event they are different.
If your workers are
scheduled for Public holidays, you have the choice to set up rates
for holiday work days. Complete the information one time and all the
data is now saved in the Template.
Easy and Simple to
use.
- Input employee
data one time
- Determine a
pay period
- Input employee
hours worked each day
- Let the
program calculate the rest
The Time and Wage
Workbook contains NO VBA at all. All computations are completed
using the Worksheet functions. User friendly and simple to use.
The Workbook and
template is can be used for any country and pay rates.
Features
- Use for
up to 50 staff or
workers.
- Easy to configure and set up
nstructions.
- Options for
public holidays rates is available.
- Set for
two different
levels of overtime payments is available.
- Options for weekend
pay levels and
overtime payments is available.
- Permits
the choice for public holiday and or 2 separate overtime pay
levels.
- Pay periods
can be chosen from 1 day to 2 weeks.
- Automatic pay
computations determined by employee data inputted.
- View by
days, weekdays, Saturdays, Sundays and public holidays in pay
period chosen.
- Facility for "Additional"
pays each day.
- Determines
grand total of all pays and hours for each pay period.
- Calculates
total pay and total hours by employee for pay period.
|