The two adjustments everybody forgets
Collections rarely equal expected revenue on the nose, and two of the reasons are pure bookkeeping rather than anything wrong.
Money paid out of the drawer during the shift — a delivery charge, a repair, tea for the crew — was collected and then spent. It has to be added back, or the drawer looks short by exactly the amount that legitimately left it. And the opening float handed over at the start was never a sale, so counting it in the closing drawer makes every shift look over by the same amount every day.
Once both are handled, what remains is a difference that means something.
Why the five payment types stay separate
Each way of getting paid fails differently, and pooling them into one 'collections' figure throws away the only information that would tell you which one broke.
- Cash walks, and it is the only type where a shortfall might be a person rather than a process.
- UPI shows a success screen on transactions that later fail — the customer leaves believing they paid, and they did not.
- Cards settle a day or two later, net of charges. Log the amount charged to the customer and record the charge as an expense; netting it off understates revenue.
- Fleet cards reconcile against a statement that arrives on its own schedule, not yours.
- Credit is not a collection at all today. The fuel left, the sale is real, and the money arrives at month-end.
The window in which an explanation still exists
A shortfall found at the close of the evening shift belongs to a named person who is still on the premises and can usually explain it in a sentence — a credit sale not written up, a UPI payment waved through, a note taken for change and not replaced.
The same figure found at month-end belongs to nobody. The shift finished three weeks ago, the people who ran it have worked twenty more since, and the honest answer to what happened is that nobody knows. Nothing about this is about blame; it is about the window in which the answer is still recoverable.
Frequently asked questions
Should credit sales count as collections?
For this reconciliation, yes — the fuel left the tank and the sale is real, so it has to appear on the collections side or the shift will always look short by the value of its credit business. Whether the money has arrived is a separate question, tracked as a receivable.
The rate changed during the shift. How do I compute expected revenue?
Split the litres at the changeover and value each block at the rate that applied to it. Applying one blended rate to the whole shift produces an expected figure that was never going to match, and then an evening spent looking for a shortfall that is really an averaging error.
What counts as a normal difference?
Small and both-directional. A shift that is over as often as it is short by a few rupees is rounding and change-making. A shift that is short slightly more often than not, month after month, is a process problem — usually credit sales or UPI failures rather than anything dramatic.