Free PTO tracker spreadsheet
A PTO tracker for Excel and Google Sheets with working formulas: accrual by pay period, time taken, running balance and a cap warning. One tab for yourself, one for a small team.
Excel workbook, about 16 KB. A direct download: no form, no account, no email.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 3 | PTO per year (hours) | 80.00 | |||||
| 4 | Pay periods per year | 26 | |||||
| 6 | Balance cap (hours, blank = none) | ||||||
| 10 | Accrual per pay period (hours) | 3.0769 | |||||
| 13 | Pay date | Accrued (hours) | Time taken (hours) | Lost to cap (hours) | Balance (hours) | Balance (days) | Warning |
| 14 | 2026-11-27 | 3.08 | 0.00 | 3.08 | 0.38 | ||
| 15 | 2026-12-11 | 3.08 | 0.00 | 6.15 | 0.77 | ||
| 16 | 2026-12-25 | 3.08 | 0.00 | 9.23 | 1.15 | ||
| 17 | 2027-01-08 | 3.08 | 8.00 | 0.00 | 4.31 | 0.54 | |
| 18 | 2027-01-22 | 3.08 | 0.00 | 7.38 | 0.92 | ||
| 19 | 2027-02-05 | 3.08 | 0.00 | 10.46 | 1.31 | ||
| 20 | 2027-02-19 | 3.08 | 0.00 | 13.54 | 1.69 | ||
What is in the PTO tracker?
What does the My PTO tab do?
It tracks one person, pay period by pay period. Enter PTO per year, pay periods per year, a starting balance and the first pay date. Each row adds the accrual, subtracts the hours you type as taken, and shows the balance in hours and days. If you enter a cap, accrual stops while the balance is at the cap, the lost hours are counted, and a warning appears one pay period before the cap is reached.
What does the Team tab do?
It summarizes up to 15 people. List each person once with their PTO per year, pay periods per year, starting balance and cap, and enter how many pay periods have passed this year. Record absences on the Team log tab (date, name, hours); the Team tab adds them up and shows each balance with a cap warning. The Team tab flags a balance that has reached the cap but does not stop accrual there; for exact cap handling keep one My PTO tab per person.
What formulas does the tracker use?
The same ones as the PTO accrual calculator. Accrual per pay period = PTO per year ÷ pay periods per year, so 80 hours a year paid every two weeks is 3.0769 hours a period. Balance = previous balance + accrual credited − time taken. Balance in days = hours ÷ hours in a day.
How do I open the PTO tracker?
In Excel
Open the downloaded file. If Excel shows it in Protected View, choose Enable Editing so you can type in the shaded cells.
In Google Sheets
Upload the file to Google Drive and open it with Google Sheets, or in a new sheet choose File, then Import, then Upload. The tracker uses only formulas that Excel and Google Sheets share.
If you are paid twice a month or monthly
The Pay date column steps forward by a fixed number of days, which fits weekly and every-two-weeks pay. For other schedules, type your real pay dates over the dates in that column; the balance formulas do not depend on the dates.
Questions about the tracker
Is the PTO tracker free?
Yes. The download is a direct link to the file. There is no form, no account and no email required.
Does the PTO tracker work in Google Sheets?
Yes. It uses only formulas that Excel and Google Sheets share. Upload the file to Google Drive and open it with Google Sheets.
How does the tracker calculate the balance?
Accrual per pay period is PTO per year divided by pay periods per year. Each row adds the accrual, subtracts the time taken, and, if a cap is set, credits only the room left under the cap.
The tracker does arithmetic. It does not know your employer's policy or your state's rules. This is general information, not legal advice.
More calculators
- PTO accrual calculator: your balance on any date, per pay period and per hour worked.
- PTO payout calculator: unused hours × hourly rate, with your state's rule.
- PTO hours to days converter: hours into days and back, with your own hours in a day.
- Prorated PTO calculator: PTO for a mid-year start or a part-time schedule, by two methods.
- PTO accrual rate table: the rate that gives 5 to 30 days a year, for every pay frequency.
- Embed the calculator: put the accrual calculator on your own site.
- PTO payout laws by state: whether unused vacation is paid out when a job ends, with the statute for each state.