Mileage log template for 2026
A mileage log is the record the IRS wants before you deduct business driving: the date, where you went, why, and how many miles. This free 2026 log works out miles from odometer readings and applies the IRS rate, 72.5 cents a mile through June 30 and 76 cents from July 1.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Date | From | To | Business purpose | Odometer start | Odometer end | Miles | Rate | Deduction |
|---|---|---|---|---|---|---|---|---|
| 2026-01-06 | Office | Acme Supply, Plano | Pick up parts for job 1142 | 41,210 | 41,238 | 28 | $0.72 | $20.30 |
| 2026-01-09 | Office | Client, 12 Elm St | Estimate for kitchen remodel | 41,240 | 41,263 | 23 | $0.72 | $16.68 |
| 2026-02-14 | Office | Bank and post office | Deposit and mail invoices | 41,502 | 41,511 | 9 | $0.72 | $6.52 |
| 2026-07-02 | Office | Trade show, Dallas | Meet vendors | 46,120 | 46,184 | 64 | $0.76 | $48.64 |
| 2026-07-15 | Home office | Client, Frisco | Quarterly review meeting | 46,440 | 46,479 | 39 | $0.76 | $29.64 |
| Total | 163 | $121.78 |
What does the IRS need in a mileage log?
For each trip: the date, where you started and went, the business reason and the miles. You also need total miles for the year, business and personal, which is why the log asks for the odometer on January 1 and December 31. The IRS wants records made at or near the time of the trip. Rebuilding a year of driving from memory in April is exactly what gets deductions cut in an audit.
What are the 2026 mileage rates?
72.5 cents a mile for business driving from January 1 to June 30, 2026, and 76 cents from July 1 to December 31, 2026, after the IRS raised the rate mid-year. The standard rate covers gas, repairs, insurance and depreciation. Parking and tolls for business trips are deductible on top. Our mileage calculator applies both rates.
Standard rate or actual costs?
You can deduct the standard rate, or your actual car costs times the business-use share. If you want the standard rate, use it in the first year the car is used for business. Either way you need this log, because the business share comes from it.
Sources
General information, not tax advice for your situation.
Is driving from home to my office deductible?
No. That's commuting. Trips from your office to clients, suppliers or job sites are business miles, and so are trips from a qualifying home office.
Can I use an app instead?
Yes, if it records the same details. Export it once a month and keep the file with your tax records.
Can an employee deduct mileage?
Not on a federal return for 2026, for most employees. The business can reimburse them tax-free under an accountable plan with a log like this one.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.