The verdict in three sentences
A group of 5 subsidiaries headquartered in Dubai, with entities in the UAE, Saudi Arabia and Egypt, that consolidates monthly reporting from emailed Excel files takes 12 days to produce figures management already considers stale. By connecting Power BI to the subsidiaries' Sage and Odoo ledgers, with a harmonised group chart of accounts and automated consolidation rules, the management close drops to 4 days. The project costs AED 75,000 to 170,000 depending on the number of sources and depth of analysis, with Power BI Pro licences at USD 14 per user per month.
Why Excel consolidation costs more than you think
In a typical Gulf group, each subsidiary runs its own ledger: Sage 300 in Dubai, Odoo in Riyadh, sometimes a local package in Cairo. All report under IFRS, but with different sub-accounts, analytical dimensions and labels. The head office controller receives five workbooks, eliminates intercompany items, converts SAR and EGP into AED, applies UAE corporate tax and Saudi zakat adjustments, then rebuilds a consolidated P&L. Every month, 2 to 3 people spend most of their time on it.
| Indicator (5 subsidiaries, 3 countries) | Excel reporting | Automated Power BI | 2026 order of magnitude |
|---|---|---|---|
| Management close | 12 days | 4 days | Decisions taken 8 days earlier |
| Controlling time per month | 25 to 35 person-days | 8 to 12 person-days | 15 to 20 days freed for analysis |
| Unreconciled intercompany variances | 3 to 8% of flows | Under 1% | Reliable eliminations |
| Formula or version errors | Frequent, untracked | Single, versioned model | Board confidence |
| Available KPIs | 10 to 15, static | 40 to 60, filterable by entity | Steering by margin, customer, product |
| Management access | Monthly PDF | Mobile dashboards | Read live in meetings |
For a group with AED 150 to 400 million of revenue, gaining 8 days on the close means reacting a month earlier to a margin or cash drift.
Architecture and project budget
The project rests on four layers. Connectors extract trial balances and general ledgers from Sage and Odoo every night. A mapping table brings all sub-accounts into a group IFRS chart of accounts. A data warehouse (Azure SQL in the UAE region or PostgreSQL) applies intercompany eliminations and currency conversions. Power BI delivers statements and dashboards with row-level security per subsidiary.
| Component | Content | Indicative budget | Timeline |
|---|---|---|---|
| Scoping and group chart of accounts | CFO workshop, IFRS mapping table, analytical dimensions | AED 9,000 to 18,000 | 2 to 3 weeks |
| Sage and Odoo connectors | Automated extraction of balances, ledgers, counterparties | AED 18,000 to 42,000 | 3 to 5 weeks |
| Warehouse and consolidation rules | Intercompany eliminations, multi-currency AED, SAR, EGP, USD | AED 24,000 to 55,000 | 4 to 6 weeks |
| Power BI dashboards | P&L, balance sheet, cash, margins, budget vs actual | AED 18,000 to 42,000 | 3 to 5 weeks |
| Training and handover | Controllers, subsidiary CFOs, documentation | AED 3,000 to 12,000 | 1 to 2 weeks |
| Power BI Pro licences (20 users) | USD 14 per user per month | About AED 1,030 per month | Recurring |
A project for 5 subsidiaries and two source systems usually lands between AED 75,000 and 110,000. With additional sources (payroll, inventory, CRM) or statutory consolidation, it approaches AED 170,000. For a simpler core or a custom reporting application, Kolonell works from 2.5 to 15M+ FCFA (about AED 16,500 to 99,000+) depending on complexity, with the rest quoted separately.
Conditions for success
The first workstream is not technical: you need a group chart of accounts approved by subsidiary CFOs and a common close calendar (entries complete at D+2, intercompany reconciled at D+3). Next, plan an on-premises data gateway if a ledger is not cloud-accessible, and check data residency rules for Saudi entities. Finally, keep the model alive: one owner per subsidiary, a monthly committee and a change log.
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.
Omar, CFO of a 5-subsidiary distribution group based in Dubai, employs three controllers at AED 22,000 monthly cost each, spending 70% of their time on consolidation, or AED 46,200 a month. After an AED 95,000 project and AED 1,030 of monthly licences, consolidation time falls to 25%, or AED 16,500. Direct gain: about AED 28,700 a month, payback in under 4 months. The real benefit lies elsewhere: seeing on the 4th of the month that a subsidiary has slipped 2 margin points, he corrects course before quarter end.
FAQ
Can Power BI connect to Sage and Odoo?
Yes, Sage through its SQL Server database and Odoo through its API or PostgreSQL database. A free data gateway is installed if the server is on premises.
How much do Power BI licences cost?
Power BI Pro costs USD 14 per user per month, about AED 51. For 20 users, the budget is about AED 1,030 a month.
Is IFRS consolidation handled natively?
No, but the project's mapping table brings all sub-accounts into the group chart. It takes 2 to 3 weeks to build with subsidiary CFOs.
What budget should a 5-subsidiary group plan?
Between AED 75,000 and 170,000 depending on sources and depth of analysis. A core with two source systems runs around AED 75,000 to 110,000.
How long until the close reaches 4 days?
The project takes 10 to 16 weeks; a 4-day close is usually reached in the third month of operation.
Let's scope your project. Tell us your subsidiaries, their accounting systems and priority KPIs: we will price the scope, indicative budget and rollout schedule. 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.
