Overtime Pay Worksheet
See also: This Worksheet is provided for your information and convenience only. This is not a claim form. For information on filing a claim, call the Employment Standards Information Centre at 1-800-531-5551 or visit www.labour.gov.on.ca.
Use this worksheet to calculate the amount of overtime pay your employer may owe you. Please copy and attach as many worksheets as you need to support your request.
Most employees must be paid overtime pay, at a rate of at least 1½ times the regular rate of pay, for hours worked in excess of 44 hours per week. However, in some cases, overtime pay is paid after 50, 55, or 60 hours per week. Overtime pay rules may also be different if you signed an overtime averaging agreement with your employer.
For more information, call the Employment Standards Information Centre at 1-800-531-5551 or visit the Ministry of Labour website at www.labour.gov.on.ca to read the "Hours of Work & Overtime" fact sheet.
Example 1
A salaried employee was not paid overtime pay after working more than 44 hours in one week:
The employee's salary is $500.00/week. The work week runs from Sunday to Saturday. The regular work week is 44 hours and during the week of May 1 to May 7, 2005, the employee worked the following hours:
| Sunday | 0 |
| Monday | 8 |
| Tuesday | 12 |
| Wednesday | 9 |
| Thursday | 8 |
| Friday | 8 |
| Saturday | 8 |
| Weekly Total | 53 |
Overtime pay is 1 ½ times the regular wage, and is payable for any hours worked in excess of 44. The employee was paid for only 44 hours at the regular rate.
| Overtime hours for this employee: | 53 hours−44 hours= | 9 Overtime Hours |
| Employee's "hourly rate": | $500.00÷44= | $11.36 per hour |
| Overtime rate: | 1 ½×$11.36/hr= | $17.04 per hour |
| Overtime pay: | 9 hours×$17.04= | $153.36 |
| Plus 4% vacation pay (153.36×0.04): | 153.36+$6.13= | $159.49 |
Sample Calculation based on Example 1
| Dates of weeks work performed Day 1: start of work week Day 7: end of work week (day/month/year) |
Number of hours worked each day (excluding paid or unpaid eating periods and unpaid breaks)[ 1 ] |
Number of hours in work week Add: Number of hours worked each day) |
Hours worked in excess of 44 (or the appropriate threshold) Subtract: Hours minus 44 or the appropriate threshold |
|---|---|---|---|
|
Week 1 Day 1: 01/05/2005 (Sunday) Day 2: 02/05/2005 (Monda) Day 3: 03/05/2005 (Tuesday) Day 4: 04/05/2005 (Wednesday) Day 5: 05/05/2005 (Thursday) Day 6: 06/05/2005 (Friday) Day 7: 07/05/2005 (Saturday) |
Week 1 0 8 12 9 8 8 8 |
Week 1 53 |
Week 1 9 |
| TOTAL OVERTIME HOURS Add: All excess hours from above |
9 | ||
| Overtime hours (From above: Total overtime hours) |
Regular wage rate (per hour) |
Overtime rate (per hour) Multiply: Regular wage rate by 1.5 |
Overtime pay earned Multiply: Overtime hours by Overtime rate |
Wages already paid for overtime hours during the same period |
|---|---|---|---|---|
| 9 | $11.36 | $17.04 | $153.36 | 0 |
| Overtime pay owed: Subtract: Overtime pay earned minus Wages for overtime hours already paid |
$153.36 | |||
| If you are no longer employed by your employer OR if you receive vacation pay on each pay cheque, you are owed vacation pay. Vacation pay (4%): Multiply: Overtime pay owed by 0.04 |
$6.13 |
|||
TOTAL OWED: |
$154.49 | |||
