AEVOMIND INSIGHTS — HR & PEOPLE

Staff holiday and absence tracking: spreadsheet or HR system?

10 October 2026 · 8 min read · By the AevoMind team

A brass desk calendar with blank pages beside a brass suitcase and a sun ornament, with small figures carrying luggage

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

A wall grid of frosted-glass squares, some tinted green and two tinted gold, with small figures standing in front of it
Team cover at a glance is what a manager needs before approving a request, and what a spreadsheet rarely shows.

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.

An open brass-bound ledger with blank ruled pages, a brass fountain pen and a small brass abacus on green velvet
Six years of holiday records, kept by hand, is a lot of ledger to trust.

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.

Where the hours go in a holiday spreadsheetIllustrative business with 25 staff, 5 of them on irregular hours: hours a year, spreadsheet versus an HR system
SpreadsheetHR system
Handling holiday requests30.0 hrs10.0 hrs
Logging absence and return to work12.5 hrs5.0 hrs
Answering “how much have I got left?”10.0 hrs0.0 hrs
Working out irregular-hours holiday10.0 hrs1.0 hrs

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
SpreadsheetHR system
Handling holiday requests30.0 hrs10.0 hrs
Logging absence and return to work12.5 hrs5.0 hrs
Answering “how much have I got left?”10.0 hrs0.0 hrs
Working out irregular-hours holiday10.0 hrs1.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.

A small figure in a coat and woolly hat carrying a brown suitcase past a white and gold desk with a softly glowing screen
Approved, recorded and covered: the request is the easy part when the system already knows who else is away.

Signs a spreadsheet has had its day

  1. Several people edit it, and nobody is sure which copy is right.
  2. Irregular-hours staff need their holiday worked out every pay period.
  3. Managers approve leave without seeing team cover.
  4. Staff ask HR for their balance instead of looking it up.
  5. 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.

Businesses train staff for AI far more often than they replace rolesShare of UK businesses reporting each approach to AI-related skills, by number of employees, June 2026
Training or retraining existing staffAutomating or replacing roles with AI
0 to 9 employees31.7%12.0%
10 to 49 employees35.6%8.2%
50 to 99 employees42.2%10.2%
100 to 249 employees43.0%7.6%
250 or more employees41.7%9.7%

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 staffAutomating or replacing roles with AI
0 to 9 employees31.7%12.0%
10 to 49 employees35.6%8.2%
50 to 99 employees42.2%10.2%
100 to 249 employees43.0%7.6%
250 or more employees41.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.

An ornate brass balance scale with small stacks of tokens on each pan, hanging perfectly level
Entitlement and time taken, kept in balance by the system rather than by memory.

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.