Tracking PTO accruals for hourly employees is messier than it looks. Hourly workers accrue at different rates depending on actual hours worked, hours fluctuate week to week, and the calculation that seemed simple in a spreadsheet turns into a source of disputes the moment someone requests a day off. Here’s how to set up PTO accruals for hourly employees correctly — what the math looks like, what the policy needs to say, and how to connect PTO tracking to your time clock and payroll export.
Why PTO accruals for hourly workers are tricky
Salaried employees accrue PTO by the week or month regardless of hours — the calculation doesn’t change pay period to pay period. Hourly employees are different. Their PTO accruals are tied to hours worked, which means the accrual changes every pay period based on the actual timesheet.
On a quiet week, a part-time employee might work 20 hours. On a busy week, the same employee works 44. Their PTO accrual should reflect the difference. If you’re managing this in a spreadsheet without live timesheet data feeding it, you’re recalculating manually every pay period — and the odds of a rounding error or missed week compound over time.
How hourly PTO accruals work
The per-hour-worked model
The most common approach: employees earn X hours of PTO for every Y hours worked. A typical policy is 1 hour of PTO per 30 hours worked. A full-time employee at 40 hours/week earns roughly 1.33 PTO hours per week, or about 69 hours (8.6 days) per year.
For part-time hourly employees, the math scales automatically. An employee averaging 20 hours/week at the same rate earns half as much PTO — which is typically the intent, and the key advantage of the per-hour model over a flat weekly or monthly accrual.
Common accrual rates
- 1 hour per 30 worked — most common; roughly 8–9 days per year for full-time employees
- 1 hour per 40 worked — conservative; roughly 6.5 days per year for full-time
- 1 hour per 20 worked — generous; roughly 13 days per year for full-time
Some states mandate a minimum paid sick leave accrual rate for hourly employees — California, Colorado, and several others have standing requirements. Know your state’s rules before finalizing your policy; your rate must meet or exceed the state minimum.
Accrual caps
Most PTO policies include a cap — a maximum balance an employee can hold at any one time. Caps prevent accrued-PTO liability from compounding indefinitely on the books. A common cap is 1.5× or 2× the employee’s annual accrual: an employee who earns 60 hours/year might have a 90–120 hour cap.
What your hourly PTO policy must cover
- Accrual rate — X hours per Y hours worked, stated explicitly
- Accrual start date — does accrual begin on day one, or after a waiting period (30, 60, or 90 days)?
- Balance cap — the maximum a single employee can hold at any time
- Carryover rule — does unused PTO roll over at year-end, or does it reset? (Some states prohibit use-it-or-lose-it for accrued PTO.)
- Payout on termination — is unused PTO paid out when an employee leaves? California and several other states require this.
- Request procedure — how far in advance must requests be submitted, and who approves them?
Step-by-step: setting up PTO tracking for hourly employees
- 01
Write the policy before configuring anything
Decide the accrual rate, cap, carryover rule, and payout rule first. The software enforces what you configure — if the policy is ambiguous, the software will automate the wrong answer.
- 02
Enter opening balances
If employees have existing PTO balances when you set up a new system, enter those balances before the first accrual period runs. Getting opening balances wrong is one of the most common and annoying migration mistakes — fix it at the start, not after employees spot the discrepancy.
- 03
Connect PTO to the time clock
PTO and availability are included in ClockOut’s Starter plan. Once configured, the system tracks accruals against actual hours worked from the time clock — no separate spreadsheet required. Managers can view and adjust individual employee balances directly from the dashboard.
- 04
Set up the approval workflow
Define who approves PTO requests for each location or department. Requests, balance checks, approvals, and scheduling conflicts are all handled in one place — the scheduler respects approved PTO automatically, so scheduling someone over their approved time off stops being a weekly argument.
- 05
Include PTO hours in each payroll export
Before exporting payroll, confirm that PTO taken during the period is recorded as compensated hours in the timesheet. PTO hours need to appear in the payroll export — most providers accept PTO as a separate line item. ClockOut Pro exports PTO hours alongside regular and overtime hours in ADP-, Gusto-, and QuickBooks-ready formats.
- 06
Audit balances quarterly
Pull a PTO balance report for every employee each quarter. Compare against the policy cap and flag any anomalies. A quarterly audit is far less painful than a year-end surprise when an employee requests three weeks of PTO they technically shouldn’t have.
How PTO fits into payroll exports
When an hourly employee takes a PTO day, those hours need to appear in payroll as compensated time — even though no actual work was clocked. Most time-tracking systems handle this by letting managers enter PTO as a timesheet entry type (rather than a separate HR record), so it flows through the payroll export alongside regular worked hours.
This is covered in more detail in the guide on exporting payroll to ADP, Gusto, and QuickBooks — the PTO line-item setup in each provider format is different and worth confirming before your first run.
Handling PTO requests and approvals
A clean request workflow removes the back-and-forth that eats up manager time. The flow should be:
- Employee submits a PTO request with dates and type (vacation, sick, personal)
- System checks current balance and flags if the request exceeds available PTO
- Manager receives a notification and approves or declines
- Employee receives the outcome via push notification or email
- Approved PTO blocks the corresponding shift on the schedule so no one books the employee for a conflict
In ClockOut (Starter+), this entire flow is built into the same dashboard where managers approve timesheets. There’s no separate HR system to log into — requests, approvals, balance views, and schedule blocking all live in one place.
Switching systems without losing PTO data
If you’re moving from a spreadsheet or another app, the most important step is exporting the current PTO balance for every employee before you switch. Enter those balances as opening balances in the new system before you run the first accrual period. The general principles in our guide on switching from paper timesheets apply to any system migration, including PTO data.