A fuel retail outlet looks simple: fuel comes in, fuel goes out, money comes in. In practice there are several hand-offs between the depot and the customer, and loss can creep in at each of them. Small daily gaps add up quickly across a network of outlets.
The four numbers that should agree
- Invoiced: what the depot dispatched and billed.
- Received: what actually reached the outlet's tanks.
- Sold: what the nozzles dispensed.
- Collected: what money and card payments came in.
Comparing these every day, for every outlet, is what we mean by four-way reconciliation. Each gap points to a different problem and a different person to talk to.
What each gap usually means
| Gap | Common causes | First action |
|---|---|---|
| Invoiced vs received | Transit theft, short delivery | Check transporter seals and decanting records |
| Received vs sold | Tank leaks, theft from tanks, calibration errors | Review night-time tank level drops and dip readings |
| Sold vs dispensed correctly | Nozzle short-dispensing | Check dispenser calibration |
| Sold vs collected | Cash shortfalls, fleet card misuse | Reconcile deposits and card settlements |
Quality is a loss too
Adulteration doesn't show up as missing litres; it shows up as fuel that isn't what it should be. Monitoring density readings against expected values helps flag tanks that need a sample tested before more fuel is sold from them.
Patterns across outlets matter. A transporter who short-delivers a little at many outlets can stay under every single outlet's tolerance. Looking across the network surfaces patterns no individual outlet would notice.
Making it practical
- Use automatic tank gauge (ATG) data where available rather than manual dips alone.
- Agree tolerances per product and outlet, so normal evaporation and temperature effects don't trigger alerts.
- Give every flag a value in rupees and a specific next step, so area managers know what to do first.
FuelLedger automates this reconciliation for every outlet, every day.