Free template
Free CRA mileage log template
A logbook for the kilometres you drive for your business, as a spreadsheet or a printable PDF. It has the trip details the CRA lists and a year summary that works out your business-use percentage.
Kilometres, totals and your business-use percentage calculate as you type.
4 pages of 25 trips and a year-summary page. Fits Letter and A4.
Columns
- Date
- Start location
- Destination
- Business purpose
- Start odometer
- End odometer
- Kilometres
- Business? (Yes/No)
The rules
What the CRA expects in a logbook
For each business trip
The CRA asks you to keep a log of every trip you make to earn business income, listing:
- The date
- The destination
- The purpose
- The number of kilometres you drive
The template also has columns for where you started and the odometer at each end of the trip. The CRA doesn't list those, but they make each entry easier to check.
Odometer readings
Record each vehicle's odometer reading at the start and end of your fiscal period. The two readings give you the total kilometres driven.
If you change vehicles during the fiscal period, record the dates of the change and the odometer reading when you buy, sell or trade. If you use more than one vehicle for your business, keep a separate record for each one.
The simplified logbook
After keeping a full logbook for one complete year, your base year, you can keep a logbook for a three-month sample period in later years, as long as the result is within 10% of the base year. You also have to show that the base year still reflects how you normally use the vehicle.
Annual business use = (sample period % ÷ base-year % for the same months) × base-year annual %. The CRA's example: the base year shows 49% for the year and 46% for April to June. A later April-to-June sample shows 51%, so (51% ÷ 46%) × 49% = 54%. That is not lower than 39% or higher than 59%, so the CRA would accept 54% in the absence of contradictory evidence.
If the calculated figure moves by more than 10%, the sample only covers its own three months, and the CRA suggests starting a new 12-month base year.
How long to keep it
Records are kept for six years from the end of the tax year they relate to. The full 12-month base-year logbook is kept for six years from the end of the last tax year it is used to support.
The arithmetic
How to calculate your business-use percentage
Total kilometres: odometer at the end of the fiscal period minus odometer at the start.
Business kilometres: add up the kilometres of every business trip in the log.
Business-use percentage: business kilometres ÷ total kilometres × 100.
Apply that percentage to your vehicle expenses. Business parking fees and supplementary business insurance are deductible in full.
Worked example
- Odometer at start of fiscal period
- 41,000 km
- Odometer at end of fiscal period
- 71,000 km
- Total kilometres
- 30,000 km
- Business kilometres from the log
- 27,000 km
- Business-use percentage
- 27,000 ÷ 30,000 = 90%
- Vehicle expenses for the year
- $5,400
- Business part
- 90% × $5,400 = $4,860
- Plus business parking and supplementary insurance
- $40 + $100
- Motor vehicle expenses claimed
- $5,000
The kilometres and dollar amounts are the CRA's own example on canada.ca; the odometer readings are added for illustration. In the spreadsheet, enter the two odometer readings on the Year summary sheet and mark each trip Yes or No, and the totals and percentage fill in.
Prefer not to fill it in by hand?
Turn on trip tracking in the ReceiptOne app and it records your drives by GPS in the background. Tag each trip business or personal, and your mileage report lists every business trip with its date, start and end addresses, purpose and distance.
Enter your odometer readings for each vehicle and the T2125 report fills in the kilometres for Chart A: business kilometres, total kilometres and business-use percentage.
FAQ
Frequently asked questions
What does a CRA mileage log need to include?
For each business trip: the date, the destination, the purpose and the number of kilometres you drive. Also record each vehicle's odometer reading at the start and end of your fiscal period, and the reading when you buy, sell or trade a vehicle.
Do I have to keep a logbook every year?
Not a full one. After one complete year of full logbook, your base year, you can keep a three-month sample logbook in later years, as long as the result is within 10% of the base year and the base year still reflects your normal use of the vehicle.
How do I calculate my business-use percentage?
Divide your business kilometres by the total kilometres driven in the fiscal period, then multiply by 100. Total kilometres are the end odometer reading minus the start reading. In the CRA's example, 27,000 business kilometres out of 30,000 is 90%.
Do I need a separate log for each vehicle?
Yes. If you use more than one vehicle for your business, the CRA asks you to keep a separate record for each one.
How long do I keep my mileage log?
Six years from the end of the tax year it relates to. A full 12-month base-year logbook is kept for six years from the end of the last tax year it is used to support.
This page and the templates are general information, not tax advice. Check the CRA's current rules or ask an accountant about your own situation.
Spotted an error or something out of date? Let us know at support@receipt-one.com.