Why SMEs still track time in Excel
For many small businesses, a spreadsheet is the first and only time tracking system. It is easy to see why:
- No extra cost: Excel or Google Sheets is already on every office computer.
- Familiar: nobody needs training to type a start time into a cell.
- Flexible: you can shape it around any shift pattern, pay rule or absence type.
- Easy to hand over: your accountant or payroll provider can open it.
A well-built employee time tracking spreadsheet handles the basics: daily hours, weekly totals, overtime and absences. The typical pattern in a business of 5 to 50 people is a shared workbook, or a template emailed to staff or site managers every Monday and collected on Friday. It works, until the team grows, people work on different sites, or one formula breaks without anyone noticing.
What your spreadsheet needs
Whatever layout you choose, a timesheet that will stand up at payroll time needs the following columns. Our free timesheet Excel template uses exactly this structure, in weekly, monthly and yearly views.
| Column | What it records | Why it matters |
|---|---|---|
| Date and employee | One row per person per day | Lets you filter, total and audit by person and period |
| Site or project | Where the work was done | Needed for multi-site teams, client billing and job costing |
| Start and finish | Times in hh:mm format | The raw data every other figure depends on |
| Break | Unpaid break in minutes | Deducted from paid hours; shows rest breaks were taken |
| Hours worked | Calculated by formula | Never typed by hand, so it cannot drift from the times |
| Contracted hours and overtime | Daily or weekly threshold, hours above it | Drives overtime pay and highlights long weeks |
| Absence code | Annual leave, sick, public holiday, unpaid | Feeds holiday balances and payroll |
| Approval | Manager initials and date | Shows who checked the week before it went to payroll |
How to set it up, step by step
Plan about half an hour for the first set-up. These steps work in both Microsoft Excel and Google Sheets.
1. Create one log, not one file per person
Use a single sheet called "Log" with one row per employee per day and the columns above. Separate files per employee are the main source of version chaos. If you need a view per person, build it with filters or summary formulas.
2. Calculate hours with a formula that handles night shifts
With start time in D, finish in E and break minutes in F, hours worked are =MOD(E2-D2,1)*24-F2/60. The MOD part makes a shift from 22:00 to 06:00 come out as 8 hours instead of a negative number. Format the result as a number with two decimals so it adds up cleanly.
3. Add overtime and weekly totals
With contracted daily hours in H, daily overtime is =MAX(0,G2-H2). For weekly totals per person, use SUMIFS on the log, for example the hours for one employee between two dates. Keep overtime rules (daily or weekly threshold) written at the top of the sheet so everyone applies the same one.
4. Restrict what can be typed
Use data validation for the absence code column (a drop-down list) and for times. Then protect the formula columns: in Excel via Review, Protect Sheet; in Google Sheets via Data, Protect sheets and ranges. This alone prevents a large share of payroll errors.
5. Flag long weeks
Add conditional formatting that colours weekly totals above a threshold you choose. In the UK, the Working Time Regulations limit average weekly working time to 48 hours over 17 weeks unless a worker opts out, so a weekly flag is a useful early warning, not the legal test itself.
6. Decide who fills it in and when
Either employees enter their own times in a shared Google Sheet with protected ranges, or a manager fills it centrally each day. Daily entry is far more accurate than reconstructing a week on Friday afternoon.
7. Export for payroll and archive
At month end, filter the log to the period, check and approve it, then export to PDF or CSV for your payroll provider. Keep the approved file in a folder with restricted access.
Excel or Google Sheets?
Both work with the formulas in this guide. Google Sheets is easier to share: there is one file in the browser, a version history and per-range protection, so employees can enter their own times without touching the formulas. Excel is more familiar to many accountants and works offline, but sharing a desktop file usually means emailing copies, which is exactly how versions multiply. If you choose Excel, keep the workbook in one shared location with controlled access so that everyone edits the same file.
One limit applies to both: in a single shared sheet, every editor can see everyone's rows. You cannot easily let each employee see only their own hours while managers see their whole team. That is one of the reasons growing teams move to an app with separate roles for admins, managers and employees.
Seven common Excel timesheet mistakes
- Typing totals by hand instead of calculating them from start and finish times.
- Minus signs on night shifts because the formula does not handle midnight.
- Mixing decimal hours and hh:mm: 7.30 is not seven and a half hours.
- One file per person, emailed back and forth, with nobody sure which version is final.
- Unprotected formulas that someone overwrites while correcting a typo.
- Hours written up from memory at the end of the week.
- Files on personal laptops or in open shared drives, which is a data protection problem as much as an accuracy one.
From spreadsheet to live dashboard
NoBadge records clock-ins from each employee's smartphone by GPS or dynamic QR code, totals hours and overtime automatically and still gives your accountant an Excel file, in one click.
The real cost of manual time tracking
Excel has no licence cost, but the time around it is not free. For a business with 20 to 30 employees, the hidden costs add up quickly:
| Cost item | Excel or paper | NoBadge |
|---|---|---|
| Admin time | About 10 hours a week collecting, checking and totalling | 2–3 hours a week, mostly reviewing exceptions |
| Error rate | Around 15% of manual timesheets contain errors | Times recorded at the tap, with position; no retyping |
| Payroll mistakes | €1,500–€2,000 a year | Hours and overtime calculated automatically |
| Total admin cost | €12,000–€14,000 a year | Around 70% less admin time |
| Proof of presence | None: the sheet shows what was typed | GPS position at clock-in or dynamic QR code on site |
| Software cost | €0 | €5,04 per active user per month; the total varies with who clocks in |
NoBadge pricing follows your team: if 10 employees clock in this month you pay for 10, if only 2 clock in next month you pay for 2, and if nobody clocks in you pay €0. There is no hardware, whereas a single badge terminal costs €800–€2,000.
NoBadge typically pays for itself in under 30 days for a 20–30 person team, because cutting about 10 hours of weekly admin to 2–3 hours is worth far more than the subscription.

