The verdict in three sentences
A KPI dashboard is not a pretty chart: it is the tool that turns your scattered data (cash register, invoices, payments) into decisions made in time. The trap is wanting to measure everything; start with 5 to 7 vital indicators updated automatically. A leader who sees cash flow in real time anticipates a shortfall instead of suffering it.
Essential KPIs by trade
| KPI | Data source | Ideal frequency | Why it is vital |
|---|---|---|---|
| Daily revenue | Cash register / invoicing | Real time | The pulse of the business |
| Gross margin | Invoicing + purchases | Daily | Selling without earning = trap |
| Available cash | Bank + Wave/OM | Daily | Avoids cash shortfall |
| Receivables (unpaid) | Invoicing | Weekly | Money out to recover |
| Stock level / stockouts | Stock / cash register | Daily | Lost sale if out of stock |
| New leads / conversion | CRM | Weekly | Fuel for future sales |
| Average ticket | Cash register / e-commerce | Weekly | Growth lever |
A restaurateur watches margin and turnover, an e-merchant the ticket and conversion rate, a wholesaler stock and receivables. The right dashboard is filtered to the 5 figures that tip your decisions.
Excel vs automated dashboard
| Criterion | Manual Excel sheet | Automated dashboard |
|---|---|---|
| Update time / week | 4 to 6 h | ~0 (auto) |
| Data freshness | D-7 to D-30 | Real time |
| Data-entry error risk | High | Low |
| Connected sources | Copy-paste | Cash, invoicing, Wave/OM |
| Automatic alerts | No | Yes (cash/stock thresholds) |
| Mobile access on the go | Hard | Yes |
| Cost | "Free" but time-consuming | from 700,000 FCFA build |
Excel is not "free": 5 hours/week of a leader at 15,000 FCFA/hour of value is ~300,000 FCFA/month of burned time, not counting decisions missed on stale data.
Mini case study
Ousmane runs a distribution SME in Dakar, 8 employees. Every Monday he spends half a day consolidating cash, bank and invoices in Excel — data already a week old. Twice this year he discovered a cash squeeze too late and paid 450,000 FCFA in overdraft fees and supplier penalties. He rolls out a dashboard (build 1,200,000 FCFA) connected to his invoicing and Wave/OM accounts, with a cash alert below 2,000,000 FCFA. Result: he saves ~5 h/week, eliminates the fees and times his purchases on same-day figures. ROI reached in under 2 months.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
How many KPIs should you track when starting?
Five to seven maximum. Beyond that, the dashboard becomes a wall of numbers nobody looks at. You expand once the daily-check habit is anchored.
Can a dashboard connect to Wave and Orange Money?
Yes, and it is a major advantage in Senegal: aggregating Wave/OM collections with the bank gives a true real-time cash view rather than a partial bank balance.
How much does an automated dashboard cost in 2026?
A custom dashboard connected to your sources starts around 700,000 FCFA and rises with the number of connectors. The return comes mainly from leader time saved (4 to 6 h/week) and better-timed decisions.
Do you need an ERP before a dashboard?
No. A dashboard can aggregate simple sources (cash register, invoicing file, mobile money accounts) without an ERP. The ERP becomes relevant later, when processes get complex.
Let's talk about your project. We identify your 5 vital KPIs and design the dashboard that lets you steer in real time. 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.
