Employee Vacation and PTO Tracking
Vacation tracking looks like arithmetic and is actually a legal and accounting question with arithmetic attached. In several states accrued vacation is earned wages, which means the balance in your spreadsheet is a debt, and how you handle it at year end and at termination is constrained by law.
This page covers the accrual methods, the state rules that catch employers out, and a tracker layout you can copy.
The three accrual methods
Which you choose determines almost everything downstream: what a mid-year joiner gets, what happens at year end, and what you owe when someone leaves.
| Method | How it works | Suits | Watch for |
|---|---|---|---|
| Annual grant | Full entitlement on a set date | Small teams, simple admin | A joiner in November has a full year's leave |
| Per pay period accrual | A fixed amount each period | Hourly and mixed workforces | Rounding drift over the year |
| Per hour worked | Accrues in proportion to hours | Part-time and variable schedules | Needs accurate hours to work at all |
Per pay period: =annual_days / periods_per_year
Per hour worked: =annual_hours_entitlement / expected_annual_hours
Pro-rated for a mid-year start: =annual_days * (days_remaining_in_year / 365)
Balance: =opening + accrued - taken - paid_out
Per-hour accrual is the one that quietly breaks. It depends on hours data being right, so if your timesheets are approximate, your leave balances are too, and the error compounds all year before anyone notices.
The balance is a liability
This is the part that surprises people who inherited the spreadsheet. Where accrued vacation must be paid out on separation, the outstanding balance is money the business owes, and it should appear as an accrued liability rather than as a number in a leave tracker.
It also grows with salaries. Vacation accrued at one rate and paid out at the final rate means an old balance costs more than it did when it was earned. A long-tenured employee with several years of untaken leave is carrying a liability that has appreciated the whole time.
Per employee: =unused_days * daily_rate
Daily rate: =annual_salary / working_days_per_year
Total exposure: =SUM(per_employee_liability)
Run that once a quarter. It is the number that turns "we should encourage people to take leave" from a wellbeing statement into a finance one, and it is usually larger than expected.
Where use-it-or-lose-it is illegal
No federal law requires paid vacation at all. Once you offer it, state law governs what you may do with it, and the states diverge sharply.
California is the strictest and the clearest. Per the California Division of Labor Standards Enforcement, earned vacation is treated as wages and vests as labor is performed. A policy providing for forfeiture of vacation not used by a specified date, the ordinary use-it-or-lose-it arrangement, is an illegal policy under California law. Whenever employment ends, for any reason, the employer must pay out all earned and accrued unused vacation at the employee's final rate of pay.
A reasonable cap is permitted, though. Because vacation vests as it is earned it cannot be taken away, but accrual can be stopped once a ceiling is reached, provided the cap is not a subterfuge for denying the benefit. That distinction, forfeiture versus a ceiling on further accrual, is the one that matters and the one most policies blur.
Other states take other positions, several requiring payout only if the policy or contract promises it. Because the rule follows the employee rather than the head office, a distributed team can be under several regimes at once, in the same way monitoring notice duties are, as our state-by-state guide sets out for that topic. Confirm each state you employ in with counsel rather than applying one policy everywhere.
A tracker you can copy
One row per employee, one tab per year, and the opening balance carried forward explicitly rather than recalculated.
| Employee | State | Opening | Accrued YTD | Taken | Scheduled | Balance | Cap | Liability |
|---|---|---|---|---|---|---|---|---|
| [name] | [state] | 0.0 | ||||||
| 0.0 | ||||||||
| Total | 0.0 | 0.00 |
Two columns earn their place. State, because the payout and forfeiture rules depend on it and you will otherwise apply one policy to everyone. Scheduled, because leave that is booked but not yet taken is the difference between a balance that looks alarming in October and one that resolves itself by December.
Keep the opening balance as a typed value rather than a formula chaining back through previous years. Every leave tracker that becomes unauditable does so because someone changed a prior year and every subsequent balance moved.
Year end, carryover and the January problem
Most vacation tracking failures happen in one week of the year, and they are predictable enough to design around.
Decide the carryover rule and write it down. Three workable options: carry everything, carry a capped number of days, or carry with an expiry date part-way through the following year. The third is the most common and the one most often applied loosely, because the expiry arrives and nobody has told the people affected.
Check the rule is lawful where each person works. An expiry date is forfeiture, and in states that treat vacation as vested wages, forfeiture is not available to you. A cap on further accrual usually is. The wording that survives is a ceiling, not a deadline.
Warn people twice, with a balance in the message. A generic reminder that leave expires is ignored; a message saying this person has this many days and this date does not. Send it in October and again four weeks before.
Expect a January bottleneck and plan the cover. If leave expires in March, the first quarter absorbs a year of deferred leave. That is a capacity question rather than a leave question, and it is the same one covered in team capacity planning.
The version of this that causes real damage is the balance nobody checked. Someone takes a day in December against a balance the tracker got wrong in March, and the correction lands as an accusation rather than as an arithmetic error. Reconcile quarterly and the January week stops being an event.
Where people leave rather than stay, the counterpart measure is how turnover is calculated, and the pattern where they stay but disengage is quiet firing if the employer is causing it.
Unlimited PTO, and what it actually changes
Unlimited or discretionary PTO removes accrual, and with it the liability, which is the reason finance departments like it. If nothing accrues, nothing is owed at termination.
That is a real advantage and it is worth being straight about it, because it is also the criticism: converting an accrued benefit into a discretionary one removes something employees had a claim on. In California in particular, moving from an accrual policy to an unlimited one does not erase vacation already vested under the old policy.
The operational catch is that unlimited policies frequently reduce leave taken rather than increase it. With no balance, there is no visible entitlement to draw down and no signal about what is normal, so people take their cue from colleagues and managers and typically take less.
If you run one, track days taken anyway. Not to police it, but because without the data you cannot see who has taken almost nothing this year, which is the only question the policy makes harder to answer and the most important one to ask.
Key takeaways
- No federal law requires paid vacation. Once offered, state law governs what you may do with it.
- In California earned vacation is wages, vests as work is performed, and use-it-or-lose-it forfeiture is illegal.
- A reasonable accrual cap is permitted in California. Stopping further accrual is legal; taking back what vested is not.
- The outstanding balance is a liability that appreciates, because old leave is paid at the final rate of pay.
- Per-hour accrual is only as accurate as your hours data, and the error compounds all year.
- Track the employee's state in the tracker, because payout rules follow the employee, not the head office.
- A carryover expiry date is forfeiture, so it is unavailable in states that treat vacation as vested wages. A cap on further accrual usually is not.
- Unlimited PTO removes the liability and usually reduces leave taken. Track days taken anyway, to see who is taking none.
Frequently asked questions
How does PTO accrual work?
Three common methods: an annual grant on a fixed date, a fixed amount each pay period, or an amount proportional to hours worked. Per pay period is the most common for mixed workforces, and per hour suits part-time and variable schedules but depends entirely on hours data being accurate.
Is use-it-or-lose-it vacation legal?
It depends on the state. In California it is not: earned vacation is treated as wages that vest as labor is performed, and a policy forfeiting vacation not used by a specified date is illegal. Other states permit forfeiture, and several require payout only where the policy or contract promises it.
Can an employer cap vacation accrual?
In California yes, and the distinction matters. A cap that stops further accrual once a ceiling is reached is permitted, provided it is not a subterfuge for denying the benefit. Forfeiting vacation already earned is not, because it has already vested.
Do I have to pay out unused vacation when someone leaves?
In California, yes, at the employee's final rate of pay whenever employment ends for any reason. Other states vary, with several requiring payout only if the employer's own policy promises it. Because the rule follows the employee, a distributed team can be under several regimes at once.
Is unused vacation a financial liability?
Where it must be paid out, yes, and it should appear as an accrued liability rather than only in a leave tracker. It also appreciates, because vacation earned at one salary is paid out at the final rate, so an old untaken balance costs more than it did when it was earned.
Does unlimited PTO reduce how much leave people take?
It frequently does. Without a balance there is no visible entitlement to draw down and no signal about what is normal, so people take their cue from colleagues and managers. Tracking days taken under an unlimited policy is worth doing, in order to see who has taken almost none.
Can I set an expiry date on carried-over vacation?
Only where forfeiture is lawful. An expiry date is forfeiture by another name, so in states that treat accrued vacation as vested wages it is not available. A cap that stops further accrual at a ceiling usually is. Where an expiry does apply, tell each affected person their actual balance and the date, twice, rather than sending a generic reminder.
What should a vacation tracker include?
Employee, their state, opening balance, accrued to date, taken, scheduled but not yet taken, current balance, any cap, and the monetary liability. State and scheduled are the two columns most trackers omit and most need.