Freelancer Mileage Log
IRS-ready trip log with 2026 H1/H2 standard mileage rates and a Schedule C Line 9 total.
Keep an IRS-ready mileage log that survives the 2026 mid-year rate change.
What's inside
- Trips: 500 rows. Date, miles, purpose, destination, notes, and category (Business / Medical / Charity / Personal).
- Auto rates: Business and medical switch from H1 to H2 on July 1, 2026 (72.5¢ → 76¢ business). Charity stays at 14¢. Rates live on a Setup tab you can edit if the IRS revises again.
- Dashboard: Business miles and $ for H1, H2, and the full year — that year total is your Schedule C Line 9 starting point. Medical, charity, and personal totals stay separate so they never contaminate Line 9.
- Blank workbook, filled SAMPLE spanning the July 1 change, and a PDF guide.
Works in Excel 2010+, Google Sheets and LibreOffice. No macros.
Tested: SAMPLE totals recalculated in LibreOffice and matched an independent Python model to the cent (Business year $264.28 on 358 miles).
Not tax advice. Substantiation rules: IRS Pub. 463.
Built with AI assistance and tested by running it end to end (details in the guide).
Refunds: 30-day refund if it doesn't work as described (refund policy).
Learn the method (free)
- How to log business miles for Schedule C (2026 IRS rates)
Keep an IRS-ready mileage log for self-employed Schedule C Line 9, with the 2026 mid-year rate change from 72.5¢ to 76¢ on July 1.
Related free tools
- Free IRS Mileage Deduction Calculator (2026)
Business, medical and charity standard mileage rates for 2026, including the mid-year business rate change (72.5¢ → 76¢ on July 1). Trip or full-year mode. Runs in your browser.
Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.