FREE PTO Tracking Template 2026 (Updated)
Keep a clean record of Paid Time Off across vacation, sick leave, and other time-off types. Grab our simple tracker for Google Sheets or Excel and start organizing PTO in minutes.
How to use this PTO spreadsheet
Add your employees
Enter employee names in the tracker. Use built‑in filters in Google Sheets or Excel to quickly view PTO by person or team.
Set your leave types
Create up to six leave categories (e.g., Vacation, Sick). Assign short codes like "V" or "SL" and log them on the calendar; the sheet totals days automatically.
Add public holidays
Populate your regional holidays once to keep the calendar accurate and avoid duplicate entries across multiple sheets.
Why not automate your PTO tracking?
ClockIt can handle accruals, approvals, balances, and reports—on web and mobile—so you don't need to manage spreadsheets manually.
14‑day free trial • No credit card required • All features included
Track time off and accruals on autopilot.
Employees request time off in seconds, balances stay accurate, and approvals happen in a tap — no spreadsheets, no manual math.
Multiple time-off types
Manage vacation, sick leave, personal days and custom leave types in one place. Employees request time off, view balances, and get real-time updates. Managers set custom rules, automate approvals, and get reports on usage.
- Custom leave types
- Real-time balances
- One-tap approvals
- Automated accruals
Days or hours
Track time off in days or hours — whichever fits your policies.
Automated accruals
Accrue by tenure, hours worked, anniversary — weekly, 2-weeks, monthly or yearly.
- Tenure rules
- Carry forward
- Probations
- Anniversary
Time off notifications
Employees and managers get instant updates on requests and approvals.
Vacation dashboard
See who's off, who's sick, and who's remote across the whole company.