How to track employee PTO accurately

Practical methods for tracking paid time off: setting up policies, calculating accruals, handling carryover, caps and payouts, spreadsheets vs. software and common errors.

In shortTo track PTO accurately, start with a clear written policy, record every accrual and every hour used in one place, calculate accruals from actual hours worked or a fixed schedule, apply carryover and cap rules automatically, and let employees see their balances. Spreadsheets work for very small teams; as you grow or face state sick leave rules, a system that links PTO to time records and approvals reduces errors and disputes.

Why PTO tracking goes wrong

PTO errors are common and costly. Balances kept in a manager’s notebook drift from payroll; accruals are calculated on scheduled hours instead of hours worked; carryover rules are applied inconsistently; employees take time off that is never recorded, or are told they have no balance when they do. Errors create disputes, damage trust and, in some states, legal liability, especially for paid sick leave and for payouts at termination. See paid time off.

Step 1: write a clear PTO policy

Our blog post on PTO accrual policies covers policy design in more detail.

Step 2: check state and local rules

Federal law does not require paid vacation or general PTO for private employers. But many states and cities require paid sick leave, with specific accrual rates, caps, carryover and usage rules, and some states treat earned vacation as wages that must be paid out at termination and limit “use it or lose it” policies. California is the best-known example. If you combine vacation and sick time in one PTO bank, make sure the combined policy meets the sick leave rules where you operate. See our state labor law pages and final paycheck rules.

Step 3: calculate accruals correctly

The most common accrual methods:

PTO accrual methods
Method How it works Example
Per hour worked Employees earn a fixed amount per hour worked 1 hour of PTO per 30 hours worked
Per pay period A fixed amount each pay period 4 hours per biweekly pay period
Annual lump sum (front-loaded) Full annual amount granted at the start of the year 80 hours on January 1
Tenure-based tiers Rate increases with years of service Higher rate after 3 years

For hourly employees, per-hour accrual is fair and simple when it is calculated from actual hours worked. Decide whether overtime hours earn PTO and write that down. Our PTO accrual calculator helps you work out rates.

A worked example (fictional)

Dana works part-time and earns 1 hour of PTO for every 30 hours worked, with a cap of 60 hours.

PTO balance over four pay periods
Pay period Hours worked PTO earned PTO used Balance
1 60 2.0 0 2.0
2 72 2.4 0 4.4
3 54 1.8 4.0 2.2
4 66 2.2 0 4.4

Each period, the system adds earned hours, subtracts hours used and stops accruing when the balance reaches the cap. Tracking these numbers per pay period, rather than once a year, keeps balances accurate.

Step 4: carryover, caps and payouts

Step 5: choose a tracking method

PTO tracking methods compared
Method Works for Drawbacks
Paper or calendar A handful of employees Easy to lose, no audit trail
Spreadsheet Small teams with one administrator Manual updates, formula errors, hard to share balances
Payroll system Teams whose payroll tracks accruals Requests and approvals often happen elsewhere
Time and attendance or HR software Growing and multi-site teams Requires setup and subscription

The key test: can employees see their balance, request time off and get approval in one place, and does the balance update automatically from hours worked and time used?

Step 6: make requests and approvals consistent

Use one channel for requests, with a clear notice period and response time. Managers should check coverage before approving and record approvals so they are visible to payroll. See how to manage time-off requests and last-minute time-off requests.

Common PTO tracking errors

Communicate balances to employees

Many PTO disputes start because employees cannot see their balance and only find out it is lower than expected when they ask for a week off. Show balances on every pay stub or in an app employees can check at any time, and explain how accruals work during onboarding with a short example. When policies change, for example a new cap or a new state sick leave law, tell employees in writing what is changing, from when and how existing balances are treated. Transparent balances reduce questions to HR and help employees plan their time off, which also makes scheduling easier for managers.

Audit your balances

Once or twice a year, compare PTO balances in your tracking system with payroll records and a sample of approved requests. Investigate differences, correct them and tell affected employees. Regular audits catch small errors before they become disputes, and they give you confidence that the figures you report to employees are right. See our time audit guide.

How EZTime helps

EZTime lets employees submit time-off requests and see their PTO balances in the mobile app, while managers approve requests with the schedule in view. Because time-off and hours worked sit in the same system as clock-ins, reports for payroll show regular hours, overtime and PTO together.

Frequently asked questions

What is the best way to track PTO?

Use one system where accruals, requests, approvals and balances are recorded together and visible to employees.

How is PTO accrual calculated for hourly employees?

Commonly as a fixed amount of PTO per hour worked, such as 1 hour per 30 hours worked, based on actual hours.

Is PTO required by federal law?

No, but many states and cities require paid sick leave, and some regulate vacation payouts and forfeiture.

Can I use a spreadsheet to track PTO?

Yes for small teams, but errors and missing audit trails become a problem as you grow.

Do I have to pay out unused PTO when someone leaves?

It depends on the state and your policy. Some states require payout of accrued vacation.

Should overtime hours earn PTO?

It is your choice unless a law specifies otherwise. State it clearly in your policy.

Where to go next

Related reading

Time off requests and balances

Employees request time off in the EZTime app and can see their PTO balance; managers approve from the same place. Pricing starts from $2 per employee a month, and the smallest accounts pay a $20 monthly minimum.

Disclaimer: This guide is general information only and is not legal advice. Paid sick leave, vacation payout and forfeiture rules vary by state and city. Check with your state labor agency or a qualified employment attorney.