HR Software vs Spreadsheets for a Growing UK Team: When It’s Time to Make the Switch
This article contains affiliate links. If you purchase via a link on this page, we may earn a commission at no extra cost to you.
The Threshold Argument Only Works If the Cost Is Right
The case for moving from spreadsheets to HR software is a cost-benefit calculation: at some headcount, the admin burden and legal exposure outweigh the subscription. That is the right way to think about it, and it depends entirely on getting the subscription figure right.
So before the framework, the number that decides it. BambooHR charges companies with 25 or fewer employees a flat monthly fee, not a per-employee rate. That is $250 a month for Core, roughly £200, whether you have ten employees or twenty-four. Not £5 to £9 per employee per month, which would put a ten-person team around £70.
That matters because ten employees is exactly where most switching advice, including earlier versions of this one, tells you to buy. At ten employees BambooHR costs about £20 per head. A UK-built alternative covering the same headcount costs £24 in total.
The threshold argument survives this correction. The recommendation changes.
What Spreadsheets Genuinely Handle
Being fair to Excel and Google Sheets first, because the honest answer is that they are fine for a while.
- Basic headcount tracking — names, job titles, start dates, contract types
- Simple holiday logging — a shared tab works at five or fewer people
- Payroll inputs — passing hours or salary figures to your accountant or payroll provider
- Training records — course completion and certification expiry dates
Under roughly eight employees, with a stable workforce on a single site, a disciplined spreadsheet carries no significant risk.
The problem is that discipline degrades. The spreadsheet that was properly maintained until the person who owned it changed roles is not a record-keeping system — it is a file that resembles one.
Where Spreadsheets Start Creating Real Risk
Statutory Record-Keeping
UK law is specific about what you keep and for how long:
- PAYE records — at least three years from the end of the tax year they relate to, with six years as best practice
- Working time records — two years, under the Working Time Regulations 1998
- Accident records — three years, under RIDDOR
- Maternity, paternity and adoption pay records — three years after the end of the tax year
- Right-to-work evidence — the duration of employment plus two years
- Pension records — six years
None of this requires software. What it requires is that the record exists, is accurate, and can be produced.
And it now has to stay retrievable for twice as long. Since 1 October 2026, the time limit for bringing most employment tribunal claims extended from three months to six. Whatever your retention policy was built around, the window in which someone can make a claim against the records has doubled.
UK GDPR and Employee Data
Employee data is personal data, and a shared spreadsheet tends to fail on four obligations at once.
Access control. If your office manager can open a tab containing salary history or medical adjustments, you do not have access control. Row-level permissions in a spreadsheet are theoretical for most businesses.
Data minimisation. Spreadsheets accumulate columns. The note someone added three years ago about an employee’s personal circumstances is data you hold without a clear basis for holding it.
Subject access requests. The deadline is one month from receipt, not thirty days — and it can be extended by a further two months where the request is complex or where you have received a number of them, provided you tell the individual within the first month. Assembling a complete, accurate response from scattered spreadsheets is where small employers miss it.
Breach detection. If the file is emailed to the wrong person or copied to a personal laptop, nothing tells you.
The ICO’s employment practices and data protection guidance sets out the expectations, and they are higher than most small employers assume.
One obligation most small employers have not yet caught up with: since 19 June 2026, under the Data (Use and Access) Act 2025, you must operate a data protection complaints procedure. Individuals are expected to complain to you before escalating to the ICO, which means an accessible route to complain, acknowledgement within 30 days, and a prominent link from your privacy notice. That is a process obligation rather than a software one, but it is a sign of the direction: the expectation is that you can demonstrate a system, not improvise a response.
Right-to-Work Evidence
Every employer must check that every employee has the right to work before employment begins, including British and Irish citizens.
The penalties, which the usual version of this article omits:
- £45,000 per illegal worker for a first breach
- £60,000 for a repeat breach within three years
Both are starting points before mitigation. Where an employer knew or had reasonable cause to believe someone was disqualified, criminal liability runs to five years’ imprisonment and an unlimited fine.
There are three compliant methods, and one is narrower than usually described:
- Manual document check — inspect originals from List A or List B, copy them, record the date
- Home Office online service — via share code, for anyone with an eVisa or settled or pre-settled status
- IDVT through a certified provider — for British and Irish citizens holding a valid passport only
IDVT is not a general-purpose remote-checking route. Describing it as something you use “in some cases for remote checks” invites exactly the wrong conclusion for a remote hire who is neither British nor Irish — for them, the online share code service is the route. The GOV.UK employer’s guide to right to work checks is the definitive reference.
And it reaches contractors now. For engagements starting on or after 1 October 2026, prescribed checks extend beyond employees to people engaged under a worker’s contract and to individual subcontractors, with liability that can reach up a contractual chain. If you engage subcontractors, our guide to hiring subcontractors covers how this sits alongside employment status and CIS.
The distinction that decides whether software helps: storing a passport scan is not a check. The statutory excuse comes from carrying out a prescribed check before employment starts and holding evidence that it happened. What a system contributes is making it a required step before the start date, logging who did it and when, and setting expiry reminders for time-limited permission.
The Absence Types That Actually Break a Spreadsheet
This is the strongest argument in the article and the list is usually incomplete. A growing team generates:
- Annual leave, including carryover rules and the 28-day cap on 5.6 weeks
- Sick leave, with SSP
- Maternity, paternity, shared parental and adoption leave — note that parental leave became a day-one right on 6 April 2026
- Time off for dependants — a day-one right to a reasonable amount of unpaid time off for unexpected events involving a dependant, under sections 57A and 57B of the Employment Rights Act 1996
- Carer’s leave — one week per 12 months, unpaid, a day-one right since 6 April 2024. A “week” means the time the employee normally works over seven days, so a three-day-a-week employee gets three days. Employees give notice of twice the number of days requested, or three days for longer periods. You cannot refuse it, only postpone it where operations would be unduly disrupted, with written reasons and revised dates.
- Neonatal care leave — up to 12 weeks, a day-one right since 6 April 2025, on top of maternity or paternity leave
- Compassionate leave, jury service, unpaid leave, fit notes and phased returns
Two corrections worth making explicitly, because they appear in most versions of this list.
Time off for dependants is not a creation of the Employment Relations (Flexible Working) Act 2023. It long predates it, under the Employment Rights Act 1996. The 2023 Act governs flexible working requests — raising the limit to two requests in any 12-month period, cutting the employer response deadline from three months to two, requiring consultation before refusal, and removing the requirement that the employee explain the business impact. Different right, different statute, different process.
And SSP changed fundamentally in April 2026. Since 6 April 2026 it is payable from day one — the three waiting days are gone — the lower earnings limit has been removed, those earning below the former threshold receive 80% of weekly earnings, and the rate for 2026/27 is £123.25. Any absence process built to start recording at day four is now recording the wrong thing.
When two of these overlap — a phased return from sickness interrupted by two days of carer’s leave — you need to know which applies, what pay attaches, and whether SSP is running or paused. That is where spreadsheets stop being reliable, and it is a stronger point than the holiday-clash example usually given. Our guide to UK holiday and absence tracking covers how one platform handles the configuration.
HR Software vs Spreadsheets: The Switching Threshold
A framework rather than a feeling. Switch when any one of these is true.
1. You have 10 or more employees. Manual tracking starts consuming real hours and the probability of a consequential error rises.
2. You have had your first absence or holiday dispute. Once someone questions a figure, you need to evidence your position. This gets sharper on 1 January 2027, when the unfair dismissal qualifying period falls from two years to six months for dismissals on or after that date. The documented evidence you would rely on now has to exist within six months of hire rather than two years.
3. You have hired a remote or hybrid team member. Remote right-to-work checks and asynchronous absence management are genuinely hard without a central system — and note the IDVT restriction above, which catches remote hires who are not British or Irish.
4. You have crossed 50 employees. Correcting the usual muddle here: gender pay gap reporting applies at 250 employees, not 50. What actually happens at 50 is the Information and Consultation of Employees Regulations 2004, which apply to undertakings with 50 or more employees averaged over the preceding 12 months. They are not automatic — the obligation triggers on a written request from at least 2% of the workforce, minimum 15 employees — but once triggered you must arrange election of representatives and negotiate a written agreement within six months, and non-compliance with a Central Arbitration Committee order can reach a £75,000 penalty.
5. You have received a subject access request or any HMRC enquiry touching employee records. Your record-keeping is going to be scrutinised. Fix it before the next one.
If two or more apply, you waited too long.
What It Actually Costs
The corrected figures, monthly, excluding VAT where UK-priced:
| 10 employees | 25 employees | |
|---|---|---|
| Breathe HR (Micro/Regular band) | £24 | £99 |
| Charlie HR (banded) | Band varies from £21 | Band varies |
| Sage HR (£5/employee, core module) | £50 | £125 |
| BambooHR Core | ~£200 flat | ~£200 flat |
The structural point worth understanding, because it tells you exactly when BambooHR becomes sensible. Its flat fee below 26 employees means the per-head cost falls as you grow into it. At ten employees you are paying around £20 a head. At twenty-five, the same £200 is about £8 a head — which is precisely the per-employee rate BambooHR charges above 25.
So BambooHR’s value inflects at roughly 25 employees. Below that you are paying a premium that gets steeper the smaller you are. At and above it, the flat fee and the per-employee rate converge and the product’s depth starts earning its price.
Which means the honest answer to “should I switch at 10 employees?” is yes — but not to BambooHR.
The Options, Priced Properly
Breathe HR — the answer at the article’s own threshold
Banded by headcount: Micro £24 for 1–10 employees, Starter £44 for 11–20, Regular £99 for 21–50, ex-VAT. UK-built, so holiday rules, Bradford Factor tracking and UK document templates are native rather than configured. Fourteen-day trial.
At ten employees, £24 total against BambooHR’s £200. No payroll or RTI — it syncs to payroll software such as Xero, and you run payroll elsewhere. Our Breathe HR review goes deeper.
Charlie HR — comparable, with a cheap way in
Core from £21 a month for 1–4 people, banded upward, with 75% off the first six months. UK employment law as the default. No free plan, despite what circulates. Seven-day trial. Our Charlie HR and BambooHR comparison sets them against each other.
Sage HR — cheapest per head, modular
£5 per employee per month ex-VAT for the core module, with scheduling, performance and timesheets priced separately. No seat minimum. Cheapest at three or four people; the modular structure means the headline understates what most businesses end up paying.
BambooHR — strong above 25
BambooHR prices in three tiers:
| Plan | 25 or fewer | More than 25 |
|---|---|---|
| Core | $250/month flat | $10 per employee |
| Pro | $425/month flat | $17 per employee |
| Elite | $650/month flat | $25 per employee |
The plans are Core, Pro and Elite. Essentials and Advantage are retired names still widely quoted. Pricing is published — in US dollars, with no GBP option, so your invoice moves with the exchange rate.
What it does well is real: centralised records with audit trails, onboarding workflows, document storage with expiry alerts, reporting that makes a SAR response manageable, and an interface non-HR managers use without training. Above 25 employees, where per-employee pricing starts, that package is competitive and the depth tells.
The limitation to budget for: BambooHR’s payroll module is built for the US market only. This is not a question of UK integrations being thin — there is no UK payroll in the product, so PAYE, National Insurance, auto-enrolment and RTI need a separate provider. Our payroll comparison covers the options, and our buying checklist covers what to settle before committing. For the wider field, see our BambooHR alternatives comparison.
Personio and HiBob
Both aimed higher — Personio for businesses scaling past 200 with stronger recruitment and performance modules, HiBob for engagement and culture features in hybrid teams. Neither publishes UK pricing, so both are quote-only. Worth a look well above the threshold this article is about.
The Compliance Calendar You Are Buying Into
Whatever you choose, these land inside a typical first contract term:
- Already in force: tribunal time limits at six months since 1 October 2026; right-to-work checks extended to individual subcontractors from the same date; SSP from day one since 6 April 2026; the DUAA complaints duty since 19 June 2026
- 1 January 2027: unfair dismissal qualifying period falls to six months
- January 2027: written statements of particulars must inform workers of their right to join a trade union, in wording the government will prescribe, for new joiners and as an annual reminder. Breach costs two to four weeks’ pay, capped at £3,004 — so your onboarding template needs updating.
Ask any vendor whether their UK templates will be updated for January, or whether that is your job.
FAQ
Do I legally need HR software in the UK?
No. You are legally required to keep accurate, secure, accessible employee records. Software makes that easier to evidence; it is not itself an obligation.
Is a spreadsheet UK GDPR compliant for employee data?
It can be in principle — the UK GDPR does not mandate software. In practice most shared setups fail on access control, data minimisation and breach detection. The standard is “appropriate technical and organisational measures,” and a password on a shared drive rarely meets it.
What does BambooHR actually cost a ten-person UK business?
Around £200 a month — the flat $250 Core fee that applies to any company with 25 or fewer employees. Not £50 to £90. The flat structure means a three-person business pays the same as a twenty-four person one.
What is the cheapest credible option at ten employees?
Breathe HR at £24 a month ex-VAT, which covers 1–10 employees in one band. Charlie HR is comparable. Sage HR is around £50 at that size on core module only.
How long do I keep employee records?
PAYE at least three years from the end of the tax year, six as best practice. Working time records two years. RIDDOR accident records three years. Right-to-work evidence employment plus two years. Pension records six years. Note that tribunal claims can now be brought within six months rather than three, so records need to stay retrievable longer than your policy may assume.
How quickly must I answer a subject access request?
Within one month of receipt, extendable by a further two months for complex or numerous requests, provided you tell the individual inside the first month.
What absence types do people forget to set up?
Carer’s leave — one week unpaid per 12 months, a day-one right since April 2024, which you can postpone but not refuse. And neonatal care leave — up to 12 weeks, a day-one right since April 2025. Both are commonly missing from leave-type lists.
Can HR software help with Making Tax Digital?
Not directly. MTD governs VAT and income tax reporting and belongs to your accounting software — MTD for Income Tax has applied since April 2026 above £50,000 of qualifying income. What matters on the HR side is RTI, and only platforms that actually run UK payroll submit it.
The Bottom Line
Spreadsheets are a reasonable start. Under eight employees with stable headcount, there is no urgent case for spending money.
Past ten, or after your first absence dispute, first remote hire, or first subject access request, the calculation turns — and it turns harder than it used to. Tribunal claims now have a six-month window. Unfair dismissal protection arrives at six months’ service from January 2027. The absence types you have to track correctly include two day-one rights introduced since 2024 that most lists still omit.
So switch at ten. Just switch to something priced for ten. Breathe HR at £24 a month covers up to ten employees, is built around UK employment law, and does not change price as you hire into the band. Charlie HR is a close equivalent with a cheap first six months.
BambooHR is a genuinely good platform and the recommendation changes at scale, not in kind. Its flat fee means it costs about £20 per head at ten employees and about £8 at twenty-five, where it converges with its own per-employee rate. Above 25 people, its depth, audit trails and onboarding workflows justify the price. Below, you are paying a premium for capability you have not yet grown into — and you will still need a separate UK payroll provider either way.
Map your own headcount against that inflection point, and buy for the size you are rather than the size you plan to be.
Pricing and features correct at time of writing. Plans and capabilities are subject to change — always confirm current details on the provider’s website before purchasing. BambooHR publishes in US dollars, so sterling costs move with the exchange rate. This article is general information about UK employment and data protection obligations, not legal advice; check the current position with Acas, the ICO, GOV.UK or a qualified adviser before relying on anything here.