Free PTO Calculator Excel Template
Download a free spreadsheet to track PTO accrual, vacation days, sick leave, and employee time-off balances. Works in Excel and Google Sheets.
What's inside the template
Employee Details Sheet
Employee names, hire dates, annual PTO allowance, accrual method, and current balance. One row per employee.
PTO Summary Dashboard
Overview of total PTO accrued, used, and remaining across your team. Shows who is approaching their cap and who has unused days.
Monthly PTO Tracking Sheet
Log individual time-off requests by date, type (vacation, sick, personal), and hours. Auto-calculates monthly and YTD totals.
What is a PTO calculator Excel template?
A PTO calculator Excel template is a spreadsheet that tracks how much paid time off each employee has earned, used, and has remaining. Instead of using expensive HR software or manual paper tracking, you enter a few numbers and the spreadsheet does the math.
Most templates calculate PTO accrual automatically based on the method you select (per pay period, per hour worked, or annual lump sum). When someone takes a day off, you log it and the remaining balance updates.
This is particularly useful for small businesses (under 50 employees) that don't need a full HRIS system but still need to track leave accurately for payroll and compliance.
Features included
| Feature | Details |
|---|---|
| PTO tracking | Track accrual, usage, and balance for each employee |
| Vacation tracking | Separate column for vacation days used and remaining |
| Sick leave tracking | Track sick hours separately (required in 15+ states) |
| Employee dashboard | Summary view of all employees with status indicators |
| Monthly reporting | Log time-off by month with auto-calculated totals |
| Excel compatible | Works in Excel 2016+, Microsoft 365, LibreOffice Calc |
| Google Sheets compatible | Open directly in Google Sheets, no conversion needed |
What you get with this free download
- · A ready-to-use spreadsheet with formulas pre-built
- · Tracks PTO, vacation, and sick leave in one file
- · Works for hourly and salaried employees
- · Supports biweekly, semi-monthly, and monthly pay schedules
- · No macros or plugins required
- · You can duplicate and customize for your company
If you need a quick calculation without downloading anything, use our online PTO calculator instead.
How to use the template
- 1. Download or open the file. Click the download button above. Open in Excel, or upload to Google Drive and open with Google Sheets.
- 2. Enter employee information. Add each employee's name, hire date, and annual PTO allowance in the Details sheet.
- 3. Select the accrual method. Choose per pay period, per hour worked, or lump sum. The formulas adjust automatically.
- 4. Log time off as it happens. When someone takes PTO, enter the date, hours, and leave type in the Monthly Tracking sheet.
- 5. Check balances on the Dashboard. The summary sheet shows each employee's current balance, days used, and accrual status.
Need help converting PTO hours to days? Use our hours to days calculator.
Frequently asked questions
- Is this PTO calculator Excel template free?
- Yes. The template is completely free to download and use. No email signup, no account, no hidden costs. You get the full spreadsheet with all features included.
- Can I use this PTO template in Google Sheets?
- Yes. The template works in both Microsoft Excel and Google Sheets. Open it directly in Google Sheets from the link provided, or upload the Excel file to your Google Drive and open with Sheets.
- Does it work for small businesses?
- Yes. The template is designed for teams of 1-50 employees. Each employee gets their own row with accrual tracking, leave used, and remaining balance. You can add or remove rows as needed.
- How do I track PTO in Excel?
- Enter the employee name, annual PTO allowance, and accrual start date. As employees take time off, log the dates and hours used. The spreadsheet calculates remaining balance, accrual to date, and days available automatically.
- Can I track vacation and sick leave separately?
- Yes. The template has separate columns for vacation days, sick leave, and personal days. You can see each balance individually or view the combined PTO total. This is useful for states that mandate separate sick leave tracking.
Download the free PTO calculator Excel template
No signup required. Works in Excel and Google Sheets.
Related calculators
- PTO Calculator · Calculate accrual per pay period online
- PTO Payout Calculator · Find the dollar value of unused PTO
- PTO Hours to Days · Convert PTO hours to work days
- Vacation Days Calculator · Track days earned and remaining
This template provides estimates. Verify all PTO calculations with your payroll system. Full disclaimer.