The verdict in three sentences
For a West African distribution SME consolidating 5 Excel files every Monday, automated dashboards linking sales, stock and cash, with WhatsApp alerts, cost FCFA 2.5 to 6 million excluding VAT (about EUR 3,800 to 9,150). Our reference case is in Dakar; an Accra project of the same scope is priced in a similar range, converted to cedis. The direct gain is 6 hours a week, but the real value comes from real-time restocking decisions, which cut stockouts and dead stock, with payback in about 7 months as a 2026 order of magnitude for an SME turning over FCFA 400 to 900 million a year.
What actually gets automated
The starting point is almost always the same: a sales file exported from the point-of-sale system, a stock file kept by the storekeeper, a bank statement, a mobile money export (Wave, Orange Money, MTN MoMo) and a receivables sheet. The project connects these sources, cleans them every night and displays reliable indicators, readable on a phone.
| Building block | 2026 range (FCFA excl. VAT) | Deliverable |
|---|---|---|
| File audit and definition of 15 to 25 KPIs | 300,000 to 600,000 | KPI dictionary approved by the owner |
| Connectors: POS, ERP or Sage, bank, mobile money | 800,000 to 2,000,000 | Daily or hourly sync |
| Data warehouse and cleaning rules | 500,000 to 1,200,000 | Reliable 24-month history |
| Dashboards: sales, margin, stock, cash | 500,000 to 1,300,000 | 4 to 6 screens, mobile version |
| WhatsApp alerts (stockout, unpaid invoice, cash threshold) | 250,000 to 600,000 | Automatic messages to owner and managers |
| Training and 2-month support | 150,000 to 300,000 | Self-sufficient team |
| Total project | 2,500,000 to 6,000,000 | Delivered in 6 to 10 weeks |
Monthly running costs (hosting, visualisation licences, WhatsApp messages) come to FCFA 50,000 to 120,000 a month.
Excel, self-service BI or custom build
| Criterion | Manual Excel consolidation | Self-service BI tool | Custom dashboards |
|---|---|---|---|
| Upfront cost | FCFA 0 | FCFA 300,000 to 1,000,000 | FCFA 2,500,000 to 6,000,000 |
| Monthly cost | 6 hours of work a week | FCFA 15,000 to 40,000 per user | FCFA 50,000 to 120,000 in total |
| Data freshness | Weekly | Depends on manual imports | Daily or hourly |
| Mobile money connection | Manual export | Rarely native | Included |
| WhatsApp alerts | None | None | Included |
| Figure reliability | Frequent copy-paste errors | Good if sources are clean | Automatic checks |
A self-service BI tool works if you already have someone able to build data models. In most West African SMEs that profile does not exist in-house, and the tool sits empty after three months.
The indicators that change decisions
| Indicator | Frequency | WhatsApp alert | Decision triggered |
|---|---|---|---|
| Stock cover in days per SKU | Daily | Below 10 days | Supplier order |
| Dead stock older than 90 days | Weekly | Above 8% of stock | Promotion or supplier return |
| Gross margin by product family | Daily | Drop of more than 3 points | Price review |
| Receivables older than 60 days | Daily | Above FCFA 15 million | Sales follow-up |
| 30-day cash forecast | Daily | Below set threshold | Defer spending, negotiate |
| Mobile money collections | Hourly | Gap with till | Cash audit |
Mini case study
Mamadou runs a food distribution SME in Dakar (FCFA 650 million turnover, 3 depots) and spent 6 hours every Monday consolidating files. At FCFA 5,000 per hour of skilled work, that is FCFA 130,000 a month. Stockouts on his 40 best-selling SKUs also cost him about FCFA 500,000 in lost margin a month, most of which stock cover alerts recovered. Monthly gain: FCFA 630,000, minus FCFA 75,000 of running costs, so FCFA 555,000 net. For a FCFA 4,000,000 project, payback comes in 7.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 much do automated dashboards cost for an SME?
Budget FCFA 2.5 to 6 million (EUR 3,800 to 9,150) excluding VAT depending on the number of sources and KPIs. Monthly running costs are FCFA 50,000 to 120,000.
Do I need to change my POS or accounting software?
No. We connect existing tools: Sage, local POS software, Excel files, bank statements and mobile money exports. Only sources with no export at all need adjustment.
Are WhatsApp alerts reliable?
They go through the official WhatsApp Business API, at a few tens of FCFA per message. An owner receives 3 to 8 useful alerts a week on average.
How long before the first screens?
Sales and stock screens are delivered in 3 to 4 weeks. The full project, including cash and alerts, takes 6 to 10 weeks.
Does my data stay confidential?
Yes, access is named, each profile sees only its own indicators, and the project complies with local data protection law (Senegal's law 2008-12, Ghana's Data Protection Act 2012).
Let's scope your project. List your current files and your 5 most frequent decisions: we will price your dashboards between FCFA 2.5 and 6 million, delivered in 6 to 10 weeks. Detailed quote within 48 h. 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.
