Skip to content

Free timesheet template (UK): weekly and monthly layouts

A free timesheet template to copy into Excel or Google Sheets, the hours formula, and what a UK timesheet has to prove under working time and minimum wage law.

·11 min read

The timesheet template below is free to copy into Excel or Google Sheets: one row per block of work, with date, client, project, task, start, finish, unpaid break and hours, plus a billable column. For UK employers there's a second tab that tracks the 48-hour average, because a timesheet here has a legal job as well as a billing one.

Most free templates stop at the grid. This page also covers the formula that gets hours right, what UK law expects your records to prove (checked on gov.uk and legislation.gov.uk today), and the columns an agency needs if the same hours are going to back an invoice or tell you whether a project made money.

Free weekly timesheet template (copy into Excel or Google Sheets)

Copy the block below, paste it into cell A1 of a new sheet, then use Data, Split text to columns (Google Sheets) or Data, Text to Columns with a comma delimiter (Excel). The three example rows show how a normal day splits across clients.

Date,Day,Client,Project,Task or ticket,Start,Finish,Unpaid break (mins),Hours,Billable (Y/N),Notes
2026-11-16,Mon,Northfield Dental,Website rebuild,Homepage build,09:00,12:30,0,3.5,Y,
2026-11-16,Mon,Northfield Dental,Website rebuild,Client call,13:15,14:00,0,0.75,Y,Agreed revised menu
2026-11-16,Mon,Internal,Admin,Team check-in and email,14:00,17:30,30,3,N,

The columns, and why each one is there:

ColumnWhat goes in itWhy it matters
Date and DayThe day the work happenedLets you total by day and by week
ClientWho the work was for, or "Internal"Splits billable from overhead
ProjectThe job or retainerFeeds project margin and estimates
Task or ticketWhat was actually doneTurns a number into something a client can check
Start and FinishClock times in 24-hour formatNeeded for working time checks and overtime
Unpaid break (mins)Lunch or other unpaid breaksBreaks with no work aren't working time
HoursCalculated, never typedStops 3.5 becoming 4 by habit
Billable (Y/N)Whether the client pays for itGives you billable hours and utilisation
NotesAnything a reviewer would ask aboutSaves a message later

The hours formula

Excel and Google Sheets store times as fractions of a day, so subtract, multiply by 24 and take the break off in hours. With Start in F, Finish in G and Break in H:

=(G2-F2)*24 - H2/60

For a shift that crosses midnight, use =MOD(G2-F2,1)*24 - H2/60 so the result doesn't go negative. Format the Hours column as a number with two decimals, not as a time, or a 7.5-hour day will display as 07:30 and break your totals.

The weekly summary

Under the entries, add five lines. These are the numbers you'll actually look at.

LineFormula (entries in rows 2 to 40)
Total hours=SUM(I2:I40)
Billable hours=SUMIF(J2:J40,"Y",I2:I40)
Billable share=Billable hours / Total hours
Contracted hoursTyped in, for example 37.5
Over or under contract=Total hours - Contracted hours

Keep one tab per person per week, or one long tab with a Person column if you'd rather filter. One long tab is easier to total for the monthly view.

Monthly timesheet template and the 17-week check

A monthly timesheet is the weekly one added up, plus one thing UK employers need: a rolling view of average weekly hours. gov.uk says nobody can work more than 48 hours a week on average, normally averaged over 17 weeks, unless they've opted out in writing.

Set up a second tab with one row per person per week:

Person,Week commencing,Hours worked,Opted out of 48-hour week (Y/N),17-week average
Sam,2026-07-27,41,N,
Sam,2026-08-03,52,N,
Sam,2026-08-10,39.5,N,

In the average column, from the 17th week onwards, use =AVERAGE(C2:C18) and drag it down so each row averages the latest 17 weeks. Add conditional formatting to turn the cell red above 48 for anyone with N in the opt-out column. The monthly totals for billing come from the first tab with a SUMIFS on person, client and month.

