calculator template · Free download
PTO Accrual Calculator
Calculate PTO accrual per pay period or per hour worked, set tenure tiers and caps, prorate for new hires and part-timers, and track balances in a ledger.
Sign in with Google below to download the PDF and CSV straight away.
Get your free download
Sign in with Google to unlock the PDF and CSV instantly. No form to fill in.
Free. By continuing you agree to our terms and privacy policy. We record your email and this download; marketing emails only if you tick the box.
What you get
- Accrual-rate tables for weekly, biweekly, semimonthly, monthly, and per-hour-worked plans
- A tenure-tier table with annual hours and per-period rates already calculated
- Proration formulas for mid-year hires and part-time FTEs, with worked examples
- A running PTO balance ledger (opening, accrued, used, closing) with blank rows
- State notes on accrual caps, use-it-or-lose-it, payout at termination, and separate sick leave
Template preview
A preview of the structure. Download the PDF or CSV for the complete, ready-to-use version.
Accrual inputs
- Employee name and ID
- Work state / country
- Hire date— Drives proration and tenure tier
- Annual PTO entitlement (hours)— e.g. 120 hours = 15 days of 8 hours
How PTO accrual works
Accrual means employees earn paid time off gradually as they work instead of receiving the full year's bank on January 1. It limits the liability of someone taking two weeks off in their first month and leaving, and it keeps the balance on the books roughly in line with time worked. The two common methods are a fixed amount per pay period and a fixed amount per hour worked. Either works as long as the policy states the rate, the cap, and what happens to unused hours.
Per-pay-period accrual rates (120 hours per year)
Per-period rate = annual hours / number of pay periods. Keep three decimals in payroll.
| Pay frequency | Periods per year | Formula | Hours per period |
|---|---|---|---|
| Weekly | 52 | 120 / 52 | 2.308 |
| Biweekly | 26 | 120 / 26 | 4.615 |
| Semimonthly | 24 | 120 / 24 | 5.000 |
| Monthly | 12 | 120 / 12 | 10.000 |
Per-hour-worked accrual
Rate per hour worked = annual hours / expected hours worked. 1 hour per 30 worked is the rate many state paid sick leave laws use.
| Accrual rate | Hours worked | Formula | Hours accrued |
|---|---|---|---|
| 1 hr per 30 worked | 80 (biweekly) | 80 / 30 | 2.667 |
| 1 hr per 30 worked | 86 (biweekly with OT) | 86 / 30 | 2.867 |
| 1 hr per 30 worked | 2,080 (full year) | 2,080 / 30 | 69.333 |
| 0.0577 hr per hour worked (120/2,080) | 2,080 (full year) | 2,080 x 0.0577 | 120.016 (use 120 cap) |
Decide in the policy whether overtime hours earn accrual. Per-hour-worked plans usually include them, which is why the 86-hour row accrues more. Most plans exclude PTO hours themselves from the hours-worked base, so time off does not generate more time off.
This is a preview — the full template continues in the download.
Sign in above to download the full template.
How to use this template
- 1
Pick an accrual method
Choose per pay period for salaried staff with steady schedules, or per hour worked for hourly and variable-schedule staff. Write the method into your PTO policy so payroll and employees read it the same way.
- 2
Set the annual entitlement and per-period rate
Divide annual hours by the number of pay periods (or by hours worked in a year) and keep at least three decimal places so rounding does not drift over 26 periods.
- 3
Apply caps and proration
Set an accrual cap or carryover cap, then prorate the entitlement for mid-year hires and for part-time employees by FTE.
- 4
Run the ledger every pay period
Record the opening balance, hours accrued, hours used, and closing balance for each employee, and reconcile to the payroll system at least quarterly.
- 5
Check state rules before finalizing
Confirm whether your states allow forfeiture, require payout at termination, or require a separate paid sick leave accrual.
Frequently asked questions
How do I calculate PTO accrual per pay period?
Divide the annual PTO hours by the number of pay periods in the year. For 120 hours on biweekly payroll that is 120 / 26 = 4.615 hours per period; on semimonthly payroll it is 120 / 24 = 5.000. Keep three decimals so the year totals correctly.
What is a typical PTO accrual rate?
Many US employers start at 10 to 15 days (80 to 120 hours) a year and add days at 3, 5, and 10 years of service. On an hours-worked basis, 120 hours a year across 2,080 hours works out to about 0.0577 hours per hour worked. Paid sick leave laws commonly set a floor of 1 hour per 30 worked.
Can an employer cap PTO accrual?
Yes. An accrual cap that pauses new accrual once the balance reaches a ceiling is allowed even in California, Montana, and Nebraska, because nothing already earned is taken away. What those states prohibit is forfeiting earned vacation, as in use-it-or-lose-it policies.
How do I prorate PTO for a new hire?
Multiply the annual entitlement by the fraction of the year remaining. Someone hired April 1 with a 120-hour plan gets 120 x 9 / 12 = 90 hours for the first year. On per-period accrual, proration happens naturally because they only accrue for the pay periods they are employed.
How is PTO calculated for part-time employees?
Multiply the full-time entitlement by the employee's FTE, or accrue per hour worked at the same rate as full-time staff. A 0.6 FTE employee on a 120-hour plan earns 72 hours a year, or 2.769 hours per biweekly period.
Do I have to pay out unused PTO when an employee leaves?
It depends on the state. California, Colorado, Illinois, Massachusetts, Montana, and Nebraska require payout of earned, unused vacation; elsewhere, your written policy usually controls. Pay it at the employee's final rate and include it in the final paycheck on the state's deadline.