Excel timesheets and the law
No law forbids spreadsheets. What the law cares about is whether your records are adequate, accurate and secure.
Working time records
In the UK, the Working Time Regulations 1998 require records adequate to show that the 48-hour average limit and night-work limits are respected, kept for two years. Across the EU, the Court of Justice's 2019 ruling in case C-55/18 requires an objective, reliable and accessible system for recording daily working time, implemented differently in each country. A spreadsheet can meet these requirements, but a file anyone can edit after the fact, with hours typed from memory, is weak evidence in a dispute. Our Working Time Regulations UK guide explains what "adequate records" means.
Data protection
Time records are personal data under GDPR and the UK GDPR. A workbook emailed around, saved on personal laptops or left in an open shared folder is hard to reconcile with the security and storage limitation principles. Restrict access, set a retention period and delete old files when it expires. Read more in GDPR and employee time tracking.
Six signs you have outgrown Excel
- You have 10 or more employees. Collecting and checking 10+ timesheets every week becomes a part-time job.
- Your team works on several sites. A spreadsheet cannot show where someone actually was when they started. A GPS time clock records the position at clock-in and checks it against the site's geofence.
- Leave requests arrive everywhere. WhatsApp, email and sticky notes lead to clashes and wrong balances. A leave management tool keeps requests, approvals and balances together.
- Pay queries are increasing. If employees regularly question their hours, the data is not trusted.
- You worry about compliance. Records reconstructed at the end of the week are hard to defend.
- Month end takes a whole day. If preparing hours for payroll takes more than a couple of hours, the spreadsheet is costing you money.
Moving from Excel to an app
Switching does not mean changing your payroll process: NoBadge exports the same kind of Excel file your accountant already uses. The difference is that the data is collected at the moment people start and finish work.
- Create your account. No credit card, 15-day free trial, ready in about 2 minutes.
- Add your sites and team. Set a geofence for each site and invite employees by WhatsApp or email link.
- Clock in from the phone. NoBadge runs in the browser of any Android phone or iPhone, with no app store download. Employees clock in by GPS or by scanning a dynamic QR code that changes every few seconds.
- Export for payroll. Hours, overtime and absences are totalled automatically and exported to Excel in one click.
A sensible approach is to run both in parallel for one pay period, compare the totals, then retire the spreadsheet. Keep the old files for as long as your record-keeping rules require.
"We simplified attendance management for teachers, tutors and admin staff across multiple sites. We save hours every week compared to the old Excel sheets." — Claudio Querelante, Director, Accademie AIEM