The premise: month-end is review, not reconstruction
Most outlets produce their monthly sheet by sitting down with a stack of notebooks and rebuilding, from primary records, a summary that could have been derived automatically had those records been entered anywhere else.
The cost is not only the evening. It is that the reconstruction happens once, at the end, when nothing found is still correctable. A reading that was wrong on the 8th is now a figure inside a total, and the shift that produced it finished three weeks ago.
This checklist assumes the days already reconcile. If they do not, the first item is the only item.
1. Stock, tank by tank
Not a monthly variance — the series of daily ones. A month collapses thirty days of signal into one number that evaporation, drift, mis-metering or a leak could all have produced.
- Plot the daily variance per tank across the month. You are looking at the shape, not the total — see stock and dip reconciliation for what each shape means.
- A trend that is negative and growing regardless of throughput warrants a tightness test, whatever the monthly total says.
- Reconcile every delivery against its invoice, corrected to 15 °C. A summer shortage is very often temperature rather than loss.
- Confirm opening stock on the 1st equals the closing dip on the last day of the previous month. A break here means someone carried book stock forward.
2. Receivables, aged
Credit is the largest working-capital item at most outlets and the least visible, because it lives in a ledger that nobody reconciles against anything.
- Age the outstanding balances: current, 30, 60, 90+ days. The free credit ledger template does the buckets for you.
- Reconcile the ledger against credit sales recorded in the daily sheets. A gap means a credit sale was recorded as cash somewhere, or a settlement was banked without being posted.
- Anything beyond 90 days is a decision, not a balance. Deciding not to decide is how a receivable becomes a bad debt.
3. Payment channels against their settlements
Cash is checked daily by counting it. The other four are only checkable against a statement that arrives on someone else's schedule.
| Channel | Reconcile against | What a gap usually is |
|---|---|---|
| UPI | Settlement statement | Transactions that showed success and later failed |
| Card | Acquirer statement | Settlement charges, or a batch not settled |
| Fleet card | Issuer statement | Timing, or a transaction rejected after authorisation |
| Credit | Customer ledger | A sale posted to the wrong account |
What each channel is reconciled against at month-end.
4. Expenses and the drawer
Total the month's drawer payouts and check them against what you would expect to spend. This is the one line where the daily reconciliation cannot help you, because a payout that was recorded balances the day whether or not it should have happened.
- Group by category — maintenance, utilities, staff, statutory, other. The full expense list has the categories, and what your accountant needs is a separate, shorter set.
- Compare against the previous two months. A category that has quietly doubled is the finding.
- Confirm every payout above a threshold you set has a document behind it.
5. The reports to produce
Five reports cover the month for every audience that asks: the owner, the accountant and yourself.
- Monthly sales — litres and value, by fuel type, with the daily series intact underneath.
- Stock summary — per tank, with the daily variance series.
- Collections summary — by payment channel, against expected revenue.
- Receivables ageing.
- Expense summary by category.
Keep the daily series in the monthly report
A monthly report that shows only totals throws away the one thing the month is good for. Almost every finding worth having — a leak, a drifting nozzle, a shift with a habit — is visible in the shape of the daily numbers and invisible in their sum.
Frequently asked questions
How long should month-end take?
An hour or two if the days reconcile, and an entire evening if they do not. The difference is not effort at month-end — it is whether the work was done thirty times in ten-minute pieces or once in a single sitting from primary records.
What does my accountant actually need?
Usually sales by fuel type with values, purchases with invoices, collections by channel, expenses by category, and closing stock per tank. Everything else is yours. Export it in a spreadsheet rather than a PDF — they will need to work in it, and a PDF becomes a retyping exercise.
Should closing stock be valued at purchase cost?
That is a question for your accountant and it depends on the valuation basis you use consistently. What matters operationally is that the closing quantity is a measured dip and not a book figure, whatever it is later valued at.