The IRS changed the 2026 business standard mileage rate in the middle of the year: 72.5 cents a mile for driving through June 30, and 76 cents a mile from July 1 (IRS Notice 2026-10 and Announcement 2026-11). A single-rate log gets 2026 wrong. This one reads each trip’s date.
Covers: a business mileage log for one tax year and up to 4 vehicles; the IRS business standard mileage rate applied by trip date (2026: 72.5¢ a mile Jan 1–Jun 30, 76¢ from Jul 1); business parking and tolls; commuting and personal miles kept separate; odometer readings and business-use %; monthly totals; a printable paper log.
Does not cover: the actual-expense method, depreciation, leased-vehicle rules, employer reimbursement plans, medical, charitable or moving mileage, or whether you may use the standard mileage rate for your vehicle. Not tax advice.
What it does
- Trips tab (1,500 rows): date, vehicle, from, to, business purpose, type (Business, Commuting, Personal), odometer start and end or just the miles, business parking and tolls. Miles, rate, amount and rate period fill in by themselves.
- Check column: flags a missing business purpose, an odometer end below the start, a date outside the year, a vehicle not on your list, no miles, or no rate for the date.
- Summary tab: per vehicle (up to 4) business, commuting and personal miles, odometer total miles, business-use %, miles and amount for each rate period, parking and tolls, and the total.
- Monthly tab: the same totals by month.
- Settings: tax year, rate periods (two spare rows if the IRS changes the rate again), vehicles with January 1 and December 31 odometer readings.
- Printable log (US Letter and A4 landscape): one page for each 2026 rate period.
- The rules come from IRS documents named in the file: Notice 2026-10, Announcement 2026-11, Publication 463, and the 2025 Instructions for Schedule C.
What’s included (instant download)
- Business-Mileage-Log-2026.xlsx (5 tabs)
- Printable log PDF, US Letter and A4 (2 pages each)
- Quick-start guide PDF (3 pages) with sources
- Note for importing into Google Sheets
Good to know
- Example trips in yellow rows and two example vehicles show every check; delete them before use.
- Tested in LibreOffice only (0 errors with example data, blank, a full 4-vehicle / 1,500-trip fill with deliberate errors, and an added third rate period; totals matched an independent calculation). Not tested by the maker in other spreadsheet apps.
- A record-keeping tool, not tax advice. It doesn’t file anything or decide what you can deduct.
- Digital download only. Licensed for use in your own business.
How this was made: The workbook, formulas, printable log, guide and wording were built with AI assistance and checked by recalculating in LibreOffice against an independent calculation. Rates and record-keeping rules are quoted from the IRS documents named above, opened on 14 Nov 2026.






Reviews
There are no reviews yet.