The verdict in three sentences
A custom financial consolidation and reporting application for a London-based group with 6 subsidiaries costs 85,000 to 200,000 GBP in 2026, with a 5-month timeline to the first live close. The main gain is time: a monthly consolidation that takes 12 days in Excel drops to 4 days once trial balance collection, IFRS adjustments, intercompany eliminations and currency translation are automated. Enterprise consolidation suites are powerful, but their annual licences often exceed what a mid-sized group needs to spend.
Why spreadsheet consolidation costs 12 days a month
In a group with subsidiaries in the UK, Ireland, the Netherlands and the US, each local accountant sends a trial balance in a different format, sometimes after the 10th of the month. The head office team rekeys, matches intercompany balances, fixes chart of accounts mismatches, translates USD and EUR ledgers under IAS 21, and rebuilds dashboards by hand. Every step is a source of error, and the board receives last month's numbers two weeks late.
| Close step | In Excel | With the app | Gain |
|---|---|---|---|
| Collecting 6 subsidiary trial balances | 3 to 4 days | 0.5 day (import or ERP API) | 3 days |
| Mapping to the group chart of accounts | 2 days | Automatic, blocking checks | 2 days |
| Intercompany matching and elimination | 3 days | 1 day (differences listed by entity pair) | 2 days |
| IFRS adjustments and currency translation | 2 days | 1 day (template entries, rate tables) | 1 day |
| Dashboards and board pack | 2 days | 0.5 day (automatic generation) | 1.5 days |
| Total monthly close | 12 days | 4 days | 8 days |
The app must also keep the audit trail auditors expect: who changed which adjustment entry, when and why. For annual consolidated accounts under IFRS 10, that traceability saves several days of audit fieldwork.
2026 budget: options compared
Custom figures are 2026 estimates for a vendor with a project manager and a finance functional consultant. Suite licences are estimates for 6 entities and 10 users.
| Option | Setup | Annual cost | 3-year total | Timeline |
|---|---|---|---|---|
| Improved Excel + Power BI | 15,000 to 30,000 GBP | 10,000 GBP | ~52,500 GBP | 1 to 2 months |
| Custom Core (collection, mapping, eliminations) | 85,000 to 110,000 GBP | 14,000 GBP | ~140,000 GBP | 4 months |
| Custom Standard (+ IFRS adjustments, FX, dashboards) | 120,000 to 160,000 GBP | 18,000 GBP | ~194,000 GBP | 5 months |
| Custom Advanced (+ budgeting, ERP APIs, disclosure notes) | 170,000 to 200,000 GBP | 24,000 GBP | ~257,000 GBP | 6 months |
| Enterprise consolidation suite | 80,000 to 150,000 GBP | 60,000 to 150,000 GBP | 260,000 to 600,000 GBP | 6 to 9 months |
The Advanced level makes sense when the group wants budget and actuals in one tool or needs draft disclosure notes generated from the consolidated ledger.
Conditions for success
Three points drive the real timeline. The group chart of accounts must be signed off by finance before development, or mapping gets done twice. Subsidiaries must be able to export trial balances from their accounting systems (Xero, Sage, NetSuite, Dynamics) in one format, which often takes a month to prepare. Finally, plan a parallel close: two months where Excel and the app run side by side to reconcile differences before switching over.
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.
Tom, group finance director of a 6-subsidiary food business headquartered in London, consolidates in 12 days each month with a team of 4. The Standard app, billed at 140,000 GBP, brings the close down to 4 days. Gain: 8 days × 4 people = 32 person-days a month. At a loaded cost of 450 GBP a day, the saving reaches 14,400 GBP a month, or 172,800 GBP a year. With 18,000 GBP of annual run cost, the project pays back in about 11 months, and the board receives numbers on the 5th instead of the 15th, which also helps with lender covenant reporting.
FAQ
How much does a custom consolidation app cost in London?
Between 85,000 and 200,000 GBP in 2026 for 4 to 8 subsidiaries, depending on adjustments and integrations. The most common scope sits around 140,000 GBP.
Does the app handle IFRS and currency translation?
Yes, the group chart of accounts, adjustment entries and IAS 21 translation (closing rate for the balance sheet, average rate for P&L) are configured. Specific adjustments such as IFRS 16 leases are defined in workshops during the first 3 weeks.
How long until the first automated close?
About 5 months for a Standard scope, including 2 months of parallel close. Time savings show from the third month.
Do subsidiaries need to change accounting software?
No, the app imports trial balances from existing tools. A common export format is enough, and an API connector can be added for 8,000 to 15,000 GBP per ERP.
Will auditors accept this kind of tool?
Yes, provided the audit trail is complete and consolidation entries can be exported. It usually cuts 2 to 4 days from the consolidated accounts review.
Let's scope your project. Describe your scope (number of subsidiaries, accounting systems, adjustments) and we will price a consolidation app, first close in 5 months. 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.