🚗 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
| Fields | Description |
|---|---|
| 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). |
| Vehicle | Which car, if you use more than one. |
| Driver | Who drove, if multiple drivers. |
Summary
| Fields | Description |
|---|---|
| Period* | e.g. January 2026. |
| Total Business km* | Sum of all trip distances. |
| Rate per km | Your jurisdiction’s approved rate — e.g. €0.25/km. |
| Total Deduction* | Total km × Rate per km. |
How to use
- 1Log every business trip the same day — do not reconstruct from memory.
- 2Record the odometer before you start driving and when you arrive.
- 3Write a specific business purpose — “client meeting” is fine, “driving around” is not.
- 4Do not include your regular commute from home to your office — that is generally not deductible.
- 5Calculate total kilometres at month-end using a SUM formula.
- 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
- 🧾 Free Invoice Template for Small Business
- 📊 Free Expense Report Template
- 📒 Free Bookkeeping Spreadsheet Template
- 🗂️ Free Chart of Accounts Template
- 📦 Free Purchase Order Template
- ↩️ Free Credit Note Template
- 📋 Free Vendor Payment Tracker Template
- ✅ Free VAT Return Checklist Template
- 🧾 Free Receipt Tracking Template
- 🏦 Free Bank Reconciliation Template
- 💸 Free Accounts Payable Template
- 📥 Free Accounts Receivable Template
- 📈 Free Profit and Loss Statement Template
- ⚖️ Free Balance Sheet Template
- 💧 Free Cash Flow Statement Template