Leave Tracker Spreadsheet (Excel)
An Excel workbook that tracks annual leave or PTO for up to 50 employees. Log each period of leave once and it counts the working days, leaves out public holidays and shows what each person has taken and has left.
Last updated
Excel (.xlsx), four sheets
Format
Works for UK and US teams
Wording
Free
Price
What is in the template
Employees sheet
- Annual allowance and days carried over
- Total available
- Taken (approved annual leave or PTO)
- Pending requests
- Remaining balance
- Approved sick days
Leave log sheet
- Employee, leave type and status chosen from drop-down lists
- First and last day
- Half-day adjustment
- Working days counted automatically, Monday to Friday
Lists sheet
- Leave types you can edit
- Statuses: requested, approved, declined, cancelled
- Public holiday dates to leave out of the count
How to use sheet
- Step-by-step instructions
- What to do at the start of a new leave year
No sign-up needed. Edit it to fit your own policy. It is a general template, not legal advice.
How to use it
- On the Employees sheet, list each person with their annual allowance and any days carried over.
- On the Lists sheet, enter this year's public holidays so they are not counted as leave.
- On the Leave log sheet, add a row for every period of leave and set its status.
- Only approved rows reduce the remaining balance. Requested rows show as pending.
- At the start of a new leave year, save a copy, clear the log and update the allowances.
Where a template stops helping
A form or spreadsheet works for a small team. These are the points where people usually move to leave software.
- It assumes a Monday to Friday week, so part-time and shift patterns need manual adjustment.
- Only one person can safely edit it at a time, and employees cannot see their own balance without access to everyone's.
- Requests still arrive by email or form and have to be typed in.
Redstone HR replaces the form and the spreadsheet: employees request leave online, managers see who else is off before they approve, and balances update on their own.
Frequently asked questions
How do I track employee leave in Excel?
Keep one sheet listing each employee's allowance and one sheet logging every period of leave. Use NETWORKDAYS to count the working days between the first and last day, and SUMIFS to add up each person's approved days. This template is set up that way already.
Does the tracker exclude weekends and public holidays?
Yes. Working days are counted Monday to Friday, and any dates you enter in the public holidays list are left out.
Can I use it for PTO in hours?
The template counts in days. To work in hours, multiply the working days column by the hours in your work day, or record the allowance in days and convert at the end.
How many employees can it handle?
It is set up for 50 employees and 500 leave entries. You can copy the formulas down for more, but a spreadsheet becomes hard to keep accurate as the team grows.
Does it work in Google Sheets?
It is built for Excel. The formulas it uses (NETWORKDAYS and SUMIFS) also exist in Google Sheets, but we have only tested the file in Excel format.
Related templates and calculators
Time Off Request Form Template
A one-page time off request form in Word. The employee fills in the dates and type of time off, the manager records the decision and the remaining PTO balance, and both sign.
Holiday Request Form Template
A one-page holiday request form in Word, worded for UK employers. Staff enter their annual leave dates and cover, and the manager records the decision and the holiday balance left.
Holiday entitlement calculator
PTO accrual calculator
Working days calculator
Stop tracking leave in spreadsheets and email
Try Redstone HR free for 14 days. No credit card, one flat monthly price, and set-up takes about 15 minutes.
“Implementing Redstone HR has reduced our paperwork and administrative tasks by over 70%.”
