Fuel Economy in a Fleet App: Which Refills Belong to the Distance You Are Comparing?
A fuel purchase is not automatically a fuel-consumption measurement. For a useful vehicle economy figure, your app needs a defined driving interval and the fuel quantity associated with that interval. Commission that relationship before commissioning a league table of your vehicles.
The practical decision is whether the records support a calculation at all. A missing starting point should produce an incomplete measurement, not a reassuring efficiency score. This guide concerns liquid-fuel measurement records, not electric-vehicle efficiency, tax evidence or a diagnosis of vehicle condition.
Start with a measurement boundary
The official FuelEconomy.gov odometer method begins with a completely filled tank and an odometer reading. At the next complete refill, it records the new reading and the gallons needed to refill. Distance is the difference between readings; miles divided by gallons gives MPG for that driving period.
That distinction matters in an app brief. The opening fill establishes the starting condition. Its purchased quantity is not automatically the denominator for the driving that follows. A system that simply groups receipts and mileage by calendar month can combine quantities and distances with different boundaries.
Ask the developer to show which opening observation, closing observation and fuel records support each displayed result. Staff should be able to inspect that relationship without reconstructing it from a monthly receipt folder.
What happens when a driver only partly fills the tank?
Agree an explicit policy before launch. The cited method describes complete refills at the measurement boundaries; it does not establish that every isolated partial-fill receipt is a complete measurement.
For a first version, you might let staff record partial purchases but withhold an interval result until the records have been reviewed. If a later version combines purchases between complete-fill boundaries, specify exactly which quantities are included and have the calculation checked. Do not silently discard an intervening receipt, and do not label an unreviewed calculation as the official method.
A missed receipt, an uncertain fill status or fuel bought for a different vehicle needs an exception state. Let the reviewer resolve the evidence or exclude the interval with a reason. Neither a blank quantity nor a missing receipt means no fuel was used.
Keep volume, money and units separate
An amount paid is useful for spending reports, but it is not the purchased volume. Store the quantity and its unit independently of the receipt total. Make the vehicle and measurement units visible at entry and in the resulting report.
If your operation uses a different distance or volume convention from the source's miles and gallons, agree the formula and unit definitions explicitly. Do not merely relabel the result as another economy measure. A mixed-unit import deserves a reviewed conversion, not a hidden assumption.
Keep the original observation available when a value is corrected. Recheck affected intervals after a changed reading or quantity. An odometer replacement or an unexplained backwards reading should interrupt automatic calculation until someone resolves the history.
Compare like records, not just confident numbers
Show the measurement period and whether its evidence is complete beside the result. A vehicle with an incomplete interval should not win a comparison because the app treated its missing fuel as zero.
Even a correctly calculated interval does not establish why economy changed. Different journeys, operating conditions and uses can make a simplistic driver ranking misleading. Decide whether the report supports a maintenance conversation, a spending review or operational planning; do not turn it into an automatic finding of fault.
These are proposed reporting safeguards, not controls certified by the source. Ask for an explainable calculation and review process rather than a promise that the dashboard will identify inefficient staff.
What should the acceptance demonstration include?
Use fictional records in your acceptance criteria. Demonstrate a complete-fill pair, an intervening partial purchase, a missing receipt, a wrongly assigned vehicle and a corrected historical reading. Inspect both the displayed result and the records included in it.
Then import an incompatible unit and an interval without a trustworthy starting observation. The app should expose the uncertainty instead of producing a plausible-looking number. Bring a blank fuel log and your review responsibilities to a workflow-app discussion. Those decisions are a stronger starting point than a dashboard mockup alone.