The verdict in three sentences
Without rigorous reconciliation, an SME lets 3 to 8 % of mobile money revenue slip away in duplicates, timeouts and source-deducted fees never re-booked. Switching from manual Excel reconciliation (6 to 12h/month) to an automated webhook + API export flow brings time under 30 minutes and the target gap under 0,5 %. Reconciliation is not accounting drudgery: it is a direct lever on treasury and audit readiness.
Where do the gaps come from?
A reconciliation gap appears whenever what the customer paid differs from what lands in your account, or from what your system recorded. Four causes concentrate most of the loss.
| Gap cause | Typical frequency | Impact | Fix |
|---|---|---|---|
| Source-deducted fees | Systematic | 1 to 2 % of revenue | Re-book as expense |
| Timeout (pending payment) | 2 to 5 % of tx | Cash locked | Check status T+1 |
| Duplicate (double debit) | 0,3 to 1 % | Refund owed | Detect by reference |
| Un-notified (missed webhook) | 1 to 3 % | Phantom revenue | Replay the webhook |
Source-deducted fees are the sneakiest gap: the customer pays 50 000, you receive 49 250, and without re-booking your accounts show a permanent shortfall.
Manual vs automated: the true cost
Manual Excel reconciliation looks free, but it costs time, errors and locked cash. Here is the comparison for an SME collecting 300 transactions/month.
| Criterion | Manual (Excel) | Automated (webhook + API) |
|---|---|---|
| Time/month | 6 to 12h | < 30 min |
| Residual gap rate | 2 to 4 % | < 0,5 % |
| Duplicate detection | Random | Automatic by reference |
| Cadence | Weekly or monthly | T+1 (daily) |
| Cost of error | High | Low |
At 300 transactions, automation pays for itself in one to two months through saved accounting time alone, before even counting recovered gaps.
Mapping the provider statement to the ledger
The key to clean reconciliation is a stable mapping between each provider statement line and a ledger entry. Every transaction breaks into gross amount, fee and net.
| Provider statement line | Ledger entry | Typical amount (on 50 000) |
|---|---|---|
| Gross amount collected | Revenue / sale | 50 000 |
| Fee deducted | Expense / commission | 750 |
| Net settled | Bank / merchant account | 49 250 |
| Refund | Sale reversal | case by case |
| VAT collected | VAT account | per regime |
Applied automatically to each webhook, this mapping ensures gross, fee and net always land in the right accounts, with VAT and withholdings correctly isolated.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Fatou runs an online grocery in Accra collecting 6 000 000/month across 400 mobile money transactions. Manually, she reconciles once a month and estimates a 3 % residual gap, i.e. 180 000/month of unrecovered revenue plus 10h of her time. Moving to automated T+1 reconciliation (webhook + API export), her gap drops to 0,4 % (24 000) and her time to 30 min. Monthly gain: 156 000 recovered + 9,5h freed, over 1 870 000/year of secured revenue.
FAQ
What gap rate is acceptable in 2026?
Aim below 0,5 % of mobile money revenue. Above 1 %, your process is leaking: look first at un-rebooked fees and never-rechecked timeouts.
How often should I reconcile?
Automated, a T+1 (daily) cadence is ideal: you catch a duplicate or timeout the next day, while the evidence is fresh. Manually, never go below weekly.
How do I handle source-deducted fees?
Re-book them systematically as a commission expense, line by line. Otherwise your booked revenue is understated by 1 to 2 % every month.
Is the webhook enough, or do I need the API export?
Both: the webhook captures each payment in real time, the API export is a daily safety net to replay missed webhooks. Together they bring the gap under 0,5 %.
What about timed-out payments?
Check their final status at T+1 via the API: many resolve (the customer did pay) and must be booked, others should be cleanly cancelled so they don't inflate phantom revenue.
Let's talk about your project. We automate your mobile money reconciliation via webhook and API export, with an audit-ready accounting mapping. 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.
