A PTO tracker is a system for recording, managing, and reporting employee paid time off — including vacation, sick leave, personal days, and other absence types — to ensure accurate payroll, legal compliance, and operational coverage. Without a reliable tracker, organisations face payroll errors, compliance violations, and the kind of leave disputes that erode employee trust.
For US employers, PTO tracking is particularly complex because there is no federal mandate for paid leave, state and city laws vary dramatically, and accrual rules change depending on jurisdiction. This guide provides a template for building a PTO tracker that works across all 50 states.
Key takeaways
- A complete PTO tracker records accrual, usage, balances, and carryover for every employee in real time.
- US PTO requirements vary by state — California, New York, Illinois, and many others have mandatory paid sick leave with specific accrual rates.
- The tracker must handle front-loaded vs accrual-based approaches, carryover caps, and usage restrictions by jurisdiction.
- Manual spreadsheets break down at scale — dedicated leave management software eliminates calculation errors and provides audit trails.
- PTO tracking is a payroll input — inaccurate data leads to incorrect pay and tax reporting.
Why PTO tracking matters for US employers
The US has no federal paid leave requirement, but a growing patchwork of state and local laws mandates paid sick leave, paid family leave, and sometimes paid vacation. As of 2026:
- 15 states + DC have mandatory paid sick leave laws
- 13 states have paid family and medical leave programs
- Multiple cities (New York City, San Francisco, Seattle, etc.) have additional local requirements
Each of these laws has different accrual rates, carryover rules, usage restrictions, and record-keeping requirements. A PTO tracker must accommodate all of them.
What your PTO tracker must track
1. Accrual method
Accrual-based: Employees earn PTO incrementally (e.g., 1 hour per 30 hours worked). This is common for sick leave in states like California and New York.
Front-loaded: Employees receive their full annual PTO allotment at the start of the year. This is common for vacation time.
Your tracker must support both methods and handle the transition between them.
2. Accrual rates
Track the exact accrual rate for each leave type:
- Vacation PTO: X days/year (or X hours per pay period)
- Sick leave: X hours per X hours worked (varies by state)
- Personal days: X days/year
- Floating holidays: X days/year
3. Caps and carryover
Annual caps: Maximum PTO balance an employee can hold (e.g., California caps sick leave carryover at 48 hours).
Carryover rules: Whether unused PTO rolls over to the next year, and how much.
Use-it-or-lose-it: Some states (notably California) prohibit use-it-or-lose-it policies for sick leave. Your tracker must respect the applicable rule.
4. Usage restrictions
Some state laws restrict when PTO can be used:
- California: sick leave can be used for the employee’s own health, family care, domestic violence, or preventive care
- New York: sick leave can be used for the employee’s own health or family care
- Illinois: sick leave can be used for the employee’s own health, family care, or preventive care
Your tracker should allow employees to specify the reason for use where required by law.
5. Balances and real-time tracking
The tracker must show:
- Current balance for each leave type
- Accrued but not yet available balance
- Pending requests (submitted but not yet approved)
- Used leave (historical)
Building the tracker: spreadsheet vs software
Spreadsheet approach
For small teams (under 25 employees), a spreadsheet can work if set up correctly.
Required columns:
| Column | Purpose |
|---|---|
| Employee name | Identification |
| Leave type | Vacation, sick, personal, floating holiday |
| Accrual rate | Hours per pay period or per year |
| Year-to-date accrued | Running total of earned leave |
| Year-to-date used | Running total of taken leave |
| Current balance | Accrued minus used |
| Carryover from prior year | Previous year’s unused balance |
| Cap | Maximum balance |
| Request status | Pending, approved, denied |
| Approval date | When the request was approved |
Limitations of spreadsheets:
- No automated accrual calculation
- No notification system for expiry dates
- No audit trail for compliance
- Error-prone with multiple leave types
- Difficult to enforce carryover caps
Software approach
For teams over 25 employees or those in multiple states, dedicated leave management software is essential.
What to look for:
- Multi-state compliance built in
- Automated accrual calculations
- Real-time balance tracking
- Manager approval workflows
- Integration with payroll systems
- Audit trail and reporting
- Employee self-service portal
Putting it into practice
Five checks to ensure your PTO tracker is accurate:
- Confirm the accrual method and rate for each leave type and jurisdiction.
- Set carryover caps and expiry dates in the tracker and enforce them automatically.
- Require manager approval for all leave requests with a documented workflow.
- Sync the tracker with payroll to ensure accurate pay deductions.
- Run a quarterly reconciliation between the tracker and payroll records.
Leave Balance is a purpose-built PTO tracker that handles multi-state compliance, automated accrual calculations, and real-time balance tracking — so you never miscalculate an accrual or miss a statutory requirement.
Frequently asked questions
How do I track PTO accrual in the US?
Use a formula: accrued PTO = hours worked × accrual rate. For example, if the accrual rate is 1 hour per 30 hours worked and the employee worked 120 hours last month, they accrued 4 hours of PTO. Dedicated leave management software automates this calculation.
Do I have to pay out unused PTO in the US?
It depends on your state and your policy. In California, unused accrued PTO must be paid out on termination. In states without a specific law, payout depends on the employment contract or company policy. If your policy promises payout, you must honor it.
What is the difference between PTO and vacation?
PTO is a broader category that includes vacation, sick leave, personal days, and other paid time off. Vacation is specifically time off for rest and recreation. Many companies use “PTO” as an umbrella term for all paid leave types.
Can I cap PTO accrual in the US?
Yes, but with caution. California prohibits caps on sick leave accrual (except the 48-hour carryover cap). For vacation/PTO, most states allow caps, but the cap must not effectively deny employees the ability to use their accrued leave. Always check state law.
How do I handle PTO in multiple states?
Each state has different rules for accrual, carryover, usage, and payout. Your PTO tracker must apply the correct rules based on the employee’s work location. This is one of the strongest arguments for using dedicated leave management software over spreadsheets.
This article is general information, not legal advice. Consult qualified employment counsel for jurisdiction-specific guidance.