Mileage log template
An IRS-ready mileage log: date, purpose, start and end odometer, miles and the deduction at the standard rate.
- ๐บ๐ธ US format ยท Letter size
- Free
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Mileage log: rate cell (yellow), then one row per trip with date, purpose, from, to, start and end odometer, miles (formula), type (dropdown), deduction (formula), totals and business miles at the bottom
- Monthly totals: business, personal and total miles plus the deduction for each month (formulas)
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
1 / 1
Mileage log 2026
| Date | Business purpose | From | To | Start odometer | End odometer | Miles | Type | Deduction (miles x rate) |
|---|---|---|---|---|---|---|---|---|
| 2026-01-05 | Client meeting, Contoso | Office, Austin TX | Contoso, Round Rock TX | 35,120 | 35,144 | 24 | Business | (auto) |
| 2026-01-05 | Return to office | Contoso, Round Rock TX | Office, Austin TX | 35,144 | 35,168 | 24 | Business | (auto) |
| 2026-01-06 | Groceries | Home | Store | 35,168 | 35,176 | 8 | Personal | 0 |
| (auto) | (auto) | |||||||
| Totals | =SUM(โฆ) | =SUM(โฆ) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Pick the year and, if you know it, the IRS standard mileage rate for that year. The rate lands in a yellow cell above the table and you can change it there at any time. Then log one row per trip: date, business purpose, where you started, where you went, and the odometer before and after. Miles is a formula, and business rows get a deduction of miles times the rate.
The Monthly totals sheet splits miles into business and personal for each month and adds up the deduction, so at tax time you have the year in one table.
Things to watch
The IRS changes the standard rate every year and sometimes mid-year, so check irs.gov before you rely on the number. Commuting from home to your regular workplace is personal, not business. Keep the log as you go: a log written from memory months later is the kind of record the IRS tends to question.
Calculators that go with this
Frequently asked questions
Where do I find the current IRS rate?
Search irs.gov for standard mileage rates. The IRS publishes the cents-per-mile rate for business, medical and charity driving each year. Type the business rate as dollars, for example 0.70 for 70 cents.
Does commuting count as business miles?
No. Driving between home and your regular workplace is personal under IRS rules. Trips from the office to a client, between job sites or to a temporary work location are business.
What about medical or charity miles?
They use different rates. Log them as Personal here so they stay out of the business deduction, or make a copy of the log sheet with the medical or charity rate in the yellow cell.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.