Free daily time clock sheet (Excel)
One day per sheet, every name on it, clock-in and clock-out beside each. Print it, put it on a clipboard by the door, and you have a record made at the time rather than remembered later.
Daily time clock sheet
Excel format (.xlsx) • Ready to download
No signup required. Works with Excel, Google Sheets and LibreOffice.
This template is a record-keeping tool, not legal or payroll advice. It does not calculate minimum wage, holiday pay or statutory sick pay for you, and it does not check working time limits. Check GOV.UK, or take advice, before relying on a spreadsheet for compliance. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
Roster and track hours in one place
A timesheet only records what already happened. Roster the shifts first and the hours record themselves — free, no signup.
What's in this template
A single day, recorded as it happens
One day per sheet
Date at the top, everybody on shift beneath. A new sheet each day, which is what makes it a contemporaneous record.
In, out and break
Three time columns per person, with paid hours calculated from them rather than entered by hand.
An initials column
Each person initials their own row. It is a small thing that turns a manager’s note into the worker’s own confirmation.
Print-ready
Set to one A4 portrait page with the header repeated, so it works on a clipboard rather than only on screen.
A daily total
Total hours across everyone on shift, which is the labour figure most managers actually want at close.
An exceptions line
One line for anything unusual — a late start, a shift covered, an early finish — recorded on the day it happened.
A day on one sheet
Names down the side, times across. Because it is filled in at the door rather than at the end of the week, this is the strongest record on the shelf — the entries are made at the moment they happen.
| Name | In | Out | Break | Hours | Initials |
|---|---|---|---|---|---|
| Priya Sharma | 08:55 | 17:02 | 0:30 | 7.6 | PS |
| Callum Reid | 11:00 | 19:30 | 0:30 | 8.0 | CR |
| Bea Okoro | 08:45 | 16:00 | 0:00 | 7.25 | BO |
The highlighted row has no break against a 7.25-hour shift. Over six hours, a worker is entitled to an uninterrupted 20-minute rest break — so that row is either a missed break or a missed entry, and it is worth resolving on the day rather than in three months.
How to use the daily clock sheet
Four steps, every day
1. Print it the night before
Date it and pre-fill the names on shift. A blank sheet that has to be filled in from scratch is a sheet that gets skipped.
2. Record at the door
People write their own in and out times as they arrive and leave. The value of this sheet is entirely in when it is filled in.
3. Check it at close
Look for blanks and missing breaks before anyone goes home, while the answer is still known.
4. File it
Scan or photograph the page and keep it. Minimum wage records have to be kept for six years, and a lost clipboard is not a defence.
Transfer the daily figures into the weekly timesheet for payroll — the two are designed to line up.
Who uses this template
UK sites where a paper record by the door is the practical option
Construction sites
Who was on site today, which is a safety question before it is a payroll one.
Manufacturing and warehousing
Shift start and finish across a floor where not everyone has a work phone.
Kitchens
A clipboard by the pass, because a phone-based system is not going near a kitchen.
Need signatures rather than initials? Use the shift sign-in sheet, which has a full signature column.
Or clock in from a tablet by the door
A paper sheet is a good record until it is lost, or someone signs in for a colleague. A tablet kiosk timestamps every entry, takes a photo at clock-in, and the day’s hours are in payroll without anyone retyping them.
Hours and record keeping
What the daily sheet feeds
Timesheets and working time records
What UK employers must record about hours, and the unpaid time that causes minimum wage breaches.
Read the guideEmployee records and UK GDPR
How long to keep each kind of record, and the lawful basis for holding it.
Read the guideNational Minimum Wage rates
Current rates by age, and how an underpayment is calculated and settled.
Read the guideMore free UK templates and tools
The rest of the set
Free rota templates
Weekly, monthly, rolling and blank staff rotas in Excel — the planning side of the same job.
Browse the rotasMinimum wage compliance checker
Work out effective hourly pay once unpaid time and deductions are counted.
Open the checkerAll free UK tools
Calculators and generators for planning and costing your workforce.
See all toolsDaily time clock sheet FAQ
-
Because of when it is filled in. A weekly timesheet completed on Friday is a reconstruction of the week; a daily sheet signed at the door is a record made at the time. In a minimum wage enquiry, where the burden of proof sits with the employer, that difference is the whole point.
-
25 rows, which covers most single shifts. For a bigger site, print one sheet per department or per entrance rather than extending the rows — the print area is set to one A4 page and adding rows will spill it onto a second.
-
Their own, with a manager checking at close. A sheet completed entirely by a manager is a manager’s recollection, which is exactly the weakness a contemporaneous record is meant to remove.
-
Keep a copy in some form — scanning or photographing the page is fine. National Minimum Wage records must be kept for six years, and there is no requirement for them to be on paper.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws and workplace requirements.