The verdict in three sentences
Manual Excel reconciliation for a high-volume store eats 10 to 20 hours a month and lets 3 to 8 % of discrepancies slip through (missed fees, duplicates, failures counted as successes). An automatic API-based reconciliation module continuously compares orders, PSP collections and bank payouts, flagging gaps in real time. Past 500 orders per month, automation pays for itself in under two months.
Manual vs automatic: the real cost
Reconciliation means verifying that every order was actually paid, that the collected amount matches the cart, and that the PSP payout to your account lands at the right value after fees. Done by hand, it is slow and error-prone.
| Criterion (2026 estimate) | Manual reconciliation | Automatic reconciliation |
|---|---|---|
| Time per month (500+ orders) | 10 to 20 h | 1 to 2 h of review |
| Error rate | 3 to 8 % | < 0.5 % |
| Duplicate detection | Random | Immediate |
| PSP fee gaps caught | Rarely | Systematically |
| Monthly close delay | 3 to 5 days | < 1 day |
| Monthly cost | Internal time | 15,000 to 40,000 FCFA |
The true cost of manual work is not zero: 15 hours at a loaded hourly cost of 3,000 FCFA already means 45,000 FCFA per month of tied-up time, before counting losses on undetected gaps.
The discrepancies automation catches
A reconciliation engine matches three flows: the order (your database), the PSP transaction (Wave, Orange Money) and the settlement (payout) to your account. Every unmatched line becomes an alert.
| Discrepancy type | Typical frequency | Impact if undetected |
|---|---|---|
| PSP fees not deducted from forecast | Very frequent | Margin overstated by 1 to 1.9 % |
| Duplicate collection | Occasional | Customer dispute, refund |
| Failed payment marked paid | Frequent | Shipped order never paid |
| Partial PSP payout | Occasional | Cash flow hole |
| Unrecorded refund | Frequent | Skewed books, wrong VAT |
Mini case study
Awa runs a cosmetics store in Dakar: 620 orders a month, average basket 18,000 FCFA. Manually she spent 16 h/month and estimated 5 % uncorrected gaps, about 45 mistracked orders. Of those 45, 6 shipped orders had never been paid (failure marked paid): a direct loss of 6 × 18,000 = 108,000 FCFA. With a 30,000 FCFA/month module she recovers 14 h and nearly eliminates these leaks. Net benefit in month one: over 100,000 FCFA.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Does automatic reconciliation work with Wave and Orange Money?
Yes, as soon as the PSP exposes an API or a transaction export. The module pulls real statuses (success, failure, refunded) and matches them to your orders, eliminating the 3-8 % errors of manual checking.
At what volume is it worthwhile?
From 300 to 500 orders per month. Below that, a tidy weekly export is enough. Above it, the time saved (10-20 h) quickly exceeds the module cost (15,000 to 40,000 FCFA).
What do I do with detected gaps?
The module classifies them: fees, duplicates, failures, refunds. You handle only the exceptions, 1-2 h of review instead of checking everything by hand.
Can I connect this to my accounting?
Yes: most modules export to CSV or FEC, ready for Sage, Odoo or your accountant, cutting the monthly close from 3-5 days to under a day.
Let's talk about your project. We plug an automatic reconciliation module into your store to kill discrepancies and the Excel chore. 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.
