Timesheet Generator
Log dates, projects, and hours for a pay period.
About this tool
Record the hours worked on each day and project across a week, two weeks, half-month or month. Totals, regular and overtime hours update live, and you can download a landscape PDF or a CSV.
How to use
How it works
Hours are summed per day. If you set a daily overtime threshold, any hours above it on that day count as overtime; a weekly threshold is applied to each calendar week (Monday to Sunday) in the period, and when both are set each week counts whichever gives more overtime. Break minutes are deducted once from the period total, and the amount is reduced in proportion. The amount is paid hours times the hourly rate, so overtime hours are shown separately but are not priced at a premium.
regular = Σ min(day hours, daily limit) overtime = Σ max(0, day hours − daily limit) amount = total hours × hourly rate
Worked example
A three-day stretch with an 8-hour daily limit
- Input
- Mon 8 h; Tue 9.5 h; Wed 7 h; rate 40; daily overtime threshold 8
- Output
- 24.5 hours (23 regular, 1.5 overtime); amount 980
- Walkthrough
- Monday 8 and Wednesday 7 are within the limit, Tuesday contributes 8 regular and 1.5 overtime. Regular: 8 + 8 + 7 = 23. Total 24.5 hours × 40 = 980.
Limitations
- No overtime premium is applied to the amount.
- Timesheets carry no tax or discount fields.
- It does not enforce local labour rules on breaks or overtime.
Questions
Does the timesheet include tax or discount?
Can I export a CSV?
How is overtime worked out?
Can I show hours as hours and minutes?
Features
- Period day grid
- Overtime thresholds
- Break deduction
- CSV export
- Approver signature line
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
Introduction to interest
Khan Academy
Money-time basics for quotes and payment schedules.
Watch on YouTubePDF, What is it FOR?
Computerphile
Invoices and quotes often ship as fixed-layout PDF packets.
Watch on YouTube
- Invoice
Wikipedia
What typically belongs on an invoice when using generators.
- How to price your products and services
Entrepreneur
Pricing frameworks that pair with freelance rate calculators.