"I sold 10,000 litres, but 10,150 left the tank." Almost every station manager has lived that gap. Reconciling means comparing, period by period, three figures that should tell the same story: what dropped in the tanks, what the pumps registered, and what was sold and collected.
The reconciliation equation
For each product and a period (a shift, a day, a month):
Opening stock + receipts − closing stock = litres that left the tank
That figure is compared with the litres dispensed (pump totalizers) and the litres sold recorded at the point of sale. If all three agree within a reasonable tolerance, the operation is under control.
The same logic underlies the volumetric balance that the Ministry of Mines and Energy defines in Resolution 31348 of 2015: an equation to determine a product's movements and stocks from the actual receipts and deliveries of a period.
The most common causes of a gap
- Level measurement: misread dipstick, badly timed reading or an outdated calibration chart.
- Temperature: fuel expands and contracts; the same product takes up different volume at different temperatures.
- Receipts: the volume invoiced by the supplier is not the volume actually delivered.
- Pumps: calibration out of range or misread totalizers.
- Unrecorded or mis-recorded sales: test dispenses, own consumption, credit sales without a ticket.
- Period cut-offs: stock is measured at 6:00 but sales close at 6:30.
- Real losses: spills, leaks or theft.
Before suspecting a person, rule out the first six.
How to reconcile without spreadsheets
- Measure tanks automatically, using the same time cut-off as the shift close.
- Record each receipt with its time and volume.
- Take pump totalizers when opening and closing each shift.
- Compare the three figures by product and keep the difference visible.
- Look at the trend: a constant gap points to calibration; one that appears only on certain shifts points to processes or people.
Doing this by hand every day is possible, but it takes hours and arrives late. Doing it automatically lets you see the gap when the shift closes.
How Orbion solves it
The platform joins the two halves: Orbion Tank provides tank measurement (level, water, temperature, detected deliveries and history), and Orbion Fuel Control records sales by dispenser, product, operator and shift, with the shift close reconciled against totalizers. The optional Kardex module is designed to reconcile inventory against sales history. Check each piece's scope for your station in the demo.
Frequently asked questions
What fuel difference is normal?
There is no universal figure we can state here. It depends on your product, climate and equipment. What is useful is tracking the difference over time: if stable, it is method; if growing, something changed.
Does temperature really matter?
Yes. Fuel volume varies with temperature, which is why serious measurements record each tank's temperature.
How often should I reconcile?
Ideally at each shift close by product, and consolidated at day end and month end (the month close supports your SICOM volumetric balance).
What do I need to get started?
Reliable tank measurement, pump totalizers and sales recorded by shift.
Does reconciliation help with the SICOM report?
It is the basis of the monthly volumetric balance; the report itself is registered in SICOM as the rule requires (see SICOM).
Take the next step
Request a demo and review with us how reconciliation would look at your station.