The verdict in three sentences
Without a real-time dashboard, you discover your cash gaps seven days too late, once the damage is done. A live dashboard that aggregates M-Pesa, Airtel Money and card rails cuts the decision lag from 7 days to 1 day, for a software cost of 15,000 to 40,000 FCFA per month (about 100-260 USD). It is the only tool that turns scattered payments into daily, actionable cash steering.
Weekly Excel versus live dashboard: the real gap
Excel tracking relies on a Friday ritual: download operator statements, copy-paste, add it all up. The problem is not the spreadsheet, it is latency: a cash breakage that started Monday only becomes visible the following Friday. A real-time dashboard reads transactions via API or webhook and refreshes indicators continuously.
| Criterion | Weekly Excel | Real-time dashboard |
|---|---|---|
| Data latency | 5 to 7 days | under 30 seconds |
| Decision lag | 7 days | 1 day |
| Multi-operator | Manual consolidation | Automatic aggregation |
| Failure rate visible | No | Yes, live |
| Threshold alerts | None | Configurable |
| Monthly cost | 0 FCFA (but time) | 15,000 to 40,000 FCFA |
| Data-entry error risk | High | Near zero |
Excel looks free, but it costs two to three hours a week and lets alerts slip. The SaaS has a visible price, but it gives time back and removes the blind spot.
The KPIs that actually matter
A good dashboard does not show everything: it shows what triggers action. Here are the indicators to keep in sight and their typical alert threshold for a Nairobi SME in 2026.
| KPI | Definition | Typical alert threshold |
|---|---|---|
| Today's collections | Net collected since midnight | Below 60% of 7-day moving average |
| Failure rate | Failed / initiated transactions | Above 12% |
| Average basket | Collected / number of transactions | Drop over 15% |
| Top products | Ranking of today's sales | Trend watch |
| Collection delay | Time from order to confirmed payment | Above 10 minutes |
| Operator split | M-Pesa vs Airtel vs card share | Depends on target mix |
The threshold alert is the most profitable feature: an automatic SMS or WhatsApp message when the failure rate crosses 12% lets you call the operator before losing a full day of sales.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Meet Grace, who runs a three-shop cosmetics chain in Nairobi. In 2025 she tracks collections on Excel every Friday. An M-Pesa incident blocks payments for three days in her Westlands shop: she only sees it on Friday, after losing about 420,000 FCFA (about 700 USD) in uncollected sales.
In 2026 she moves to a real-time dashboard at 30,000 FCFA per month, or 360,000 FCFA per year. On the very first incident, the threshold alert fires at 9:40 a.m.; she switches customers to Airtel Money within an hour and saves about 380,000 FCFA. A single avoided incident covers the annual subscription and leaves 20,000 FCFA of net margin, before counting the recovered admin time.
FAQ
Do I need a developer to connect my operators? For M-Pesa and Airtel Money, integration goes through their merchant APIs or an aggregator. Budget 3 to 7 days of setup; after that the dashboard runs on its own and updates in under 30 seconds.
Does a dashboard replace my accounting? No. It steers cash day to day; accounting stays with your accountant. But a clean categorized export from the dashboard cuts their data-entry time by 80%.
What does the solution really cost? The SaaS costs 15,000 to 40,000 FCFA per month depending on volume and number of shops. Add a one-off setup of 150,000 to 400,000 FCFA if you want a custom, branded dashboard.
Is it useful for a single shop? Yes, as soon as you collect more than 30 transactions a day. Below that, the failure alert and average basket alone already justify the tool.
Can I earn money by recommending this kind of tool? Yes. The Kolonell referral program pays 15% + 5% recurring on website and dashboard projects, 12% on e-commerce, 10% on marketplaces and 8% on institutional. Refer a merchant and earn a commission on every signature.
Let's talk about your project. We build your multi-operator collections dashboard, and you can become a Kolonell referral partner. 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.

