The verdict in three sentences
With manual entry, 3 to 8 % of your mobile money collections end up unreconciled and pollute your books. An automatic pipeline — webhook → journal → reference matching → ERP entry — cuts the closing effort fivefold. The concrete 2026 result in Accra: a monthly close that drops from 10 days to 2 days.
The reconciliation pipeline, step by step
Mobile money reconciliation is not an end-of-month Excel export: it is a continuous flow. Every payment confirmed by Wave, MTN MoMo or Moov triggers a webhook. That webhook feeds a transaction journal, which is then matched against invoices or orders through a unique reference. Once the match is found, the accounting entry is pushed into the ERP.
| Step | Action | Automatable | Time saved |
|---|---|---|---|
| 1. Receipt | Provider webhook | Yes | Real time vs entry |
| 2. Journaling | Timestamped DB insert | Yes | 100 % |
| 3. Matching | Order ref ↔ payment | Yes (95 %) | ÷ 5 effort |
| 4. Exception | Manual handling of misses | No (5 %) | Targeted |
| 5. ERP entry | Accounting document | Yes | 2-day close |
The key metric is the automatic matching rate: with a clean reference injected at checkout, you reach 92 to 97 % reconciliation without intervention. The remaining 3 to 8 % are exceptions (partial amount, duplicate, refund) handled by hand.
Source, format and matching field per provider
Each provider exposes its data differently. Here is how to align them in 2026.
| Provider | Export format | Matching field | VAT to extract |
|---|---|---|---|
| Wave | JSON API + CSV | client_reference | Net line + 18 % |
| MTN MoMo | API + PDF statement | externalId | Rebuilt 18 % |
| Moov Money | Operator CSV | Merchant reference | Net line + 18 % |
| Orange Money | API + portal | order_id | Net line + 18 % |
| Bank transfer | MT940 file | Label + amount | Per invoice |
VAT (18 % across the WAEMU zone, or your local rate) must be extracted or rebuilt for every entry, otherwise the accounting reconciliation is wrong even if the gross total matches.
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
Kofi runs a hardware store in Accra collecting 420 mobile money payments a month, average basket 32,000 FCFA equivalent. Manually, his accountant spent 2 days keying entries and left ~5 % of transactions unreconciled, roughly 672,000 FCFA of blur every month. After automation: 94 % matching, only 25 exceptions handled by hand in 40 minutes, close wrapped in 2 days. The unreconciled blur falls below 1 %, an error risk cut sixfold.
FAQ
How much does setting up automatic reconciliation cost? For an SME collecting a few hundred payments a month, expect a 2026 order of magnitude of 600,000 to 1,500,000 FCFA depending on the number of providers and target ERP. It pays back in 3 to 6 months through saved accounting time.
Do I need to change ERP? No. Most ERPs (Sage, Odoo, or an in-house ledger) accept imports via API or file. We build a connector that pushes entries into your existing tool.
What about payments with no reference? They fall into the exception queue. With a well-designed checkout injecting a unique reference, that volume stays under 5 to 8 %. You can also match by amount + timestamp as a fallback.
Does reconciliation handle refunds? Yes, a refund generates a reverse webhook that creates a reversing entry linked to the original transaction, keeping the balance accurate.
How long to go live? A single-provider pipeline ships in 2 to 3 weeks; multi-provider with ERP, expect 4 to 8 weeks depending on export complexity.
Let's talk about your project. We wire your mobile money to your ERP for a 2-day close, not 10. 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.