The verdict in three sentences
If your group already runs on Microsoft 365 and your data sits in a standard ERP, Power BI is the fastest and cheapest route to an executive dashboard. If your subsidiaries use mixed software, Excel files and statements from several local banks, or you want a tool that partners and shareholders can open without a licence, a custom build becomes cheaper over 3 years. Either way, the realistic target is moving from a day 15 close to day 3 in 6 to 12 weeks.
Why your figures arrive on day 15
In most mid-sized UAE groups (trading, construction, logistics, hospitality), monthly consolidation follows the same path: each subsidiary exports its trial balance, the financial controller reworks it in Excel, treasury reconciles statements from four or five banks (Emirates NBD, ADCB, FAB, Mashreq, RAKBANK), then group finance assembles a 30-tab workbook. Since UAE corporate tax at 9% came into force, the pressure for clean entity-level figures has only grown.
| Monthly close step | Current timing | With a connected dashboard |
|---|---|---|
| Subsidiary trial balance export | Day 3 to 5 | Automatic, daily |
| Multi-bank reconciliation | Day 5 to 8 | Day 1 (statement import) |
| Intercompany eliminations | Day 8 to 11 | Day 2 (configured rules) |
| Formatting KPIs | Day 11 to 13 | Instant |
| Review and release to the CEO | Day 13 to 15 | Day 3 |
| Controller time per month | 18 person-days | 4 to 5 person-days |
The gain is not only speed. A CEO who sees margins by subsidiary on day 3 can correct a purchase price or collection drift within the month, instead of discovering it six weeks later.
Power BI vs custom build: 2026 figures
| Criterion | Power BI (licences + integrator) | Custom dashboard |
|---|---|---|
| Implementation | AED 18,000 to 48,000 | AED 50,000 to 140,000 |
| Licences | USD 10 to 20 per user per month (Pro or Premium Per User) | None |
| Recurring cost for 25 users | about AED 15,000 to 22,000 per year | AED 7,500 to 15,000 per year (hosting, maintenance) |
| 3-year total (estimate) | AED 63,000 to 114,000 | AED 72,500 to 185,000 |
| Standard ERP connection (Dynamics, Odoo, SAP B1) | Native connectors | Specific development |
| Local software, Excel, bank statements | Possible but fragile | Designed for it, with checks |
| Licence-free mobile access (shareholders, banks) | Paid or impossible | Included |
| Timeline | 6 to 8 weeks | 8 to 12 weeks |
Simple decision rule: under 30 users, clean data in a mainstream ERP, a team already fluent in advanced Excel, choose Power BI. Over 40 users, mixed sources, a need to share with a board or lenders, custom is sturdier. Many groups combine both: a custom data warehouse, with Power BI for controllers' ad hoc analysis.
KPIs to show from version 1
| Block | Key indicators | Source |
|---|---|---|
| Activity | Revenue by subsidiary, product and emirate, variance to budget | ERP, POS |
| Profitability | Gross margin, EBITDA, profit by subsidiary | Trial balances |
| Cash | Consolidated position by bank, 13-week forecast | Bank statements, payment gateways |
| Collections | DSO by subsidiary, receivables over 90 days | ERP, CRM |
| Purchasing and stock | Stock turnover, stock-outs, supplier price drift | ERP |
| Tax | VAT at 5%, corporate tax provision at 9%, filing deadlines | Accounting |
Version 1 should fit one screen per block, with an automatic alert when a threshold is crossed, for instance consolidated cash below 30 days of fixed costs.
Mini case study
Omar, CEO of a trading group with 5 subsidiaries in Dubai and Sharjah (AED 170 million revenue), receives his figures on day 15. He chooses a custom dashboard at AED 67,000, plus AED 900 a month.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Time spent by three financial controllers: from 18 to 5 person-days a month, 13 days saved.
- Loaded cost of a person-day: about AED 1,200, so AED 187,200 a year recovered.
- A 0.5-point margin drift on a AED 36 million subsidiary spotted three months earlier: about AED 45,000 preserved.
- First-year cost: 67,000 + 10,800 = AED 77,800.
With about AED 232,000 of estimated annual gains, the project pays back in about four months and keeps paying every year.
FAQ
Does Power BI work for users travelling between countries?
Reports are online, so they need a connection. A custom dashboard can add an offline mode and automatic PDF exports emailed every morning, useful for executives on the road.
Can payment gateways be included in cash reporting?
Yes. Accounts with gateways such as Network International, Telr or Stripe export or connect by API and appear as banks in their own right in the consolidated position, refreshed at least daily.
Do we need to change ERP first?
No. Over 85% of projects connect to the existing system. An ERP change costs AED 120,000 and more, only worth it if the current tool cannot produce a reliable export.
Who maintains the tool after delivery?
Maintenance covers data-flow monitoring, new KPIs and support for AED 600 to 1,200 a month. A financial controller is trained in 2 days for routine adjustments.
What is a realistic timeline for version 1?
Allow 6 to 8 weeks for Power BI on a standard ERP, 8 to 12 weeks for a custom build with 4 to 6 data sources.
Let's scope your project. List your subsidiaries, software and banks, and we will price a Power BI or custom dashboard between AED 18,000 and 140,000, delivered in 6 to 12 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.
