CRA Mileage Logbook 2026: Business vs Personal Km, Vehicle Expense Tracker (Canada)

- 600-row trip log (date, from, to, purpose, business or personal, odometer or km), with a check column that flags missing details, odometer typos and dates outside the tax year

- Business km, total km (odometer or log) and your business-use %

- Vehicle-expense sheet that applies your business-use %, plus parking at 100%: the figure you need for T2125/T776 line 9281

- 2026 CRA reasonable per-km allowance rates for provinces ($0.73 / $0.67) and territories ($0.77 / $0.71), from canada.ca, as a reference for employer reimbursement

- Monthly km chart and an instructions tab with the CRA's logbook requirements

- Built and tested in Excel/LibreOffice, using only functions that also exist in Google Sheets. To open it in Google Sheets: upload the .xlsx to Google Drive, then Open with → Google Sheets. It hasn't been tested in a live Google Sheets account. Formula-cell protection applies in Excel only (there's no password: Review → Unprotect Sheet).

Instant download: .xlsx, README and test cases.

Estimate, not tax advice. Not affiliated with or endorsed by the CRA.

Licence: In addition to Payhip's standard licence, you may use this template for your own records, personal or commercial; don't resell or share the file.