CRA Mileage Log 2026 Canada, Vehicle Expense Tracker, Business Use Percentage, T2125 Car Expenses, Excel Google Sheets

Keep a CRA-style mileage logbook, work out your business-use %, and organize your vehicle expenses for your tax return, all in one spreadsheet for Excel or Google Sheets.

Designed by Tallyfern in Ontario with the help of AI tools. Every formula and CRA rate is tested against CRA's published figures before release.

For Canadian self-employed people, sole proprietors, side hustlers and employees who drive their own vehicle for work. Canada's 2026 per-km allowance rates are built in.

✦ WHAT IT DOES
• Logbook: 600 rows for date, from, to, purpose, client, odometer start/end (or just the km) and parking. Business km are calculated for you. A Check column flags a missing date, destination, purpose or km, trips outside the tax year and odometer typos.
• Business-use %: enter your odometer on Jan 1 and Dec 31. The Summary shows total km, business km, personal km and your business-use %.
• Vehicle Costs (self-employed): 12 months of fuel, electricity (EVs), insurance, maintenance and repairs, licence and registration, loan interest and leasing. Each is multiplied by your business-use %. Business parking and supplementary business insurance count at 100%. You get a total to give your accountant or enter in your tax software for Form T2125 (line 9281), before CCA and limits.
• Per-km allowance (employees and employers): 2026 rates of $0.73/km for the first 5,000 km and $0.67/km after, or $0.77 / $0.71 in Yukon, NWT and Nunavut. Compare the result with what your employer paid.
• Simplified logbook: kept a full logbook for a base year? Log a 3-month sample and the sheet runs CRA's simplified-logbook calculation, including the within-10% check.
• Monthly summary and chart of trips, business km and costs.
• Print-ready on Letter or A4, or save it as a PDF to keep with your records.

✦ WHAT'S INCLUDED
• Blank workbook (.xlsx) for one vehicle and one tax year
• Filled SAMPLE workbook (.xlsx) with a fictional photographer's year of driving
• README (PDF): download and setup for Excel, Excel for the web and Google Sheets

✦ COMPATIBILITY
• Microsoft Excel 2016 or later / Microsoft 365, on Windows and Mac
• Excel for the web (free Microsoft account)
• Google Sheets: upload the .xlsx to Google Drive and open it with Sheets
• No macros, no add-ins, no subscription

✦ FREE 2027 RATES UPDATE
When CRA publishes the 2027 per-km rates, I'll update the workbook, and you get the update free. If it doesn't appear in your Purchases, just message me.

✦ HOW TO DOWNLOAD
1. On Etsy, go to You › Purchases and reviews › Download files (or use the link in your order email).
2. Open the .xlsx in Excel, or upload it to Google Drive or OneDrive (see the README).
3. Start on the Start Here tab.

This is a digital download. Nothing will be shipped.

✦ PLEASE NOTE
• General information, not tax advice. This workbook organizes your records; it doesn't decide what you can deduct. Capital cost allowance (CCA) and the CRA limits on interest and leasing for passenger vehicles aren't calculated. Check canada.ca or talk to an accountant about your situation.
• Tallyfern is not affiliated with the Canada Revenue Agency. Rates come from the CRA's "Automobile and motor vehicle allowances" page (2026 rates, checked 2026-10-03).
• Licensed for one person (personal or business use). Each additional user needs their own copy. Please don't resell or share the files.

✦ RETURNS
Because this is an instant digital download, returns and exchanges aren't accepted. If something isn't working, message me and I'll help.

Designed by Tallyfern, a small digital-products studio in Ontario, Canada. 🌿

Please note: this is a record-keeping template, not tax, legal or accounting advice, and Tallyfern is not affiliated with the CRA. Check figures and rates against canada.ca or with a qualified accountant before you rely on them, as we can't guarantee the CRA will accept any claim, and using the file outside its intended purpose is at your own risk. Licensed for use by one person (personal or business use); each additional user needs their own copy, and no resale or sharing. To the extent the law allows, our liability is limited to the price you paid.