Truck Mileage Log Spreadsheet: Setup and Formulas

Formulas & functions · Updated November 21, 2026

A truck mileage log spreadsheet is a simple way to record each trip’s date, vehicle, odometer readings, miles, and business purpose. In Excel for Microsoft 365 on Windows, create those columns, then calculate trip miles by subtracting the starting odometer reading from the ending reading; keep the original readings so the result can be checked later.

What a truck mileage log records

A useful log links a trip to the vehicle and the reason for travel. The odometer readings provide a traceable basis for the distance rather than relying on a driver’s memory or a rounded estimate. A spreadsheet can also make it easier to filter trips by driver, truck, customer, job, or month.

Decide what the log is for before building it. A small contractor may want records for business-trip reporting and expense review. A fleet manager may need mileage by truck, route, or driver for operating analysis. Those purposes overlap, but a mileage log does not automatically meet every tax, insurance, maintenance, or transportation-regulatory recordkeeping requirement.

For a basic trip-by-trip log, include:

  • Date of travel and, if useful, departure time.
  • Driver and truck identifier, such as a fleet number or license plate reference.
  • Starting and ending odometer readings.
  • Calculated trip miles.
  • Starting point, destination, and a specific business purpose.
  • Optional fields for customer, job number, personal miles, tolls, or notes.

Use a consistent unit—miles or kilometers—and label it clearly. If more than one truck is involved, record the vehicle on every trip row. A separate tab for each truck may look tidy initially, but one combined table is usually easier to sort and summarize.

Set up the worksheet in Excel

Put one trip on each row, with headings in row 1. A practical layout is: A Date, B Driver, C Truck ID, D Purpose, E From, F To, G Start odometer, H End odometer, I Trip miles, J Business miles, and K Notes. If every recorded trip is business travel, column J may be unnecessary; if you also record personal or nonbusiness driving, keeping business miles separate can prevent confusion.

Enter real Excel dates in column A, not dates typed into a sentence such as “Monday, April 4.” Keep odometer fields numeric, without typing units into the cells; place the unit in the heading instead. For example, enter 128450 rather than “128,450 miles” if Excel is treating the latter as text. Format the date column with a readable date format and use a consistent number format for odometer readings and miles.

To make the range filterable and easier to extend, select the headings and a few rows, then choose Insert > Table and confirm that the table has headers. Excel tables add filter controls to the headings and generally carry formatting and formulas into new rows. On Excel for Mac, the Insert > Table command is also available, though the ribbon layout can differ slightly. In Excel for the web, table creation is also available from the Insert tab.

Keep the headings short and unambiguous. “Start odometer” and “End odometer” are clearer than “Start” and “Finish,” especially when someone else reviews the file. If drivers enter data, protect the formula column from accidental edits only after testing the sheet and ensuring the people responsible can still add rows.

Calculate trip miles with a formula

With start odometer readings in G2 and end readings in H2, enter this formula in I2 to leave the result blank until both readings are present: =IF(OR(G2="",H2=""),"",H2-G2). For a trip that starts at 128,450 and ends at 128,578, the result is 128 miles. Copy the formula down the column, or use an Excel table so the formula can fill into new rows.

The calculation assumes both readings use the same odometer and that the ending reading is later than the starting reading. If a reading was mistyped, the result can be implausible or negative; do not silently change the miles to make them look reasonable. Check the source readings and correct the underlying entry with a note if needed. If the odometer was replaced, reset, or rolled over, document the situation and use a method appropriate to the vehicle rather than treating the negative result as a normal trip.

With business miles recorded in I2:I1000, use =SUM(I2:I1000) in a summary cell to total that range. If the three example trip values are 128, 96, and 140 miles, the total is 364 miles. This is a straightforward sum; it does not decide whether every mile qualifies as business travel or is reportable for a particular purpose.

To total January 2026 business miles when dates are in A2:A1000 and business miles are in J2:J1000, use =SUMIFS($J$2:$J$1000,$A$2:$A$1000,">="&DATE(2026,1,1),$A$2:$A$1000,"<"&DATE(2026,2,1)). If January trips have 128 and 96 business miles and a 140-mile trip falls on February 2, the formula returns 224. The end boundary is February 1, exclusive, so a trip dated in February is not included. Adjust the date boundaries for the month you need.

Record trips consistently

Enter the readings close to the time of travel, using a phone, paper trip sheet, dispatch record, or other reliable source if the spreadsheet is not available in the truck. A weekly catch-up from memory is more likely to omit a stop or confuse which vehicle was used. If trips are entered later, retain supporting information and identify the entry as a correction or late entry instead of presenting an estimate as a contemporaneous reading.

Use a specific purpose rather than a vague label. “Delivery” may be enough in a simple internal fleet log, but a customer, job, or delivery reference can make the entry more useful later. “Visit to Northside job site to inspect load” communicates more than “work.” Do not put sensitive personal or customer details in a shared file unless they are needed and access is appropriate.

