PTO Tracker Template, Without the Spreadsheet
Download the starter CSV if you want one. Or skip it, because the arithmetic a template cannot do is already done here.
Your team's leave calendar
PTO template, in practice
Most searches for a PTO tracker template end at a spreadsheet with a tab per employee and a column per month. That works for about a quarter. Then someone joins in March and needs a prorated allowance. Someone else carries five days over but the cap is five and they had seven. A public holiday lands mid holiday and the day count is now wrong. Somebody sorts a column and breaks every formula below row forty. The template did not fail because it was a bad template. It failed because leave arithmetic is genuinely fiddly, and a grid of cells has no way to know that the fourth of July is not a working day.
So this page offers both. There is a starter CSV below if a spreadsheet is genuinely what you need, laid out with one row per absence and the columns payroll usually asks for. It imports cleanly into Excel, Google Sheets and Numbers, and it is yours to reshape. But the tracker on this page does the part a template structurally cannot: it computes working days for a booking, skips public holidays by rule for any year rather than from a list that expires, applies your carryover cap once per policy year rather than to a running total, prorates a first year by complete months, and warns you when too many people are away on the same day.
The two are not exclusive. Plenty of teams run the tracker day to day and export a CSV once a month for whoever needs it in a spreadsheet. The payroll export gives a row per absence clipped to whatever date range you ask for, with the untrimmed total kept in its own column so nothing looks like it went missing. The balances export gives a row per person with carryover, accrued, used, scheduled and remaining laid out as separate columns, so the arithmetic is auditable rather than hidden inside a formula bar.
Nothing here requires an account, and none of your data leaves the browser. If you want the spreadsheet, take the spreadsheet. If you want the maths done for you, it is already running above.
What this handles
- What a template cannot compute
- Public holidays by rule for any year, a carryover cap applied once per year, first year proration, and clash detection across the whole team.
- What the CSV is good for
- Handing a static record to payroll, archiving a closed year, or starting from a shape you want to customise heavily.
- Move between the two freely
- Export any date range as CSV whenever you need it. The tracker stays the source of truth and the spreadsheet stays a snapshot.
- No formulas to maintain
- Nobody has to remember which cells are calculated. Sorting, filtering and inserting rows cannot break anything.
Common questions
Where do I download the PTO tracker template?
The download link on this page gives you a CSV with one row per absence and the columns payroll normally asks for. It opens in Excel, Google Sheets, Numbers and anything else that reads CSV.
Why use a tracker instead of a spreadsheet template?
Because the hard parts of leave tracking are the parts a spreadsheet cannot do on its own: knowing which days are public holidays, applying a carryover cap correctly at each year boundary, prorating a first year, and spotting when several people booked the same week.
Can I import my existing spreadsheet?
Direct spreadsheet import is not supported, because the shape of every homemade template is different and guessing wrong would corrupt real records. What imports cleanly is a backup file exported from this tracker, which is how you move between browsers or machines.
What columns does the payroll export include?
Employee, leave type, start, end, days inside the requested range, total days for the whole absence, whether the type deducts from the allowance, and the note.
Does the CSV open correctly in Excel?
Yes. Exports use CRLF line endings and a UTF-8 byte order mark, so accented names open correctly rather than as mojibake, and fields containing commas or quotes are escaped to RFC 4180.
Is the template free to use commercially?
Yes. Download it, edit it, rebrand it and use it inside your company. There is no licence to accept and no attribution required.
Guides worth reading
- PTO Tracking in a SpreadsheetA layout and formulas that work, plus the four failure modes that make spreadsheet balances wrong.
- How to Calculate Prorated PTOWork out a first year allowance for a mid year joiner, with the complete months rule and worked examples.
- PTO Accrual Methods, ComparedAnnual grant, monthly accrual, hourly accrual and unlimited, compared on liability, admin and fit.