The verdict in three sentences
For a group of 7 subsidiaries in Dubai whose financial controller consolidates 7 Excel files every month in 6 working days, automated collection and consolidation costs 60,000 to 180,000 AED as a custom build (2026 market estimate), versus 15,000 to 40,000 EUR per year (about 60,000 to 160,000 AED) for an off-the-shelf consolidation tool, with 8 to 12 weeks to implement. The realistic goal is to bring the management close down to 2 days through consistency checks run as soon as data is submitted. The choice between a market tool and custom code depends mainly on how diverse the subsidiaries' accounting systems are and whether statutory consolidation is needed.
Where the 6 closing days come from
Each subsidiary sends its own Excel file with its own tabs, its own account labels and sometimes a sign error. The controller spends 2 days chasing and correcting, 2 days reconciling intercompany flows and 2 days producing the report for group management. The high-value work, variance analysis, comes last, when the executive committee is already waiting.
An automated solution replaces file emails with a submission portal (or a direct extract from accounting systems), applies a common management chart of accounts, runs checks and blocks any inconsistent data before it enters consolidation.
| Automated consistency check | Rule applied | Action on mismatch |
|---|---|---|
| Trial balance | Total debits = total credits | Submission rejected, message to subsidiary |
| Intercompany matching | Subsidiary A receivable = subsidiary B payable, 1,000 AED tolerance | Alert to both subsidiaries |
| Account mapping | Every local account mapped to the group management chart | Unmapped account flagged |
| Abnormal variance | Change above 25% on a line versus prior month | Mandatory subsidiary comment |
| Cash consistency | Declared bank balance = imported statement | Blocking above 500 AED |
| Headcount and payroll | Average cost per employee within plus or minus 15% | Alert to the controller |
| Completeness | All tabs and KPIs filled in | Automatic reminder at day 2 |
Custom build or market consolidation tool
| Criterion (2026 order of magnitude) | Market consolidation tool | Custom development |
|---|---|---|
| Entry cost | 10,000-30,000 EUR of configuration | 60,000-180,000 AED project |
| Recurring cost | 15,000-40,000 EUR per year in licenses | Hosting and maintenance, 9,000-27,000 AED per year |
| Statutory consolidation (eliminations, minorities) | Native | To be built if needed, extra cost |
| Fit with local accounting systems | Generic connectors, exports required | Connectors written for each system |
| Time to implement | 10 to 16 weeks | 8 to 12 weeks |
| Custom management reporting | Good, within tool limits | Fully tailored to the group |
| Dependency | Vendor and certified integrator | Provider, code handed to the group |
If the main need is monthly management reporting and statutory consolidated accounts remain with the audit firm, custom code is often cheaper over three years. At Kolonell, this type of platform falls within the medium application grid (4,000,000-7,000,000 FCFA, i.e. 6,100-10,670 EUR) or the complex grid (7,000,000-15,000,000+ FCFA, i.e. 10,670-22,870 EUR) depending on the number of connectors.
What the project must deliver
A submission portal per subsidiary with separate access rights, a common management chart of accounts and a mapping table the controller can maintain without a developer, the check engine above, a group dashboard with budget versus actual variance analysis, and export to Excel and PowerPoint for the executive committee. Payroll data falls under the UAE Personal Data Protection Law (or DIFC and ADGM rules for entities in those free zones): access to payroll figures must be logged.
Mini case study
Omar, financial controller of a group of 7 subsidiaries in Dubai, ties up 2 people at head office for 6 days each month and 7 subsidiary accountants for 2 days. After automation, head office drops to 2 days and subsidiaries to 1 day. Annual gain: 2 × 4 × 12 = 96 days at head office and 7 × 1 × 12 = 84 days in subsidiaries, i.e. 180 days. At an average loaded cost of 1,200 AED per day, that is 216,000 AED per year. With a 140,000 AED project and 20,000 AED of annual maintenance, payback comes in under 9 months on time saved alone. Compared with a market tool at 25,000 EUR per year, about 100,000 AED, the custom build is also cheaper from the first year of license avoided.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
How long does it take to go from 6 to 2 closing days?
The project takes 8 to 12 weeks, then 2 to 3 closes to stabilise mapping and checks. A 2-day close is a realistic target by month four.
Do subsidiaries need to change accounting software?
No. The trial balance is extracted from each system, by API or standard export. Plan 1 to 2 weeks of work per distinct system.
Can it handle multiple currencies?
Yes, if a subsidiary reports in SAR, EGP or EUR, conversion uses the closing or monthly average rate, configurable. Translation differences are isolated on a dedicated line.
Who maintains the account mapping table?
The financial controller, through a simple interface. A new local account is mapped in under 2 minutes, without technical help.
Do we need to replace Excel completely?
No. Excel remains the analysis and presentation tool, but it is no longer the collection channel. The dashboard exports tables in one click.
Let's scope your project. Describe your subsidiaries, their accounting systems and your closing calendar: we will scope the perimeter, budget and an 8 to 12 week plan. 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.
