The verdict in three sentences
Collecting via several providers also means several statements, fee schedules and settlement delays. Without tooling, finance spends hours matching orders to transactions by hand and lets discrepancies slip. A unified dashboard targets over 99.5 % of transactions matched automatically and frees 8 to 15 hours per month.
What to reconcile, and how
Reconciliation links each order to its transaction, then to its bank settlement, backing out fees. Here are the key fields and their matching rule.
| Field | Source | Matching rule |
|---|---|---|
| Order reference | Store | Primary key of the match |
| Transaction ID | Provider (M-Pesa/Paystack) | Tied to order reference |
| Gross amount | Provider | = order amount |
| Fees charged | Provider statement | Deducted from gross |
| Net settled amount | Settlement statement | Gross - fees |
| Settlement date | Bank / provider | T+1 to T+3 by method |
| Status | Provider | Paid / refunded / failed |
The heart of the system: the order reference must travel inside every transaction. Without it, no automatic match is reliable.
The metrics that matter
A good dashboard does more than list: it alerts on discrepancies. Here are the KPIs to track (2026 targets).
| Metric | Target | Alert if |
|---|---|---|
| Reconciliation rate | > 99.5 % | < 98 % |
| Unmatched transactions | near 0 | > 10 / day |
| Settlement discrepancy | 0 | any gap above threshold |
| Average payout delay | T+1 / T+3 | > T+4 |
| Actual vs expected fees | matches schedule | gap > 0.2 pt |
With these alerts, a late payout or an abnormal fee surfaces immediately instead of being discovered at month-end.
Mini case study
James runs finance for an Accra store collecting via M-Pesa, Paystack and card, around 900 orders per month. He used to spend about 12 hours a month matching by hand in a spreadsheet, with 3 to 4 % of transactions unclear. With a unified dashboard the reconciliation rate hits 99.6 % and the time drops to 2 hours a month. Ten hours freed each month, plus settlement gaps finally caught.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Why not reconcile in a simple spreadsheet?
A spreadsheet does not auto-deduct per-provider fees or detect missing settlements. Beyond 300-400 orders a month, manual work becomes a source of errors and wasted time.
What reconciliation rate should I target?
Over 99.5 %. Below 98 %, too much money stays unmatched, usually mis-counted fees or late payouts.
How do I handle different fees per provider?
The dashboard backs out fees from each settlement statement, then compares to expected fees per schedule. Any gap above 0.2 points triggers an alert.
How much time does the dashboard save?
Between 8 and 15 hours of finance work per month for a 500-to-1,000-order store, on top of the settlement gaps it catches.
Can it also handle M-Pesa or multi-country expansion?
Yes: the same matching logic (order reference + settlement statement) applies to any provider, including M-Pesa or a multi-country aggregator.
Let's talk about your project. We build your unified reconciliation dashboard across M-Pesa, Paystack and card. 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.
