Home/Spreadsheets/HR & Employee Trackers/Employee PTO Tracker
Employee PTO Tracker
An employee PTO tracker for Excel: vacation, sick days and half-days for up to 200 employees, with balances that reset on each work anniversary or on January 1, an automatic dashboard and a weekly who's-out view. It opens in Microsoft Excel, has no macros and nothing to install, and is yours to reuse as often as you like.
What it does
- PTO allowance, used and remaining for every employee; you choose which leave types deduct PTO
- Each leave type resets on its own schedule: work anniversary or January 1
- More vacation with length of service, and sick days by salary or hourly pay type
- Dashboard with KPI cards, monthly trend, absence mix and top 5 absentees, plus weekly availability
- Team Report and a one-employee annual report with a color-coded calendar
- Works for any year, with full-day and half-day codes
- Opens in Excel
$5.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 buyers say
- ★★★★★
Wonderful communication. Great spreadsheets. I needed some slight tweaking and Morgan fixed it for me and emailed it to me which I truly appreciate it.
- ★★★★★
Great and easy to use template. Amazing value. Very easy to edit. Highly recommend if you have a pretty significant size team.
Read this listing's reviews on Etsy
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.
- Home
- Instructions
- Settings
- Employees
- January–December (12 monthly tabs)
- Hours Log
- Dashboard
- Team Report
- Employee Report
Works in
- Microsoft Excel 2019, 2021 and Microsoft 365 (Windows, Mac and Excel for the web)
- Not compatible with Google Sheets, Numbers, LibreOffice or OpenOffice
- Desktop or laptop recommended
Others in HR & Employee Trackers
- 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 →

- Excel + Google SheetsEmployee Leave TrackerAn employee leave tracker for small teams: set your PTO policy once, log each request…$17.99View →
