Report this item to Etsy

PTO Tracker Spreadsheet, Vacation Accrual Tracker Google Sheets & Excel, Employee Time Off Tracker, Leave Calendar, HR Template 2027

Price:$14.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 File

Track every employee's PTO without the math. Accruals, balances, caps and carryover calculate automatically, and a monthly calendar shows who's out each day.

HOW IT WORKS
✓ Set the plan year and the date to accrue through (or use =TODAY() so it's always current)
✓ Add employees: accrual frequency (monthly, semi-monthly, biweekly, weekly or annual front-loaded), hours per period, annual cap, carryover and an optional hourly rate
✓ Log time off: start and end date, leave type, hours and status (Approved / Pending / Denied)
✓ Accrued, used, pending and available hours (and days) update instantly, and low or negative balances are flagged

DASHBOARD: total accrued, used and available hours, pending requests, low-balance count, PTO liability in dollars, approved time off by month (chart) and available balance by employee (chart).
WHO'S-OUT CALENDAR: pick a month to see each person's leave color-coded by type (vacation, sick, personal…) with a daily headcount out.
FLEXIBLE: edit leave types and choose which ones deduct from PTO (e.g. jury duty and bereavement don't). Up to 50 employees and 2,000 requests.

Perfect for small business owners, HR and office managers, team leads and nonprofits.

INCLUDED: .xlsx file (opens in Excel or upload to Google Sheets), Start Here guide, Dashboard, Settings, Employees, Time Off Log and Calendar tabs, sample data you can clear.
Check your local labor laws and company policy for accrual and carryover rules.

PLEASE NOTE: Digital download — no physical item is shipped. Requires Excel 2016+/Microsoft 365 or a free Google account. Message me with any issue and I will fix it.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 17, 2026