PTO Accrual Explained and Free Template
PTO is one of the most important benefits employees consider when evaluating a job, and one of the most administratively painful for small businesses to track accurately. Accrual-based PTO systems are more equitable than front-loading and reduce early-year liability, but they require consistent calculation and clear policies to work correctly. Manual tracking in spreadsheets introduces errors, and unclear rollover and cap policies create disputes.
This guide explains what PTO accrual is, the four methods companies use to structure it, the formulas to calculate it in Google Sheets, best practices for caps and rollover rules, and an interactive calculator you can use right now to check balances for any employee.
What Is PTO Accrual?
PTO accrual is a system where employees earn paid time off gradually over time rather than receiving their entire annual balance on day one. Instead of giving an employee 120 hours of PTO on January 1, the company allows them to earn PTO incrementally each pay period, each month, or based on hours worked. By the end of the year, the employee has earned the same total hours -- they just accumulated them progressively rather than receiving the full amount upfront.
Accrual systems benefit employers by controlling PTO liability and discouraging large blocks of early-year time off before an employee has earned their balance. They benefit employees who receive clear, trackable proof of what they have earned rather than a lump balance that can be disputed. And because several states classify accrued PTO as earned wages, an accrual system with clear documentation protects both parties if a dispute arises at termination.
The Four Common PTO Accrual Methods
1. Monthly Accrual
Employees earn a fixed amount of PTO once per month. If the annual PTO allotment is 120 hours, the monthly accrual rate is 10 hours. This is the simplest method to track and explain to employees, and it aligns naturally with monthly payroll cycles. The downside is that employees who start mid-month may need a prorated calculation for their first period.
Monthly accrual rate = Annual PTO hours ÷ 12 Example: 120 ÷ 12 = 10 hours per month
2. Per Pay Period Accrual
PTO is earned every payroll cycle. This is the most common method for hourly and salaried employees on biweekly or semi-monthly payroll. For a biweekly schedule with 26 pay periods per year, 120 annual PTO hours accrues at 4.62 hours per paycheck. This method ties PTO directly to the payroll cycle, which simplifies integration with payroll software.
Biweekly rate = Annual PTO hours ÷ 26 Example: 120 ÷ 26 = 4.62 hours per pay period Semi-monthly rate = Annual PTO hours ÷ 24 Example: 120 ÷ 24 = 5 hours per pay period
3. Hours Worked Accrual
This method is most common for hourly and part-time employees because it scales directly with the actual time worked rather than assuming a fixed schedule. Employees earn a set number of PTO hours for every defined block of hours worked. A common rate is 1 hour of PTO earned per 40 hours worked. An employee working 160 hours in a month earns 4 hours of PTO regardless of how those hours were distributed across days or weeks.
Accrual rate = PTO hours earned per hours worked Example: 1 hour PTO per 40 hours worked 160 hours worked ÷ 40 = 4 hours PTO earned
4. Anniversary Accrual
Employees receive PTO based on their employment anniversary date rather than the calendar year. A common structure grants one block of PTO hours on each anniversary date, with the amount increasing at defined tenure milestones. This method rewards tenure clearly and avoids the prorating complexity that calendar-year accrual creates for employees hired mid-year. The tradeoff is more administrative complexity in tracking each employee's individual anniversary cycle rather than a single reset date for everyone.
PTO Accrual Calculator
Enter the employee's details below to calculate their current accrual and balance. Copy the results to paste into your records.
🅾 PTO Accrual Calculator
Results update as you type.
Prefer a spreadsheet? Open the Google Sheets PTO template →
PTO Accrual Formulas for Google Sheets
If you manage PTO in a spreadsheet, two formulas handle most accrual tracking needs automatically.
Monthly accrual based on start date:
=DATEDIF(StartDate, TODAY(), "M") * MonthlyAccrualRate
Where StartDate is the cell containing the employee's hire date or accrual start date and MonthlyAccrualRate is the per-month accrual amount. This formula recalculates every day, so the balance updates automatically without any manual entry.
Current balance:
=PTOEarned - PTOUsed
Where PTOEarned contains the accrual formula result and PTOUsed is the total hours taken. Using a running sum for PTOUsed rather than a single cell means you can log each absence without rebuilding the formula.
For hours-worked accrual, replace the DATEDIF formula with a sum of actual hours worked divided by your accrual ratio:
=SUM(HoursWorkedRange) / AccrualRatio * PTOHoursPerBlock
Best Practices for PTO Accrual Systems
Define accrual caps clearly. A cap sets the maximum balance an employee can hold before accrual pauses. Once the employee hits the cap, no additional PTO accumulates until they use some. A typical cap is 1.5 to 2 times the annual accrual amount -- so an employee who earns 120 hours per year might cap at 180 to 240 hours. Caps prevent unlimited liability accumulation and encourage employees to actually use their time off.
Set explicit rollover policies. Decide what happens to unused PTO at year end and put it in writing. Options include unlimited rollover, rollover up to a defined maximum, or use-it-or-lose-it. Important: use-it-or-lose-it policies are illegal in states that classify accrued PTO as earned wages, including California, Colorado, and Illinois. Confirm your state's requirements before implementing any forfeiture policy.
Track PTO types separately. Many companies track vacation, sick leave, and personal days as separate accrual buckets with different rates and rules. Combining them into a single PTO bank simplifies administration but reduces the employer's ability to enforce sick leave policies in states that have specific sick leave accrual requirements. Keeping them separate creates more complexity but more compliance flexibility.
Make balances visible to employees. Employees should be able to check their current PTO balance without asking HR. When balances are opaque, employees either over-request time off and create disputes or under-request because they do not know what they have. A shared spreadsheet, an employee portal, or a regular paycheck stub showing the current balance eliminates most PTO-related questions before they happen.