Skip to content
The title slide and first slides of the Canada Vehicle Logbook template

Canada Vehicle Logbook

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Self-employed Canadians and employees with vehicle costs use this logbook to back up a claim. The Trips tab records each trip with the odometer at both ends, its purpose and whether it was business or personal. The Costs tab lists fuel, insurance, repairs and other bills. The Vehicles tab uses your January and December odometer readings to turn the logbook into a business share and a business part of costs. The Dashboard summarizes kilometres and spending.

Fill in the logbook on the day of the trip. Odometer readings are harder to rebuild from memory than a date and a destination. Log personal trips as well, since the business share compares business kilometres with all kilometres. Keep the bills in a folder and mark any row that is missing a receipt. Check the CRA guide on vehicle logs for current requirements, and talk to a tax professional if you use the car for both employment and self-employment.

Useful for

  • Back up a vehicle claim with a dated trip list
  • Work out the business share for a year
  • Spot missing fuel and repair receipts

What's included

  • 5 tabs: Dashboard, Trips, Costs, Vehicles, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Trips: a table
  • Costs: a table
  • Vehicles: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Trips tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Do I have to log every trip for the whole year?

The CRA asks for enough records to show your business use, and the rules for a sample period are set out in its guidance. Check the current guide, or consult a tax professional on which method fits your situation.

How does the sheet work out the business share?

The Vehicles tab divides your logged business kilometres by the total kilometres driven in the year, taken from your January and December odometer readings. Costs are multiplied by that share.

Can I use it for two vehicles?

Yes. Give each vehicle its own row on the Vehicles tab, use the same name on the Trips and Costs tabs, and each vehicle gets its own share and cost split.

  • #tax-tracker
  • #canada-vehicle-logbook
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…