Use this tool to estimate earned PTO, current balance, projected accrual, and cap impact from worked hours.
Calculator Inputs
Example Data Table
| Example Employee | Annual PTO | Hours/Week | Weeks/Year | Worked To Date | Used PTO | Carryover | Cap | Accrued | Available |
|---|---|---|---|---|---|---|---|---|---|
| Alex Rivera | 120 | 40 | 50 | 960 | 24 | 8 | 160 | 65.60 | 41.60 |
| Jamie Lee | 80 | 30 | 50 | 600 | 10 | 4 | 120 | 36.00 | 26.00 |
| Chris Patel | 160 | 40 | 52 | 1560 | 48 | 12 | 200 | 132.00 | 84.00 |
Formula Used
Annual Work Hours = Hours Per Week × Work Weeks Per Year
Hourly Accrual Rate = Annual PTO Hours ÷ Annual Work Hours
Raw Accrued PTO = Carryover Hours + (Hours Worked To Date × Hourly Accrual Rate)
Accrued PTO = Minimum of Raw Accrued PTO and Accrual Cap
Available Balance = Accrued PTO − PTO Used Hours
Projected Accrued PTO = Carryover + ((Worked To Date + Future Hours) × Rate)
This structure helps HR teams, managers, and employees compare policy limits with actual earned time.
How to Use This Calculator
- Enter the employee name for cleaner output.
- Add annual PTO hours granted under the benefit plan.
- Enter eligible hours per week and work weeks.
- Fill in worked hours to date.
- Add already used PTO and any carryover balance.
- Enter an accrual cap if your policy uses one.
- Add projected future hours to estimate upcoming balance.
- Click calculate to view results, chart, and download options.
Frequently Asked Questions
1. What does PTO hourly accrual mean?
PTO hourly accrual means leave grows based on eligible hours worked. Instead of receiving all time at once, employees earn small portions throughout the year.
2. How is the hourly accrual rate calculated?
Divide annual PTO hours by annual eligible work hours. If a worker earns 120 PTO hours over 2,000 work hours, the rate is 0.06 PTO hours per worked hour.
3. Why does the calculator ask for carryover hours?
Carryover hours add unused time from an earlier period. Including them gives a more realistic starting balance before current-year accrual is applied.
4. What happens when an accrual cap is reached?
A cap limits additional growth once the balance hits a policy threshold. The calculator stops accrual at that level until used time creates room again.
5. Can this calculator work for part-time staff?
Yes. Enter the employee’s actual eligible weekly hours and work weeks. The rate and earned balance will adjust automatically for part-time schedules.
6. Should overtime hours be included?
Include overtime only if your policy says those hours are PTO-eligible. Some employers accrue on all worked hours, while others exclude overtime or paid non-work time.
7. Why might payroll totals differ from this result?
Payroll systems may use different rounding, pay-period cutoffs, waiting periods, or policy exclusions. This tool is best for estimation and internal planning.
8. How often should PTO accrual inputs be reviewed?
Review inputs whenever policies change, hours change, or payroll closes a new period. Frequent updates keep forecasts and employee balances more reliable.