Reconciling mobile money collections with your books (2026)

The verdict in three sentences

Mobile money reconciliation fails because three numbers never line up on their own: the amount the customer paid, the amount paid into your account (after fees) and the amount recorded in your books. The method comes down to three columns to match: reference, amount, date. A merchant who automates this reconciliation typically recovers several hours per week and eliminates most unexplained gaps.

Why gaps appear

Payouts are not a mirror of your sales. Fees are deducted at source, some operators pay out on a delay or in batches, and references differ across channels. The result: your statement never looks like your cash log.

This accumulation produces the 10 to 20% gaps seen among merchants who reconcile by hand.

The 4-step reconciliation method

• Export the transaction CSV from each channel (Wave, OM, aggregator) over the same period. 2. Normalize: one row = one transaction, with reference, gross amount, fee, net amount, date. 3. Match each collection to its corresponding sale in the books (key = reference, fallback amount + date). 4. Handle exceptions: anything that doesn't match goes into a to-justify list (fees, refund, duplicate).

Moving from a spreadsheet to dedicated software pays off once you exceed roughly 500 transactions per month: the time saved covers the subscription several times over.

Mini case study

Ibrahim, a restaurateur in Abidjan, processes 1,200 transactions/month for revenue of 9,000,000 FCFA. Reconciling by hand, he spent 8 hours/month and still kept a 2 to 3% unexplained gap, up to 270,000 FCFA he couldn't trace. He switches to software at 15,000 FCFA/month. Reconciliation drops to 45 minutes/month, and the tool reveals that most of the gap came from fees at source (1.5% on average, about 135,000 FCFA) and two double notifications. Annual tool cost: 180,000 FCFA, for finally accurate books and 7 hours saved every month.

FAQ

Why is the paid-out amount lower than what the customer paid? Because merchant fees (order of magnitude 1% to 1.8% in 2026) are deducted at source. You must record the gross amount as a sale and the fee as an expense, or your books will never balance.

Can a batched payout be itemized? Yes: each operator provides an export or statement detailed per transaction. That CSV, not the batched payout line, is the basis for reconciliation.

At what volume do I need software? Generally from 500 transactions/month. Below that, a spreadsheet with a VLOOKUP is enough. Above it, manual time costs more than the subscription.

How do I avoid counting a sale twice? By checking for double webhook notifications and using the transaction reference as a unique key. The same ID must never create two cash entries.

How long should I keep exports? At least the applicable legal accounting retention period (often several years). Keep the raw CSVs: they are your evidence in a dispute or audit.

Let's talk about your project. We connect your Wave and Orange Money collections to an automatic reconciliation dashboard. WhatsApp +221 77 596 93 33.