A monthly report that reconciles: the five numbers that matter

A monthly report is worth reading when every number in it can be traced to a source system and matched against something outside that system. Five carry most of the decisions in a trading business: revenue invoiced, cash collected, gross margin, stock value and aged receivables; add delivery cost per delivered order if you ship. The report fails less often because a number is bad than because two numbers cannot be reconciled and nobody notices until a supplier or a bank does.

Why these five?

Each answers a different question, and together they cover the whole cycle: did we sell, did we get paid, did we earn, what is sitting in the warehouse, and what is still owed to us.

Drop any one and the picture distorts. Revenue without collection looks like a good month while the bank balance falls. Collection without margin looks like cash discipline while each order loses money. Margin without stock value hides the cash that walked into the warehouse and stayed there. Stock value without receivables hides the goods you sold on credit to customers who are not paying.

Where does each number come from?

One owning system per number. Where two systems could both answer, choose one and make the other reconcile to it.

Number	Owning system	Reconciles against
Revenue invoiced	Invoicing or ERP	Ledger revenue
Cash collected	Bank plus cash book	Bank statement
Gross margin	Invoicing and stock cost	Stock movements
Stock value	Stock system	Physical count
Aged receivables	Ledger	Receivable balance
Delivery cost per order	Courier statements	Delivered orders

Which check catches a wrong month?

One check per number, each against an independent record.

Revenue invoiced must equal ledger revenue to the dinar. A difference is usually a credit note posted into the following month, an invoice left in draft, or a delivery billed in one system and cancelled in the other.

Cash collected is matched to the bank statement, and cash to a counted, signed sheet. A gap here is a timing difference or a receipt nobody banked; the second is the one that matters.

Gross margin is revenue minus the cost of goods taken from stock movements. If margin jumps without a price change, look for cost prices that were never updated after a supplier increase, or a movement posted twice.

Stock value is quantity at period end multiplied by cost, compared against a physical count of a sample — the fast-moving lines, not the tidy ones. A large difference is a movement nobody recorded, and it will reappear as a margin error next month.

Aged receivables must total the ledger receivable balance exactly. A name in the wrong age bucket is not an accounting error, but it produces the wrong collection plan, which costs cash.

Delivery cost per delivered order comes from courier statements divided by delivered orders. If it moves, check returns first: a returned parcel is often billed in both directions, and the cost lands in a month with no revenue beside it.

What does the close look like?

1. Cut the period: note the last invoice number and the last receipt number included.
2. Post everything dated inside the month, credit notes included.
3. Reconcile the bank account and the cash box, and keep the reconciling items in a list.
4. Value stock from movements at period end, and count a sample.
5. Produce the five numbers, each with its source system shown on the page.
6. Run the checks above and write down every difference with its explanation.
7. Compare each number with last month and with the same month a year earlier, in one paragraph of plain language.
8. Sign: preparer and approver, with a date.

The close is a routine with a fixed order, not a task that begins when someone remembers. If it takes four days, that is a fact about the data, not about diligence.

Who signs it?

Two names. The preparer is whoever keeps the books — a bookkeeper, an accountant, or in a small business the owner. The approver is whoever can explain each line to a bank, a supplier or a partner: usually the owner or the general manager.

Signing means "I can explain every difference", not "the total looks plausible". That is why the differences are written down next to the numbers rather than resolved silently. A report signed by one person who both prepared and approved it is a draft with a date on it.

Where this goes wrong

The permanent override. A number never matches, so somebody types the right figure over it each month. Within a quarter nobody knows which cells are calculated, and the report has become an opinion.

A screenshot of the ERP. Exporting a system report and calling it a monthly report skips the reconciliation, which is the only part that catches errors. It is a printout, and it will be trusted until the first wrong month.

Cut-off errors. An invoice dated the 30th for goods delivered on the 2nd puts revenue in one month and cost in another. Margin then swings for reasons that have nothing to do with trading, and the discussion is about the chart instead of the business.

Returns and discounts in the wrong period. A credit note issued in the following month for last month's sales flatters a bad month and penalises a good one.

The number nobody may question. When the owner supplies a figure personally, no one checks it, and an error survives for a year because questioning it is a social risk.

A definition changed mid-year. The margin definition is improved in June and history is not restated, so every comparison across the year is wrong in a way that is invisible.

What this does not cover

This is not accounting or tax advice, and it is not a full profit and loss, a balance sheet or a cash-flow statement; it is the small set of numbers that tells you whether the month traded as intended. It assumes a single currency: multi-currency operations add a rate decision that must be written down, or the margin comparison is meaningless. It also does not cover group consolidation across several legal entities, which needs its own rules about inter-company sales.

We build the report from the source systems and the checks that make it reconcilable, so the month closes with a signature rather than an argument.