After each step, the template will be updated. This way, all your previous master settings will be in use.
Each day of work has several columns. They are:
- Day - day of the week (e.g. Monday, Tuesdays etc.)
- Date - date (beginning with Pay Period Starting)
- Start - the time an employee starts the shift
- End - the time an employee ends the shift
- Time Break - the time (measured in hours) an employee is on a break (e.g. lunch break)
- Regular Hrs. - the amount of time spent working in a day. The template computes it as the duration of employee's shift minus Time Break.
- Overtime - the hours worked after the shift has ended
- Sick - the hours excluded from the work shift due to illness
- Vacation - the hours excluded from work due to vacation
- Holiday - the hours excluded from work due to a specific holiday
- Other - the hours excluded from work due to a specific reason, other than illness, vacation, and holidays.
- Total Hours - the amount of hours an employee worked in a day.
For each day, you have only a few lines to complete: Time Break, Overtime, Sick, Vacation, Holiday, and Other. Timesheet Calculator Template computes the total amount of hours an employee worked in a day and in a week. It also provides weekly subtotals, like the total of vacation days or the total of overtime.
To have a complete paycheck, you need to enter a fee for each category. Consider regular hours, overtime, sick, vacation, holiday, and other factors. The template will compute the fees generated by each category and the total.
Bi-Weekly Time Sheet
Bi-weekly Time Sheet works similarly with the Weekly Time Sheet. The difference is that this time you manage two weeks of work in a single table.