Mileage Log Template

Fill in your name, vehicle and odometer reading, then print a blank mileage log or download it as a CSV for Excel or Google Sheets. The log is built in your browser and nothing is uploaded.

A mileage log needs four things for every trip: the date, where you went, the business purpose and the distance.

This page gives you an empty log to fill in. To add up the amount you can claim from your trips, use the mileage calculator.

Last reviewed 5 November 2026

Raise the limit

Enter your email and we send a 6-digit code. Once confirmed, you get a higher limit.

We use your email to send the code. We keep it as a contact record. See how we handle it in the privacy policy.

Enter your code

We sent a 6-digit code to . It expires in 15 minutes.

Driver:
Vehicle:
Odometer at the start of the year:
Blank mileage log

What a mileage log must contain

  • The date of every trip, written when you drive it rather than months later.
  • Where you started and where you went.
  • The business purpose, such as the client or site you visited.
  • The distance, taken from an odometer or a route you can show again.
  • The odometer reading at the start and end of the year, so the total can be checked.

The IRS asks for the date, mileage, destination and business purpose of each trip, and the Canada Revenue Agency expects a logbook that separates business from personal kilometres. Check the current rules with the tax authority or an accountant: this page is a template, not tax advice.

How to use this template

  1. Type your year, name, vehicle and the odometer reading on 1 January.
  2. Pick the distance unit and the number of rows.
  3. Print the log and keep it in the vehicle, or download the CSV and fill it in on your phone or computer.
  4. Write each trip the day you drive it, and total the distance at the end of the year.

Turn your trips into an amount with the mileage calculator

Read what a mileage log must contain

Paper, spreadsheet or automatic

A paper log is simple but easy to forget. A spreadsheet is easier to total and to back up. The most reliable log is one that is recorded for you: GPS trip history already has the date, route and distance of every drive, and you only add the purpose.

FAQ

Frequently asked questions

The date of each trip, where you went, the business purpose and the distance. Many people also note the odometer reading at the start and end of the year so the total can be checked.

Yes. Download the CSV and open it in Excel, Google Sheets or Numbers. A spreadsheet works as a log as long as it carries the same fields and you fill it in when you drive.

As you drive. A log written the same day is much easier to defend than one rebuilt from memory months later.

You can print a log of 25 rows right away. Confirm your email to get a log of up to 100 rows.

No. The log is built in your browser. Your name, vehicle and odometer reading never leave your device.

Tired of filling in a log by hand?

Traxelio records every trip from the vehicle itself, so the mileage log fills in without anyone typing it.