The equation
Every daily cash reconciliation at a fuel outlet reduces to one comparison between two numbers that were produced by completely different means.
Expected revenue comes from the meters: litres sold per fuel type, multiplied by the rate that applied to them. Collected revenue comes from the drawer and the terminals: cash, UPI, card, fleet and credit, adjusted for money paid out and for the float.
The comparison works precisely because neither side was derived from the other. The moment someone types a collections figure to match expected revenue, the check has stopped checking anything.
Written out
Litres × rate = expected. Cash + UPI + card + fleet + credit = collected. Collected + drawer expenses − opening float = accounted for. Accounted for − expected = the difference you investigate.
The two adjustments most pumps forget
Collections rarely equal expected revenue exactly, and two of the reasons are pure bookkeeping rather than anything being wrong.
First, money paid out of the drawer during the shift — a delivery charge, a repair, tea for the crew — was collected and then spent. It must be added back, or the drawer looks short by precisely the amount that legitimately left it, every single day.
Second, the opening float handed over at the start was never a sale. Counting it in the closing drawer makes every shift look over by the same figure, which quickly trains everyone to ignore the number entirely.
Handle both and what remains is a difference that means something.
Keep the five channels apart
Pooling collections into a single figure discards the only information that would tell you which channel broke on a day the drawer is short. Each of the five fails in a characteristic way.
| Channel | How it fails | Symptom |
|---|---|---|
| Cash | Short-changed, taken, or not banked | Shortfall on the cash line only |
| UPI | Success screen on a transaction that later fails | Collected figure exceeds what settled |
| Card | Settles later, net of charges | Looks short if the charge is netted off |
| Fleet card | Reconciles against a statement on its own schedule | Timing gap, not a loss |
| Credit | Fuel left today, money arrives at month-end | Shortfall if credit is not counted as a sale |
How each payment channel goes wrong, and what it looks like on the sheet.
Credit is a sale today and a receivable tomorrow
This is where most pumps keep a second set of records, and a second set of records is where reconciliation goes to die. A transport operator fills up on Tuesday, the fuel genuinely leaves the tank, and no money arrives until the account is settled.
Recorded properly, that is revenue on Tuesday and a receivable until it is paid — and Tuesday still balances. Recorded as a note in a diary, it is a hole in Tuesday's cash that somebody has to remember the reason for, and it will be found again at month-end as an unexplained shortfall.
Credit therefore has to be tracked twice: once as a payment type so the day reconciles, and once on the receivables ledger so you know what is outstanding.
The routine, at the close of every shift
Ten minutes, in this order. Doing it out of order means going back, because each step consumes the previous one.
- Close the meter readings on every nozzle. A nozzle with no closing reading makes the rest of the exercise meaningless.
- Compute expected revenue per fuel type at the rate that applied. Split the litres if the rate changed.
- Count the drawer. Physically, before looking at what it should be — knowing the target first is how a count becomes a confirmation. The shift cash calculator does the comparison once you have both sides.
- Total the terminals: UPI, card, fleet.
- Add credit sales for the shift.
- Add back drawer expenses; subtract the opening float.
- Compare. Anything beyond rounding gets a name and a reason before the shift leaves.
Count first, compare second
Someone who knows the expected figure before they count is not counting — they are checking. The order costs nothing and is the difference between a control and a formality.
What a persistent gap is telling you
A single short shift is noise. A pattern is a process problem, and the direction and consistency point at which one.
- Short and over about equally, by small amounts — rounding and change-making. Normal.
- Short slightly more often than not, month after month — usually credit sales not being written up, or UPI failures being waved through.
- Short on one shift consistently — a person or a habit specific to that shift.
- Over consistently — the float is being double-counted, or expenses are being recorded that were not actually paid out.
- Large and sporadic — a rate change applied to the wrong block of litres. Check the days against price revisions.
Frequently asked questions
How much daily variance is normal at a petrol pump?
Small and both-directional. What matters more than the size is the symmetry: a pump that is over as often as it is short is making change imperfectly, which is unavoidable. A pump that is short slightly more often than not, consistently, has a process problem — and the most common one is credit sales being recorded late rather than anything dishonest.
Should card settlement charges be netted off the collection?
No. Log the collection at the amount charged to the customer and record the settlement charge as an expense when it lands. Netting it off makes the day appear to balance while quietly understating both revenue and costs, and it hides the charge from anyone reviewing what the outlet actually spends.
What if I only reconcile monthly?
Then every difference you find belongs to nobody. The shifts finished weeks ago and the people who ran them have worked twenty more since. Monthly reconciliation tells you that money is missing; it almost never tells you where it went, which makes it a report rather than a control.
Does UPI need separate reconciliation against the bank?
Yes, and it is worth doing weekly. A UPI payment that showed success at the pump and later failed is invisible in your own records — the customer left believing they had paid, and so did your operator. Only the settlement statement reveals it.