Home/Spreadsheets/HR & Employees/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 you get
- 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
- Opens in Excel and in Google Sheets
$17.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
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
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- 09 Team Dashboard
- 06 Balances
- 07 Team Calendar
- 05 Time Off Log
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
Honest scope
This is a record-keeping template, not legal or HR advice. Leave, overtime and pay rules vary by state and by employer policy; the file reports what you enter and does not decide what anyone is entitled to.
Others in HR & Employees
- Employee PTO TrackerAn employee PTO tracker for Excel: vacation, sick days and half-days for up to 200…$7.99View →
- Interactive Excel Formulas Cheat SheetAn Excel cheat sheet with 243 formulas and functions: a searchable workbook you can…$4.99View →
- Employee Schedule TemplateAn employee schedule template for small businesses: build the week's staff shifts from…$10.99View →
- Performance Review Comment BankA performance review comment bank that starts from your ratings: rate eight…$14.99View →
