Skip to content
Nika

🚗 Free Mileage Log Template

Below is a complete mileage log: date, destination, business purpose, starting and ending odometer readings, and total distance. Copy it into a spreadsheet and claim every kilometre you are entitled to.

If you drive for business — visiting clients, running errands, travelling between sites — those kilometres are a legitimate deductible expense in most jurisdictions. But tax authorities require a contemporaneous log: a record made at or near the time of the trip, not reconstructed from memory months later. This template gives you the columns they want to see.

Trip Log Columns

FieldsDescription
Date*The date of the trip.
Starting Location*Where the trip began — usually your office or home.
Destination*Where you drove to.
Business Purpose*Why the trip was necessary — e.g. “Client meeting with ACME Corp.”
Start Odometer*Odometer reading at departure.
End Odometer*Odometer reading at arrival.
Total km / miles*End − Start (auto-calculated).
VehicleWhich car, if you use more than one.
DriverWho drove, if multiple drivers.

Summary

FieldsDescription
Period*e.g. January 2026.
Total Business km*Sum of all trip distances.
Rate per kmYour jurisdiction’s approved rate — e.g. €0.25/km.
Total Deduction*Total km × Rate per km.

How to use

  1. 1Log every business trip the same day — do not reconstruct from memory.
  2. 2Record the odometer before you start driving and when you arrive.
  3. 3Write a specific business purpose — “client meeting” is fine, “driving around” is not.
  4. 4Do not include your regular commute from home to your office — that is generally not deductible.
  5. 5Calculate total kilometres at month-end using a SUM formula.
  6. 6Multiply by your local tax authority’s approved rate to get the deduction amount.

Or automate this

Writing down every odometer reading by hand is tedious, and that is exactly why most people lose this deduction. Nika can track mileage from your calendar and location data, categorise trips as business or personal, and build the log for you — from {price} per trip. Drive the miles; she logs them.

Questions

Is my daily commute deductible?

No. The trip from your home to your regular place of work is a personal commute and is not deductible. However, trips from your office to a client site, between job sites, or to a temporary work location generally are deductible.

What mileage rate should I use?

Each tax authority sets its own approved rate per kilometre — check your local rules. The rate is designed to cover fuel, maintenance, depreciation, and insurance, so you do not separately claim those costs if you use the mileage method.

Other templates