PTO Accrual Tracker Template (Excel)
Accrues PTO per hour worked across 26 pay periods with a running balance.
Actualizado 2026-10-20
Excel biweekly
- Accrual rate per hour
- 26 pay periods
- PTO used column
- Running balance
¿Prefieres no usar una hoja de cálculo? Usa la calculadora.
La plantilla y su descripción están en inglés por ahora.
Accrues PTO per hour worked across 26 pay periods with a running balance.
How accrual is calculated
The rate per hour worked is annual PTO hours / annual work hours, for example 80 / 2080 = 0.0385 hours of PTO per hour worked. Each pay period row multiplies hours worked by that rate, subtracts PTO used and carries the balance forward: =previous balance + accrued - used. Change B2 and B3 for your plan; set the opening balance in B5 for carry-over from last year.
For per-period or lump-sum accrual plans, set hours worked to the same number each row (for example 80) or type the accrual directly into column C.