Looking for a CRA mileage log Excel template free of charge? A spreadsheet is one of the most accessible ways to start tracking business kilometres for your tax return. The CRA accepts digital spreadsheets — including XLSX, CSV, and PDF formats — as valid vehicle logbook records. Below is the exact column structure your template needs, the formulas that save time, and why many Canadians eventually move from spreadsheets to automatic GPS tracking.
What the CRA Requires in a Mileage Log
Before building your Excel template, you need to understand what the CRA expects. For every business trip, your logbook must record:
- Date — the exact date the trip took place.
- Destination — the address or location you drove to.
- Business purpose — a concise reason for the trip such as a client meeting, delivery, or site visit.
- Kilometres driven — the distance covered during that specific trip.
In addition to per-trip records, the CRA requires your vehicle’s odometer reading at the start and end of each fiscal year. These two readings establish total kilometres driven across all purposes, which determines your business-use percentage.
If you use the vehicle for both business and personal driving, you must track both categories. Commuting between your home and a regular place of work always counts as personal use — no exceptions.
The CRA also requires you to retain your mileage log for six years from the date you file the associated tax return. For your 2025 return filed in April 2026, that means keeping records until at least December 2031.
CRA Mileage Log Excel Template Structure
Here is the column layout your free template should follow. Each column maps directly to a CRA requirement:
| Column | Field | Example |
|---|---|---|
| A | Date | 2026-03-15 |
| B | Destination | 123 Main St, Ottawa |
| C | Business Purpose | Client meeting — ABC Corp |
| D | Trip Type | Business |
| E | Odometer Start | 42,150 |
| F | Odometer End | 42,218 |
| G | Trip Distance (km) | =F2-E2 |
| H | Running Total (km) | =SUM($G$2:G2) |
Year-end summary tab. Create a second sheet in the same workbook with these calculated fields:
- Total business km: =SUMIF(Log!D:D,“Business”,Log!G:G)
- Total km driven: Year-end odometer minus January 1 odometer
- Business-use percentage: =Total business km / Total km
- Deduction factor: Apply this percentage to your eligible vehicle expenses on Form T2125 (self-employed) or Form T777 (employees)
This structure covers the full and simplified logbook methods. If you qualify for the CRA simplified logbook method, you still need every column above — but only for a three-month sample period after establishing a 12-month base year.
Formulas and Features That Improve the Template
A basic table captures the data, but a few Excel formulas make the template significantly more useful:
Auto-calculate trip distance. In column G, use =F2-E2 to derive distance from odometer readings. This eliminates manual subtraction errors and creates a verifiable chain between consecutive trips.
Running business total. Column H uses =SUM($G$2:G2) to show cumulative business kilometres at any point during the year. This helps you monitor progress toward the 5,000 km threshold where the CRA rate drops from $0.73 to $0.67 per kilometre in 2026.
Conditional formatting. Highlight rows where the Trip Type column is blank. Missing classifications are one of the most common spreadsheet errors found during audits.
Data validation. Add a dropdown in the Trip Type column that restricts entries to “Business” or “Personal.” This prevents typos and inconsistent labels that break SUMIF formulas.
Odometer gap check. Add a helper column with =E3-F2 to flag gaps between consecutive trips. A gap means personal kilometres occurred between logged trips — which is fine, but large unexplained gaps can raise audit questions.
What CRA Auditors Look for in Spreadsheet Logs
An Excel mileage log will satisfy CRA requirements on paper, but auditors are trained to spot signs that a log was reconstructed after the fact rather than maintained in real time:
Round numbers. If every trip distance ends in 0 or 5, the data was likely estimated. Real odometer readings produce random digits.
Identical distances. Driving to the same client should produce slightly different kilometre readings each time due to route variation, traffic detours, and stops. A column of identical figures suggests the entries were copied.
Batch modifications. Spreadsheet software records file metadata including last-modified dates. If your entire year of entries was saved in one or two sessions, the log appears reconstructed.
No weekend entries. Many self-employed Canadians work weekends. A log that shows exclusively Monday-to-Friday trips for twelve months may not match fuel receipts or calendar records.
Odometer continuity gaps. If a trip ends at 43,500 km and the next starts at 44,200 km, the 700 km gap needs to be accounted for — typically through personal driving entries in the same period.
Understanding these red flags is important whether you track in Excel or use an app. For a full breakdown of what triggers a closer look at your vehicle claims, see CRA audit triggers for small business.
Why Spreadsheets Fall Short for CRA Compliance
The core limitation of any Excel mileage log is that every data point is self-reported. There is no independent verification behind the numbers. When an auditor questions a specific entry, you rely on memory and indirect evidence like fuel receipts or calendar appointments to defend it.
Here is where manual tracking creates friction:
- Forgotten trips. If you do not log a trip the same day, you may forget it entirely. Missed entries reduce your business-use percentage and your deduction.
- No GPS proof. Spreadsheets cannot prove you actually drove the route. A GPS-verified record contains coordinates, timestamps, and distance data that cannot be fabricated retroactively.
- Time cost. Logging each trip manually — opening the file, entering the date, typing the destination, reading the odometer — takes two to three minutes per trip. At five trips per day, that is over 40 hours per year spent on data entry alone.
- Version control risk. Accidentally overwriting a file, losing a local copy, or forgetting to back up can mean losing an entire year of records. The CRA requires six years of retention, and a single lost file can void your deduction for that year.
- No real-time tracking. A spreadsheet cannot detect when you start driving. You must remember to log every single trip, every single day.
For self-employed Canadians filing vehicle expenses on Form T2125, the stakes are high. The self-employed vehicle expenses guide explains how your logbook feeds directly into your deduction calculation.
A Better Approach: Automatic GPS Tracking With Tripbook
A free Excel template is a reasonable starting point, but Tripbook eliminates every limitation listed above. The app runs in the background on your iPhone, automatically detecting trips via GPS and recording the date, start and end locations, distance, and route — the exact fields the CRA requires.
What Tripbook handles automatically:
- Detects trip start and end without manual input
- Records GPS-verified coordinates and route for every trip
- Calculates business-use percentage from classified trips
- Generates a year-end CSV or PDF export that maps directly to Form T2125 or T777
- Stores records in the cloud with automatic backup for six-plus years
- Tracks odometer readings digitally — no squinting at the dashboard
Instead of spending 40-plus hours per year on manual data entry, you spend a few seconds classifying each trip as business or personal. Everything else is captured automatically.
Tripbook is free to download and produces the same CRA-compliant summary you would build manually in a spreadsheet — backed by real-time GPS data instead of self-reported numbers.
Download Tripbook to replace your Excel template with GPS-verified mileage tracking that holds up under a CRA audit.
For the official CRA per-kilometre rates to use in your deduction calculation, see CRA mileage rate 2026.
