How to use the Excel timesheet template download

Step 1

Fill in the employees name, division, work site, employee number, manager name and working period at the top of the timesheet template.

Step 2

Employees can complete the timesheet throughout the work week, completing shift start time, end time, any breaks and any overtime. If used in Excel, enter times in 24-hour format and the formulas will automatically calculate hours worked. If used in hard copy your payroll team can manually calculate this inline with the applicable pay rules, modern award or EBA interpretation once the timesheet has been submitted.

Step 3

At the end of each work week, or the final shift, the employee signs the timesheet, acknowledging they have not sustained any injuries. Their direct manager can then sign the hours submitted to approve that those hours worked are true and correct and ready to submit to payroll for processing and payment.