Sheet template · People & HR
PTO Tracker
Track employee time-off allowances, requests, used days, and remaining balances in a simple team sheet.
Small teams that need a shared vacation and paid-time-off view with lightweight balance formulas.
Sign in to start an independent editable workbook from this Sheets template.
Structured preview
PTO Tracker at a glance
Preview only8 columns · 3 sample rows
| Employee | Team | Annual allowance | Used | Pending | Remaining | Next planned leave | Notes |
|---|---|---|---|---|---|---|---|
| Taylor Reed | Operations | 20 | 8 | 2 | =C4-D4-E4 | 2026-10-12 | Coverage confirmed |
| Jordan Lee | Client success | 18 | 6 | 0 | =C5-D5-E5 | 2026-11-04 | |
| Team remaining | =SUM(F4:F6) |
Adapt allowance rules and balances to your policy; this tracker is not a payroll or legal-compliance system.
What's included
- Employee and team register
- Allowance, used, and pending fields
- Remaining-balance formulas
- Planned leave and coverage notes
How to use it
- 1Replace the sample people and allowance values with your policy-approved data.
- 2Record approved time off separately from pending requests.
- 3Review balances and coverage with the responsible manager before confirming leave.
Continue exploring