Free annual leave tracker (Excel)
A clean, formula-driven tracker for staff annual leave. Enter each person’s allowance and what they’ve booked — total entitlement and remaining days work themselves out. A bookings log tab keeps the detail.
What’s inside
- • Tracker tab — name, department, allowance, carried-over, booked and remaining.
- • Auto totals — total entitlement and remaining update as you type.
- • Bookings log — record each request with dates, type and status.
- • A Read me tab with quick instructions.
Great for a small team — until it isn’t
A tracker relies on someone updating it every time leave is booked or changed. Miss one and balances drift. Rotaleave lets staff request leave, routes it for approval, and keeps everyone’s balance live — with reports for the numbers HR needs. Working out an allowance first? Try the accrual calculator.
Common questions
What does the annual leave tracker do?
It keeps one row per person with their allowance, any carried-over days, and what they’ve booked. Total entitlement and remaining days calculate automatically, and there’s a separate log for individual bookings.
Do I need to know Excel formulas?
No. The totals are already set up — you just type the allowance, carried-over and booked figures, and the sheet does the arithmetic.
Can I track leave in hours?
The tracker works in days. If your team books holiday in hours (shift or part-time work), that’s exactly where a tool like Rotaleave helps — it tracks allowances to the minute.
More free templates & tools
Live balances beat a spreadsheet
Let staff book, managers approve, balances stay right. Free for 10 or fewer.
Start free