Multi entity consolidation
Each entity's ledger mapped to one group chart of accounts.
Platform / Financial consolidation
AIchieve for Financial consolidation
Multi entity · Intercompany · FX
One group view, across every entity and currency
Each entity's ledger is consolidated with eliminations, currency translation and adjustments applied, and every number stays traceable to the entity it came from. The group view is there as soon as the entities close.
Connects to each entity's ERP, in any currency.
← Back to BoardsBoards/Group Consolidation
Consolidated P&L · September
Dashboards + AI Overview
Scenario: ActualsEntity: GroupPeriod: YTD Sep FY26Currency: GBPRate: Average+
4 entities, 3 currencies
£1.85M
Group revenue YTD
Intercompany
−£117K
Revenue eliminated
14 of 15 matched
1
Pair to review
Translated at average rate
38.4%
Group gross margin
Consolidation by Entity
£K · translated from local ledgers · eliminations applied · one intercompany pair to review
| £K · YTD Sep | UK Ltd | KSA LLC | Benelux BV | Ireland Ltd | Eliminations | Group |
|---|---|---|---|---|---|---|
| P&L Revenue | 902 | 641 | 322 | 104 | −117 | 1,852 |
| P&L Cost of sales | 530 | 404 | 227 | 63 | −83 | 1,141 |
| P&L Gross margin | 372 | 237 | 95 | 41 | −34 | 711 |
| P&L Operating costs | 168 | 120 | 58 | 25 | — | 371 |
| P&L EBITDA | 204 | 117 | 37 | 16 | −34 | 340 |
| Margin | 41.2% | 36.9% | 29.4% | 39.0% | 38.4% |
AI Overview
ModelerSeptember consolidated across four entities and three currencies. 14 of 15 intercompany pairs matched automatically. The UK to Ireland pair is £3K apart and needs a decision.
Review pairOpen statements
- Ledgers synced from each entity
- Eliminations and FX applied
- 1 intercompany pair to review
What is included
Everything the group close needs
From entity ledgers to consolidated statements, with the audit trail kept at every step.
Intercompany matching
Pairs matched on amount and reference, with tolerances you set.
Eliminations
Revenue, cost and balances eliminated automatically for matched pairs.
Currency translation
Average rate for the P&L, closing rate for the balance sheet, difference to reserves.
Adjustments and journals
Group adjustments posted with an owner, a reason and an audit trail.
Consolidated statements
Group P&L, balance sheet and cash flow, by entity and in total.
See it in AIchieve
From entity ledgers to one group view
Intercompany
Intercompany matched before anyone asks
Pairs are matched on amount and reference as entities close. Matched pairs are eliminated, and anything outside your tolerance is flagged with its likely cause.
- Matched on amount and reference
- Tolerances you set
- Likely cause shown for every break
← Back to BoardsBoards/Intercompany
Intercompany Matching
Dashboards + AI Overview
Scenario: ActualsEntity: All pairsPeriod: Sep FY26Type: All+
Revenue and balances
15
Intercompany pairs
On amount and reference
14
Matched automatically
UK → Ireland
£3K
Difference to resolve
YTD
£117K
Revenue eliminated
Intercompany Pairs
£K · matched on amount and reference · tolerances you set · one pair outside tolerance
| Pair | Type | Seller £K | Buyer £K | Difference | Rule | |
|---|---|---|---|---|---|---|
| IC-01 UK → KSA | Management fee | 48.0 | 48.0 | 0.0 | Auto | Matched |
| IC-02 UK → Benelux | Goods | 33.0 | 33.0 | 0.0 | Auto | Matched |
| IC-03 UK → Ireland | Recharge | 17.0 | 14.0 | 3.0 | Tolerance £1K | To review |
| IC-04 KSA → Benelux | Goods | 11.0 | 11.0 | 0.0 | Auto | Matched |
| IC-05 Benelux → Ireland | Goods | 8.0 | 8.0 | 0.0 | Auto | Matched |
| Revenue pairs | 117.0 | 114.0 | 3.0 | 15 pairs in total |
AI Overview
Modeler14 of 15 pairs matched on amount and reference. Ireland booked the September recharge at £14K against £17K in the UK, which looks like a missing invoice line.
Post adjustmentAsk Ireland
- Matched on amount and reference
- Eliminations posted for matched pairs
- 1 pair outside tolerance
Currency
Every currency translated the way your auditors expect
Each entity reports in its own currency. The P&L is translated at the average rate, the balance sheet at the closing rate, and the difference goes to the translation reserve, with the rates kept for every period.
- Average and closing rates by period
- Translation difference to reserves
- Rates kept for every period
← Back to BoardsBoards/Currency Translation
Currency Translation
Dashboards + AI Overview
Scenario: ActualsEntity: AllPeriod: Sep FY26Rates: Loaded 30 Sep+
Average and closing
2
Rate sets per currency
To the translation reserve
−£11K
Translation difference
Riyal against sterling
−1.4%
September movement
Before eliminations
£1.97M
Revenue translated
Translation by Entity
Local ledgers translated · P&L at average rate, balance sheet at closing rate · difference to reserves
| Entity | CCY | Revenue local K | Average | Revenue £K | Net assets local K | Closing | Translation £K |
|---|---|---|---|---|---|---|---|
| UK Ltd | GBP | 902 | 1.000 | 902 | 1,240 | 1.000 | 0 |
| KSA LLC | SAR | 3,024 | 0.212 | 641 | 2,400 | 0.209 | −7 |
| Benelux BV | EUR | 373 | 0.863 | 322 | 520 | 0.858 | −3 |
| Ireland Ltd | EUR | 121 | 0.863 | 104 | 180 | 0.858 | −1 |
| Group | 1,969 | −11 |
AI Overview
AnalystThe riyal weakened 1.4% against sterling in September, which takes £7K off KSA net assets in sterling. It goes to the translation reserve, not the P&L.
View rate tableOpen balance sheet
- Rates loaded for each period
- Average and closing applied by line
- Difference posted to reserves
Agents
Three agents working through the close
They map the ledgers, check the result and consolidate the plan the same way, so the group view is ready when the entities are.
Modeler
Builds the group structure
Modeler · 06:00
September consolidated across 4 entities and 3 currencies. 14 of 15 intercompany pairs matched automatically.
- Maps every ledger. Each entity's accounts to the group chart.
- Sets up eliminations. From your intercompany relationships.
- Adds entities. A new entity joins without a rebuild.
Analyst
Checks the result
Analyst · 06:03
Ireland booked the September recharge at £14K against £17K in the UK. Looks like a missing invoice line.
- Finds breaks. Intercompany differences and their likely cause.
- Explains FX. How much movement came from currency.
- Flags anomalies. Entries out of line with the entity's history.
Planner
Consolidates the plan too
Planner · 06:11
A further 3% fall in the riyal would take £30K off FY27 group revenue and £5K off EBITDA.
- Group budget and forecast. Consolidated the same way as actuals.
- Currency scenarios. The effect of rate moves on the group.
- Entity changes. New entities modelled before they join.
One connected cycle
Part of one finance cycle, on one model
Every capability works on the same model and the same live data, so the budget, forecast, close and board pack never need reconciling with each other.
Questions
What finance teams ask about consolidation
Anything not covered here, we would rather answer on your own numbers.
Ready when you are
Bring last month's consolidation workbook.
Your own entities and your own ledgers. See the group consolidated, intercompany matched and currencies translated, with every number traceable to the entity it came from.
✓ Each entity keeps its ERP
✓ Your data, not a sample dataset
✓ Every number traceable