
A mileage log template gives your driving records a consistent structure. Whether you make occasional client visits or drive for deliveries every day, the aim is to capture enough information to explain each business journey later.
You can start with a spreadsheet or printed sheet. The most useful format is the one you will maintain accurately.
What should an IRS mileage log contain?
Your records should establish the date, destination, business purpose, and distance of business driving, alongside the information needed to determine total annual vehicle use.
Record journeys at or near the time they occur. An annual total without supporting trip information is much less useful than a timely record.
Copyable mileage log template
Copy this layout into Excel or Google Sheets, or use it as a printable mileage log.
| Date | Vehicle | From | To | Business purpose | Start odometer | End odometer | Business miles |
|---|---|---|---|---|---|---|---|
| 10/12/2026 | Vehicle A | Office | Client premises | Project meeting with Client A | 24,510 | 24,528 | 18 |
| 10/12/2026 | Vehicle A | Client premises | Office | Return from project meeting | 24,528 | 24,546 | 18 |
The completed rows are fictional examples.
Add a separate annual summary recording beginning and ending odometer readings, total mileage, business mileage, commuting mileage, and other personal mileage. Check the IRS mileage rate 2026 when using the log to calculate a deduction.
How to use the mileage log in Excel
With the columns above, the start odometer is column F and the end odometer is column G.
For a journey consisting entirely of business driving, enter this formula in H2:
=G2-F2
Copy it down for later entries. Review the result before treating it as business mileage. If a journey includes a personal detour, the entire odometer difference should not automatically be classified as business.
To total the business mileage in rows 2 through 100, use:
=SUM(H2:H100)
Keep an untouched copy of the template so you can begin a new period without deleting your historical records.
Write business purposes that make sense later
A short, specific description is more useful than a vague label.
| Vague entry | More useful entry |
|---|---|
| Work | Site inspection for Project B |
| Meeting | Contract review meeting with Client C |
| Supplies | Collection of packaging supplies from Supplier D |
You do not need a long narrative. You need enough context to understand the journey when reviewing the log months later.
Spreadsheet or printable mileage log?
A spreadsheet works well if you want totals and sorting. A printed log may suit drivers who prefer writing information immediately after parking.
If using paper, photograph or scan completed pages regularly. If using a spreadsheet, keep backups and check that formulas include newly added rows.
Avoid maintaining several competing versions of the same log. Choose one main record and use other documents to support it.
What changes when you use automatic tracking?
Automatic tracking can reduce manual distance entry. You still need to review trip classifications and explain business purposes.
Driver AI’s automatic mileage tracker offers trip recording, trip notes, and mileage reports. These features can help drivers who find it difficult to maintain a manual spreadsheet consistently.
For a broader view of your business, keep the log alongside a small business income and expenses spreadsheet. Start with the template above, or use Driver AI to make recording and reviewing your trips easier.