Fuel and mileage reconciliation: catching the numbers that don't add up

Fuel spend and recorded mileage on a given vehicle should broadly track each other over time, within a reasonably consistent range for that vehicle's typical fuel consumption. When the relationship between the two quietly drifts — spend rising faster than mileage, or mileage rising without a corresponding rise in fuel purchased — it's usually pointing at one of a fairly small number of underlying causes, and none of them tend to resolve on their own once the drift has started.

What actually causes the numbers to diverge

A few things account for most genuine discrepancies: a vehicle developing a mechanical fault that's quietly degrading fuel efficiency before it becomes a full defect anyone's noticed at a daily check; fuel card misuse, whether accidental (fuelling the wrong vehicle) or deliberate; inaccurate mileage recording, particularly where odometer readings are logged manually and prone to transcription error; or a genuine change in how a vehicle's being used — more idling time, heavier loads, a different route profile — that shifts consumption without anything actually being wrong.

Why this is worth checking regularly, not just when something feels off

The trouble with waiting for something to 'feel off' before checking is that a gradual drift, spread across weeks or months, doesn't create the kind of sharp anomaly that draws attention on its own — it's the accumulated pattern that matters, and that only shows up if someone's actually comparing fuel and mileage figures on a regular cycle rather than reactively. A vehicle whose efficiency has quietly dropped ten or fifteen percent over several months represents a real, ongoing cost that a one-off glance at this month's fuel bill won't reveal.

Reconciliation as an early maintenance signal

A genuine efficiency drop is often a maintenance issue arriving early, before it's visible anywhere else — tyre pressure, wheel alignment, a developing engine or drivetrain issue can all show up as a fuel efficiency change well before they produce a defect a driver would notice on a walkaround check. Treating a persistent fuel/mileage discrepancy as a prompt to bring a vehicle in for a closer look, rather than assuming it's simply route variation, can catch a maintenance problem meaningfully earlier than waiting for it to become an obvious fault.

Fuel card controls worth having in place

Basic controls make a genuine difference here — restricting a driver's fuel card to their assigned vehicle where practical, requiring the vehicle registration or odometer reading at the point of sale where the system supports it, and reviewing transactions against the expected vehicle and route rather than only checking total spend against budget. None of this needs to be adversarial toward drivers; the great majority of discrepancies have entirely mundane explanations, but a control that would catch the rare genuine problem is worth having regardless.

Reconciliation across a multi-depot fleet

For fleets running from more than one depot, reconciliation is worth doing at both the individual vehicle level and rolled up by depot, since a depot-wide pattern — several vehicles all showing a similar drift — points toward something systemic at that site (a fuel card process issue, a route change affecting the whole depot) rather than an individual vehicle problem, and is worth investigating differently as a result. Treating every discrepancy as an isolated, vehicle-specific issue can miss a depot-level cause that would otherwise be obvious once the numbers are looked at together.

Weighing driver behaviour without jumping to conclusions

It's tempting, when a discrepancy turns up, to assume a specific driver is responsible for misuse, but the honest starting position should be that most discrepancies have entirely mundane explanations — a genuinely different route that week, more time spent idling in traffic, or simply a data entry error somewhere in the chain. Treating every discrepancy as a disciplinary matter from the outset, before checking the more mundane explanations first, tends to damage trust with drivers who are doing nothing wrong far more often than it catches genuine misuse, which is rare by comparison. The investigation should follow the data, not a starting assumption about who's likely to blame.

How this connects to wider fleet KPIs

Fuel efficiency, tracked consistently over time, is one of the more useful fleet-level KPIs precisely because it reflects several underlying factors at once — vehicle condition, driving style, route planning and load weight all show up in the same number, which makes a sustained shift in either direction worth investigating even before it's clear which specific factor is behind it. Fleets that only look at fuel spend as a raw cost line in the accounts, rather than as a compliance and maintenance signal in its own right, are missing one of the more genuinely useful early-warning figures available without any additional equipment or software investment.

Seasonal and weather-related variation

It's worth building some allowance for genuine seasonal variation into how discrepancies are assessed — cold weather increases fuel consumption through longer warm-up periods and heavier auxiliary use, and winter road conditions can mean more idling and lower average speeds across an entire fleet at once. A discrepancy that shows up consistently every winter and resolves every spring is a different pattern to one that's specific to a single vehicle or a single depot, and treating the two the same risks either chasing a non-issue every winter or, worse, missing a genuine vehicle-specific problem because it's assumed to be seasonal when it isn't.

What to actually track

• –Fuel spend against recorded mileage per vehicle, reviewed on a regular cycle rather than only when something looks unusual
• –Efficiency trend over time per vehicle, not just a single period's raw numbers
• –Fuel card transactions checked against the expected vehicle and route
• –Discrepancies rolled up by depot as well as by individual vehicle
• –Odometer reading accuracy, particularly where readings are still logged manually