FREE PTO Tracking Template 2026 — Canada
Track vacation, sick leave, and statutory holidays for your Canadian team. Download our free spreadsheet for Google Sheets or Excel and start organizing PTO in minutes.
How to use this PTO spreadsheet
Add your employees
Enter employee names in the tracker. Use built‑in filters in Google Sheets or Excel to quickly view PTO by person or team.
Set your leave types
Create up to six leave categories (e.g., Vacation, Sick, Personal, Bereavement). Assign short codes like "V" or "SL" and log them on the calendar; the sheet totals days automatically.
Add public holidays
Add Canadian statutory holidays — New Year’s Day, Good Friday, Canada Day, Labour Day, Thanksgiving, and Christmas Day — to keep the calendar accurate.
Track time off and accruals on autopilot.
Employees request time off in seconds, balances stay accurate, and approvals happen in a tap — no spreadsheets, no manual math.
Multiple time-off types
Manage vacation, sick leave, personal days and custom leave types in one place. Employees request time off, view balances, and get real-time updates. Managers set custom rules, automate approvals, and get reports on usage.
- Custom leave types
- Real-time balances
- One-tap approvals
- Automated accruals
Days or hours
Track time off in days or hours — whichever fits your policies.
Automated accruals
Accrue by tenure, hours worked, anniversary — weekly, 2-weeks, monthly or yearly.
- Tenure rules
- Carry forward
- Probations
- Anniversary
Time off notifications
Employees and managers get instant updates on requests and approvals.
Vacation dashboard
See who's off, who's sick, and who's remote across the whole company.