The verdict in three sentences
An SME collecting payments through mobile money and card without systematic reconciliation loses on average 3 to 8% of its revenue in gaps that never get recovered. The problem is not theft: it is that the payment app, the bank statement and your sales software speak three different languages, on three different timelines. The 2026 fix fits in one sentence: a single matching key (the transaction reference) reconciled automatically every night.
Why the money "disappears"
When a customer pays 10,000 NGN through Paystack, three events happen at three separate moments: the notification (immediate), the settlement into your bank account (T+1 in Nigeria), and the entry in your books (whenever you type it — often never). Without a common key, you cannot tell whether this morning's deposit matches yesterday's sale or the day before's.
Every processor exposes a unique reference — that is your anchor. Reconciliation means matching that reference across three sources: the processor export, the settlement bank statement, and your internal order.
| Processor / rail | Settlement delay | Statement format | Matching key |
|---|---|---|---|
| Paystack | T+1 business day | Dashboard + settlements API | Settlement ID + amount |
| Flutterwave | T+1 | Transfers/settlements API | tx_ref + flw_ref |
| Wave | Same day (instant) | API + CSV, ref WV-xxxxx | Transaction reference |
| M-Pesa | Same day to T+1 | Daily statement export | Receipt no. + amount |
| MTN MoMo | T+1 | Daily CSV | Reference + payer number |
The most reliable key is the transaction reference, never the amount alone: two sales of 10,000 NGN on the same day become indistinguishable if you match on amount.
The real cost of fees and gaps
One thing people forget: the settled amount is never the paid amount. Fees are deducted at source, creating a legitimate gap you must model — otherwise every line looks wrong.
| Item | Manual (spreadsheet) | Automated (matching) |
|---|---|---|
| Weekly time | 6 hrs/week | 20 min/week |
| Unexplained gap rate | 2 to 5% | < 0.3% |
| Time to spot a missed sale | 15 to 30 days | 24 hrs |
| Paystack fees modelled | 1.5% + 100 NGN (cap 2,000) | pre-computed per line |
| Data-entry error risk | High | Zero |
| Monthly labour cost | ~120 USD | ~15 USD |
At scale, one cent unreconciled per transaction across 3,000 transactions/month is small; but a whole "forgotten" sale (customer paid, order never fulfilled or double-counted) costs the full margin plus your reputation.
Mini case study
Tunde runs a cosmetics shop in Lagos: 520 transactions/month, average basket 8,000 NGN, revenue 4,160,000 NGN/month. Finally reconciling Paystack, his bank statement and his ledger, he uncovers a recurring 4.2% gap, i.e. 174,700 NGN/month — paid orders never tracked and refunds never deducted. The automated matching tool costs him about 15 USD/month and gives back 5 hours a week. Return on investment: positive in the first week, with roughly 2M NGN/year of revenue secured.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
What is a normal gap rate before automation?
Between 2 and 5% of volume for an SME entering data by hand. Above 5%, you almost certainly have whole untracked sales, not just mis-deducted fees.
Does Paystack really settle on T+1?
Yes, standard Paystack settlement is T+1 on business days, with a settlement ID you can match against. Flutterwave is similar; Wave settles same-day with a WV-xxxxx reference.
Can I match on amount alone?
Not advisable: two sales of the same amount on the same day become impossible to tell apart. Always use the transaction reference as the primary key and the amount as a secondary check.
How long does it take to automate reconciliation?
A connector that imports processor exports and matches by reference takes 3 to 5 development days, costing roughly 250,000 to 500,000 FCFA depending on the number of sources to wire in.
Do I still need an accountant with the tool?
The tool reconciles line by line; the accountant validates the exceptions (the < 0.3% that do not match). You move from data entry to control work, which is far faster.
Let's talk about your project. We wire your Paystack, Flutterwave and mobile money exports into automated matching so you recover every naira. 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.
