Present Mileage, Engine Hours and Maintenance Records Clearly

A fleet spreadsheet often combines different records: dashboard readings, maintenance exports, fuel reports and notes from branch managers. Before sharing it, check that each figure belongs to the correct unit and that its meaning is clear. A dated reading and a short explanation are more useful than a precise-looking number copied from an unknown source.

Record the reading, unit and date together

Take a current odometer reading for each vehicle when it is practical and safe to do so. Record miles or kilometers explicitly, along with the date. If you use a maintenance report because the vehicle is elsewhere, identify it as the latest recorded reading and include the report date. Don’t describe an old service entry as today’s mileage.

Use the VIN or company unit number consistently. If unit numbers were reused after a replacement, use the VIN to separate the histories. Keep a dashboard photograph with the vehicle’s photo folder, and note when a unit remains in service so everyone knows that the reading can change before handover.

Label engine, idle and equipment hours separately

Some vehicles display engine hours as well as mileage; others do not. If hours are available, copy the label used by the vehicle or fleet system. Keep total engine hours separate from idle hours and from a meter on a piece of equipment. A refrigerated box’s unit hours, for example, should not be entered in a field labeled engine hours without an explanation.

Do not convert hours into an invented mileage figure or apply one wear formula to every vehicle. Describe the work instead: deliveries with frequent stops, passenger travel, site use or operation of fitted equipment. Use actual information from your records or staff, and leave unverified details marked as unknown. Maintenance requirements should come from the manufacturer’s schedule for the vehicle and its use.

Summarize the history without replacing the source records

Put routine service, major repairs and unresolved issues into a short summary for each unit. Include dates and readings when those are available. Keep the underlying invoices or system exports organized so an entry can be checked. If you list a replacement engine, transmission or other major component, record what the invoice actually says rather than treating the entire vehicle as renewed.

• Routine service: the record period covered and where the supporting records are kept.
• Major work: the component, date, recorded reading and available invoice or work order.
• Current issues: warning lights, reported symptoms, open work orders and completed diagnoses.
• Installed equipment: any separate maintenance history for liftgates, bodies or other included equipment.

A useful note can be modest: “Service records available from acquisition onward; earlier history unknown.” Avoid claims such as “fully maintained” if the records do not show what work was required and completed. For the wider pricing discussion, see what goes into a fleet purchase offer.

Make gaps and contradictions visible

If a dashboard reading and a system export disagree, keep both sources and investigate the difference. Check the vehicle identifier, date and unit of measurement first. Record known instrument or component changes, and do not silently edit a source document to make the values match. Where the answer is still unclear, explain the limitation to the reviewer.

Distinguish “no records available” from “no repairs needed” and “not checked” from “no warning lights.” Leave a missing reading blank or mark it unavailable in the inventory notes. This also helps when branch staff are combining company cars, SUVs, vans and trucks that have different record systems.

Add recall information with its limits

Use NHTSA’s recall lookup to check a VIN and record when you checked it. NHTSA explains that its VIN results do not show every category of recall or campaign, and do not list recalls already repaired. A result showing no unrepaired recalls is not a general condition report. Follow any manufacturer instructions and retain records of completed work.

Before sharing documents, remove unrelated employee, customer and payment information from copies while keeping the source records under your company’s retention policy. The inventory template is a starting point for the overview; arrange the sharing of detailed invoices and records during the review.