Two details from gov.uk that change what goes into the Hours worked column. Working time includes job-related training, travel that's part of the job, working lunches and overtime you've asked for. It doesn't include lunch breaks with no work, unpaid overtime someone volunteers for, or holiday. If your team logs everything they do, including staying late by choice, the timesheet will run higher than the legal working time figure, which is the safe direction to be wrong in.

What a UK timesheet has to prove

There's no prescribed UK timesheet form. What the law asks for is records that let you show you've kept within the rules. Three pieces matter for a small agency or studio.

Working time records: two years

Regulation 9 of the Working Time Regulations 1998 says an employer must keep records adequate to show it has complied with the weekly limit and the night work rules, and must keep them for two years from the date they were made. It also says, since 1 January 2024, that the records can be kept "in such manner and format as the employer reasonably thinks fit", and that you don't need to record each worker's daily hours if you can show compliance without doing so.

In practice that means a salaried team that clearly works around 37.5 hours a week doesn't need a clocking-in system to satisfy working time law. It doesn't mean you can have no records at all, and the moment someone is regularly working long weeks, the 17-week tab above is the simplest way to show where they stand.

If someone has opted out of the 48-hour average, gov.uk says the opt-out must be voluntary and in writing, and the employer must keep a record of it. Put the signed opt-out in the person's file and the Y in the timesheet tab.

Minimum wage records: six years

Regulation 59 of the National Minimum Wage Regulations 2015 requires records "sufficient to establish" that each worker was paid at least the minimum wage, kept for six years from the end of the pay reference period after the one they cover. The six years has applied since 1 April 2021. The records can be kept on a computer.

Hours are half of that calculation, which is why timesheets end up being minimum wage records whether you meant them to or not. From April 2026 the National Living Wage for workers aged 21 and over is £12.71 an hour, and £10.85 for 18 to 20 year olds.

Breaks and rest

gov.uk's rest breaks guidance gives workers over 18 one uninterrupted 20-minute break if they work more than six hours a day, 11 hours' rest between working days, and 24 hours off each week (or 48 hours each fortnight). Breaks aren't on the regulation 9 list of things your records must show, but the Unpaid break and Start/Finish columns make it obvious when someone has worked through lunch or finished at 11pm and started at 8am.

The simple rule most small employers settle on: keep timesheets for six years, because the longest requirement that applies to them is six.

Worked example: the salaried junior and the minimum wage

Minimum wage problems in small agencies rarely come from low salaries on paper. They come from long weeks nobody adds up. Here's a hypothetical case, simplified to an annual average to show the mechanism. The real calculation works per pay reference period and has its own rules for salaried hours, so use gov.uk or Acas before relying on it.

A junior designer, aged 23, on £25,500 a year, contracted for 37.5 hours a week.

£25,500 ÷ (37.5 × 52) = £25,500 ÷ 1,950 hours = £13.08 an hour

That's above £12.71. Now suppose launch season runs long and the timesheets show an average of 46 hours a week across the year, with the extra hours asked for by their manager.

£25,500 ÷ (46 × 52) = £25,500 ÷ 2,392 hours = £10.66 an hour

That's £2.05 an hour below the National Living Wage. Nobody decided to underpay anyone; the hours crept up the way they do when deadlines stack. The timesheet is what lets you see it before HMRC does, and it's also the record you'd need to show it didn't happen.

The same 46-hour average puts them over the 48-hour limit in some 17-week windows if a few weeks hit 55, so the second tab earns its place here too.

Employee, contractor and client timesheets

The template works for all three, but what you check on each one is different.

Timesheet forWho fills it inWhat it backs upWhat to check
EmployeesThe employeePay, working time, minimum wageWeekly totals, 17-week average, breaks
Contractors and freelancersThe contractorTheir invoice to youHours match the agreed scope and rate
Client billing (time and materials)Your team, reviewed by youYour invoice to the clientEvery billable row has a clear task

For contractors, the timesheet supports their invoice and nothing more. Working time and minimum wage rules follow employment status, and our guide to contractors vs employees for agencies covers where that line sits. Don't use timesheets to manage a contractor like staff; how you treat them is part of how status gets judged.

