Mileage & taxesUpdated for 2026

Mileage Log Template: A Practical Guide for Excel, Google Sheets, and Print

Copy a simple mileage log template into Excel or Google Sheets, learn what to record, and build a more consistent business mileage routine.

November 5, 20264 min read
White sedan on a city street beside a mileage log sheet, green pen and car key

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.

DateVehicleFromToBusiness purposeStart odometerEnd odometerBusiness miles
10/12/2026Vehicle AOfficeClient premisesProject meeting with Client A24,51024,52818
10/12/2026Vehicle AClient premisesOfficeReturn from project meeting24,52824,54618

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 entryMore useful entry
WorkSite inspection for Project B
MeetingContract review meeting with Client C
SuppliesCollection 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.

Ready to make mileage tracking easier?

Spend less time entering trips manually. Use DriverAI to record your mileage, classify business journeys, and keep your trip records organized.

FAQ

Frequently asked questions

No specific commercial template makes a record valid automatically. The adequacy and accuracy of the information matter.

Yes, as a recordkeeping format. Maintain the underlying information and backups.

A fuel receipt does not establish the business purpose and distance of each journey.