SDSimpleDesigns

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

Employee Leave Tracker — the workbook open in Excel

See it in action

What it looks like

Employee Leave Tracker screenshot
Employee Leave 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 Leave Tracker$17.99Buy on Etsy