Keep the date as a date, not a text label
A June 30 trip and a July 1 trip use different 2026 business rates. The CSV contains rows that Excel and Google Sheets can open; it is not an XLSX workbook. Check the imported date and numeric columns before copying any formula. A clear label helps organize the file, but the dated route and business reason carry the useful evidence.
| Field | Illustrative value |
|---|---|
| Workbook owner | Sample sole proprietor |
| Distance unit | Miles |
Fill it in and review the result
For a sheet with trip date in A2 and miles in D2, =IF(A2<DATE(2026,7,1),D2*0.725,D2*0.76) illustrates the split for valid 2026 business dates. This formula is not a general all-years rate lookup. Reject missing dates instead of silently assigning the July rate.
| Date | From | To | Purpose | Miles |
|---|---|---|---|---|
| 2026-06-30 | Client A | Supply house | Job 12 parts | 18 |
| 2026-07-01 | Supply house | Client B | Job 15 visit | 18 |
Read the output with its limits
The CSV exports calculated amounts, not live Excel formulas. If you add formulas in a workbook, retain the original imported CSV and check that the two June/July sample amounts remain different. 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 Workbook owner, Distance unit 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 Workbook owner: Sample sole proprietor; Distance unit: Miles. 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 trip date. 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 the sample like a real report
The editable example contains 2 trip rows totaling 36 miles. The first row runs from Client A to Supply house for job 12 parts. The last runs from Supply house to Client B for job 15 visit. Each row needs its own date and purpose even when both belong to one project.
For this trip date worksheet, check that no row is duplicated, no personal detour remains inside a work distance, and no date falls outside the labeled period. A valid June 30 business row uses 72.5¢; a July 1 row uses 76¢. Other mileage categories use their own rates.
This page starts with a june 30 drive and a july 1 drive in the same spreadsheet. Treat that as an illustration, not a record of your drive. Replace it with observed or supportable details. If a route was added later from a calendar or map, mark the reconstruction and retain the appointment, invoice, receipt, or service record used to rebuild it.
Print one test page before building a full report. Confirm that trip date is visible, long purposes wrap, and no table column is cut off. A browser PDF can use a different paper size or margin than the office printer, so inspect the saved file rather than assuming the on-screen preview guarantees the final layout.
Use consistent units. This template expects miles, and its 36-mile sample is not a place to enter kilometers, reimbursement dollars, or odometer readings. Put start and end odometers only in labeled context fields. Converting or mixing units silently makes the rate calculation impossible to verify.
In this trip date file, keep the first sample date, 2026-06-30, separate from the last, 2026-07-01. Dates decide the 2026 rate period. Do not assign July’s 76¢ to a June row because the report was printed later, or divide an annual total without dated evidence.
Give each trip in the keep the date as a date, not a text label one primary purpose another person can understand. “Meeting” is weaker than a review tied to a project. “Supplies” is weaker than replacement valve for rental A. The report can stay concise without exposing information the receiver does not need.
Reconcile the CSV with the printout. The downloadable rows should preserve trip date, dates, routes, purposes, and distances. Open the CSV in a spreadsheet and make sure dates and decimals were not automatically reformatted. Keep the untouched download before adding formulas, colors, or manual totals.
For trip date, a signature records approval only after an authorized person signs, and a vehicle header is useful only after correct readings are entered. Treat every blank, default, and sample value as unfinished. The generator cannot know whether a plausible value belongs to the scenario: A June 30 drive and a July 1 drive in the same spreadsheet
If this trip date report combines clients, properties, vehicles, or activities, preserve the allocation in a field or purpose. One annual total is difficult to divide later. Monthly files make corrections easier, while a year-end keep the date as a date, not a text label summary can be rebuilt from reviewed exports.
Save support for a june 30 drive and a july 1 drive in the same spreadsheet with a repeatable name, such as 2026-10 vehicle project mileage. Keep Social Security numbers, bank logins, full patient names, and unnecessary home addresses out of a broadly shared PDF. Store any private cross-reference for trip date in a controlled location.
Review the deduction or reimbursement method separately from this trip date template. Standard mileage, actual expenses, an accountable plan, Schedule E, medical mileage, and charitable service do not use one rule. The form organizes keep the date as a date, not a text label inputs; cited IRS material and a qualified professional address eligibility.
Finish by asking whether the scenario still matches the rows: A June 30 drive and a July 1 drive in the same spreadsheet If the work changed, update the context and purposes before reuse. Copying last month’s completed sheet is efficient only when every inherited value is reviewed; otherwise it produces a polished record for the wrong activity.
Sources reviewed October 28, 2026: Record rules, 2026 rate adjustment.