The verdict in three sentences
For a distribution group with 9 subsidiaries run from Johannesburg, moving from a 10-day consolidation to 1 day is realistic in 2026, whether you choose Power BI or a custom dashboard. Power BI starts faster and costs less below about 24 users, while a custom build, with no per-user licence, becomes cheaper beyond that and copes better with load shedding and unstable links in regional subsidiaries. In both cases, about 70% of the budget goes to the same place: connectors to each subsidiary's ERP and a common IFRS data model.
Why consolidation takes 10 days
In most Southern African distribution groups, each subsidiary runs its own accounting and sales tools: Sage Intacct in Johannesburg, Sage Pastel in Durban, Odoo in Gaborone, a spreadsheet in Lusaka. Group finance receives exports by email between the 3rd and the 8th of the month, maps accounts to the group chart, converts rand, pula and kwacha, eliminates intercompany flows and rebuilds margins by product family. The CEO gets the dashboard around the 10th, after stock and discount decisions have already been made.
An automated executive dashboard removes these manual steps: daily extraction from each ERP, a central data warehouse, mapping and FX rules coded once, KPIs refreshed every morning. The CEO checks sales, margin, stock, receivables and cash collected from a phone.
Power BI or custom: 2026 comparison
The ranges below are 2026 estimates. At Kolonell they match our grid: simple application EUR 3,810-6,100, medium application EUR 6,100-10,670, maintenance EUR 110 or 180 per month.
| Criterion | Power BI Pro | Custom dashboard |
|---|---|---|
| Licence | about EUR 13 (USD 14) per user per month | no per-user licence |
| Connectors and data model | EUR 3,810-6,100 | included in the project |
| Full project | EUR 3,810-6,100 | EUR 6,100-10,670 |
| Hosting | included at Microsoft, gateway to maintain | EUR 75-230 per month |
| Delivery time | 6 to 10 weeks | 10 to 16 weeks |
| Offline and mobile use | limited | designed for it, WhatsApp alerts possible |
| Screen customisation | strong, within tool limits | complete |
Licence costs climb fast once subsidiary managers, category managers and sales reps need to see the numbers.
| Number of users | Power BI Pro licences per year | Custom hosting per year |
|---|---|---|
| 10 | EUR 1,560 | EUR 900-2,750 |
| 25 | EUR 3,900 | EUR 900-2,750 |
| 50 | EUR 7,800 | EUR 900-2,750 |
| 100 | EUR 15,600 | EUR 900-2,750 |
| 150 | EUR 23,400 | EUR 1,370-2,750 |
Total 3-year cost for 30 users
| Item | Power BI | Custom |
|---|---|---|
| Setup | EUR 4,950 | EUR 8,380 |
| Licences over 36 months | EUR 14,040 | EUR 0 |
| Hosting over 36 months | included | EUR 5,400 |
| Maintenance over 36 months | EUR 3,960 (EUR 110 per month) | EUR 6,480 (EUR 180 per month) |
| 3-year total | EUR 22,950 | EUR 20,260 |
| Break-even | below 24 users | above 24 users |
Two technical points often tip the balance. The Power BI on-premises gateway must stay online on a local server: during load shedding or a network outage at a subsidiary, the refresh fails. A custom solution instead pushes each subsidiary's data to a cloud database as soon as the link is back. On compliance, customer data remains subject to POPIA and to the data protection laws of each SADC country, whatever the tool.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Thabo runs a fast-moving consumer goods distribution group: 9 subsidiaries, head office in Johannesburg. Every month, 2 financial controllers spend 10 days each on consolidation and 9 subsidiary accountants spend 2 days each, so 38 person-days. After automation, 1 day per controller and half a day per subsidiary remain, about 6 days.
Gain: 32 person-days per month at an average loaded cost of EUR 140, so EUR 4,480 per month and EUR 53,760 per year. He chooses Power BI for 25 users: EUR 4,950 setup, EUR 3,900 in licences and EUR 1,320 in maintenance, so EUR 10,170 in year one. Payback: about 2.3 months, before counting restocking decisions taken 9 days earlier.
FAQ
Is Power BI enough for a group with 9 subsidiaries?
Yes, if subsidiaries have an ERP that can export data and a stable connection, and if users stay below about 24. Beyond that, the EUR 13 per user per month licence weighs more than hosting a custom solution.
How long does it take to go from 10 days to 1 day of consolidation?
Allow 6 to 10 weeks with Power BI and 10 to 16 weeks for a custom build, including 3 to 4 weeks to map each subsidiary's accounts to the group chart. The first automated month-end close serves as acceptance testing.
Can we include multi-currency subsidiaries?
Yes, daily FX rates from the South African Reserve Bank or a market feed are loaded automatically. Each KPI can be shown in local currency and in rand, which removes most of the 1 to 2 days usually spent on conversions.
What happens if a subsidiary loses power or internet?
With Power BI, the gateway refresh fails and figures stay at the previous day. A custom build stores data locally and syncs it once the connection returns, with no manual action.
Who maintains the dashboard after delivery?
A maintenance contract of EUR 110 to 180 per month covers connector changes, new KPIs and monitoring of daily loads. An internal owner still needs 2 to 4 hours per week to validate the numbers.
Let's scope your project. Tell us how many subsidiaries, which ERPs and how many dashboard readers you have: we compare Power BI and custom over 3 years, with a budget of EUR 3,810-10,670 and delivery in 6 to 16 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.
