2026 mileage tracker spreadsheet
- 100 trip rows
- Business / Commute / Personal dropdown
- Automatic 72.5¢ → 76¢ rate by 2026 trip date
- Business-mile and IRS benchmark summary
- No macros
Free 2026 mileage log template
Free 2026 mileage log template - Excel, CSV & PDF
Keep a clean business-mileage record with date, destination, business purpose and miles. Download a blank Excel, CSV or printable PDF template — no email required.
Excel.XLSXAutomatic 2026 IRS rate by date · no macrosDownload Excel →
CSV.CSVBlank portable table for 50 tripsDownload CSV →
Printable.PDFUS Letter worksheet · 15 handwritten trip rowsDownload PDF →
2026 IRS business mileage rate: 72.5¢/mile Jan 1–Jun 30 and 76¢/mile Jul 1–Dec 31. Excel applies the rate only to Business rows dated in 2026.
No email gateNo Excel macrosBlank filesUS Letter PDF
Inside the template
One row per trip. Enough context to review it later.
DriveQuery 2026 Mileage Log
Business miles0.0
IRS benchmark$0.00
| Date | Start | Destination | Business purpose | Category | Miles | IRS rate | Benchmark amount |
|---|---|---|---|---|---|---|---|
| 03/15/2026 | Office | Customer A | Quarterly review | Business | 18.4 | $0.725 | $13.34 |
| 08/12/2026 | Office | Project site | Site visit | Business | 42.6 | $0.760 | $32.38 |
| 08/13/2026 | Home | Office | — | Commute | 12.1 | — | — |
Preview only. Every download starts blank, ready for your own mileage record.
Choose your format
Excel for automation. CSV for portability. PDF for paper.
Universal mileage log
- 50 blank trip rows
- No formulas or proprietary features
- Easy to import into spreadsheets or accounting tools
- UTF-8 encoded
Printable mileage log
- US Letter landscape format
- 15 trip rows per printed sheet
- Driver, vehicle and period fields
- Business-purpose and category columns
- 2026 rate reminder on the page
2026 rate logic
The Excel sheet handles the 2026 mid-year IRS rate change
When Category is Business, the spreadsheet reads the trip date and applies the correct 2026 IRS rate automatically. Dates outside 2026 are left without an automatic rate rather than carrying the 2026 rate forward.
Trip through Jun 3072.5¢per business mile
→ Jul 1 →
Trip from Jul 176¢per business mile
Commute and Personal rows do not receive an IRS business-rate amount. Keeping those categories visible helps prevent an annual mileage record from silently treating every mile as business.
Recordkeeping
A template is useful only if the entries are timely and explainable
Date
When the business transportation occurred.
Destination
Where the business travel went.
Business purpose
Why the travel was business-related.
Miles
Business mileage for the trip, plus total mileage context for the year.
IRS Publication 463 explains transportation recordkeeping and the value of timely kept records. A spreadsheet or computer record can be an adequate written record when it contains the required information. IRS Publication 463.
Manual vs automatic
Use the spreadsheet if you want manual control. Use DriveQuery if you want your Tesla to capture the trip facts.
Manual templateYou remember the trip
Enter the date, destination, purpose and miles yourself.
→
DriveQueryThe car captures the facts
Review classification and add the business context that automation should not guess.
The template is intentionally free without an email requirement. It should remain useful even if DriveQuery is not the right product for you.
FAQ
Mileage log template questions
What should a business mileage log include?
A useful business mileage record should keep the date, business destination, business purpose and business miles for each trip, along with total annual mileage and any supporting documentation required for the expense or reimbursement.
Does the Excel template handle the 2026 IRS rate change?
Yes. For Business rows dated in 2026, the Excel template applies 72.5 cents per mile through June 30 and 76 cents per mile from July 1. Dates outside 2026 are left without an automatic IRS rate.
Is the mileage log template free?
Yes. The Excel, CSV and printable PDF versions can be downloaded without entering an email address.
What is the difference between the Excel, CSV and PDF versions?
Excel includes formulas, a Business/Commute/Personal dropdown, a summary and no macros. CSV is a simple portable table for importing into other tools. PDF is a US Letter landscape worksheet with driver, vehicle and period fields for handwritten trips.
Does using this template make a mileage deduction or reimbursement automatically valid?
No. A template organizes the record but does not determine whether a trip is deductible or reimbursable. Tax treatment depends on the facts, applicable rules and employer policy.
Can DriveQuery replace the manual mileage spreadsheet for Tesla drivers?
DriveQuery is being built to capture trip facts from the Tesla automatically, then let the driver review classification and business purpose before export. The template remains useful for manual workflows or as a reference format.
Requirements
Mileage log for taxes
Understand what the IRS record should retain and what automation can capture.
Calculator
Mileage reimbursement calculator
Apply the correct 2026 rate automatically by trip date.
Automatic
Business mileage tracker for Tesla
Move from manual entry to vehicle-captured trip facts and review.
Free tool · available now
Create the mileage log in your browser
Enter start and destination addresses, calculate road miles, classify the trip and export PDF or Excel. The 2026 IRS business rate is applied by trip date.
Keep the free template. Automate the repetitive part when you are ready.
DriveQuery is being built for Tesla drivers who want a mileage record without rebuilding every trip at month-end.