A time and mileage log template is a reusable record for noting when a trip began and ended, how far a vehicle traveled, and why the trip took place. Use the blank table below to track each journey consistently; adjust its columns to suit whether you need a personal travel record, a work-trip log, or a simple vehicle-use history.
What a Time and Mileage Log Records
A time and mileage log combines two kinds of information: time details and distance details. For a vehicle trip, the time portion usually records the date and departure and arrival times. The mileage portion records the starting and ending odometer readings, or the distance traveled. A purpose or destination field explains what the trip was for.
People use logs for different reasons. An employee may need to document work-related driving for an employer’s reimbursement process. A self-employed person may want an organized record of business travel. A household might track shared vehicle use, while a driver may record trips to understand routine driving or keep a service history. The information a particular organization or authority requires can differ, so a general-purpose template is a starting point, not a guarantee that every required field is included.
This kind of log is not the same as a timesheet. A timesheet usually records hours worked or tasks performed, while a time and mileage log describes travel. A trip log also does not by itself establish that a journey qualifies for reimbursement or any particular treatment; that depends on the applicable rules and the facts.
Time and Mileage Log Template
Use one row per trip. Record odometer readings in the same unit throughout the log, such as miles or kilometers.
| Date | Driver | Departure time | Arrival time | Start odometer | End odometer | Distance | Purpose and destination | Notes |
|---|---|---|---|---|---|---|---|---|
Sample — fictional details: On 12 May 2026, fictional driver Alex Example left at 9:10 a.m. with an odometer reading of 18,240 and arrived at 9:32 a.m. at 18,248. Distance: 8 miles. Purpose and destination: “Pick up office supplies, North Street shop.” Notes: “Round trip not included; separate return row to follow.”
Fields to Include and Why They Matter
The template’s basic fields make it possible to understand a trip later, rather than merely collect numbers. A date identifies when it happened; the driver field helps distinguish trips when more than one person uses the vehicle. Departure and arrival times show the travel window. If elapsed time matters for your record, it can be calculated from those entries, allowing for any time-zone or overnight details relevant to a long journey.
Odometer readings provide a direct way to calculate distance: subtract the starting reading from the ending reading. For example, an end reading of 18,248 minus a start reading of 18,240 equals 8 miles. The distance column is useful as a quick summary, but retaining both readings makes the calculation traceable. If you enter only distance, make sure you have a consistent method for measuring it.
Purpose and destination are often the most informative fields. “Work” may be too vague months later; “visit project site, West Avenue” gives more context. Notes can capture an unusual circumstance, such as a detour, a second stop, a different driver, or an odometer issue. Avoid putting unnecessary personal or sensitive details in a log that others may see.
How to Fill In the Log
Complete the record as close to the trip as practical. Memory fades, and reconstructing a route or time later can be difficult. Follow a repeatable routine:
- Write the date and identify the driver and vehicle if the log is shared or covers more than one vehicle.
- At the start, note the departure time and odometer reading. Use the same time convention and distance unit every time.
- At the end, record the arrival time and ending odometer reading.
- Calculate the distance by subtracting the start reading from the end reading, then add the trip’s purpose and destination.
- Review the entry for missing digits or unclear descriptions. Add a note if the journey included multiple stops or an unusual route.
For a journey with several stops, decide on a consistent approach. You can record the whole outing as one row and list each stop in the notes, or create a separate row for each leg. Separate rows provide more detail, while one row is quicker to maintain. If you split a journey, make the start and end readings for each leg line up with the vehicle’s actual odometer readings.
A Worked Example: Calculating Distance and Time
Suppose a fictional driver leaves at 1:05 p.m. with an odometer reading of 42,610 and arrives at 1:47 p.m. with a reading of 42,628. The trip distance is 18 miles, calculated as 42,628 minus 42,610. The elapsed trip time is 42 minutes. The driver might describe the purpose as “deliver signed documents to the Main Street office.” If the driver then continues to a different destination, recording that next leg separately can make the route easier to follow.
Odometer readings and route estimates may not match perfectly. A route can change because of traffic, road closures, or a stop, and a vehicle’s odometer measures its movement rather than the distance between two addresses on a map. For a record that needs to be auditable, keep the original readings and explain meaningful differences instead of silently changing the figures.
Choosing a Paper or Digital Format
A printed sheet works well when a driver can write down readings in the vehicle and later file the page. It is easy to use without a device, but handwriting can be hard to read and totals may need to be calculated by hand. Leave enough room for the purpose and notes fields; a very narrow table can make the log less useful.
A spreadsheet or other digital document can calculate distance automatically and make entries easier to sort by date, driver, or purpose. It also makes it simple to add rows. The trade-offs are that formulas can be overwritten, files can be misplaced, and a device may not be available at the moment a trip begins or ends. If using a digital copy, keep a backup and check calculations periodically. A simple paper log can also be transferred to a digital record later, as long as the transcription is checked against the original.
Choose the format people will actually complete. For a shared vehicle, decide where the log lives, who is responsible for entering trips, and how corrections are made. For instance, a team might use one vehicle sheet with a driver column, while a personal log may need only one driver field or no driver field at all.
Keeping Entries Clear and Consistent
Consistency matters more than elaborate wording. Choose either 12-hour or 24-hour time, use one distance unit, and stick to a predictable description style. Identify the vehicle when multiple vehicles are involved, perhaps with a unit number or a non-sensitive label. If a trip is for a particular project or work location, use a short name that will still make sense later.
Keep the record legible and make corrections transparently. On paper, draw a single line through an incorrect entry so the original remains readable, then write the corrected information nearby and add initials or a date if the record’s process calls for it. In a digital file, retain a clear history where possible or note the correction rather than obscuring why a value changed. Do not fill gaps by guessing; mark an estimate as an estimate and explain its basis if the log allows notes.
Store the log where authorized users can find it, but avoid exposing it more widely than necessary. Trip records can reveal routines, destinations, and work patterns. Follow your organization’s handling and retention procedures when the log relates to work. If a situation has legal, tax, or reimbursement consequences, ask a qualified professional about the requirements that apply.
Common Problems and How to Avoid Them
- Missing purpose: A distance total alone does not explain why the trip occurred. Add a concise purpose and destination while the details are fresh.
- Mixed units: Do not combine miles and kilometers in one distance column without labeling and converting them consistently.
- Reversed readings: Check that the ending odometer is not lower than the starting reading. If it is, verify the digits and note a rollover, replacement, or other unusual event if relevant.
- Unclear time entries: Include a.m. or p.m. when using a 12-hour clock, or use a consistent 24-hour clock.
- Duplicate or overlapping trips: Compare dates, times, and readings when reviewing a shared log, especially if separate drivers are entering information.
- Late reconstruction: Avoid relying on memory for routine entries. If an entry must be completed later, label what is estimated and what is known.
A common misconception is that a trip log only needs a total at the end of a month. Totals can be useful, but they do not show how the figure was produced. Individual trip entries make it easier to check arithmetic, explain a destination, and identify missing information. Whether a particular record must contain additional details depends on the purpose for which it is being kept.
Frequently Asked Questions
How do I calculate mileage from odometer readings?
Subtract the starting odometer reading from the ending reading. If the start is 18,240 and the end is 18,248, the distance is 8 miles, provided both readings use the same unit.
Should I record every trip or only work trips?
That depends on why you are keeping the log. A personal vehicle-use history may include every trip, while a work record may focus on trips specified by an employer or applicable process. State the scope clearly and follow the relevant instructions.
What if I forgot to write down a trip?
Enter what you can verify, such as the date, route, or available odometer information, and identify any estimated details rather than presenting them as exact. Do not invent a reading to fill a gap.
Can I use this template for kilometers?
Yes. Label the distance as kilometers and use kilometer odometer readings throughout. Do not mix units within the same log unless each entry is clearly labeled and converted appropriately.
Is a time and mileage log the same as a timesheet?
No. A trip log records travel details such as departure, arrival, and distance. A timesheet generally records work hours or tasks. An organization may require both, but one does not automatically replace the other.