The verdict in three sentences
When financial controllers spend 6 days a month copying 40 Excel files, the executive team steers two weeks late and cannot verify the numbers. Automating subsidiary reporting (collection, checks, consolidation, dashboard) costs between 120,000 and 300,000 AED in 2026 for a 3 to 4 month project, plus BI licences of 10 to 20 USD per user per month. The expected result is a management close on day 5 instead of day 15, with variances explained before the executive committee.
The diagnosis: 40 files, 4 countries, 6 days
The pattern is common for a Dubai-headquartered group that has expanded into Saudi Arabia, Oman and Kenya: each subsidiary keeps its books under IFRS in its own system (SAP Business One, Odoo, Zoho Books, sometimes a local tool), then sends head office an Excel reporting pack. Formats drift, charts of accounts diverge and currencies multiply (AED, SAR, OMR, KES).
| Monthly step | Current situation | After automation |
|---|---|---|
| Collecting 40 files | 2 days of chasing | Automatic extraction on day 2 |
| Formatting and account mapping | 2 days | Automatic (mapping table) |
| Consistency checks | 1 day, partial | 120 automatic rules |
| Intercompany eliminations | 1 day | Automatic matching |
| FX translation to AED | Half a day | Automatic, central rates table |
| Dashboard production | 1 to 2 days | Continuously updated |
| Availability for the board | Day 15 | Day 5 |
| Controlling team time | 12 person-days | 2 to 3 person-days |
Time saved matters, but the real benefit is reliability: every dashboard figure traces back to a source entry, which changes the conversation with subsidiary managers.
Architecture and budget
The typical solution has three layers: connectors that extract trial balances and management data from each accounting system, a data warehouse that maps them to the group reporting chart, and a dashboard (Power BI, Metabase or Looker Studio) with views by subsidiary, by country and consolidated in AED.
| Item | 2026 market budget (AED, ex VAT) | Timeline |
|---|---|---|
| Scoping, group reporting chart, mapping | 20,000 to 45,000 | 3 weeks |
| Connectors to 7 accounting systems | 30,000 to 90,000 | 4 to 6 weeks |
| Data warehouse and control rules | 30,000 to 70,000 | 4 weeks |
| Intercompany eliminations, FX, consolidation | 15,000 to 45,000 | 2 weeks |
| Board dashboard and subsidiary views | 25,000 to 50,000 | 3 weeks |
| Typical total project | 120,000 to 300,000 | 3 to 4 months |
| BI licences (15 users) | 150 to 300 USD per month | Depends on tool |
For reference, Kolonell prices this type of project between its medium application band (4,000,000 to 7,000,000 FCFA, i.e. 6,100 to 10,670 EUR) and its complex band (7,000,000 to 15,000,000+ FCFA, i.e. 10,670 to 22,870+ EUR), depending on the number of source systems. Monthly maintenance then runs at 35,000, 75,000 or 120,000 FCFA depending on service level, useful because each new subsidiary or system change requires a new connector.
Pitfalls to avoid
Do not start with the dashboard: without a common reporting chart, it will just show wrong numbers faster. Fix one FX rate policy (closing vs average) for the whole group from day one. Keep a controlled manual upload route for subsidiaries whose system cannot be accessed automatically.
Mini case study
Omar, group financial controller of a 7-subsidiary distribution group in Dubai, consolidates 40 files a month with one colleague. Illustrative scenario: project at 200,000 AED, BI licences at 225 USD a month (about 830 AED) and maintenance at 2,500 AED a month, i.e. about 240,000 AED in year one.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Time saved: 9.5 person-days a month x 12 = 114 days at 1,200 AED a day, i.e. about 137,000 AED. Decision effect: on working capital of 60 million AED, spotting an inventory or receivables drift ten days earlier and cutting it by 1% frees 600,000 AED of cash. The project pays back within the year as soon as that single lever is used.
FAQ
How much does automating subsidiary reporting cost in Dubai in 2026?
Budget 120,000 to 300,000 AED ex VAT for 5 to 10 subsidiaries, plus 10 to 20 USD per user per month in BI licences. The main cost driver is the number of different accounting systems to connect.
Do subsidiaries need to change accounting systems?
No, automation plugs into what exists. A system change is only justified if a subsidiary's tool allows no extraction, which rarely concerns more than one subsidiary in seven.
Does it handle IFRS and multiple currencies?
Yes, mapping runs from each subsidiary's IFRS accounts to the group reporting chart, with FX translation from a central rates table. Management reports stay separate from statutory financial statements.
How quickly do we reach day 5?
Usually from the second or third close after go-live, i.e. 4 to 5 months after project kickoff.
Which BI tool should we pick?
Power BI at about 14 USD per user per month suits most groups already on Microsoft 365. Self-hosted Metabase removes licences but needs slightly more maintenance.
Let's scope your project. Tell us your number of subsidiaries, countries and accounting systems: we will price a scope, an indicative budget and a schedule up to the first day-5 close. 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.
