How to Create a Mileage Report for Tax or Reimbursement

A mileage report is the compiled record of every business trip you drove: when, where, why, and how far. Learning how to create a mileage report for tax or reimbursement is less about the spreadsheet and more about capturing those four facts while the trip is still fresh.

Whether you are claiming a deduction or sending an expense report to payroll, the IRS expects contemporaneous records — made at or near the time of travel, not reconstructed in April. This guide covers what to include, how to compile the report, and the mistakes that get claims denied.

Why the Report Exists

Self-employed drivers use the report to support a vehicle deduction. Employees use it so an employer can reimburse business use of a personal car. In both cases the record has to show that each trip was ordinary and necessary for work.

IRS Publication 463 is the primary source. It wants timely, detailed records of business vehicle use — not a single annual estimate. A late, reconstructed log is one of the most common reasons a vehicle claim gets denied.

For 2026 the business standard mileage rate is 72.5 cents per mile from January 1 through June 30 and 76 cents per mile from July 1 through December 31. Dates on each trip matter because the two halves of the year use different rates. How those rates compare with actual vehicle costs is covered in standard mileage rate vs. actual vehicle expenses.

What to Include

There is no single official form, but a defensible report answers the same questions for every trip:

• Date of travel
• Starting location and destination
• Business purpose (more specific than “meeting”)
• Miles driven
• Vehicle, if you use more than one
• Optional: parking and tolls, if you will claim them separately

On top of the trip rows, keep beginning- and end-of-year odometer readings so the totals reconcile. If a vehicle enters or leaves business use mid-year, record the odometer then as well. The same fields belong in an IRS mileage log; the report is that log, totaled and ready to submit.

A Sample Mileage Report

Date	From / to	Purpose	Miles
2026-01-04	Home (Denver) to client office	Sales meeting	12.3
2026-01-04	Client office to supply store	Purchase materials	5.1
2026-01-05	Home (Denver) to Boulder conference	Industry conference	24.7
2026-01-06	Boulder conference to home	Return from conference	24.7
Total			66.8

At the second-half 2026 rate of 76 cents, 66.8 business miles is about $50.77. Use 72.5 cents for trips before July 1. Do not mix the two rates on the same trip.

How to Create the Report

1. Choose a tracking method. A notebook, a spreadsheet, or a GPS app all work if you actually use them the same day.
2. Record every business trip as it happens. Date, start, destination, purpose, miles. Do not guess or round.
3. Classify the trip. Business, personal, or commuting. Only the first belongs on a deduction or most reimbursement reports.
4. Compile on a schedule. Weekly or monthly. Export from the app or total the spreadsheet. Group by period and show a grand total.
5. Reconcile. Business miles plus personal and commuting miles should be consistent with the odometer change for the period.
6. Apply the right rate. Employer policy for reimbursement; the IRS period rate for a deduction. See how mileage reimbursement works.
7. Submit or store. Send the report with the expense claim, or keep it with the tax file.

Tools That Make It Easier

A spreadsheet is enough for a handful of trips a month. Publication 463 includes a sample daily log you can copy. Once you are making several trips a week, reconstructing them from memory is the failure mode.

A mileage tracker app records the route, distance, date and time automatically. You still mark the trip as business and write the purpose. Way Mileage Tracker does that capture-and-classify loop and exports a report you can attach to an expense claim or a tax file. How that compares with a notebook is the subject of mileage tracker app vs. manual mileage logs.

Mistakes to Avoid

• Logging days or weeks later. Late entries look reconstructed.
• Vague purposes. “Meeting” is weaker than “contract review at Acme, 14th Street.”
• Rounding miles. Record the GPS or odometer figure, not “about 20.”
• Counting the commute. Home to a regular workplace is generally personal.
• Skipping mid-year odometer readings when a vehicle starts or stops business use.
• Using one 2026 rate for the whole year.
• Throwing the report away after filing. Keep U.S. tax records at least three years after you file.

Frequently Asked Questions

Submit It, Then Keep It

The report is only as good as the trip records underneath it. Capture each business drive the day it happens, classify it honestly, apply the rate that actually applies to that date, and keep the file with the rest of the year’s tax or expense records. If you would rather review a captured list than reconstruct one, start with Way Mileage Tracker.