Mileage Log Template That Survives an IRS Audit

The IRS standard mileage deduction is one of the most valuable write-offs for self-employed workers. At 72.5 cents per mile in 2026, a driver logging 20,000 business miles can claim a $14,500 deduction. But that deduction lives or dies based on one thing: your mileage log.

An incomplete or suspicious log is one of the most common reasons the IRS reduces or eliminates vehicle expense deductions during an audit. This guide gives you a template that meets every IRS requirement and explains exactly what auditors look for.

What the IRS Requires

IRS Publication 463 (Travel, Gift, and Car Expenses) specifies what your mileage log must contain for each business trip:

1. Date of the trip
2. Destination (name or area — "Downtown Phoenix, client office" not just "work")
3. Business purpose (why the trip was for business — "Delivered order #4521" or "Met with client about Q3 proposal")
4. Miles driven for the trip

Additionally, you must record:

• Odometer reading at the start of the year (January 1 or when you start using the vehicle for business)
• Odometer reading at the end of the year (December 31)
• Total miles driven for the year (business + personal)
• Total business miles for the year

The log must be contemporaneous — recorded at or near the time of each trip. A log created from memory at year-end is considered unreliable and is far more likely to be challenged.

The Template

Create a spreadsheet with these columns:

Column	Field	Example
A	Date	2026-03-15
B	Starting Location	Home office — 123 Oak St
C	Destination	ABC Corp — 456 Main Ave, Phoenix AZ
D	Business Purpose	Client meeting — Q2 contract review
E	Miles (Trip)	24.3
F	Round Trip?	Yes
G	Total Miles	48.6
H	Odometer Start	47,832
I	Odometer End	47,881
J	Vehicle	2022 Toyota Camry

At the top of the sheet, add a header section:

• Year: 2026
• Vehicle: 2022 Toyota Camry (VIN optional but helpful)
• Odometer Jan 1: 45,200
• Odometer Dec 31: (fill at year-end)
• Total Miles: (calculated: Dec 31 odometer minus Jan 1 odometer)
• Business Miles: =SUM(G2:G1000)
• Business Use %: =Business Miles / Total Miles

What IRS Auditors Actually Look For

Knowing the rules is one thing. Understanding what triggers scrutiny is another. Here are the red flags auditors check:

Round Numbers

Every trip logged as exactly 10, 20, or 50 miles signals estimation, not measurement. Real trips produce numbers like 12.3, 7.8, and 34.1 miles. If your log is full of round numbers, it looks reconstructed.

Missing Business Purpose

"Business" is not a business purpose. "Client meeting at XYZ Corp to discuss proposal" is. The IRS wants to know specifically why each trip qualifies as a business expense. Vague descriptions invite follow-up questions.

No Personal Trips

If your log shows 100% business use and the vehicle is your only car, the IRS will be skeptical. Everyone drives to the grocery store, the doctor, and to visit friends. A log that claims zero personal use for a vehicle that is clearly used personally is a major red flag.

Inconsistency with Other Records

Your mileage log should be consistent with your calendar, gas receipts, and toll records. If your log says you drove to Dallas on March 15, but your gas receipts show you bought fuel in Houston that day, there is a problem. This is one reason why keeping gas receipts alongside your mileage log is valuable — even if you use the standard mileage rate and do not technically need them. For more on this, see our guide on how long to keep gas receipts.

Year-End Clustering

A log where 80% of entries are dated in the last two months of the year — right before the deduction deadline — looks like it was created in a panic rather than maintained throughout the year.

How to Maintain Your Log Consistently

1. Log each trip the same day. Do not batch a week of trips on Sunday. The IRS values contemporaneous records.
2. Use your phone. Keep the spreadsheet accessible on your phone (Google Sheets works offline). Log trips in the parking lot before you forget.
3. Set a daily reminder. A 30-second reminder at 6 PM to log any trips you took that day catches anything you missed.
4. Record odometer readings on the 1st and 15th. Mid-month odometer checks help verify your trip logs against actual miles driven.
5. Note personal trips too. You do not need to detail personal trips, but noting "personal" on days you did not drive for business shows the IRS you are not padding your numbers.

Mileage Tracking Apps vs Spreadsheets

A mileage tracking app like Stride, MileIQ, or Everlance automates much of the logging process using GPS. This has advantages: no manual entry, no forgotten trips, and built-in classification (swipe to mark trips as business or personal). The downside: battery drain, occasional GPS inaccuracies, and subscription fees.

A spreadsheet is free and fully customizable, but it requires discipline. The best approach for many self-employed workers is to use a mileage app for automatic trip logging and pair it with a fuel tracker like FuelSnap for gas receipt documentation. Together, they cover both halves of the IRS requirement: miles driven and expenses incurred.

How Mileage and Fuel Records Work Together

Your mileage log proves how many miles you drove for business. Your fuel records prove how much gas you bought. Together, they create a complete, cross-referenced picture:

• Mileage log says you drove 20,000 business miles
• Your car gets ~30 MPG
• Expected fuel consumption: ~667 gallons
• Gas receipts show you purchased 710 gallons (reasonable — accounts for personal driving)

If your mileage log claims 40,000 business miles but your fuel records only show 500 gallons purchased, the math does not add up. Cross-referencing catches errors and strengthens your documentation. For more on the deduction itself, see our complete guide on writing off gas on your taxes.

The Bottom Line

A mileage log is required for any vehicle expense deduction — whether you use the standard mileage rate or actual expenses. The IRS wants dates, destinations, business purposes, and miles. Keep the log contemporaneous, avoid round numbers, include your business-use percentage, and cross-reference with gas receipts for maximum credibility.

Start the template on January 1 (or today, if you are reading this mid-year — late tracking is better than no tracking). Pair it with FuelSnap for automatic gas receipt logging, and you will have audit-proof records for your entire vehicle expense deduction.