How to use the timesheet calculator
Here are the step by step instructions on how to use the timesheet calculator:
1. Select your timesheet details
For each employee, select the weekly timesheet to see one week of time entries or use the bi-weekly timesheet to see two weeks’ worth of time entries and add the number of days worked.
2. Add overtime rates
If an employee is eligible for overtime pay, select the employee’s overtime rule—whether they receive overtime pay for hours worked over 7.6 in a day, or 38 in a week. Note any employee who works in excess of 38 hours per week or 7.6 hours in a day must be paid overtime in Australia. Then add the employee’s base hourly pay rate, and select their overtime rate. This calculator can help with overtime rates that are 1.5 and 2 times the rate of the employee’s base pay. However, these rates are just a guide only: overtime rates may vary depending on workplace agreements or industry. If the employee is not eligible for overtime, select “Exempt.”
3. Add times worked—don’t forget overtime and breaks
For each day the employee worked, add their clock in and clock out times. Those should include overtime hours. For even simpler calculations, use an automated timesheet tool like QuickBooks Time to do the math for you.
For each day the employee took an unpaid break, add those minutes in the box provided. Unpaid break minutes are subtracted from the total time.
4. Download and save or print the data
As you fill in the clock in and clock out times, the calculator determines the employee’s total hours (regular and overtime) and total gross pay.
Once you have completed the information, enter your email address in the box provided to download a copy of your employee’s times worked.