Business Mileage Log 2026

$19.00

A mileage log spreadsheet for 2026 that applies the right IRS business rate to each trip by date (72.5¢ to June 30, 76¢ from July 1), keeps commuting out, adds parking and tolls, flags incomplete rows, and totals everything by vehicle and by month. Includes a printable log for the car.

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.

Be the first to review “Business Mileage Log 2026”

Your email address will not be published. Required fields are marked *