This driver mileage log spreadsheet is a free Excel template for recording individual trips, odometer readings, business miles, personal or commute miles, fuel use, and mileage reimbursement in 2026. It is structured for fleet managers, service fleets, delivery teams, dispatchers, small carriers, and owner-operators who need one consistent trip record.
The file has four sheets: Dashboard, Mileage Log, Drivers & Vehicles, and Settings. Instructions identify yellow input cells and gray calculated outputs, helping users preserve formulas while updating operating data. Populated trip and roster records demonstrate the intended format; unused prepared rows are available for actual entries.
In practice
What this workbook helps you do
- ✓Keeps driver, vehicle, trip type, locations, purpose, and odometer details together in one trip row.
- ✓Separates business miles from personal or commute miles and calculates eligible reimbursement in U.S. dollars.
- ✓Combines fuel gallons, fuel cost, and calculated MPG with the related trip record.
- ✓Summarizes selected dates and drivers while identifying incomplete, inconsistent, or duplicate records.
Instructions
How to use the file
Set the reimbursement rate and reporting dates
Begin on Settings and review the yellow assumption cells. B4 holds the Company Mileage Reimbursement Rate; the supplied example is $0.670 per business mile and is not a tax or regulatory determination. B5 and B6 contain the default report start and end dates. B7 and B8 set the earliest and latest dates accepted by the log and Dashboard. The supplied boundaries are January 1, 2020, through December 31, 2035. The confirmed units are miles, gallons, and U.S. dollars.
Replace the sample driver and vehicle rosters
Use Drivers & Vehicles to maintain up to 100 driver rows and 100 vehicle rows. Driver inputs are Driver ID, Driver Name, Status, and Home Terminal. Vehicle inputs include Vehicle ID, Year, Make, Model, Vehicle Type, Assigned Driver, Status, and Starting Odometer. Driver and vehicle names from these rosters supply the Mileage Log dropdown lists. Status accepts Active or Inactive, and Assigned Driver uses the driver-name list.
Enter one operating trip per Mileage Log row
The table runs from row 6 through row 505, providing 500 prepared trip rows in total. Populated records at the top are samples; remaining unused rows are blank operating rows. Replace or clear only their input cells rather than deleting calculated formulas.
Users enter Trip ID, Trip Date, Driver, Vehicle ID, Trip Type, Start Location, End Location, Business Purpose or Notes, Start Odometer, End Odometer, Business Miles, Reimbursement Eligible, Fuel Gallons, and Fuel Cost. Trip Type choices are Business, Personal, Commute, and Mixed.
Formula cells calculate Total Miles as end odometer minus start odometer, Personal or Commute Miles as total miles minus business miles with a minimum of zero, the applicable reimbursement rate, reimbursement amount, and MPG. The Validation Flag reports an issue or OK based on the row information. Avoid typing over columns K, M, O, P, S, and T because those columns contain formulas through row 505.
Choose a Dashboard view and review exceptions
On Dashboard, enter or select the Report Start Date, Report End Date, and Driver in B3:B5. The driver selection can be All Drivers or a name supplied from the roster. Calculated results include trips, total miles, business miles, personal or commute miles, fuel gallons, average MPG, fuel cost, reimbursement, and business-mile percentage. Review the monthly summary, monthly mileage chart, data-quality counts, and driver breakdown before using totals elsewhere.
Inside the file
Included features
Log each trip with odometer readings
Each mileage record begins with a unique Trip ID and trip date, followed by the assigned driver and vehicle. Start and end locations provide route context, while Start Odometer and End Odometer establish the distance traveled. The odometer input validation accepts values from 0 through 2,000,000.
Entering both readings allows the Total Miles formula to calculate the difference. A missing reading produces a validation message, while a lower end reading or a zero-mile result is identified for review. Trip IDs also have a uniqueness validation rule across the 500-row log.
Separate business mileage and reimbursement
Business Miles is a user-entered value validated so it cannot be negative or exceed calculated Total Miles. Personal or Commute Miles is then calculated as the remaining distance. For Business and Mixed trips, Business Purpose or Notes gives the record an operational explanation; the Dashboard separately counts missing purposes for those trip types.
When Reimbursement Eligible? is Yes, the row uses the company rate from Settings. Reimbursement Amount equals business miles multiplied by that rate and is rounded to two decimal places. Selecting No produces a zero rate. Review company policy before deciding which trips qualify.
Monitor fuel costs and trip MPG
Fuel Gallons and Fuel Cost are optional user-entered trip fields with numeric validation. Gallons can range from 0 through 300, and fuel cost can range from $0 through $5,000. When Total Miles and Fuel Gallons are present, MPG is calculated by dividing miles by gallons.
The Dashboard adds gallons and fuel cost for the selected dates and driver. Average MPG is calculated from total miles divided by total fuel gallons rather than by averaging individual trip MPG values. If fuel entries are omitted, those trips do not contribute gallons or fuel cost to the summary.
Review driver totals and data quality
The Dashboard presents a monthly summary of trips, total miles, business miles, and reimbursement. Its chart compares total miles and business miles by month. A separate driver breakdown reports trips, total miles, business miles, and reimbursement for each displayed driver.
Use Rows Needing Review alongside the detailed quality checks. The Dashboard reports missing business purposes, duplicate Trip ID rows, end odometers below start readings, business miles above total miles, and zero-mile trips. Return to the affected Mileage Log row to correct an input; calculated cells update from the revised information.
Common questions
About this workbook
The Mileage Log table contains 500 prepared data rows, from row 6 through row 505. That total includes the populated sample records at the top and the unused blank rows available for operating data. The sample entries illustrate field use and should not be treated as actual fleet history.
Yes. Drivers & Vehicles provides 100 driver rows and 100 vehicle rows. Driver names and vehicle IDs feed the corresponding Mileage Log dropdowns. The vehicle roster can also record an assigned driver, but each trip still requires its own Driver and Vehicle ID selections.
For a row marked Yes under reimbursement eligibility, the spreadsheet retrieves the company mileage rate from Settings and multiplies it by Business Miles. The result is rounded to two decimal places. The included $0.670 rate is only an example company assumption and should be reviewed before use.
Trip ID cells have a custom validation rule requiring a blank or unique value within A6:A505. The Dashboard also calculates the number of rows whose Trip ID appears more than once. Correct each affected input so every operating trip can be identified separately.
No such determination is built into the file. It organizes trip, mileage, fuel, and reimbursement information, but it does not replace accounting, legal, tax, DOT/FMCSA, safety, or compliance advice. Users remain responsible for confirming required records, retention periods, reimbursement policies, and supporting documentation.
Editorial team
Prepared and checked with care
Casey Morgan
Fleet operations editorCasey turns dispatch, driver, vehicle, and delivery workflows into clear workbook guides.
About the editorial identities
Jordan Lee
Workbook quality editorJordan documents the automated formula, recalculation, download, and usability checks applied before publication.
About the editorial identities