SDSimpleDesigns

Home/Spreadsheets/HR & Employees/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 you get

  • 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
  • Opens in Excel
$7.99one-time, no subscription
Buy on Etsy

Instant digital download · one-time purchase · no subscription

Employee PTO Tracker — the workbook open in Excel

What it does

What it looks like

Employee PTO Tracker screenshot
Employee PTO Tracker screenshot

Every tab in the workbook

These are the actual sheet names in the file, not a feature list.

Works in

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 Tracker$7.99Buy on Etsy