The verdict in three sentences
An SME collecting across multiple wallets (M-Pesa, Airtel Money, MTN MoMo) sees 2 to 4% of transactions stay unreconciled without tooling. Reliable reconciliation crosses three keys: reference + amount + timestamp, plus fee and settlement-delay tracking. Automated, it drops the error rate from 6% (manual entry) to 0.5%.
Why multi-wallet complicates everything
Each wallet has its own CSV export, reference format, fees and settlement delay. A single customer payment of KSh 2,000 may appear as KSh 1,980 at T+1 on M-Pesa (after ~1% fee) and at T+2 on Airtel Money. Without normalization, accounting sees gaps and the team spends hours figuring out "who paid what".
| Wallet | Export format | Settlement delay | Collection fee | Typical gap |
|---|---|---|---|---|
| M-Pesa | timestamped CSV | Same day/T+1 | ~1-1.5% | 1-1.5% |
| Airtel Money | CSV / statement | T+2 | ~1.5% | 1.5% |
| MTN MoMo | CSV / API | T+1 to T+3 | ~1.5-2% | 1.5-2% |
| Stripe | detailed CSV | T+2 to T+7 | 2.9% + fixed | 3%+ |
| Bank transfer | statement | T+1 to T+3 | flat fee | varies |
A concrete reconciliation model
The winning process is monthly and systematic: export each wallet, normalize columns, auto-match by composite key, then handle exceptions manually. The "fee" column must be isolated so gross revenue stays correct and VAT is computed on the right amount.
| Step | Action | Matching key | Error rate |
|---|---|---|---|
| 1. Export | CSV of each wallet | — | — |
| 2. Normalize | Unified columns | ref, amount, date | — |
| 3. Auto-match | Orders ↔ collections | ref + amount + timestamp | 0.5% |
| 4. Fees | Isolate fee line | net vs gross | — |
| 5. Exceptions | Handle gaps > 1% | manual review | residual |
| 6. Bookkeeping | Entry + VAT | gross amount | — |
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Wanjiru, owner of a cosmetics shop in Nakuru, collected on M-Pesa and Airtel Money: 450 transactions/month for KSh 1,200,000. On manual reconciliation, about 3% (14 transactions) stayed unidentified monthly and entry error hit 6%. Moving to automated matching by reference + amount + timestamp, unreconciled fell below 0.5% and she saved about 8 hours/month, roughly KSh 20,000 of time, while making her VAT reliable.
FAQ
Why does the collected amount differ from the invoiced amount? Because collection fees (1-2%) are deducted before payout. Isolate the fee line so gross revenue and VAT stay computed on the right amount.
Which matching key should I use? The combination reference + amount + timestamp is most robust. Reference alone fails when it's missing or truncated in a wallet's export.
How often should I reconcile? A systematic monthly reconciliation suffices for an SME, with a weekly check on large amounts. Waiting for the quarter multiplies hard-to-trace exceptions.
How do I handle different settlement delays? Reconcile on transaction date, not payout date. M-Pesa pays around T+1, Airtel Money T+2: without that distinction you wrongly think payments are missing at month-end.
Do I need dedicated software? A tooled spreadsheet works under 300 transactions/month. Beyond that, an automated reconciliation module lowers error to 0.5% and frees several hours monthly.
Let's talk about your project. We tool your multi-wallet reconciliation for reliable cash flow and VAT. 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.
