Free Mileage Log Template: IRS-Compliant Format for 2026
You do not need to buy a mileage log book — the IRS only cares about four data points per trip. This guide gives you a free, IRS-compliant mileage log template you can copy into Google Sheets, Excel, or a paper notebook in 60 seconds. Then run your total miles through our [business mileage deduction calculator](https://gigmytax.com/calculators/business-mileage-deduction) to see the 2026 write-off.
What the IRS actually requires (Publication 463)
Every mileage log — paper, spreadsheet, or app — must capture four data points per trip: **date**, **business purpose**, **miles driven** (or start/end odometer), and **destination or start/end location**. That is the entire requirement. Fancy templates with 20 columns are not more IRS-compliant than a plain 4-column table.
The free mileage log template (copy this)
Columns: Date | Purpose | Start Location | End Location | Start Odometer | End Odometer | Business Miles. Example rows — 01/03/2026 | DoorDash delivery block | Home (Austin, TX) | Home | 45,120 | 45,183 | 63. 01/03/2026 | Uber Eats block | Home | Home | 45,183 | 45,241 | 58. 01/04/2026 | Instacart batch | Home | Home | 45,241 | 45,289 | 48. Odometer columns are optional if you record miles directly, but auditors prefer both.
Google Sheets version — free and cloud-backed
Open a new Google Sheet, paste the header row, and start logging. Freeze row 1 (View → Freeze → 1 row). Add a running total in the Business Miles column with =SUM(G2:G). Share it with yourself for automatic Google Drive backup. At year-end, download as PDF for your tax records. Zero cost, zero risk of losing the file.
Paper log version — best if your phone dies mid-shift
Any spiral notebook works. Print the 4-column header once at the top of each page (Date, Purpose, Miles, Destination). Fill in during breaks between trips or at the end of each shift. Photograph each completed page monthly and store the photos in Google Photos or Dropbox — a paper log destroyed in a car fire without a digital backup counts as no log at all.
How to fill in the 'Business Purpose' column correctly
Vague purposes get disallowed in audits. Good: 'DoorDash delivery block,' 'Client meeting — Acme Corp — Q1 review,' 'Home Depot supply run for Etsy shop.' Bad: 'work,' 'errand,' 'business.' If a purpose is not specific enough for a stranger to understand three years later, it is not specific enough for an auditor.
Commuting rules — do NOT log these as business
The first drive from home to your first business stop and the last drive home from your last business stop are commuting, not business (unless you qualify for the home office exception — see our [home office deduction guide](https://gigmytax.com/blog/home-office-deduction-guide)). Log them as personal miles in a separate column if you want the total, but do not include them in the business miles total on Schedule C Line 9.
Odometer readings — you need three per year
Schedule C Part IV asks for **total miles**, **business miles**, and **commuting miles** for the year. To fill it out accurately you need your odometer reading on January 1 (or the date you started using the vehicle for business) and December 31. Snap a photo of your dashboard on those dates — it takes 5 seconds and covers you if audited.
Should you use a template or an app?
Apps (Stride, Everlance, MileIQ, Hurdlr) win 95% of the time because they auto-track via GPS — no manual entry, no missed trips, no forgotten drives. Use a template if: you distrust apps with your location, drive very few business miles (<2,000/year), or already have a workflow around a paper log. For a full-time gig worker, an app will capture 20–40% more deductible miles than a template you have to update manually.
Retention — how long to keep the log
Keep your log for at least **3 years** after the return is filed (the standard IRS audit window). Extend to **7 years** if you claimed depreciation or Section 179 on the vehicle. Store two copies: the working file (Sheets/notebook) and a year-end PDF snapshot in cloud storage. Never delete an old log until the audit window closes.
What a completed 2026 log means at tax time
Total your business miles column at year-end. Multiply by **$0.70** (the 2026 IRS rate) to get your Schedule C Line 9 deduction. Complete Part IV with your three odometer readings and the miles split (business / commuting / other). Every 1,000 business miles is worth $700 in deductions and roughly $210–$280 in real tax savings for most gig workers. See the exact math in our [business mileage deduction calculator](https://gigmytax.com/calculators/business-mileage-deduction).
Bottom line
You do not need to spend money on a mileage log. A free Google Sheet with four columns — date, purpose, miles, destination — beats every paid log book on the market as long as you actually update it. Combined with a January 1 and December 31 odometer photo, it will survive any IRS audit.
Frequently asked questions
+Is a free mileage log template IRS-compliant?
Yes, as long as it captures the four required data points per trip: date, business purpose, miles driven, and destination or start/end location. A plain Google Sheet or notebook is fully IRS-compliant per Publication 463.
+Can I use Excel or Google Sheets for my mileage log?
Yes. Both are accepted by the IRS as long as entries are made contemporaneously (at or near the time of each trip) and include all four required data points. Google Sheets has the advantage of automatic cloud backup.
+Does the IRS require odometer readings?
Not for every trip, but you need beginning-of-year and end-of-year readings to complete Schedule C Part IV (Information on Your Vehicle). Snap a dashboard photo on January 1 and December 31.
+How do I track mileage without an app?
Create a 4-column log (date, purpose, miles, destination) in Google Sheets or a spiral notebook. Update it at the end of each shift while the trips are fresh. Photograph paper pages monthly and back them up to cloud storage.
+What's the 2026 IRS mileage rate for my log?
70¢ per business mile. Multiply your total logged business miles by $0.70 at year-end and enter the result on Schedule C, Line 9.
Related calculators
- Mileage Tax Deduction CalculatorDeduct business miles at the 2026 IRS standard rate.
- Business Mileage DeductionBusiness-use miles for freelancers and small-business owners.
- Tax Deduction CalculatorStack every 1099 write-off — mileage, home office, phone, retirement.
- Mileage Reimbursement CalculatorReimburse or bill business miles at the IRS rate.
Related guides
- How to Track Mileage for Taxes: The 2026 Step-by-Step GuideLearn how to track business mileage for taxes in 2026: best apps, IRS-compliant logs, audit-proof records, and how to reconstruct missed trips legally.
- Mileage Deduction Rules 2026: Every IRS Requirement in One PlaceThe complete 2026 IRS mileage deduction rulebook: 70¢ standard rate, standard vs. actual method, commuting rules, recordkeeping, and audit-proof documentation.
- IRS Mileage Rate Guide: 2026 Rates, History, and How to Use ThemComplete IRS mileage rate guide for 2026: business, medical, and charity rates, historical rate chart, how the IRS sets the rate, and how to apply it on Schedule C.
- Standard Mileage Rate 2026: The Complete IRS 70¢ Per Mile Guide2026 IRS standard mileage rate is 70¢/mile. Complete guide for gig workers: business miles, rules, examples, deductions, and how to track every mile.
- DoorDash Mileage Deduction 2026: How Dashers Track, Claim & Maximize Every MileClaim every DoorDash mile at the 2026 IRS rate of 70¢. Learn which trips count, how to track them, and how Dashers save thousands.
- The Complete 1099 Deductions Checklist for 2026Printable 1099 tax deductions checklist for 2026. Every Schedule C write-off freelancers and contractors miss — mileage, home office, phone, health, retirement.