Free to Use • No Signup Required • Updated June 2026

Free PTO Calculator Excel Template

Download a spreadsheet to track PTO, vacation, and sick leave for yourself or your team.

PTO Tracker Spreadsheet

CSV format — opens in Excel, Google Sheets, and LibreOffice Calc.

  • Annual PTO hours and pay frequency
  • Per-period accrual formula columns
  • Used hours and remaining balance
  • Sample rows for hourly and salaried employees
Download free template

How to use the template

  1. Download the CSV and open it in your spreadsheet app.
  2. Enter each employee's annual PTO hours and pay periods per year (26 for biweekly, 12 for monthly).
  3. Update Hours Used when leave is taken.
  4. Remaining Balance = Accrued YTD − Hours Used (adjust formulas to match your policy).

Pair this template with our PTO Calculator and PTO Accrual Calculator to validate accrual rates.