An IRS mileage log Excel template is the fastest free way to start tracking your business driving for tax purposes. The IRS does not publish an official spreadsheet, but it does spell out exactly what information every mileage log must contain. Get the columns wrong and your entire deduction could be disallowed in an audit.
This guide walks you through the required fields, shows you how to build a working Excel template from scratch, and explains when a spreadsheet stops being enough.
What the IRS requires in a mileage log Excel template
The IRS accepts any format — paper, PDF, spreadsheet, or app — as long as each trip entry records five pieces of information. For the full regulatory breakdown, see our IRS mileage log requirements guide.
Every row in your Excel template needs these columns:
- Date — The calendar date the trip took place.
- Starting location — A street address or recognizable place name.
- Destination — Where you drove, with enough detail for the IRS to verify.
- Business purpose — A specific explanation like “Met with client ABC to review contract,” not just “business.”
- Miles driven — The distance for that individual trip.
You also need two additional data points recorded outside your trip rows: your odometer reading on January 1 and December 31 of each tax year. These let the IRS confirm that your per-trip totals match your actual annual mileage.
How to build your Excel mileage log step by step
Open a blank workbook and create these column headers in Row 1:
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
| Date | Start Location | Destination | Business Purpose | Miles | Category | Deduction ($) |
Columns A through E cover the IRS requirements. Column F lets you tag each trip as Business, Personal, or Commuting so you can filter later. Column G calculates the dollar value automatically.
Add the deduction formula
In cell G2, enter:
=IF(F2="Business", E2 * 0.725, 0)This multiplies business miles by the 2026 standard rate of $0.725 per mile. Drag the formula down for every new row.
Add a summary section
Below your trip data — or on a separate sheet — create a summary block:
- Total business miles:
=SUMIF(F:F,"Business",E:E) - Total personal miles:
=SUMIF(F:F,"Personal",E:E) - Total deduction:
=SUMIF(F:F,"Business",G:G) - Odometer Jan 1: (enter manually)
- Odometer Dec 31: (enter manually)
This summary gives you everything you need when it is time to fill out Schedule C or submit a reimbursement request. For a deeper comparison of spreadsheet approaches, see our mileage tracking spreadsheet guide.
Format tips
- Set Column A to the Date format so Excel sorts chronologically.
- Use Data Validation on Column F to create a drop-down list with Business, Personal, and Commuting.
- Freeze Row 1 so headers stay visible as you scroll.
- Name your file with the tax year, such as “Mileage-Log-2026.xlsx.”
Common Excel mileage log mistakes that trigger audits
A spreadsheet only protects you if you use it correctly. These are the errors the IRS looks for most often:
Vague business purposes. Writing “meeting” or “errand” is not specific enough. The IRS expects you to name the client, project, or task.
Rounded or estimated miles. Entering “about 30 miles” signals reconstruction, not real-time logging. Use your car’s trip meter or a mapping tool for exact figures.
Batch entries weeks later. The IRS requires contemporaneous records — entries made at or near the time of each trip. Filling in two weeks of driving from memory undermines your log’s credibility.
Missing odometer readings. Without January 1 and December 31 readings, the IRS cannot cross-check your claimed business percentage against total vehicle use.
No separation between trip types. Lumping business and personal miles into one column without a category tag makes it impossible to demonstrate that commuting miles were excluded from your deduction.
When an Excel template is not enough
A spreadsheet works well when you drive a handful of business trips per week and you are disciplined about logging each one the same day. It starts to fall apart when:
- You drive 15+ business trips per week. Manual entry takes too long and errors multiply.
- You forget to log trips. There is no reminder system in Excel. A missed trip is a missed deduction.
- You need GPS-verified distances. The IRS gives more weight to GPS data than to self-reported mileage. Excel cannot capture GPS coordinates.
- You share vehicles or manage a team. Coordinating a single spreadsheet across multiple drivers creates version-control headaches.
- You want real-time deduction totals. A formula can sum what you have entered, but it cannot tell you what you forgot to enter.
For a full side-by-side comparison, read our guide on mileage tracking app vs. paper log.
How Tripbook replaces your Excel mileage log
Tripbook records every drive automatically using your phone’s GPS. Each trip captures the date, start and end addresses, exact distance, and route — all without manual entry. You classify trips with a single swipe, and the app calculates your deduction at the current IRS rate in real time.
Because every trip is time-stamped and GPS-verified, your log meets the IRS standard for contemporaneous records without any extra effort. At tax time you export a complete, audit-ready report in seconds.
If your Excel template is costing you more time than it saves, switching takes under a minute.
Final thoughts on using an IRS mileage log Excel template
An IRS mileage log Excel template is a solid starting point for anyone who wants to claim the standard mileage deduction without paying for software. Build it with the five required columns, add a category tag and deduction formula, and commit to logging every trip the same day it happens. When the volume or complexity of your driving outgrows a spreadsheet, an automatic tracker like Tripbook picks up exactly where Excel leaves off.