Choose whether a row represents one leg, one round trip, or a daily total and apply that rule throughout. Separate legs are useful when a driver visits several destinations, because each destination and purpose can be recorded. A daily total may be simpler for a vehicle with one clear route, but it gives less detail about stops. Avoid mixing individual legs and full-day totals in the same miles column; that can count the same distance twice.

Make the spreadsheet easier to review

Use Excel’s filters to find trips for one vehicle or date range, and sort by date when checking gaps. Freeze the heading row with View > Freeze Panes > Freeze Top Row so column names stay visible while scrolling. These features help with review but do not verify that the values entered are true.

Set a routine for comparing selected entries with source evidence, such as dispatch records, fuel receipts, work orders, or odometer photos where appropriate. The evidence should support the trip details, not just the total distance. Establish who may edit the workbook and where the official copy is stored. A shared file with a clear owner and regular backups is safer than several emailed copies named “final.”

For a large fleet, keep the raw trip log separate from summaries. Avoid deleting or overwriting old rows to make a report cleaner; filter or create a summary instead. If corrections are made, record what changed and why, especially when the workbook supports formal reporting. A spreadsheet’s version history can help, but it is not a substitute for a deliberate recordkeeping process.

Common mistakes and limitations

  • Recording only trip miles: A calculated distance without start and end readings is harder to reconcile. Keep both readings when they are available and relevant.
  • Using the wrong vehicle: A driver may use a different truck than usual. Require a truck ID on each row rather than assuming it from the driver’s name.
  • Mixing business and personal use: Track categories separately and define them consistently. A truck’s total mileage and its business mileage are not necessarily the same figure.
  • Double-counting: Do not enter both the mileage for each leg and a daily round-trip total covering those same legs.
  • Overwriting formulas: Protect or visually distinguish calculated cells, and check that formulas extend to new rows.
  • Treating the spreadsheet as proof by itself: A neat workbook cannot establish that a trip occurred. Keep appropriate supporting records and correct errors transparently.

Do not use a mileage spreadsheet as a substitute for a commercial driver’s hours-of-service record or an electronic logging device when those rules apply. Mileage tracking and hours-of-service tracking answer different questions. Requirements depend on the operation and jurisdiction, so check the applicable transportation rules.

Tax records and business use

In the United States, the IRS describes vehicle-use records in Publication 463, including information such as the date, destination, business purpose, and mileage. A spreadsheet can organize those details, but it does not determine whether a trip is deductible or which vehicle-expense method may apply. Commuting and business travel can be treated differently, and the details matter. Rules, forms, and standard mileage rates can change, so consult current IRS guidance or a qualified tax professional for your circumstances.

For a vehicle used for both business and personal purposes, record enough information to distinguish the categories that matter for the recordkeeping task. Do not assume that all truck miles are business miles simply because the truck is used for work. Conversely, do not infer a tax result from a spreadsheet total alone. The workbook is a recordkeeping aid, not tax or legal advice.

Spreadsheet or mileage-tracking app?

An Excel log is inexpensive, flexible, and easy to tailor to a small operation. It works well when trips are relatively few, drivers can enter readings reliably, and someone is responsible for checking the file. You can add job numbers or fleet-specific fields without adopting a new platform.

A dedicated mileage or fleet app may be more suitable when many drivers need to submit trips, when automatic trip capture is useful, or when managers need centralized reporting. Apps may involve subscription charges, device requirements, privacy considerations, and setup work. Compare what the product actually records, how corrections are handled, whether data can be exported, and whether it satisfies the intended recordkeeping need. Automation reduces manual entry but does not guarantee that trip classifications or records are correct.

Frequently Asked Questions

What columns should a truck mileage log have? At minimum, use date, truck identifier, driver, starting and ending odometer readings, trip miles, destination, and business purpose. Add customer, job number, or separate business and personal mileage fields if they serve a clear need.

Should I log every trip or just daily mileage? Log each leg when destinations or purposes differ, or when detailed trip records are needed. A daily total can work for simpler internal tracking, but use one consistent method and do not combine daily totals with the legs they already include.

Can Excel calculate mileage automatically? Excel can calculate the difference between two odometer readings with a formula. It cannot know whether the readings are accurate, whether a trip was business-related, or whether the result meets a specific tax or regulatory requirement.

Can I use the same spreadsheet for multiple trucks? Yes. Use one row per trip and include a truck ID on every row. A combined table can then be filtered by vehicle, driver, or date without maintaining separate files that may be difficult to reconcile.

Is a mileage spreadsheet enough for an ELD or hours-of-service log? No. A spreadsheet that records distance does not by itself satisfy hours-of-service or electronic logging device requirements. Check the rules that apply to the operation and use the required records or equipment.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.