Annual Leave Tracker Excel - Free Template

1. Open the Leave Log sheet and enter each employee’s ID, name, department and location. Add the leave year start and end dates so every request sits in the right period.
2. Record the leave dates, leave type and working days taken. If an employee takes 5 working days from 12/01/2026 to 16/01/2026, enter 5 in the Working Days Taken column.
3. Fill in the annual entitlement and any carry forward days. For example, 25 days plus 2 carried forward gives a total allowance of 27 days.
4. Update the approval status, approver and notes. Use Notes for details such as school holidays, half-days or a medical appointment.
5. Check the Days Remaining, Utilisation % and Warning Flag columns. Use them to see who is close to their allowance and who still has enough time left.
6. Review the Summary Dashboard regularly. It gives you a quicker read on the team than scanning the log line by line.
7. Use the Instructions sheet if you need to reset the file for a new leave year. Keep the same structure so comparisons stay consistent.

This template suits the people who actually have to keep leave under control: an office manager in a 12-person firm, a bookkeeper at a Ltd company, or a charity treasurer covering school holiday periods. If three staff want the same week off in August, you need one sheet that shows entitlement, approvals and remaining days without guesswork.

The Leave Log is set up for one request per row, so you can track a worker across the full leave year. Image 1 shows the core fields: employee ID, name, department, location, employment type, leave year start and end, entitlement, carry forward, leave dates, leave type, working days taken, approval status, approver, notes, days remaining, Utilisation % and warning flag.

Who uses it and when

A sole trader with 4 employees usually starts paying attention when the summer rota fills up or when someone books Christmas off. A builder’s office might have 2 joiners, 1 labourer and 1 admin assistant all needing the same Friday, so you need the numbers in front of you before the week is lost.

Why the dashboard matters

Image 2 gives you a quicker view for month-end and planning meetings. If one employee has used 22 of 25 days by September, you can see the pressure early and reassign cover before it turns into an absence problem.

How the instructions sheet helps

Image 3 is there for first-time users or cover staff. That matters in real life, because leave records are often picked up by someone else during holidays, sickness or a busy year-end close.

Annual leave itself sits under UK employment law, and the record-keeping side matters when you are proving what has been booked and paid. The statutory holiday entitlement is 5.6 weeks a year for full-time staff, which is 28 days for someone working a 5-day week, and part-time staff get the pro-rata equivalent.

For payroll records, you need enough detail to show that holiday pay has been handled correctly under PAYE and National Insurance. If a worker takes 5 days off and your tracker says 5 days were approved, the leave log should line up with the payroll run and any holiday pay paid through RTI.

Record retention and audit trail

Companies should keep payroll and employment records for 6 years, and that includes holiday records where they support pay and entitlement calculations. For sole traders, the safer working practice is to keep the record set for at least 5 years after the 31 January Self Assessment deadline, because holiday pay can feed into business cost reviews and dispute handling.

Useful working example

If a team has 8 employees on 25 days’ entitlement and each person books 20 days, that is 160 days of leave to schedule across the year. A simple tracker makes it obvious whether July and August are already overloaded, rather than finding out when three people are already away and the phones are ringing.

When this becomes a control sheet

If you are running a VAT-registered business, the leave tracker also supports month-end discipline. A 4-person office that loses 2 staff for a full week can easily delay invoicing, credit control and bank reconciliations, so the holiday record is not just HR admin — it is part of keeping the business moving.

The most common problem is not having a single version of the truth. One manager keeps approval in email, another keeps a paper diary, and payroll is still working from last month’s spreadsheet, so an employee ends up with 2 extra days paid or loses a day they were entitled to take.

Overlaps and double-booking

If 2 key staff are approved for the same week and no one spots it, the cost is usually overtime or lost output. In a small trades firm, replacing one absent person for 5 days at even £120 a day in temporary cover is £600 before you count the management time.

Wrong balances create real disputes

A balance that is 1 day out sounds minor, but it becomes an argument fast when someone is leaving, carrying leave forward or querying their final payslip. A 28-day allowance with 3 days carried over should show 31 available days; if the tracker only shows 30, that missing day can turn into a grievance or a corrected payroll run.

Approvals that are not recorded

If a request is not marked as approved, the employee may assume it is fine and book travel or childcare. When the manager later refuses it, you end up with frustration, re-planning and, in some cases, a rushed unpaid absence because the date was already committed elsewhere.

Letting the log drift from reality

The tracker only works if it is updated as soon as leave is agreed. A month of delay can leave you with 10 or 15 unposted requests, and by then the dashboard is already misleading when you need it most.

The easiest way to keep this alive is to tie it to an existing routine, not to hope someone remembers it later. For most small businesses, the best hook is the weekly team meeting, the payroll cut-off or the Friday rota check.

Practical habits that stick

• Update approved leave every Friday before close of business.
• Copy the previous month’s review pattern so nothing is missed.
• Use the warning flag as soon as someone nears the last 5 days of entitlement.
• Check the dashboard before you approve a new request in a busy period.

Small shortcuts that save time

Use the same leave year dates for everyone in the current cycle, then roll them forward once a year. If you are managing 15 staff and each one books 6 requests a year, that is 90 entries — so even a 30-second saving per entry gives you nearly 45 minutes back.

When to move beyond a spreadsheet

Once you have multiple locations, shift patterns, or holiday approval linked to payroll and GDPR controls, a dedicated HR system starts to make more sense. Until then, this tracker is a practical control sheet for a small team that needs clarity more than software overhead.