Reconcile each vehicle on its own
A pickup and an SUV have separate odometers, trips, and potentially different method histories. Enter each vehicle’s observed start and end readings and supported first-half and second-half business miles. The worksheet flags business mileage above the total odometer change. The report should let a bookkeeper trace each subtotal back to a dated and understandable trip.
| Field | Illustrative value |
|---|---|
| Owner | Sample business owner |
Fill it in and review the result
Business-use percentage divides supported business miles by the vehicle’s total miles. A pickup with 8,000 business miles out of 10,000 total is 80% in this illustration. Do not average that percentage with another car before reviewing the individual records. Read the current source guidance as well as the example because a similar route can receive different treatment.
Read the output with its limits
The preview calculates each car’s annual change and business-use percentage. It rejects business miles above that change. A successful arithmetic check still does not prove the readings or classify the nonbusiness miles. Confirm the vehicle and period before exporting because the 2026 business rate changes on July 1.
Check the header before the trip rows
This worksheet keeps Owner in the report context. Those fields answer a different question from the mileage total: they identify which vehicle, person, property, assignment, period, or evidence set the rows belong to. Review them whenever the sheet is copied for a new month or client.
The current sample reads Owner: Sample business owner. Replace every sample value before printing. A correct trip table under the wrong vehicle or claim period creates a report that looks finished but cannot be reconciled. If one file covers several properties, projects, or vehicles, either split it or identify the correct context on every affected row.
The distinguishing field for this form is vehicle and odometer. Keep its supporting source outside the browser because the generator does not save entries. Download the CSV for checking and print the PDF for reading; open both files once before relying on them at tax time.
Audit every vehicle before combining the totals
Give each car a stable name that matches registration, service records, and prior returns. A generic Vehicle 1 label may work while editing, but it is weak in a year-end archive when a household owns a pickup, an SUV, and a replacement car.
Enter supported start and end odometers for the period each vehicle was available. If a car was purchased, sold, or placed in business use during the year, record those dates. Do not invent full-year readings for a vehicle you did not own on both dates.
The annual change is end odometer minus start odometer. Business miles cannot exceed that change. Passing this arithmetic check only proves the inputs are possible; it does not identify commuting, other personal driving, or a missing business trip inside the remaining miles.
Keep January–June and July–December business miles separate because the 2026 optional business rate changes from 72.5¢ to 76¢ on July 1. Build those subtotals from dated trip rows. Dividing the annual business total in half is not a substitute for dates.
Calculate business-use percentage separately for each vehicle. A pickup used on service calls can show a high percentage while a family SUV used for occasional estimates shows a lower one. Do not average percentages or move miles between cars to reach a preferred result.
Review method history for every car. A prior Section 179 claim, accelerated depreciation, lease, actual-expense election, or simultaneous fleet use can affect standard-mileage availability. This worksheet performs split-rate arithmetic; it does not decide method eligibility.
Match each mileage subtotal with service invoices, odometer photos, inspection records, or other dated evidence of total use. A trip log explains business travel. An oil-change receipt can support a reading. Neither document automatically replaces the other in a complete file.
If two spouses or businesses share one car, tag every trip with the activity that caused it. Produce separate activity reports without duplicating the underlying vehicle miles. Combined business miles across activities still cannot exceed the car’s actual movement.
Download the CSV and inspect vehicle columns before adding spreadsheet formulas. Keep the untouched export. Print the PDF and confirm that all rows fit on the page, especially names, odometers, business-use percentages, and both rate-period amounts.
A replacement vehicle needs its own record even if it takes over the old car’s route. Close the first record on its disposal date, preserve the final reading, and begin the next vehicle with its own placed-in-service evidence.
At year end, reconcile the combined report with separate vehicle files and the prior return. Investigate duplicate trips or impossible overlaps. Give the preparer vehicle specifications and method history, not only the dollar estimate shown by the browser.
Separate parking and tolls by vehicle or assignment when those costs are tracked outside the standard-mileage amount. Do not add fuel, repairs, insurance, or depreciation again to a standard-mileage calculation. Keep actual-expense records available if a preparer is comparing methods for an eligible vehicle.
Read the final printout from left to right. Every vehicle should show a plausible annual change, supported business subtotal, percentage, and rate-based amount. Blank unused vehicles should stay blank. A zero entered for an active vehicle can hide missing work just as easily as an exaggerated number can overstate it.
Keep a short note explaining which vehicle was normally used for each kind of work, but let the dated trip row control when reality differs. A normal assignment pattern helps find mistakes; it is not permission to assign every unattributed trip to the same car.
Sources reviewed October 28, 2026: Record rules, 2026 rate adjustment.