How to use the timesheet generator
- Under Document, add a Timesheet no., the Week starting date and the Project.
- Under Parties, fill in Employer / client and Employee / contractor.
- In Hours, add one line per day with the Date, Work done and Hours. Use + Add day for more.
- Under Totals, set the Hourly rate, Overtime after (hours per week) and Overtime multiplier.
- Check the totals, then print the sheet for signatures or download it as PDF or CSV.
What it does and when to use it
A timesheet is the record behind a pay packet or a contractor’s bill. This one turns a week of daily entries into the four numbers people argue about — total hours, regular hours, overtime hours and gross pay — and shows how each was reached, so the worker and the approver can check it in a minute.
Use it for hourly staff, part-timers, freelancers billing by the hour, or a contractor on a fixed weekly rate who is paid extra for long weeks. The printed sheet ends with Employee and Approved by signature lines.
For a full pay record with deductions, use the payslip generator. Travel and other costs claimed during the same week belong on an expense report, not on the timesheet.
How it works
Each Hours entry is turned into whole minutes, then:
- Total hours = sum of all entries
- Regular hours = the smaller of total hours and the overtime threshold
- Overtime hours = total hours − threshold, if positive
- Regular pay = regular hours × hourly rate
- Overtime pay = overtime hours × hourly rate × multiplier
- Gross pay = regular pay + overtime pay, with gross pay also written in words
Pay is rounded to the cent. If the hourly rate is 0, the sheet shows hours only. Everything is calculated in your browser.
Worked examples
The sample week. Days of 9, 9, 8.5, 9 and 7.5 hours make 43 hours. With a $32 rate, a 40-hour threshold and 1.5×: 40 × $32 = $1,280.00 regular, 3 × $48 = $144.00 overtime, so Overtime hours: 3 h and Gross pay: $1,424.00.
A 37.5-hour week in pounds. Same hours, rate £25, overtime after 37.5 hours at 1.5×. Regular pay 37.5 × £25 = £937.50; overtime 5.5 × £37.50 = £206.25; Gross pay: £1,143.75.
Limits and tips
- Breaks are not subtracted. Enter hours actually worked.
- Night, weekend or holiday premiums are not built in; add a separate line note or adjust the rate.
- Fill the sheet daily rather than from memory at the end of the week.
Frequently asked questions
How do I type half hours?
Is overtime worked out per day or per week?
Which overtime threshold and multiplier should I use?
Is gross pay what the worker takes home?
Can contractors use it to bill a client?
How do we know nothing is uploaded? Test it yourself on the privacy proof page.