Reconciling mobile money statements: why the numbers never quite match your books
At the end of the month, the total on your Airtel Money or MTN MoMo statement almost never matches what your sales book says you took in. The gap is rarely fraud or a stolen till — it's usually a mismatch between what the statement actually records and what got written down at the time of sale, plus a handful of timing quirks that only show up once you sit down to compare the two side by side.
A mobile money statement lists individual transactions, each with its own reference number, timestamp, and the net amount that hit your float — not always the same figure the customer handed over. Certain transaction types carry a small fee or commission that's deducted before your balance updates, so a K500 sale can land as a slightly different number in the statement. If your books record the price you charged rather than the amount tied to that specific transaction reference, the two totals drift apart a little more with every sale, and by month-end nobody can say exactly where the gap came from.
The bigger mismatches usually come from three places. Timing is the most common: a sale made late on the last night of the month can settle into your float, or appear on the statement export, a day later than the sale itself, so it lands in the wrong month on one side of the comparison. Running two lines — a shop-counter Airtel Money till alongside an MTN MoMo agent number, say — and only reconciling one against the books is the second. And refunds sent back to a customer as a separate transfer, rather than logged against the original sale, show up on the statement as an unexplained debit with nothing in the books to match it to.
We build reconciliation into the POS, invoicing, and payroll systems we set up, so every sale is tied to its mobile money transaction reference the moment it happens, not guessed at when the statement finally comes in weeks later. If reconciling your books still means comparing two totals and hoping they're close enough, that's worth fixing before it's the difference you can't account for at tax time.