The verdict in three sentences
Reconciliation means confirming that every order you captured matches a real line on your Paystack or Flutterwave settlement, net of fees. Without a method, the average e-commerce SME carries a 2 % to 5 % cash gap on monthly revenue — money lost to forgotten fees, unmatched refunds and duplicate payments. Wiring the provider API into your store cuts the work from 4-8 hours a month to under 30 minutes and makes your cash flow trustworthy.
Where the gaps come from
A gap is almost never theft — it is a timing and fee mismatch. The three main causes in 2026 are the settlement delay (a sale on the 30th lands in your account on the 1st), merchant fees that never get booked (1.3 % to 1.5 % plus flat NGN fees), and refunds processed outside the system. Add partial payments and customers who pay twice after a perceived failure.
| Gap source | Frequency | Typical monthly impact |
|---|---|---|
| Merchant fees not deducted | Very common | 1.3 % to 1.5 % of revenue |
| Settlement delay shift | Systematic | 1 to 2 days of revenue pending |
| Refunds off the ledger | Common | 0.3 % to 1.2 % of revenue |
| Duplicate customer payments | Occasional | 0.5 % to 1 % of orders |
| Manual entry error | Common | 1 % to 2 % of lines |
Manual vs automated: the real cost
Manual matching means exporting the merchant dashboard (CSV), opening it in a spreadsheet and comparing line by line with orders. It works under 300 orders a month and collapses beyond. Automation connects the provider API to your store to reconcile every transaction, including VAT tracking, in real time.
| Approach | Time / month | Export or API cost | Reliability |
|---|---|---|---|
| Manual spreadsheet (CSV) | 4 to 8 h | Free | 2-5 % gap |
| CSV + macro | 2 to 3 h | Free | 1-3 % gap |
| Provider API + reconciliation | < 30 min | 0 to 15 USD/month | < 0.5 % gap |
| Connected accounting tool | < 15 min | 10 to 30 USD/month | < 0.5 % gap |
Rule of thumb: past 150 orders a month, automation pays for itself in a single saved workday.
Mini case study
Chidi runs a sneaker store on WooCommerce in Lagos. His July 2026 revenue shows 4,200,000 NGN across 260 orders, settled via Paystack and Flutterwave. Matching by hand, he saw a recurring 3.5 % gap — roughly 147,000 NGN he could not explain. On review, half came from merchant fees never deducted (about 63,000 NGN) and half from two refunds and one duplicate payment left unmatched. After wiring API reconciliation across both gateways, his gap drops below 21,000 NGN and, above all, he reclaims six hours a month.
FAQ
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Do I need accounting software to reconcile mobile money and card payments?
No — a spreadsheet is enough below 150 orders a month. Above that, a tool connected to the Paystack or Flutterwave API cuts the work tenfold and pulls the cash gap under 0.5 %.
Why does my Paystack settlement never match my sales exactly?
Because the settlement is net of fees (1.5 % + 100 NGN) and shifted by the T+1 payout. A sale captured on the 31st may only land the next day — not an error, just a delay to model.
How much time does manual reconciliation cost an SME?
On average 4 to 8 hours a month for a store of 100 to 300 orders. At local admin rates that is real money in unproductive time, before counting the undetected gaps themselves.
Is the merchant dashboard CSV export free?
Yes, with most providers in 2026. Real-time API access, however, may cost between 0 and 15 USD a month depending on volume and the gateway you pick.
How do I catch a duplicate customer payment?
Sort transactions by amount and phone number within the same day: two identical lines flag a duplicate to refund. An automated tool raises that alert instantly.
Let's talk about your project. We connect your store to Paystack and Flutterwave APIs for automatic reconciliation and zero cash gap. 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.
