What the Expense Report Doesn't Survive Without
An expense report submitted without contemporaneous mileage records is an estimate. Your company's finance department calls it an estimate. The IRS calls it unsupported. The audit that happens three years later calls it a liability. Whether you're reimbursing yourself from a business account, submitting to a corporate travel department, or calculating the mileage deduction on a Schedule C, the odometer reading at departure and arrival is the documentation that makes the number real rather than approximate.
Most road warriors develop a system eventually. The problem is usually that they develop it after the first time an expense report gets kicked back or a deduction gets questioned. This template is the system you build before that conversation.
How the Odometer Math Works
Odometer Start and Odometer End are integer fields — the actual readings from the dash at the beginning and end of the day's driving. Total Daily Miles calculates automatically: End minus Start. No mental math at the end of a long day, no rounding to a round number because you're approximating.
The precision of the odometer reading matters. "Drove about 200 miles" and "drove 211 miles (Odometer Start: 48,392 / End: 48,603)" are different documents. The second version survives an audit. It also compounds correctly across a multi-day trip — Day 1 ends at 48,603, Day 2 starts at 48,603, the log is self-consistent and internally coherent.
The Departure and Arrival fields capture where you drove, not just how far — critical for trip purpose documentation when the same vehicle is used for both personal and business travel on the same day. "Departure: Indianapolis / Arrival: South Bend / Purpose: Client site visit, Harmon Manufacturing" is a business record. An odometer delta without a stated route and purpose is harder to defend.
The Four Expense Categories and What Falls Where
Fuel, Meals, Lodging, Other. Four fields that cover the vast majority of business travel expenses, with Other as the catch-all for tolls, parking, ferry crossings, or anything that doesn't fit the standard categories.
The total calculates automatically: Fuel + Meals + Lodging + Other = Total Daily Expenses. For a four-day road trip, the four daily expense totals sum to your total trip expense. For a multi-person trip, the Name field at the top of each record distinguishes whose expenses are whose.
Two Notes fields round out each day's record — one for anything billable that needs narrative explanation, one for administrative follow-up or context that doesn't belong in the expense line. The field separation matters if you're submitting expense documentation to a client where the expense notes become part of the billing record. What you want the client to see and what you want to remember for your own purposes are sometimes different things.