Printable Overtime Worksheet Generator
Standard Formula
Generates clean summary data formatted for physical printing and manual review.
Printable summary worksheet suitable for employee payroll audit trails and documentation.
How Printable Overtime Worksheet Generator Works?
The Printable Overtime Worksheet Generator works by splitting weekly hours into regular and overtime hours, pricing each, and laying out the summary for printing.
1Enter the employee ID
Type a name number or ID for the record, 101 by default.
2Enter the hourly rate
Type the base wage, $25.00 by default.
3Enter weekly hours
Add total hours worked, 45 by default.
4Print the worksheet
40 regular hours ($1,000.00) plus 5 overtime hours ($187.50) total $1,187.50. Press Ctrl + P (Cmd + P on Mac) to print or save a PDF.
Printable Overtime Worksheet Generator Formula
The Printable Overtime Worksheet Generator formula is Gross = (Min(Hours, 40) × Rate) + (Max(0, Hours − 40) × Rate × 1.5).
Regular line
Regular = Min(Hours, 40) × Rate
Overtime line
Overtime = Max(0, Hours − 40) × Rate × 1.5
Worksheet total
Gross = Regular + Overtime
- Employee ID
- Identifier printed on the worksheet.
- Hours
- Total hours in the workweek.
- Gross
- Total on the signed worksheet.
Worked example: worksheet lines
Employee 214, $21.00 per hour, 47.5 hours.
Regular 40 × $21.00 = $840.00. Overtime 7.5 × $31.50 = $236.25. Gross = $1,076.25.
Printable Overtime Worksheet Generator Conversion Table
The Printable Overtime Worksheet Generator conversion table shows a sample week of 5 employees, laid out the way the printed worksheet reads.
| Employee ID | Rate | Hours | Regular Pay | Overtime Pay | Gross |
|---|---|---|---|---|---|
| #101 | $25.00 | 45 hrs | $1,000.00 | $187.50 | $1,187.50 |
| #102 | $18.50 | 42 hrs | $740.00 | $55.50 | $795.50 |
| #103 | $22.00 | 50 hrs | $880.00 | $330.00 | $1,210.00 |
| #104 | $30.00 | 40 hrs | $1,200.00 | $0.00 | $1,200.00 |
| #105 | $27.75 | 47.5 hrs | $1,110.00 | $312.19 | $1,422.19 |
What is Printable Overtime Worksheet Generator?
A Printable Overtime Worksheet Generator is a tool that produces a clean, printable summary of one employee’s regular pay, overtime pay and gross pay for a workweek.
Paper records still matter for audits, union grievances and small businesses without payroll software. The FLSA requires employers to keep payroll records for at least 3 years and time cards for 2 years (29 CFR §§ 516.5–516.6).
A printed worksheet with a supervisor signature creates a clear audit trail for overtime approval.
What are the uses of Printable Overtime Worksheet Generator?
There are 4 main uses of the Printable Overtime Worksheet Generator.
Small business payroll
Owners without software print weekly pay records.
Overtime approvals
Supervisors sign printed overtime summaries.
Audit files
HR teams keep worksheets for record-retention rules.
Employee copies
Workers keep a printed record of hours and pay.