Skip to content

Mileage log for taxes

A printable business mileage log that totals the miles and the deduction at the IRS rate for each trip's date: 72.5 cents a mile through June 30, 2026, and 76 cents from July 1. Print it, save it as a PDF or download Excel. No app, no sign-up.

Mileage log

Not uploaded.

Opening the mileage log

How to use this mileage log template

  1. Add each business trip: the date, where you started and went, why, and the miles. Tick Round trip to count the miles there and back, or switch to odometer readings.
  2. Add any parking fees and tolls you paid on the trip.
  3. Read the totals: business miles and the deduction at the IRS rate for each trip's date, with 2026 split at July 1.
  4. Print the log or save it as a PDF, or download it as Excel or CSV for your records or your accountant.

The IRS mileage rate for 2026

2026 has two business rates. The IRS set 72.5 cents a mile in December 2025 (Notice 2026-10), then raised it to 76 cents for miles driven on or after July 1, 2026 (Announcement 2026-11). Miles driven before July 1 stay at 72.5 cents, so a log for 2026 needs its miles split at that date. This one splits them automatically.

IRS standard mileage rates for business use, by period
Miles drivenBusiness rate
July 1, 2026 to December 31, 202676 cents a mile
January 1, 2026 to June 30, 202672.5 cents a mile
January 1, 2025 to December 31, 202570 cents a mile
January 1, 2024 to December 31, 202467 cents a mile

The standard rate is claimed instead of your actual car expenses, such as gas and repairs. Business parking fees and tolls are the exception: they're deducted in addition. Rates are from the IRS Standard mileage rates page, checked October 9, 2026.

What the IRS asks a mileage log to show

IRS Publication 463 lists what proves car expenses: the mileage for each business use, the total miles for the year, the date of each use, your business destination, and the business purpose. The log has a place for each. Use the odometer boxes for the start and end of the year to record the year's total; the log then shows the share of driving that was for business.

Records should be made at or near the time of each trip, and a log updated weekly counts as timely. The IRS doesn't allow deductions for amounts that are estimated. Keep the log with your return: generally for 3 years from the date you file it.

A worked example

A contractor drives from the office to clients, suppliers and the bank across the end of June and the start of July 2026. Every trip is a round trip.

mileage log 2026.xlsx

RowABCDE
1DateToBusiness purposeMilesParking
506/29/2026Supply storeBuy brackets and lumber12.8
606/30/2026Whitfield DentalMeeting about the remodel19.6$12.00
707/01/2026Client site, Grove CityKitchen remodel walkthrough33.0
807/02/2026Supply storePick up cabinet order12.8
Part of the sample log. Round trips count the miles twice: 9.8 each way is 19.6.

The five trips through June 30 add up to 104.2 miles, at 72.5 cents: $75.55. The five from July 1 add up to 149.8 miles, at 76 cents: $113.85. With $12.00 of parking, the total is $201.40 for 254.0 business miles. At a single rate the answer would be off, which is why the log keeps the two halves of 2026 apart. Open Try a sample log to see every trip.

Which trips count

Driving between home and your main or regular place of work is commuting, and the IRS doesn't allow it as a business expense, however far it is. Trips from your workplace to a client, a job site, a supplier, the bank or the post office are business trips. Parking at your own workplace is a commuting cost too; parking when you visit a customer is deductible.

The standard rate here is the business rate. Medical and charity driving have their own lower rates; a charity mile is 14 cents. If an employer or client pays you a different rate per mile, choose My own rate per mile to total a reimbursement claim instead.

Mileage logs for Uber, Lyft and DoorDash drivers

The record the IRS asks for is the same for gig driving: the date, destination, business purpose and miles of each trip. If your driving app gives you a trip export, import it here, then add the purpose and any business driving the export leaves out, such as trips to pick up supplies. The log applies the rate for each trip's date, so trips on both sides of July 1, 2026 come out right.

Importing, printing and keeping the log

Already keeping trips in a spreadsheet or an app export? Use Import trips from a spreadsheet: it reads Excel and CSV files with a Date column and a Miles (or Distance) column, or odometer start and end columns. Names for the other columns, such as Destination or Purpose, are picked up too.

Print gives a clean log in date order with the totals and a line to sign. Excel gives the log plus a summary sheet with each rate period, ready to hand to an accountant. To combine several years' files, use merge Excel files. This log adds up miles; it isn't tax advice. Check with a tax professional if you aren't sure a trip counts or which method to use.

Questions

What is the IRS mileage rate for 2026?

For business driving, 72.5 cents a mile for miles driven from January 1 to June 30, 2026, and 76 cents a mile from July 1 to December 31, 2026. The IRS raised the rate in the middle of the year (Announcement 2026-11), so each mile counts at the rate for the date it was driven. The log does that split for you.

What does a mileage log need to show for the IRS?

For each business trip: the date, the destination, the business purpose and the miles. You also need the total miles you drove the car in the year. IRS Publication 463 lists these. The log has a column for each, and an optional odometer reading for the start and end of the year to give the total.

Do I have to write down every trip on the day?

No. The IRS says records should be made at or near the time of the trip, and a log filled in weekly counts as a timely kept record. A log made long afterward carries less weight, and the IRS doesn't allow deductions based on estimates.

Can I deduct parking and tolls as well as the mileage rate?

Yes. With the standard mileage rate you can also deduct business-related parking fees and tolls. Parking at your own regular place of work is a commuting cost and isn't deductible. Enter parking and tolls on each trip and they're added to the total.

Are miles driven to work deductible?

No. Driving between your home and your main or regular place of work is commuting, which the IRS treats as personal however far it is. Trips from your workplace to clients, job sites, suppliers or the bank are business trips.

Can I use this mileage log with Google Sheets?

Yes. Download the Excel file and open it in Google Sheets with File, Import. To bring trips in from Sheets, download them as CSV and use Import trips from a spreadsheet.

Where is my mileage log saved?

In your browser, on this device only. Nothing is uploaded, so the log is there next time you open the page on the same computer or phone. Download the Excel file now and then as a backup, and keep a copy with your tax records.

Last updated by Muhammad Yahya. How the tools are tested.