Free Timesheet Template
Download (CSV)A clean monthly timesheet: date, start, end, break minutes and worked hours per row, with totals and overtime at the bottom. One sheet per person per month.
How to use it
- Each worked day gets a row: shift start, shift end and the unpaid break taken in minutes.
- Worked hours = (end - start) - break. In a spreadsheet, a formula does this; the example row shows the format.
- At month end, the person signs it, their manager approves it, and the totals go to payroll.
Where paper and spreadsheet timesheets go wrong
- They are filled in at the end of the week from memory, which is how 8:12 becomes 8:00 and five-minute finishes become half-hours.
- Breaks get recorded as what the rota said, not what happened.
- Someone retypes every line into payroll, and every retype is a chance to be wrong.
- There is no record of where the person was when they "clocked in".
The fix the industry settled on is a time clock app: staff punch in and out on their phone or a shared kiosk, the timesheet builds itself, and payroll gets an export instead of a retype. Team Pilot includes exactly that, with GPS and geofencing where proportionate, on every plan including the free one. The time clock page explains how the pieces fit.
A note on UK breaks
Workers are entitled to a 20-minute rest break when the working day exceeds six hours. Recording breaks honestly on the timesheet is the simplest evidence that breaks are actually happening.