IRS Mileage Log Excel Template — Free Download
Download a free IRS mileage log Excel template with every required column. Learn how to set it up, add formulas, and avoid common audit mistakes.
Tripbook teamUpdated · 5 min read All guides
On this page
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.
- XLSXMileage log for Excel or Google SheetsFilled example sheet plus a blank log; miles, business share and deduction calculate automatically
- PDFPrintable mileage logPage 1: filled example. Page 2: blank log to print
The deduction uses the IRS business rate of 76¢ a mile from 1 July 2026; change the rate cell for trips before that date (72.5¢).
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 * IF(A2>=DATE(2026,7,1), 0.76, 0.725), 0)This looks more complicated than the usual single-rate formula, and there is a good reason for it. The IRS raised the business rate part-way through 2026, so the year has two: 72.5 cents per mile for trips driven January 1 through June 30, and 76 cents per mile from July 1 onward (IRS standard mileage rates). The nested IF reads the trip date in Column A and applies whichever rate was in force that day, so you can keep the whole year in one sheet instead of maintaining two.
Drag the formula down for every new row. If you are building a log for the 2025 tax year instead, the rate was a flat 70 cents and the simpler =IF(F2="Business", E2 * 0.70, 0) is all you need.
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)
For 2026, add two more lines so you can show your work if anyone asks which miles were claimed at which rate:
- Business miles, Jan 1 – Jun 30:
=SUMIFS(E:E,F:F,"Business",A:A,"<"&DATE(2026,7,1)) - Business miles, Jul 1 – Dec 31:
=SUMIFS(E:E,F:F,"Business",A:A,">="&DATE(2026,7,1))
This summary gives you everything you need when it is time to fill out Schedule C or submit a reimbursement request.
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.
Keep records for at least 3 years. The IRS can audit returns up to three years after filing. If you claim vehicle depreciation, hold your logs for six years.
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.