Mileage Log Template for Taxes: A Practical Structure You Can Reuse

A mileage log template only works if it fits the way you actually drive for work. Most templates found online are either so bare-bones they miss IRS requirements or so cluttered they take longer to fill out than the trip itself. This guide gives you a detailed, reusable structure built for US tax filing — with example rows, IRS requirements, and common mistakes to avoid.

What the IRS actually requires in a mileage log

IRS Publication 463 spells out five elements for every business trip you want to deduct:

1. Date of the trip
2. Destination — the name of the city or town, plus the street address or general description of the location
3. Business purpose — the business reason for the trip or the business benefit you expect to gain
4. Miles driven for business
5. Total miles for the period (so the IRS can verify your business-use percentage)

The IRS expects these records to be “timely” — meaning you log trips at or near the time they happen, not reconstructed months later from memory. Under IRC Section 274(d), vehicle expenses fall under the “strict substantiation” rules, which means estimates and approximations are not enough if you’re audited. The IRS can disallow your entire mileage deduction if your log fails these requirements.

Odometer readings are not explicitly mandated for every trip, but they provide strong supporting evidence. Recording the odometer at the start and end of each trip creates a verifiable chain that’s difficult to dispute.

The template: columns and structure

Use these seven columns for each row:

Date | Start Location | Destination | Business Purpose | Miles | Odometer Start | Odometer End

Here is a sample log with eight trips covering different scenarios you are likely to encounter:

Date	Start Location	Destination	Business Purpose	Miles	Odometer Start	Odometer End
2026-01-06	42 Elm St (Home Office)	Acme Corp, 200 Main St	Quarterly review meeting with client	14.2	58,310	58,324
2026-01-09	42 Elm St (Home Office)	O’Hare Airport, Terminal 2	Flight to Denver for trade show	28.7	58,401	58,430
2026-01-14	42 Elm St (Home Office)	Office Depot, 88 Industrial Blvd	Purchase printer paper and toner for business	6.3	58,512	58,518
2026-01-14	Office Depot, 88 Industrial Blvd	42 Elm St (Home Office)	Return from supply run	6.3	58,518	58,524
2026-01-20	Warehouse A, 15 Dock Rd	Client Site B, 900 Park Ave	Delivery stop 2 of 4: monthly supply drop-off	11.8	58,610	58,622
2026-01-20	Client Site B, 900 Park Ave	Client Site C, 45 River Rd	Delivery stop 3 of 4: monthly supply drop-off	9.4	58,622	58,631
2026-01-23	42 Elm St (Home Office)	Marriott Downtown, Columbus OH	Travel to 2-day project kickoff (one-way, overnight)	142.0	58,700	58,842
2026-01-28	42 Elm St (Home Office)	Dr. Smith, 500 Medical Dr	Annual DOT physical for commercial license	8.6	58,920	58,929

A few things to note about these rows:

• The supply store trip is split into two rows (outbound and return) because each leg has a distinct start and destination. You could also record this as a single round-trip row with doubled miles — pick one method and stick with it.
• The multi-stop delivery route logs each leg separately. This matters when stops serve different clients and you need to attribute miles per engagement.
• The overnight trip records only the outbound leg on the travel day. The return leg gets logged on the day you drive back.
• The medical trip is included because DOT physicals required for your commercial driver’s license can be deductible as a business expense, though standard medical mileage uses a different rate (21 cents per mile for 2026). Keep these on separate rows and clearly label the purpose.

Monthly tab layout

A practical spreadsheet setup for your mileage log template:

• One workbook per tax year (e.g., “2026_Mileage_Log.xlsx”)
• One tab per month (Jan, Feb, Mar…)
• One row per trip leg

At the top of each monthly tab, add a summary area:

• Total business miles for the month
• Total personal miles for the month
• Running annual business miles (formula pulling from all prior tabs)
• Deductible amount at the current standard mileage rate ($0.74 per mile for 2026)

At year-end, create a summary tab that pulls totals from all 12 months. This becomes your source document when filling out Schedule C (Line 9) or Form 2106.

Common log mistakes that trigger audit problems

Vague or missing business purpose

Writing “work” or “meeting” without further context is the single most common weakness. The IRS wants to know who you met, what project it related to, or what business activity the trip supported. “Client meeting — reviewed Q1 deliverables with Acme Corp” is far stronger than “meeting.”

Round numbers on every trip

If every trip in your log is exactly 10.0 miles, 15.0 miles, or 20.0 miles, it signals estimation rather than actual measurement. Use GPS or odometer readings to capture real distances with decimal precision.

Gaps in the record

A log that covers January through April, skips May through September, then picks up again in October suggests the records were reconstructed. The IRS gives more weight to contemporaneous records — ones created at or near the time of the trip. Gaps undermine credibility even for the months you did record.

No separation of personal and business miles

If your log shows only business trips and zero personal use, that raises flags. Almost every vehicle has some personal use. Record both, or at minimum, note your total miles for the year (from odometer readings at January 1 and December 31) so the business-use percentage can be calculated.

Editing old entries without a trail

If you use a spreadsheet and routinely overwrite rows, there is no way to show the IRS that changes were corrections rather than fabrications. Consider locking or protecting completed months. If you need to change a past entry, add a note explaining the correction.

Paper vs. digital logs

Paper logs

The IRS does not require any specific format. A paper notebook with the right columns is technically acceptable. The problems with paper are practical:

• Hard to total up miles without manual math
• Easy to lose or damage
• Difficult to search when the IRS asks about a specific trip two years later
• No backup unless you photocopy pages

If you use paper, photograph or scan each page monthly and store the images in a dated folder.

Spreadsheet logs

Excel or Google Sheets templates are the most common approach. They allow formulas for running totals, easy filtering by purpose or destination, and straightforward export to PDF or CSV. The risk is accidental edits — protect completed months by locking cells or sheets.

App-based logs

A mileage log app that uses GPS to detect and record trips removes most of the manual burden. The best apps capture the date, start and end locations, and distance automatically, leaving you to add the business purpose and classification. When tax season arrives, you export the data as a PDF or CSV that meets IRS requirements.

The ideal setup for most people combines an app for daily capture with a monthly spreadsheet review. The app handles the tedious recording; the spreadsheet serves as your verification and archive layer.

Recommended workflow: app plus template

1. Daily: Let a mileage tracking app capture your trips automatically
2. Weekly: Review and classify untagged trips — add business purpose notes while the context is fresh
3. Monthly: Export the month’s data to your spreadsheet template, verify totals against your calendar, and lock the tab
4. Quarterly: Spot-check a handful of trips against calendar entries or receipts
5. Year-end: Generate the annual summary, calculate the deduction, and archive everything in your tax folder

This keeps your records consistent, contemporaneous, and audit-friendly.

Related US guides

• Mileage Log Requirements for IRS: What to Record and How to Store It
• IRS Mileage Rate 2026: Practical Guide for Self-Employed Drivers
• Independent Contractor Mileage for Taxes: End-to-End Claim Workflow

Quick monthly checklist

Before closing out each month:

• No uncategorized trips remain
• Every business trip has a specific purpose note
• Totals reconcile with your work calendar
• Odometer start/end values are consistent with prior month’s closing reading
• PDF and CSV exported and saved to your tax folder

A good mileage log template is less about design and more about repeatable discipline. Get the columns right, fill them in promptly, and lock each month when it’s done.

MileTrack captures trips automatically, classifies them as business, commute, or private, and exports tax-ready reports with all the fields the IRS requires. See the current US product page at miletrack.app/en-us.

Tax note: this article is educational content only, not professional tax advice. Consult a qualified tax professional for guidance specific to your situation.