AEVOMIND INSIGHTS — HR & PEOPLE
Staff holiday and absence tracking: spreadsheet or HR system?

For a small team on regular hours, a holiday spreadsheet can work. Since 6 April 2026, though, the record itself is a legal duty: Acas says holiday and holiday pay records must be kept for at least six years. In an illustrative business with 25 staff, an HR system saves under an hour a week; the stronger case is a record that is complete and still there in six years.
The short answer
For a small team on regular hours, a holiday spreadsheet can work. It stops working when more than one person edits it, when some staff work irregular hours, or when managers cannot see who else is off before they say yes. And since 6 April 2026, the record itself has become a legal duty: Acas says employers must keep holiday and holiday pay records for at least six years.
The time saved by an HR system is real but modest — in our illustration, under an hour a week for 25 staff. The stronger case is a record that is complete, consistent and still there in six years. This article covers the rules a tracker must handle, the record you now have to keep, the arithmetic, and the signs a spreadsheet has had its day.
The rules a holiday tracker must handle
- Entitlement. GOV.UK says almost all workers are entitled to 5.6 weeks’ paid holiday a year — at least 28 days for most people on a 5-day week, with statutory paid holiday limited to 28 days.
- Bank holidays. An employer can choose to include them in statutory leave, so the tracker must know which way your contracts go.
- Irregular hours and part-year workers. For leave years beginning on or after 1 April 2024, holiday builds up at 12.07% of hours actually worked in each pay period — 5.6 weeks of leave divided by the 46.4 weeks worked in a 52-week year, as GOV.UK explains.
- Carry-over and payments in lieu, which now have to be recorded as well as worked out.

The record you now have to keep
Acas says that from 6 April 2026 employers must record holiday taken, holiday carried over from previous years, holiday pay and any payments in lieu, and keep those records for at least 6 years from the date they were made. It adds that being unable to show holiday records could be a criminal offence, and that the Fair Work Agency will be given enforcement rights.
A spreadsheet can hold that, but it has to survive six years of edits, copies and leavers’ files. An HR system keeps the history by design, with an audit trail of who changed what. Take your own advice on how the rules apply to your contracts.

The arithmetic
Take an illustrative business with 25 staff, five of them on irregular hours. Each person books about eight separate periods of holiday a year, is off sick about twice, and asks a few times how much leave they have left.
Illustrative inputs, not client data: 8 holiday requests per person a year at 9 minutes (3 with a system); 2 absences per person at 15 minutes (6); 4 balance questions per person at 6 minutes (staff check their own); irregular-hours holiday worked out monthly at 10 minutes a person (1). Totals: 62.5 hours a year, 16.0 with a system.
Show the data
| Spreadsheet | HR system | |
|---|---|---|
| Handling holiday requests | 30.0 hrs | 10.0 hrs |
| Logging absence and return to work | 12.5 hrs | 5.0 hrs |
| Answering “how much have I got left?” | 10.0 hrs | 0.0 hrs |
| Working out irregular-hours holiday | 10.0 hrs | 1.0 hrs |
That comes to about 62.5 hours a year on the spreadsheet against 16.0 with an HR system that handles requests, checks cover, applies the 12.07% rule and lets staff see their own balance — about 46.5 hours back, or a little under an hour a week. That is honest but small, which is why the record matters more than the minutes.

Signs a spreadsheet has had its day
- Several people edit it, and nobody is sure which copy is right.
- Irregular-hours staff need their holiday worked out every pay period.
- Managers approve leave without seeing team cover.
- Staff ask HR for their balance instead of looking it up.
- Absence and fit notes are tracked somewhere else, or not at all. GOV.UK says a fit note is needed after more than 7 days’ sickness in a row.
Any two of these usually mean it is time for an HR and people system.
Where AI is heading in HR
The workforce is ahead of the paperwork. In the Office for National Statistics’ surveys, 55% of working people in Great Britain reported using AI for work or education in May to June 2026, while 34.9% of UK businesses with ten or more employees reported using AI. The two come from different surveys and are not directly comparable, but the gap is a reason to write down how staff may use AI at work. And when businesses act on AI skills, they mostly train the people they have.
Source: Office for National Statistics, Artificial intelligence in UK businesses: 2023 to 2026 (July 2026), Business Insights and Conditions Survey. Open Government Licence v3.0. Businesses may report more than one approach.
Show the data
| Training or retraining existing staff | Automating or replacing roles with AI | |
|---|---|---|
| 0 to 9 employees | 31.7% | 12.0% |
| 10 to 49 employees | 35.6% | 8.2% |
| 50 to 99 employees | 42.2% | 10.2% |
| 100 to 249 employees | 43.0% | 7.6% |
| 250 or more employees | 41.7% | 9.7% |
In an HR system, the useful applications are practical: answering routine policy questions from your own handbook, spotting a request that clashes with team cover, and drafting a return-to-work note for a manager to check. None of it replaces the conversation a manager should have; it removes the admin around it.

What an HR system should connect to
Holiday and absence records are most useful when other systems can read them: scheduling, so nobody is booked while away (see scheduling in a spreadsheet and operations and scheduling); payroll, so holiday pay is calculated from the same record; and single sign-on, so staff use one login. The general case for joining systems up is in why businesses end up running a dozen disconnected tools.
Frequently asked questions
How much paid holiday are UK workers entitled to?
GOV.UK says almost all workers are legally entitled to 5.6 weeks' paid holiday a year. Most workers on a 5-day week must receive at least 28 days, and statutory paid holiday is limited to 28 days. An employer can choose to include bank holidays as part of that statutory leave, so a tracker needs to know which approach your contracts take.
How is holiday worked out for irregular-hours workers?
For leave years beginning on or after 1 April 2024, holiday for irregular-hours and part-year workers builds up at 12.07% of the hours actually worked in each pay period. The figure comes from 5.6 weeks of leave divided by the 46.4 weeks worked in a 52-week year. A system can apply it every pay period automatically; a spreadsheet needs someone to do it.
How long must employers keep holiday records?
Acas says that from 6 April 2026 employers must keep records of annual leave and holiday pay, including holiday taken, holiday carried over, holiday pay and any payments in lieu, for at least 6 years from the date they were made. It adds that being unable to show holiday records could be a criminal offence, and that the Fair Work Agency will be given enforcement rights.
Is a spreadsheet good enough for tracking staff holiday?
For a small team on regular hours it can be, provided it records everything the law now requires and is kept, intact, for six years. It stops being good enough when several people edit it, when irregular-hours staff need monthly calculations, when managers cannot see team cover before approving, or when nobody is sure which version is the real one.
When does an employee need a fit note?
GOV.UK says employees must give their employer a fit note if they have been ill for more than 7 days in a row and have taken sick leave. For 7 days or less they do not need a fit note. An absence tracker should prompt for the fit note on the eighth day rather than relying on someone to remember.