Free Mileage Log Template for 2026 (Excel)

By the JAJPO team · How we build our tools

A free mileage log for business driving. Record each trip with its date, destination, business purpose and odometer readings, and the log works out your miles and your deduction at the 2026 IRS standard mileage rates, including the rate change on July 1.

Free template

Free Mileage Log Template (Excel)

Excel file (.xlsx) · opens in Excel, Google Sheets, Apple Numbers and LibreOffice · 2 sheets · formulas included

Shaded cells are for you to fill in; the totals work themselves out.

Preview: the Mileage log sheet
Preview of the Mileage log sheet
Mileage Log
VehicleMake and modelTax year2026
IRS rate (first half)$0.725IRS rate from2026-07-01IRS rate (second half)$0.760
2026 IRS standard mileage rates: 72.5¢ a mile to June 30 (Notice 2026-10), 76¢ from July 1 (Announcement 2026-11). Change the shaded rate cells for other years.
DateStartDestinationBusiness purposeOdometer startOdometer endMilesRateDeduction
autoautoauto
autoautoauto
autoautoauto
autoautoauto
autoautoauto
autoautoauto
autoautoauto
autoautoauto
autoautoauto
autoautoauto

How to use the mileage log template

  1. Download it and fill in your vehicle and the tax year at the top.
  2. Check the IRS rates. The shaded cells hold the 2026 rates: 72.5¢ a mile from January 1 to June 30, and 76¢ from July 1. For another year, type in that year's rates.
  3. For each business trip, record the date, where you started, where you went, the business purpose, and the odometer at the start and end.
  4. Read your totals. Miles, the rate for each trip's date and your deduction work themselves out. No odometer readings? Type the miles straight into the Miles column.

What the IRS expects in a mileage log

IRS Publication 463 asks for records made at or near the time, showing the miles for each business use of your car, the date and the business purpose, plus your total miles for the year. Noting where you went makes the purpose clear, and an odometer reading on January 1 and December 31 gives your total miles. A log kept up as you go is much stronger than one rebuilt later.

  • Commuting doesn't count. Driving between home and a regular workplace isn't deductible.
  • Parking and tolls for business trips are deductible on top of the standard rate.

Log or online calculator?

The free Mileage Deduction Calculator has its own trip log that stays in your browser, works out your deduction at the right rate for each trip, and compares the standard rate with actual expenses. Driving for Uber, Lyft or DoorDash? The Gig Driver Tax Calculator shows what to set aside from each payout.

Frequently asked questions

What is the IRS mileage rate for 2026?

72.5 cents a mile for business driving from January 1 to June 30, 2026, and 76 cents from July 1, 2026. The IRS hasn't published the 2027 rate yet; it usually does in December.

Can I use this log for a car I use for personal driving too?

Yes. Record only the business trips here, and your total miles for the year separately. The IRS uses both to work out the business share.

Is the template really free?

Yes. We ask for your email so we can send you tax-deadline reminders and new templates; you can unsubscribe at any time.

Related