SDSimpleDesigns

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

Employee PTO Tracker — the workbook open in Excel

See it in action

What buyers say

Read this listing's reviews on Etsy

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, in order, read out of the workbook itself.

Works in

Others in HR & Employee Trackers

Employee PTO Tracker$5.99Buy on Etsy