Free Timesheet Template for UK Businesses

Free Template

Download the Excel template

A ready-to-use Excel timesheet you can fill in today. No software, no signup, no cost — just download and start tracking hours.

  • No email required
  • Instant download
  • Works with Excel & Google Sheets
  • All HMRC-required fields included
OR
TimeTallyTimeTally Software

Automate your time tracking entirely

Employees log hours on mobile. You approve in one tap. Hours flow straight to payroll. No spreadsheets, no chasing.

5.0 on the App Store
TimeTally timesheet entry screen showing employee hours submission
  • Employees submit hours via iOS app in seconds
  • Manager approval with full digital audit trail
  • Automatic overtime & pay calculations
  • One-click export to Xero, QuickBooks or CSV

What's included in the template

Every field a UK employer needs to stay compliant with HMRC and the Working Time Regulations 1998.

Employee Name & ID

Identifies who worked the hours — required for NMW enforcement records

Start & End Times

Exact times worked each day, with break durations recorded separately

Total Hours & Overtime

Daily and weekly hour totals, with overtime calculated at your configured rate

Manager Approval

Space for manager signature or approval — creates the paper trail you need

Pay Period Reference

Links each timesheet to the correct payslip for audit purposes

Easy to Edit

Simple Excel and Google Sheets format — add or remove columns to suit your business

How to use the timesheet template

Up and running in five steps — no software needed.

1

Download

Click the download button to get the Excel file instantly — no email required.

2

Add employees

List all staff members who submit time tracking in the employee column.

3

Record hours

Fill in start times, end times, and break durations for each day worked.

4

Check totals

Verify daily and weekly totals are within the 48-hour Working Time limit.

5

Approve & file

Manager signs or approves, then store securely for at least 3 years (6 recommended).

UK timesheet legal requirements

Under the Working Time Regulations 1998 and HMRC's National Minimum Wage enforcement rules, UK employers must keep adequate records of hours worked. Getting this wrong can lead to NMW penalties, back pay orders, or employment tribunal claims.

3-year minimum retention (6 recommended)

HMRC requires timesheet and wage records to be kept for at least 3 years for National Minimum Wage purposes. For employment tribunal claims — covering unfair dismissal, discrimination, or unpaid wages — records can be requested going back 6 years. Most employment solicitors recommend keeping all timesheet records for 6 years as standard practice. Paper records can be lost, damaged, or misfiled — digital records stored in the cloud are far safer.

48-hour weekly maximum (Working Time Regulations)

Employees cannot be required to work more than an average of 48 hours per week, calculated over a 17-week reference period. Workers can opt out in writing, but you cannot make this a condition of employment. Your timesheet must show weekly totals clearly so you can monitor compliance — particularly for employees who work variable hours or take on overtime regularly.

Break records are mandatory

Any shift longer than 6 hours entitles the worker to a minimum 20-minute uninterrupted rest break. Young workers (under 18) are entitled to 30 minutes after 4.5 hours. Unpaid breaks must be deducted from total hours worked — this directly affects both pay calculations and NMW compliance. Your timesheet must record break duration separately from working time.

Manager approval creates your audit trail

While not legally mandated, manager approval of time tracking is essential protection against disputes. If an employee later claims they worked hours you didn't pay, an approved timesheet is your primary evidence. With paper templates, this means a physical signature. With digital timesheet software, approval is timestamped and tamper-evident.

Read our full HMRC timesheet requirements guide for the complete legal picture.

The hidden cost of “free” templates

Spreadsheets are free to start but expensive to maintain. Here's what you're actually paying in time every pay period.

Chasing submissions every week

No automatic reminders — you email, text, and chase staff before you can even start payroll.

Calculation errors

One broken formula or typo means someone gets overpaid or underpaid. You often don't catch it until payday.

No approval audit trail

If HMRC asks who approved a timesheet, spreadsheets have no built-in workflow or timestamp.

Manual payroll entry

Copy-pasting hours into your payroll software every month is slow, tedious, and error-prone.

Version control chaos

Which file is right — Timesheet_v3_FINAL_updated.xlsx or the one from last week's email?

No holiday integration

Time Tracking and leave live in separate spreadsheets with nothing connecting them — leading to payroll mistakes.

This is what TimeTally does instead

The template gets you started. TimeTally replaces it entirely — with mobile timesheet entry, manager approvals, automatic pay calculations, and direct payroll export. All in one place, from £2/employee/month.

Employees log hours in seconds

Staff submit their hours via the iOS app or mobile browser — start time, end time, breaks. No paper forms, no spreadsheets, no chasing. Hours are calculated automatically and sent to you for approval.

  • One-tap clock in & clock out
  • Breaks deducted automatically
  • Works on any device, iOS app available
  • Automatic reminders for late submissions
