Free Mileage Log Template for 2026 (Excel)
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)
Shaded cells are for you to fill in; the totals work themselves out.
| Mileage Log | ||||||||
| Vehicle | Make and model | Tax year | 2026 | |||||
| IRS rate (first half) | $0.725 | IRS rate from | 2026-07-01 | IRS 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. | ||||||||
| Date | Start | Destination | Business purpose | Odometer start | Odometer end | Miles | Rate | Deduction |
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto | ||||||
| auto | auto | auto |
How to use the mileage log template
- Download it and fill in your vehicle and the tax year at the top.
- 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.
- For each business trip, record the date, where you started, where you went, the business purpose, and the odometer at the start and end.
- 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
- Mileage Deduction Calculator: your 2026 deduction, with a trip log.
- Free income and expense spreadsheet: the rest of your business costs.