Free Mileage Log Template for 2026
A simple, IRS-compliant mileage log for gig workers. 20,000 business miles × $0.725 (2026 IRS rate) = $14,500 tax deduction. Track every mile, save thousands.
Last reviewed: May 27, 2026 · By Brenden Warn, ShiftTracker founder, 5+ years driving for DoorDash, Uber Eats, Walmart Spark · 35,000+ tasks completed
CSV / Excel Template
Opens in Excel, Numbers, or Google Sheets
52-row template with auto-calculating mileage formulas and a year-end summary. Edit on any device with a spreadsheet app.
Download CSV →Printable PDF
Print one page per month, fill in at shift end
14-page print-ready PDF with cover page, 12 monthly log pages, and an annual summary. Keep in your glove box.
Download PDF →$0.725
per mile (2026 IRS rate)
$14,500
deduction at 20,000 miles
~$5,200
real tax savings (22% bracket + 15.3% SE)
What an IRS-Compliant Mileage Log Actually Needs
Per IRS Publication 463 (Travel, Gift, and Car Expenses), every business trip needs four data points to qualify as a deductible mileage log entry:
1. Date of the trip
A specific date — not "sometime in March." Both the CSV and PDF templates have a Date column for this.
2. Starting and ending odometer (or total miles)
Odometer readings are the canonical format the IRS specifically references. Read directly off your vehicle, not generated by software.
3. Business purpose
A short phrase like "DoorDash dinner shift, downtown Boise" or "Uber Eats lunch zone." Specific enough that an auditor 2 years later understands the trip.
4. Destination / route
For gig work, the "route" is your shift zone or platform region. For non-recurring trips, the specific destination (e.g., "auto shop for oil change — vehicle maintenance").
Both templates capture all four fields per row. Fill them in at shift end (contemporaneous = required), don't reconstruct from memory at year-end.
How to Use the Template (the 60-Second Version)
- Open the CSV in Excel/Sheets, or print the PDF. The CSV has formulas pre-built for auto-calculating per-shift miles and the year-end deduction. The PDF is for drivers who prefer pen-and-paper in the glove box.
- At shift start: write the date, the platform you're working (DoorDash, Uber Eats, Spark, etc.), and your starting odometer. Takes 5 seconds.
- At shift end: write your ending odometer. The total miles for that shift = end − start. The CSV computes this automatically.
- Add the business purpose: a short phrase identifying the shift (e.g., "DoorDash dinner — downtown Friday"). This is what makes the log audit-defensible.
- Optional — log earnings: the templates include an Earnings column so you can compute your true hourly rate alongside the mileage. Worth doing once a week.
- At year-end: sum the Business Miles column, multiply by $0.725 (2026 IRS rate). That's your Schedule C, Line 9 entry.
What Your Mileage Is Actually Worth in 2026
The 2026 IRS standard mileage rate is $0.725 per business mile. Each mile reduces both federal income tax AND the 15.3% self-employment tax — so the real tax savings per mile is typically $0.22–$0.27 depending on your bracket.
| Annual Business Miles | Deduction (× $0.725) | Real Tax Savings | Driver Profile |
|---|---|---|---|
| 10,000 mi | $7,250 | ~$2,700 | Part-time / weekends |
| 15,000 mi | $10,875 | ~$4,050 | Active part-time |
| 20,000 mi | $14,500 | ~$5,400 | Full-time gig driver |
| 25,000 mi | $18,125 | ~$6,750 | Heavy / multi-app driver |
Real tax savings estimate combines 22% federal income tax bracket + 15.3% self-employment tax. Your actual savings depend on your state, filing status, and other income.
Why Paper or Spreadsheet Logs Still Work in 2026
Despite the proliferation of GPS-based auto-tracking apps, manual odometer logs remain the IRS's preferred format. Three reasons gig workers still use the template:
- Audit defensibility: odometer readings come from the vehicle, not from software. An auditor can't argue the metadata was retroactively manufactured.
- Battery cost: gig apps (DoorDash, Uber Eats, Spark) already run background GPS for routing. Stacking a second GPS tracker drains battery 15–25% faster — manual logs don't.
- Privacy: no continuous location dataset stored on a third party's server.
The trade-off: manual logs require 10 seconds of input per shift. Most drivers do fine — but if you forget shifts often, an app like ShiftTracker enforces the discipline by reminding you at shift start and end.
Frequently Asked Questions
What does an IRS-compliant mileage log need to include?
What is the 2026 IRS standard mileage rate for business use?
Can I use a spreadsheet or paper log instead of an app?
Do I have to track every single trip, or can I batch by shift?
Should I track miles to gas stations and bathroom stops while on shift?
Related Tools
Mileage Tax Calculator
Plug in your annual miles and see your 2026 deduction in real time.
Best Mileage Tracker Apps Compared
8 mileage apps reviewed by a 5+ year gig worker.
IRS Mileage Deduction Rules for Gig Workers
Deeper guide on what counts as business mileage.
How to Track Mileage for Taxes
Best tracking methods and audit-proof practices.
Skip the manual entry
ShiftTracker captures odometer readings in 5 seconds per shift, calculates deductions at the 2026 IRS rate automatically, and generates Schedule C-ready reports. Same IRS Publication 463 format — no manual math.
Download ShiftTracker (Free)