PTO Accrual Calculator
Work out how much paid time off an employee earns per hour worked, per pay period or per year. Add a starting balance, hours used and a cap, and the calculator shows the new balance in hours and days.
Let TimeClick keep each employee’s PTO balance up to date
Employees clock in on a shared PC or the phone app, and TimeClick totals their hours, overtime and time off for payroll, with a one-time license from $299 and unlimited employees.
Free PTO tracker spreadsheet
To track one employee’s balance through the year, download the free PTO tracker for Excel. Enter the PTO hours earned each pay period, the starting balance and an optional maximum balance, then fill in hours used. It keeps a running balance for up to 53 pay periods and stops earning at the cap. It also opens in Google Sheets with File, Import.
How to use the PTO accrual calculator
- Pick how PTO accrues at your business: per hour worked, per pay period or a yearly allotment.
- Enter the accrual rate or the yearly PTO hours.
- Add the starting balance and any hours used this period.
- If your policy has a cap or a carryover limit, enter it.
- Enter the hours in a workday so the result also shows days.
The result shows the hours earned this period, the new balance, the accrual rate per hour and per pay period, and the pay period when the balance reaches the cap.
Three ways PTO accrues
Per hour worked
The employee earns a set amount of PTO for every hour they work. A common rate is 1 hour of PTO for every 30 hours worked. An employee who works 80 hours in a pay period earns 80 / 30 = 2.67 hours (2:40).
Per pay period
The yearly PTO is split evenly across pay periods. With 80 hours a year and biweekly pay (26 pay periods), the employee earns 80 / 26 = 3.08 hours each payday.
Yearly allotment
The full year’s PTO is granted at once, often on the hire date or January 1. If a new employee starts on July 1 and you prorate by month, an 80-hour allotment becomes 40 hours for the first year.
PTO caps and carryover
- A cap is the most PTO an employee can hold. Once the balance reaches it, accrual stops until they use some time. A cap doesn’t take away hours already earned.
- A carryover limit is how much unused PTO moves into the next year. Some states restrict “use it or lose it” policies, so check yours before setting one.
The calculator applies hours used before it checks the cap, so the balance is never counted twice.
State PTO and sick leave rules to know
Federal law doesn’t require paid vacation or sick leave. The Fair Labor Standards Act “does not require payment for time not worked, such as vacations, sick leave or federal or other holidays” (U.S. Department of Labor). Several states set their own rules:
- California: a “use it or lose it” vacation policy is “an illegal policy under California law”; caps are allowed; “all earned and unused vacation must be paid to the employee at his or her final rate of pay” when they leave (California DLSE). California paid sick leave accrues at “at least one hour of paid sick leave for each 30 hours of work” (DLSE).
- Washington: “at least one hour of paid sick leave for every 40 hours you work,” with carryover of “balances of 40 hours or less to the next year” (L&I).
For every state, see PTO laws by state.
PTO accrual calculator FAQ
Does PTO accrue on overtime hours?
It depends on your policy and state. Many per-hour policies count all hours worked, including overtime. Paid time off itself usually doesn’t count toward overtime; see does PTO count towards overtime.
How do part-time employees accrue PTO?
With a per-hour-worked method, part-time staff accrue in proportion to the hours they work. Some state sick leave laws cover part-time employees too.
What’s the difference between accrued and available PTO?
Accrued PTO is what the employee has earned. Available PTO is what they can use now, which can be less if your policy has a waiting period.
What’s the difference between a cap and carryover?
A cap limits the balance at any time. Carryover limits what moves into a new year.
Do I have to pay out unused PTO when someone leaves?
Some states require it, including California. Check PTO laws by state.
How do I handle PTO for an employee hired mid-year?
With a yearly allotment, prorate it by months or pay periods left. With per-hour or per-pay-period accrual, they start earning from their first period.
Is sick leave the same as PTO?
Some employers combine them into one PTO bank; others keep them separate. Several state sick leave laws set minimums either way.
How does TimeClick track PTO?
You set accrual rules for each employee, and TimeClick keeps running balances. Employees request time off from their login, an admin approves it, and PTO hours appear on payroll reports. See the PTO tracker and the accrued time and PTO guide.