A free holiday tracker spreadsheet. And a way out of it.
If a spreadsheet is enough for now, use ours: it counts working days, knows the UK bank holidays and keeps balances straight. When it stops being enough, the six steps below move you to LeaveWise in about an hour.
A tracker that does the counting for you.
Four sheets, no macros, works in Excel, Numbers and Google Sheets. Free, no email address required.
- Working days per booking, skipping weekends and bank holidays for your region
- Bank holidays for this year and next, from GOV.UK, for England & Wales, Scotland and Northern Ireland
- Entitlement, carry-over, adjustments, days used and remaining per person
- Half days, leave types, approval status and who approved
- A “starting balances” sheet that becomes your checklist if you move to LeaveWise
22–31 December is 8 weekdays, but Christmas Day and the Boxing Day substitute are not charged, so it costs 6. Easter Thursday to Tuesday costs 2. The sheet works that out; you do not.
From the sheet to LeaveWise in six steps.
There is no spreadsheet import in LeaveWise yet, and we would rather tell you that than pretend. The steps are quick because the sheet already holds everything you need.
- 1
Tidy the sheet first.
One row per person with their email, department, days per week, entitlement, carry-over, any adjustment and the days used so far. The template’s “Starting balances for LeaveWise” sheet is exactly this list.
- 2
Create the team and pick the leave year.
Set the leave year to match the sheet (January or April are the usual ones), choose your bank-holiday region and whether bank holidays are deducted.
Set your leave year - 3
Add leave types or a policy.
A policy bundles the entitlement; 25 days annual leave, say. Assign it to everyone it applies to, then handle the exceptions individually.
Leave types vs leave policies - 4
Invite people and set working patterns.
Invite by email. For part-timers, set the days they work on their profile so requests are counted on their pattern and pro-rata applies.
Part-time working patterns - 5
Set each starting balance with an adjustment.
For each person, add an adjustment for the difference between the policy entitlement and what the sheet says they have left, with a reason such as “balance brought over from spreadsheet”. The reason is kept on the record.
Adjustments and time off in lieu - 6
Book the leave already approved.
Add upcoming approved leave on each person’s behalf so Who’s Out is right from day one. Past leave is already reflected in the starting balance, so it does not need re-entering.
Book leave on behalf of someone
What the sheet will never do.
It cannot stop two people in the same department booking the same week, send a request to the right manager, or tell you who approved what six months ago. It cannot show a part-timer the days they will actually be charged before they ask. And every year-end means an afternoon of reconciliation.
- Coverage warning before a manager approves
- Requests routed to the department manager
- Cost shown before the request is sent
- Audit log of who changed what
- Year close with carry-over, no reconciliation

Can we import existing balances?
Set each person's starting position with an adjustment and a reason, or assign a policy. There is no spreadsheet import yet.
How do we get set up?
Create your team, add leave types or assign a leave policy, set your working days and invite your people. You can set existing balances with an adjustment and a reason.
Can our leave year run April to March?
Yes. Choose your leave-year start in Team Settings. Balances and reports follow that year, and you can book leave up to the end of the next leave year.
What about part-timers on different days?
Set each person's working pattern. Leave is counted only on the days they work, and pro-rata can be switched on to calculate a proportional entitlement.
How much does leave management software cost for a small UK business?
LeaveWise is £4.99 a month for up to 5 users, £9.99 for 12, £14.99 for 20 and £39.99 for 100, billed monthly with no contract or setup fee. Most HR platforms charge per employee per month, which costs a 10-person team several times more.
Ready to retire the sheet?
Every feature on every plan, from £4.99 a month for five people. Monthly billing, no contract.