Free download — no email required
Mileage Log Template (2026 IRS Rates)
One row per business trip: the date, where you went, why, and the odometer. The Excel file works out the miles, picks the IRS business rate from the trip date, and adds up each month and the year. 2026 has two rates, so the date matters.
What the IRS says a mileage log must show
IRS Publication 463 (2025 edition, read Nov. 11, 2026), Table 5-1, lists what to keep for car expenses:
- Amount: "the mileage for each business use, and the total miles for the year."
- Time: "For car expenses, the date of the use of the car."
- Place: "Your business destination."
- Business purpose: "Business purpose for the expense."
On timing it says: "You should record the elements of an expense or of a business use at or near the time of the expense or use and support it with sufficient documentary evidence." It also says a log kept weekly counts: "If you maintain a log on a weekly basis that accounts for use during the week, the log is considered a timely kept record."
On records for part of the year: "You can keep an adequate record for parts of a tax year and use that record to prove the amount of business or investment use for the entire year." The IRS adds that you must show the part you kept is typical of the whole year. Publication 463 has the full rules.
The template's columns follow the IRS's own example log, Table 5-2, "Daily Business Mileage and Expense Log": date, destination (city, town, or area), business purpose, odometer start and stop, and miles this trip. We added a job column and the IRS rate.
2026 has two IRS business rates
| Trip date | IRS business rate | IRS source |
|---|---|---|
| Jan. 1 – June 30, 2026 | 72.5 cents a mile | IR-2025-128 |
| July 1 – Dec. 31, 2026 | 76 cents a mile | IR-2026-29 |
From the IRS standard mileage rates page, read Nov. 11, 2026.
How the Excel file uses it: the rate cell reads the trip date. June 30 gets 72.5 cents. July 1 gets 76 cents. A date outside 2026 shows "No rate in file": the file does not guess a rate the IRS has not given.
How to use the file
- Type one business trip per row on the Mileage log tab: the date, the destination, the business purpose, and the job if you want it.
- Type the odometer at the start and at the end of the trip. Business miles = end minus start. No odometer? Type the miles in the Business miles cell (that replaces the formula on that row only).
- The IRS rate and the amount fill in from the date and the miles.
- The Totals tab adds business miles and amounts by month and for 2026. It also has a place for the odometer at the start and end of the year, because the IRS asks for the total miles for the year.
- The PDF is a printable one-page log, for the truck. The CSV is a blank log with the column names only, for any other app.
For a filled-in contractor week and which drives count, see how to track mileage for taxes.
Rather keep the log on your phone?
In Job Cost Pro you log trips by hand in the app, on every plan: the date and the miles, where you went and why, and the job if you want. The app shows the IRS rate for each trip's date, and the mileage log goes into the year-end tax package. The Free plan includes 1 tax package per tax year: one for this tax year and one for last tax year. Pro and up have no limit. Free plan available. Some features require a paid plan. Get Job Cost Pro on iPhone or in any browser. The template stays free either way.
This is not tax advice. Check the IRS pages or ask your tax person.
Guides for this tool
FAQ
How do I make a mileage log?
Write one line per business trip: the date, where you went, why you went, and the miles. This template has those columns ready, and the Excel file adds up the miles and applies the IRS rate for the trip date. IRS Publication 463 asks you to record each trip at or near the time, so fill it in as you go, not at tax time.
What does the IRS require for a mileage log?
IRS Publication 463 (2025), Table 5-1, says to keep "the mileage for each business use, and the total miles for the year," the date you used the car, "Your business destination," and the "Business purpose for the expense." It also asks for records made at or near the time of the trip. Publication 463 has the full rules.
How do I make a mileage log in Excel?
Download the Excel file and type each trip: the date, destination, purpose, and the odometer at the start and end. The miles, the IRS rate for that date, and the amount fill in. The Totals tab adds them by month and for the year.
What does a mileage log look like?
A table with one row per trip: date, destination (city, town, or area), business purpose, odometer start and end, and miles. The IRS shows one in Publication 463, Table 5-2. This template follows it and adds a job column and the IRS rate.
What is the 2026 IRS mileage rate for business?
Two rates: 72.5 cents a mile for trips from Jan. 1 to June 30, 2026, and 76 cents a mile for trips from July 1 to Dec. 31, 2026 (IRS standard mileage rates page, read Nov. 11, 2026). The Excel file picks the right one from each trip date.
Can I use it in Google Sheets?
Google Sheets can open Excel files: upload the file to Google Drive and open it with Google Sheets. The file uses only basic formulas (IF, AND, OR, ISNUMBER, ROUND, SUMIFS, COUNTIF, SUM and DATE) that Google Sheets also has. The CSV is a blank log with the column names, for any app.
Should I use the standard mileage rate or actual car expenses?
That is a tax choice with its own rules, and this page does not make it for you. IRS Publication 463, chapter 4, explains both ways. Ask your tax person.