Home/Spreadsheets/HR & Employee Trackers/Employee Leave Tracker
Employee Leave Tracker
An employee leave tracker for small teams: set your PTO policy once, log each request as one row, and every vacation, sick and personal balance calculates itself for up to 100 employees. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What it does
- Balances for Vacation, Sick, Personal, Floating and Other: entitled, carried over, accrued, taken, scheduled, pending and remaining
- Accrual upfront, monthly or per pay period, with a probation period and prorating for mid-year hires
- Carryover caps with an expiry date and a use-it-or-lose-it watch list
- Requests with an approval step, late-notice flags and an overlap check
- Team calendar by day and department, plus a 14-day coverage strip
- One-page balance statement per employee and 20 built-in self-checks
- Opens in Excel and in Google Sheets
$17.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
Secure checkout on Etsy · ★★★★★ 5.0-star shop

See it in action
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, in order, read out of the workbook itself.
- 01 Start Here
- 02 Settings
- 03 Leave Types
- 04 Employees
- 05 Time Off Log
- 06 Balances
- 07 Team Calendar
- 08 Employee Snapshot
- 09 Team Dashboard
- Google Sheets Guide
- 11 QA Checks
Works in
- Microsoft Excel 2019, 2021 or Microsoft 365
- Google Sheets with a free Google account: upload to Drive and convert it to a Google Sheet (a guide tab is included)
- Not compatible with Numbers, LibreOffice or OpenOffice
Others in HR & Employee Trackers
- ExcelEmployee PTO TrackerAn employee PTO tracker for Excel: vacation, sick days and half-days for up to 200…$5.99View →

- Excel + Google SheetsEmployee Training MatrixA training matrix and skills matrix for small teams: every employee down the side…$10.97View →

- Excel + Google SheetsPTO Tracker (Sage & Terracotta)A PTO tracker for Google Sheets and Excel: add your team once, type a leave code on any…$13.99View →

- Excel + Google SheetsPerformance Review WriterAn employee evaluation spreadsheet that writes the performance review for you: rate…$17.99View →
