HR template
Vacation and PTO tracker
Accrue paid time off by month, log requests, and see each balance at a glance. Request days count working days only and skip holidays.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
2 sheets
- Balances
- Requests
62 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 203 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Named ranges
- Live dates
- Frozen headers
A look at the Balances sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Time off balances | |||||||
| 2 | Allowance accrues evenly through the year. Approved requests reduce the balance. | |||||||
| 3 | Year | 2026 | Months accrued | 11 | Out in next 7 days | 1 | ||
| 4 | ||||||||
| 5 | ||||||||
| 6 | Employee | Team | Annual days | Carryover | Accrued | Taken | Pending | Balance |
| 7 | Avery Lin | Leadership | 25.0 | 3.0 | 22.9 | 8.0 | 0.0 | 17.9 |
| 8 | Jordan Patel | Sales | 20.0 | 2.0 | 18.3 | 11.0 | 0.0 | 9.3 |
| 9 | Riley Chen | Product | 20.0 | 0.0 | 18.3 | 2.0 | 4.0 | 16.3 |
| 10 | Morgan Diaz | Engineering | 22.0 | 5.0 | 20.2 | 10.0 | 0.0 | 15.2 |
| 11 | Sam Okafor | Support | 20.0 | 1.5 | 18.3 | 1.0 | 0.0 | 18.8 |
| 12 | Quinn Rivera | People | 20.0 | 0.0 | 18.3 | 0.0 | 3.0 | 18.3 |
- pto
- vacation
- leave
- time off
- holidays
More hr templates
HRWeekly timesheetRecord time in, lunch and time out for each day of the week. Hours over 40 become overtime and pay is calculated at your rates.
HRPayroll registerCalculate gross pay, withholdings, deductions and net pay for each person on a pay run. Rates live in one box so a change updates every row.
HREmployee shift schedulePlan a week of shifts with a dropdown in every cell. Hours per person and coverage per shift add up as you fill the grid.
HREmployee directoryKeep contact details, teams, managers and start dates in one tidy list. Look anyone up by name and see headcount by department.
Start your vacation and pto tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.