How to manage a vehicle fleet without losing control of the details

The short version

• Keep one record per vehicle and driver, joined by assignment dates rather than overwritten names.
• Run daily exception checks, weekly planning and a monthly cost review.
• Measure availability, maintenance compliance, fuel efficiency and cost per kilometre together.
• Treat local documents and units as operational data, not notes in a spreadsheet.

1. Build a reliable fleet record

Start with the entities that change at different speeds. A vehicle has a plate, VIN or national identifier, tank capacity, odometer and acquisition value. A driver has a licence, class and expiry. The assignment between them has a start and an end date. Keeping those as separate records preserves history when a driver changes vehicles.

Every fuel transaction, service, inspection, document and expense should point back to the vehicle that generated it. That relationship is what makes cost per kilometre and vehicle-level history possible without manual reconciliation.

• Vehicle identity and status
• Driver eligibility and licence expiry
• Current and historical assignments
• Odometer readings with dates and sources
• Documents, maintenance, fuel, inspections and other expenses

2. Use an operating cadence

A fleet does not need another dashboard nobody opens. It needs a routine that turns exceptions into owned work. Keep the daily review short and reserve trend analysis for a predictable monthly meeting.

3. Measure the few numbers that change decisions

A useful KPI has a clear source and an action attached to it. Cost without distance penalises vehicles that work more; efficiency without comparable routes can punish the wrong driver. Read each number in context and compare like with like.

• Availability: days ready for work divided by planned operating days.
• Preventive-maintenance compliance: work completed on or before its due date divided by scheduled work.
• Fuel efficiency: kilometres travelled divided by litres or gallons consumed between trustworthy odometer readings.
• Cost per kilometre: fuel, maintenance, other operating cost and depreciation divided by distance.
• Document compliance: valid required documents divided by required documents.

4. Control fuel through reconciliation and exceptions

Fuel control begins by joining the card or receipt, vehicle, date, volume, amount and odometer. Reconciliation proves that a transaction belongs to a known unit. Exception rules then focus attention on values that deserve review: volume above tank capacity, repeat fills too close together, a backwards odometer or a unit price far from the fleet’s recent average.

An exception is a prompt to investigate, not proof of misuse. Tank-capacity data may be wrong, a driver may have entered an odometer incorrectly, or a transaction may have posted late. Preserve the original record and document the review outcome.

5. Design around the fleet’s country

Mexico, Brazil and Colombia do not share one currency, one document set or even one common fuel-volume convention. Configure the fleet’s operational country separately from each reader’s language. Store canonical values where calculation requires it, then display the local unit.

• Mexico commonly works in MXN and litres, with records such as tarjeta de circulación and verification requirements.
• Brazil works in BRL and litres, with CRLV-e, IPVA and other vehicle- or operation-specific obligations.
• Colombia works in COP and often records fuel in gallons, with SOAT and revisión tecnomecánica among the core controls.
• Always validate requirements, intervals and document names against current local rules and the vehicle’s use.

6. Move from spreadsheets in controlled stages

Do not begin by importing every historical cell. First load active vehicles, active drivers and current assignments. Then add live document expiries and the next maintenance obligations. Once identifiers are clean, bring in fuel and expense history for the period needed to establish a baseline.

• Choose one owner for each source file.
• Standardise plates, dates, decimal formats and card numbers before import.
• Resolve duplicates instead of silently merging them.
• Reconcile totals for a sample period before switching the spreadsheet off.
• Keep the old file read-only for audit, with a clear cutover date.

As featured in