Free template
A free weekly timesheet for UK employers, in Excel and PDF. The Excel version works out daily hours, unpaid breaks, overtime and gross pay for you, including night shifts that finish the next morning. The PDF is ready to print and fill in by hand.
One week per sheet, no sign-up. Save a copy for each week, or print a stack of the PDF for staff to fill in.
Free to use and adapt within your organisation.
Use the Monday the week starts on. The dates for the rest of the week fill in by themselves.
Type times as 09:00 and 17:30. For a night shift from 22:00 to 06:00, enter it as it happened and the sheet counts it as eight hours, not a negative number.
Paid breaks count as working time, so leave them in the hours. Enter unpaid breaks in minutes, for example 30.
The employee signs to confirm the hours are right, and the manager signs to approve them before they go to payroll.
Store each week's sheet somewhere you can find it again. Records that show you paid at least the minimum wage have to be kept for years, not months.
Timesheets and payroll usually work in decimal hours, which is where most mistakes creep in. Half an hour is 0.5, not 0.3. The Excel version does this for you; if you are filling in the PDF by hand, this is the conversion.
| Minutes | Decimal hours | Example |
|---|---|---|
| 15 | 0.25 | 7 hours 15 minutes is 7.25 |
| 20 | 0.33 | 7 hours 20 minutes is 7.33 |
| 30 | 0.50 | 7 hours 30 minutes is 7.50 |
| 40 | 0.67 | 7 hours 40 minutes is 7.67 |
| 45 | 0.75 | 7 hours 45 minutes is 7.75 |
To check a single week quickly, the free hours worked calculator does the same sums in your browser.
There is no law that says you must use timesheets, but you do have to keep records that show you paid at least the National Minimum Wage, and those records have to be kept for six years. You also need records showing you kept to the working time limits, such as the 48 hour average week, for two years. Timesheets are one of the simplest ways to have both.
The rules and rates change, so check the current position on gov.uk: National Minimum Wage for employers and maximum weekly working hours.
This page is general guidance, not legal advice.
Take the finish time away from the start time, then take off any unpaid break. For example, 09:00 to 17:30 is 8 hours 30 minutes, and with a 30 minute unpaid lunch that is 8 hours. The Excel timesheet does this for every day and adds up the week.
As 7.50 in decimal hours, or 7:30 if your payroll uses hours and minutes. The common mistake is writing 7.30, which payroll will read as 7 hours 18 minutes.
Yes. If the finish time is earlier than the start time, the Excel version treats it as a shift that ran past midnight, so 22:00 to 06:00 counts as eight hours before any break.
Paid breaks should, because they are working time. Unpaid breaks should not. Workers are generally entitled to a 20 minute rest break if they work more than six hours a day, and it is up to the contract whether that break is paid.
Not timesheets as such, but you must keep records that prove you paid at least the minimum wage, for six years, and records that show you met the working time limits, for two years. For hourly paid staff, timesheets or clocking records are usually how employers do that.
The template is weekly, because that is how most hourly paid staff are checked. For a month, save a copy for each week and add the weekly totals together, or copy the sheet four or five times in the same workbook.
Enter the number of hours a week after which overtime starts, and any hours above that are counted as overtime. There is no legal overtime rate in the UK, so the rate you enter should be whatever the employee's contract says. Leave the overtime box blank if you do not pay overtime.
No. Gross pay is before tax, National Insurance, pension contributions and any other deductions. It is there as a check before the hours go to payroll, not as a payslip.
It uses standard formulas, so it opens and calculates in LibreOffice, and should work the same way if you upload it to Google Sheets.
Yes. The Excel file is not locked, so you can add a logo, rename columns or add your own. If you change the start, finish or break columns, check the hours formula still points at the right cells.
Usually when checking them takes longer than the work they record, or when you find you are paying for hours nobody can confirm. A paper or spreadsheet timesheet relies on people writing down the right times; a clocking system records them as they happen. For a handful of staff on regular hours, a good timesheet is often enough.
Syncro Connect records start and finish times from a clocking terminal, the app or the web, works out the hours and breaks, and exports them for payroll. From £2 per employee per month, excluding VAT, with a free trial and no card needed.