The verdict in three sentences
Mobile money collects fast, but the bank credits on a delay: the aggregator wires you the net 3 to 7 days later, once a cash-out fee of 1 to 2 % is deducted. Without an export and mapping method, an Accra merchant never manages to explain why the bank statement doesn't match the sales. The goal: an unexplained gap under 0.5 % through rigorous CSV matching.
Three levels to reconcile
Reconciliation is not "sales vs bank". There are three tiers, and the gap hides between them.
| Level | Source | What you read |
|---|---|---|
| Transactions | Your system | Confirmed gross sales |
| Operator settlement | MTN / AirtelTigo CSV | Net after merchant commission |
| Bank statement | Bank | Aggregated aggregator payout |
Between operator settlement and the bank wire sits the aggregator, which deducts its cash-out fee and bundles several days into one wire. That is where most "unexplained gaps" are born.
Reference figures and method
| Parameter | 2026 order of magnitude | Note |
|---|---|---|
| Cash-out fee | 1-2 % | Deducted at source |
| Aggregator wire delay | 3-7 days | Bundles several days |
| Target unexplained gap | < 0.5 % | After analysis |
| Typical SME volume | GHS 40,000-200,000/month | Depending on activity |
| Reconciliation frequency | Weekly | Avoids pile-up |
The method is four moves: export the operator CSV and bank statement to the same format, map cryptic bank labels (e.g. "AGGREG PAYOUT 0412") to a sales period, sum the expected nets, then isolate each unmatched line. Weekly reconciliation saves you from untangling three months of gaps at once.
Mini case study
Kwame runs a hardware store in Accra with GHS 120,000 of mobile money sales in March. His bank statement shows only GHS 116,400 credited. He panics: GHS 3,600 missing.
Applying matching: cash-out fee 1.5 % = GHS 1,800 (legitimate), plus GHS 1,200 from a late-March MTN wire that landed April 3 (T+5 shift, out of period). That leaves GHS 600 of real gap, i.e. 0.5 %, which he pins down: a one-day truncated AirtelTigo CSV. He claims it, the aggregator regularizes. Without a method, he would have booked the full GHS 3,600 as a loss.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Why is my bank wire lower than my sales?
Because the aggregator deducts a cash-out fee of 1 to 2 % before wiring, and bundles several days into one movement. A Tuesday wire may cover Friday-to-Monday sales, hence the apparent gap.
How do I map unreadable bank labels?
Build a lookup table between the label (e.g. "PAYOUT AGGREG 0412") and the relevant sales period, based on amount and date. Once the mapping is set, it reuses every month.
How often should I reconcile?
Weekly rather than monthly: a gap caught in time resolves with one call, while three months piled up become impossible to untangle. A typical SME volume of GHS 40,000-200,000/month takes under an hour weekly.
What residual gap is acceptable?
After analysis, target an unexplained gap under 0.5 % of volume. Beyond that, there is a truncated CSV, a misconfigured commission, or a late aggregator wire to claim.
Do I need accounting software for this?
A structured spreadsheet is enough to start, but past GHS 200,000/month a tool that imports CSVs and matches automatically saves hours. The essential is the discipline of merchant_ref and mapping, not the tool.
Let's talk about your project. We automate the import of your operator CSVs and bank statements with reconciliation targeting a gap under 0.5 %. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
