The verdict in three sentences
If your leadership team sees last month's figures at D+15, every decision runs two weeks behind the field. Power BI (10 to 20 USD per user per month, plus 2 to 6 million FCFA, about 3,500 to 10,500 USD, of setup in Dakar) suits teams that already have clean data and an in-house analyst. A custom dashboard connected to Sage or Odoo, at 4 to 12 million FCFA (about 7,000 to 21,000 USD), wins when data must be cleaned, field operations integrated and KPIs delivered at D+1 on mobile.
Why month-end close takes 10 to 15 days
The delay rarely comes from the accounting software itself. It comes from sales keyed in at month end by regional branches, mobile money receipts (Wave, Orange Money) reconciled by hand, stock counted in spreadsheets and adjustments made in a workbook only the controller understands. A dashboard only helps if it automates those flows.
| Data source | Common situation | What the dashboard must do |
|---|---|---|
| Sage 100 or Sage X3 | Entries validated at month end | Read provisional entries every night |
| Odoo (sales, purchasing, stock) | Up to date but not consolidated | Aggregate by branch, product, client |
| Wave and Orange Money receipts | Statements exported by hand | Automatic daily reconciliation |
| Banks | PDF statements | Statement import, cash position |
| Regional branches | Spreadsheets sent by email | Mobile entry or direct sync |
| Annual budget | CFO's workbook | Automatic actual versus budget |
Power BI or custom: cost comparison
With the dollar around 565 FCFA in 2026, a Power BI Pro licence costs about 8,000 FCFA per user per month, a Premium Per User licence about 13,500 FCFA.
| Criterion | Power BI | Custom dashboard |
|---|---|---|
| Licences | 10 to 20 USD per user per month | None, hosting 50,000 to 150,000 FCFA (90 to 265 USD) per month |
| Setup | 2 to 6 million FCFA (3,500 to 10,500 USD) | 4 to 12 million FCFA (7,000 to 21,000 USD) |
| Sage or Odoo connection | Generic connectors, sometimes a gateway to maintain | Dedicated connector, business logic included |
| Field data (branches, mobile money) | Must be prepared upstream | Collected and cleaned by the tool |
| Mobile use for the CEO | Good, Power BI app | Mobile-first, WhatsApp or SMS alerts |
| Self-service reporting | Strong with a trained analyst | More limited, new screens on request |
| 3-year cost for 15 users | 6.3 to 18.2 million FCFA (11,000 to 32,000 USD) | 5.8 to 17.4 million FCFA (10,000 to 31,000 USD), maintenance included |
The 3-year figure includes setup, licences or hosting and 10 to 15% annual maintenance. The two options converge; the real difference lies in input data quality and user profile. In Europe or North America, the same custom build typically runs 25,000 to 70,000 USD.
Which KPIs to publish at D+1
An effective executive dashboard fits on one screen: revenue for the day and month to date versus budget, gross margin by business line, consolidated cash position, receivables over 60 days, stock value and stock-outs, plus three metrics specific to your business (fill rate, average basket, productivity per branch). Beyond 10 to 12 KPIs, leadership stops looking.
Mini case study
Mr Ndiaye, CFO of a consumer goods distributor in Dakar with 6 regional branches and 4.2 billion FCFA (about 7.4 million USD) of revenue, waits 14 days each month for consolidated figures. Two controllers spend about 6 days a month compiling files. He chooses a custom dashboard connected to Sage 100 and Odoo, with Wave and Orange Money reconciliation, for 8.5 million FCFA (about 15,000 USD) and 90,000 FCFA of monthly hosting. The 12 person-days freed each month, valued at 45,000 FCFA a day, are worth 540,000 FCFA a month, or 6.5 million FCFA a year. Above all, spotting a stock-out 10 days earlier on a single key product can prevent several million FCFA of lost sales.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Does Power BI work with Sage 100?
Yes, through connectors or an intermediate database, but it often needs a gateway on a local server. Budget 1 to 2 million FCFA (1,800 to 3,500 USD) of connection work within setup.
How long until a first dashboard is live?
4 to 6 weeks for a first version with 8 to 10 KPIs, 8 to 12 weeks for a multi-branch version with mobile money and budget. Sage or Odoo data quality is the main driver of delay.
Does the data stay confidential?
The dashboard can be hosted in Senegal or a European cloud, with role-based access (CEO, CFO, branch managers). Senegal's Law 2008-12 on personal data applies to any client data displayed.
Can alerts be sent via WhatsApp?
Yes, an alert can fire when cash drops below a threshold or a critical item falls under 7 days of cover. The integration usually adds 500,000 to 1,000,000 FCFA (900 to 1,800 USD).
What budget for a 50-person company?
A custom dashboard with 8 to 10 KPIs connected to a single system sits around 4 to 6 million FCFA (7,000 to 10,500 USD). Power BI for 5 users costs roughly 2.5 to 6.5 million FCFA in year one.
Let's scope your project. Executive dashboard connected to Sage, Odoo, your banks and mobile money, from 4 to 12 million FCFA (7,000 to 21,000 USD) depending on scope, first KPIs within 4 to 6 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.
