The verdict in three sentences
Reconciliation — matching provider statements, website orders and accounting — is the most underestimated financial task of an online merchant. Before reconciliation, the average gap between what the site thinks it sold and what the provider actually settled reaches 1 to 3%, and manual matching costs 4 to 6 hours a week. Automating reference-based matching cuts disputes by 40% and frees valuable time.
Where the gaps come from
A reconciliation gap is almost never theft: it is mis-booked fees, partial payments, refunds and settlement lags. Here are the typical causes and their weight.
| Gap cause | Frequency | Impact on gap |
|---|---|---|
| Uncounted PSP fees | Very common | 1.0 – 1.7% |
| Settlement lag (T+1/T+3) | Common | Timing only |
| Partial refunds | Medium | 0.3 – 0.8% |
| Duplicate transactions | Rare | 0.1 – 0.5% |
| Disputes / chargebacks | Medium | 0.2 – 0.6% |
| Manual entry errors | Common | 0.5 – 1.5% |
The sum of these gaps explains why the bank balance never exactly matches the revenue shown on the site dashboard.
Manual vs automated: the real cost
The manual process means exporting each provider's CSV, laying it next to orders and ticking line by line. Here is the monthly comparison.
| Criterion | Manual reconciliation | Automated reconciliation |
|---|---|---|
| Time per week | 4 – 6 h | 15 – 30 min |
| Residual gap | 1 – 3% | < 0.3% |
| Dispute detection | Late | Near real time |
| Dispute rate | Baseline | −40% |
| Month-end reliability | Low | High |
| Monthly cost (time) | ~20 h | ~2 h |
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
On an accountant's salary of ZAR 15,000/month, saving 18 hours recovers roughly ZAR 1,700 of time each month — before counting lower dispute losses.
Mini case study
Thabo handles accounting for an online shop in Johannesburg doing ZAR 240,000 in monthly sales. Every month-end he spent two full days ticking provider statements against orders, with a 2.4% residual gap he could not explain. After setting up automatic reference-based matching, the gap fell to 0.2%, time dropped from 16 hours to 90 minutes a month, and untreated disputes fell 40%. The result: a reliable close and about ZAR 1,500 of time recovered each month.
FAQ
Why does my bank statement never match the site's revenue? Because the site shows gross collected, while the bank receives net after PSP fees, delayed by settlement timing. The normal gap equals fees (1 to 1.7%) plus timing.
How does reference-based matching work? Each transaction carries a unique ID on both the site and provider side. Automation matches the two, flags orphans (paid but no order, or vice versa), and leaves the accountant to handle only exceptions.
How long does it take to set up? For a standard shop, integrating provider exports and the matching rule deploys in a few days. The time saving shows from the first close.
Does automation really reduce disputes? Yes, by about 40% in practice, because it catches anomalies early: you answer a dispute within 48 hours instead of discovering it a month later, when it is too late.
Let's talk about your project. We automate your mobile-money reconciliation and connect your exports to your accounting. 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.
