The verdict in three sentences
Without automated reconciliation, 3 to 5 % of revenue in a mobile money store vanishes in untraced gaps. The method is three moves: match every transaction reference to its order, export payments daily, and fire an alert above a 1 % gap. Done well, this recovers ~6 hours a week and ends the cash gaps in an Accra store.
Where the gaps come from
A cash gap is almost never theft: it is a mismatched payment, a forgotten refund or a duplicate. Here are the typical causes and their weight.
| Gap cause | Frequency | Share of revenue hit |
|---|---|---|
| Payment received with no linked order | frequent | 1-2 % |
| Order confirmed with no confirmed payment | frequent | 1-2 % |
| Unrecorded refund | occasional | 0.5 % |
| Duplicate payment | rare | 0.3 % |
| Provider fees not deducted | systematic | ~1 % |
Combined, these micro-leaks easily reach 3 to 5 % of revenue: on a store doing GHS 75,000/month, that is GHS 2,250 to 3,750 evaporating every month.
The 3-move reconciliation method
Reconciliation does not need heavy accounting software, just tooled discipline.
| Move | Frequency | Threshold / rule |
|---|---|---|
| Reference / order matching | Automatic, real time | 100 % of transactions |
| Payment export | Daily | End of day |
| Gap alert | Automatic | > 1 % or > GHS 75 |
| Provider fee deduction | Every settlement | ~1.5 % Flutterwave |
| Monthly close | Monthly | Target gap < 0.5 % |
Flutterwave settlement in Ghana runs around T+1 to T+2: you must reconcile order date against payout date, otherwise cash flow looks inconsistent when everything is actually fine.
The time and money saved
A store reconciling by hand easily spends an hour a day and still lets gaps slip. Automating changes both.
Mini case study
Modibo runs an appliance store in Accra: GHS 75,000/month revenue. Before, he lost ~4 % in untraced gaps, i.e. GHS 3,000/month, and spent 1 h/day checking payments (~6 h/week). He sets up reference/order matching, daily export and an alert on any gap above GHS 75. Gaps fall to ~0.5 % (GHS 375/month): he recovers GHS 2,625/month and 6 hours/week. Over a year, that is GHS 31,500 and more than 300 hours saved.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Become a Kolonell referral partner
Do you help merchants struggling with their books and payments? Refer them and earn with the Kolonell referral (apporteur d'affaires) program: 15 % + 5 % recurring on a showcase site, 12 % on e-commerce, 10 % on a marketplace, 8 % on an institutional project. A 2,500,000 FCFA e-commerce store earns you 300,000 FCFA for a single successful introduction.
FAQ
Do I need accounting software to reconcile?
No. A daily payment export and automatic reference/order matching are enough for a store. Accounting software becomes useful later, for tax.
Why a GHS 75 alert threshold?
Below it, micro-gaps (rounding, fees) do not warrant action. Above GHS 75 or 1 % of revenue, the gap should be investigated the same day.
Does Flutterwave's settlement delay distort reconciliation?
Only if you compare the wrong dates. Reconcile against the settlement date, not the order date, to avoid false cash-flow alerts.
How do I handle provider fees in reconciliation?
Systematically deduct the ~1.5 % processing fee on each payout. Otherwise the amount received always looks lower than the order, creating a permanent false gap.
How long does setup take?
On an existing store, 2 to 4 days to wire the automatic export and alerts. The longest part is cleaning up the history of unlinked transactions.
Let's talk about your project. We automate your mobile money reconciliation to eliminate cash gaps in Accra. 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.