For client billing on time and materials, the Task or ticket column is the one clients read. "Development, 6h" invites a question. "Checkout: fixed VAT rounding on basket totals, 6h" usually doesn't.

The agency columns most templates leave out

The ranking templates for this search are built for payroll: name, date, in, out, total. That's enough to pay people. It isn't enough to run a service business, where the same hours also decide whether a project made money.

Three additions make the difference.

Client and project on every row. Without them you know how long people worked, not what they worked on, and you can't see that one retainer is quietly eating 70 hours a month against 50 sold. Profitable retainer pricing walks through how that happens.

A billable flag. Billable hours divided by available hours is your utilisation rate. Billable revenue divided by all hours worked is your effective hourly rate. Both come straight off this sheet once the flag is there.

The estimate, at project level. If the proposal said 40 hours for the homepage, put 40 next to the project in your monthly tab and compare. That single comparison, repeated for a few jobs, will improve your next quote more than any pricing framework.

How to get timesheets filled in honestly

A timesheet reconstructed on Friday afternoon is mostly fiction: rounded numbers against whichever project people remember. The hours aren't lied about, they're guessed, and guessed hours make every number built on them wrong.

What helps, in rough order of impact:

  1. Log daily, at the end of the day, while it's fresh. A two-minute habit beats a twenty-minute Friday ritual.
  2. Use tasks people recognise. If the project list doesn't match the work, people pick the nearest code.
  3. Show the team what the data is for. When hours come back as better estimates and fairer workloads, logging improves. When they come back as judgement, rounding starts.
  4. Don't use individual hours to rank people. Look at projects and teams.

Our article on time tracking your team won't quietly sabotage goes deeper on the framing, and an end of day report is a natural place to attach the day's hours.

When a spreadsheet stops being enough

A spreadsheet timesheet is fine for a team of a few people with a handful of clients. These are the signs it's time to move on:

  • you're chasing people for timesheets every week;
  • you copy hours from the sheet into invoices or a margin calculation by hand;
  • people log against the wrong project because the list is out of date;
  • you can't answer "how many hours has this retainer used this month?" without opening three files;
  • you need approval and sign-off before hours go to payroll or a client.

What to move to depends on which of those is the real problem. If your need is employee hours for payroll, with manager approval and an export to your payroll provider, a dedicated timesheet or time and attendance app is the better fit, and it will be cheaper than a broader tool.

If the problem is that hours, projects and client work live in different places, Suprwork's Projects & Time is built for that. People start a timer on a ticket from the web, desktop or phone, or log hours after, so every entry already carries its client, project and task. Whether hours count as billable comes from the project, so utilisation needs no extra column. You can compare estimates with the hours actually logged, person by person, and Margin prices logged time at each person's cost rate to rank projects from worst margin to best. Everyone on your team is included at a flat price; see pricing.

What it doesn't do, so you can judge the fit: there's no timesheet approval or sign-off step, hours logged after the fact are recorded as hours rather than start and finish times with breaks, and it doesn't run payroll or calculate holiday pay. If your timesheet is mainly a payroll document, keep that in a payroll or attendance tool.

Sources

All checked on 20 November 2026.

Common questions

Is there a free timesheet template for a UK small business?
Yes. The weekly layout on this page is free to copy into Excel or Google Sheets. It records date, client, project, task, start, finish, unpaid break and hours, and the 17-week tab checks the 48-hour average the Working Time Regulations set.
How long do you have to keep timesheets in the UK?
Working time records must be kept for two years. Records that show you paid at least the minimum wage must be kept for six years from the end of the following pay reference period, so most employers simply keep timesheets for six years.
Do UK employers have to record daily working hours?
Not always. Since 1 January 2024 the Working Time Regulations say an employer need not record each worker's daily hours if it can show compliance with the limits another way. You still need adequate records, and hours matter for the minimum wage.
What should a timesheet include?
The person, the week or pay period, and for each entry the date, the work it was for, start and finish times, unpaid breaks and total hours. Agencies should add client, project and a billable flag, because the same hours feed invoices and project margin.

Keep reading