A spreadsheet is a good way to track leave for a small team. It's free, everyone understands it, and it does exactly what you tell it to. It stops working when the team, the rules or the number of people touching it grow past what one person can keep straight.
Signs it has stopped working
- The spreadsheet isn't where leave is decided. Requests arrive by email, chat or in passing, and are typed in later. The file records decisions; it doesn't hold them.
- Only one person can safely edit it. When they're away, nobody books leave, or someone books it and the formulas break.
- Balances need explaining. Someone asks "why do I have 6.5 days left?" and the answer means scrolling through a year of cells.
- Part-timers and public holidays need their own formulas. Pro-rating, and charging part-timers only for the public holidays on their working days, is where spreadsheets usually go wrong. See part-time holiday entitlement.
- Clashes are spotted late. Two people with the same skill book the same week, and you find out when the work doesn't get done.
- Carry-over is done by hand at the end of the year, from memory or a second tab.
One of these on its own is a reason to tidy the file. Three or more is usually a reason to move.
Keeping the records
In many countries, leave records are something an employer has to keep, often for years, not just something useful to have. How long depends on the law where your people work, so check the rule for each country your team is in.
A spreadsheet can meet that, if it's kept, backed up and not overwritten each year. Many aren't: last year's tab gets copied, cleared and reused.
What to look for in a replacement
- Balances that show how they add up. Every change to a balance, with who made it, when and why, so you can answer "why this number?" without a spreadsheet.
- Part-time rules built in. Allowances pro-rated from each person's working week, and public holidays handled on top of the allowance or as part of it.
- Cover checks before approval. A warning when approving would leave a team, role or skill short.
- Your history comes with you. An import that checks every row before saving, so you can see what didn't match.
- A way out. A full export of your records, so you're never locked in.
How to move
- Decide which file is the authoritative one, and which bookings are already approved.
- Agree each person's opening balance before the move. See checking opening leave balances.
- Turn the calendar grid into a list: one row per booking, with who, which leave type, first day and last day.
- Pilot with a few people, including a part-timer and someone with leave already booked.
- Keep the old file, read-only, for as long as you need it for your records.
The switching checklist covers each step.
Sources
- GOV.UK, Holiday pay (record keeping from 6 April 2026)
- Acas, Keeping records of holiday
- Acas, Checking holiday entitlement
This is general guidance, not legal advice: for a decision about a particular person, check the sources above or take advice.