Free IRS Mileage Log Template 2026: Excel and Printable PDF

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.

Download the template

• Mileage log template as Excel (XLSX) — a log sheet with a category dropdown plus a summary that totals business miles and applies the 2026 split-year IRS rates (72.5¢ January–June, 76¢ from July 1) automatically. Works in Google Sheets, LibreOffice, and Numbers.
• Printable monthly log sheet (PDF) — a letter-size grid for a paper glove-box log, with all required fields.

Free, no sign-up, no email address. Both files match the structure explained below.

Is there an IRS-approved mileage log?

No — and it is worth being blunt about it, because “IRS-approved” appears on a lot of templates and app landing pages. The IRS certifies no template, no spreadsheet and no app. There is no approval programme to enter.

What exists instead is a standard of evidence. Publication 463 lists the elements a record has to carry, and IRC Section 274(d) puts vehicle expenses under strict substantiation, which means those elements are not satisfied by a reasonable estimate the way most other business expenses can be. A log meets the standard or it does not; the file format it lives in never enters into it.

The practical consequence is freeing rather than restricting: the sheet below is not special, and neither is any product. Get the five elements right, keep them timely, and a paper grid is worth exactly as much as a subscription.

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

The XLSX uses nine columns — the seven below plus Category (the dropdown that separates business, commute and personal) and Vehicle, which matters once a second car enters the picture. The printable PDF uses eight: it drops the Vehicle column and records the vehicle once in the sheet header instead, next to month, year and the odometer boxes. The core seven are:

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 (20.5 cents per mile for January–June 2026, 23.5 cents from July 1). 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.76 per mile since July 1, 2026; $0.725 for January–June travel)

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

Printable and paper logs

The IRS does not require any specific format. A paper notebook with the right columns is technically acceptable, and so is the printable PDF above — a letter-size landscape grid with the required fields already ruled, sized to live in a glove box. 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.

The XLSX above opens in Google Sheets (File → Import → Upload), LibreOffice and Numbers. Sheets and LibreOffice keep the Category dropdown on the log rows; Apple Numbers drops data validation on import — the values stay, the list disappears, and you type the category instead. The summary tab holds the two rate cells as plain numbers formatted as currency ($0.725 and $0.760), and the deduction total multiplies each half-year’s miles by its own rate, so a year spanning 1 July prices correctly without you splitting anything by hand.

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: 72.5¢, Then 76¢ From July 1
• 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.