TimeTally timesheet entry showing employee hours submission on mobile
TimeTally employer timesheet review dashboard showing submitted hours

Review & approve time tracking in one place

All submitted time tracking land in your dashboard. Approve or query in a single tap, with a timestamped audit trail that's far more defensible than a signed spreadsheet.

  • See all pending time tracking at a glance
  • Approve individually or in bulk
  • Full edit history and audit trail
  • Dispute resolution with timestamped records

Overtime & pay calculated automatically

Set hourly rates, overtime thresholds, and TOIL rules once. TimeTally calculates the correct pay for every employee every week — no formulas, no manual adjustments, no mistakes.

  • Configurable hourly rates per employee
  • Overtime at 1.5x, 2x, or any multiplier
  • TOIL accrual and usage tracking
  • Weekly pay summaries ready for payroll
TimeTally pay page showing automatic overtime and pay calculations
TimeTally export to payroll showing Xero and QuickBooks integration

Export straight to payroll — no re-keying

Once time tracking are approved, export hours and pay data directly to Xero, QuickBooks, or CSV. No copy-pasting, no Monday morning data entry, no errors.

  • Direct Xero & QuickBooks integration
  • CSV export for any payroll software
  • Approved hours only — no accidental drafts
  • Saves hours of admin every pay period

Loved by UK small businesses

Real reviews from TimeTally customers

Setup was dead simple and the team just got on with it. Got everyone up and running in an afternoon with no help needed. Does everything we need for timesheets and holidays without the faff.
SM

S.M.

Has completely changed how I handle timesheets. Used to dread it every week — now it takes me minutes. Really easy to get around and my staff picked it up straight away.
JT

J.T.

Started using it just for rotas but quickly realised it does loads more. The timesheets and leave management are great, and it even handles TOIL and overtime which I wasn't expecting. Use it for everything now.
RK

R.K.

Download on the App Store

Frequently asked questions about timesheet templates

What must a UK timesheet include to be legally compliant?

Under the Working Time Regulations 1998 and HMRC's National Minimum Wage enforcement rules, UK employers must keep records of hours worked. A compliant timesheet needs: employee name and ID, dates worked, start and end times, break durations, total hours worked (daily and weekly), overtime hours, and manager approval. HMRC requires these records to be kept for at least 3 years — 6 years is recommended for employment tribunal protection.

Can I use an Excel timesheet template for HMRC purposes?

Yes, Excel templates are acceptable for HMRC record-keeping provided they contain all required fields and are stored securely for the required period. However, Excel spreadsheets have no audit trail — records can be edited without trace. Digital timesheet software like TimeTally creates tamper-evident logs that are far more defensible if HMRC or an employment tribunal asks questions.

How long do I need to keep timesheet records in the UK?

HMRC requires timesheet records to be kept for a minimum of 3 years for National Minimum Wage purposes. However, if an employee might bring an employment tribunal claim (for unfair dismissal, discrimination, or unpaid wages), those records can go back up to 6 years. Most employment solicitors recommend keeping all payroll and timesheet records for 6 years as standard.

Do I need employees to sign time tracking?

There is no statutory requirement for employees to physically sign time tracking, but having a record of approval significantly strengthens your position in a dispute. A manager countersignature (or digital approval) confirms that the hours were reviewed and agreed. Digital timesheet software can capture this approval automatically, with a timestamped audit trail.

What is the difference between a timesheet and a rota?

A rota (or schedule) plans who should work and when — it is a forward-looking tool. A timesheet records what actually happened — the hours employees actually worked. Both serve different purposes: the rota manages coverage, and the timesheet feeds payroll and legal records. Most businesses need both, especially if actual hours frequently differ from planned shifts.

Is a free timesheet template enough for my business?

A free template works for very small businesses with just a few employees and straightforward hours. As your team grows, spreadsheets create problems: no reminders for late submissions, no approval workflow, manual payroll entry, no holiday integration, and no audit trail. Most businesses with 5 or more employees find dedicated timesheet software saves more time than it costs.

Does TimeTally work alongside this timesheet template?

You can absolutely use this template while evaluating digital options — it gives you everything you need legally. If you want to move to automated time tracking, TimeTally replaces the template entirely: employees log hours via app, managers approve digitally, and data exports straight to Xero, QuickBooks, or CSV. Start a free trial at any point and import your existing employee list.

Ready to ditch the spreadsheet?

Use this template while you're getting started. When you're ready to automate, TimeTally handles everything.

No credit card required • Free 14-day trial • Cancel anytime