Thred

AI financial consolidation: intercompany, eliminations and FX for groups on Xero and Exact Online

Manoj Tutika · Published 16 November 2026 · Last checked 16 November 2026

Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.

Book a demo

What does AI financial consolidation actually do?

A group close has two kinds of work. The first is mechanical: pull a trial balance from every entity, map it to a group chart of accounts, find the intercompany invoices and balances, book the eliminations, translate the foreign entities and roll it all up. The second is judgement: what to do when UK Ltd says its Dutch subsidiary owes £44,720 and the subsidiary says it owes nothing, whether an average rate is still fair after a volatile quarter, and how to treat a part-year acquisition.

AI financial consolidation hands the first kind to agents and makes the second kind faster. The agents work in each entity's ledger as the month goes, so by the time the group close starts, intercompany is already matched and every remaining difference arrives with an explanation and the documents behind it.

Why is consolidation hard on Xero and Exact Online?

Most groups of SMEs do not run a consolidation system. They run one ledger per entity and a spreadsheet on top.

On Xero, every organisation is its own file. Xero has said that consolidated reporting is not currently planned (Xero response of 23 July 2025, checked 16 November 2026), so groups use a spreadsheet or an app from the Xero App Store.

On Exact Online, the Premium edition lets you work across several administrations from one place, and Exact says you can produce a cross-administration general ledger analysis, balance sheet or profit and loss from a central dashboard. For full consolidation with eliminations, currency translation and sub-consolidations, Exact sells a separate product, Exact Consolidation, powered by LucaNet (checked 16 November 2026).

Either way, the report is only as good as what sits in each ledger. If one side of an intercompany recharge is booked and the other is not, no consolidation tool can fix that. It can only show you the gap.

How do intercompany matching and eliminations work?

Under IFRS 10 and FRS 102 the group is presented as one economic unit, so anything the entities do with each other has to come out: intercompany sales and costs, receivables and payables, loans, interest and dividends, and the parent's investment against the subsidiary's share capital.

The work, step by step:

  1. Tag every intercompany relation in each ledger, so the counterparty entity is known on every line.
  2. Each month, compare both sides: invoices issued against invoices received, and balances owed against balances owing, in the same currency.
  3. Explain every difference. The usual causes are an invoice booked in one entity but not yet in the other, a payment in transit, a different exchange rate on each side, or a recharge one side disputes.
  4. Correct the cause in the entity ledger, not in the consolidation. That keeps the entity accounts right as well.
  5. Book the eliminations in the consolidation layer: revenue against cost, receivable against payable, investment against equity.

A worked example in pounds

UK Ltd owns 100% of NL BV, which reports in euros. UK Ltd invoices NL BV a management fee of €70,000 during the year, booked in UK Ltd at £59,500. The illustrative rates are an average of €1 = £0.85 and a closing rate of €1 = £0.86. NL BV's profit and loss is translated at the average rate, its balance sheet at the closing rate. At year end NL BV still owes €52,000 of fees, which is £44,720 at the closing rate on both sides.

Consolidating UK Ltd and NL BV, with the elimination column (£, illustrative rates)
LineUK LtdNL BV (translated)EliminationsGroup
Revenue1,200,000510,000(59,500)1,650,500
Cost of sales(700,000)(306,000)0(1,006,000)
Overheads(300,000)(119,000)59,500(359,500)
Operating profit200,00085,0000285,000
Intercompany receivable44,7200(44,720)0
Intercompany payable044,720(44,720)0

Two things to notice. The elimination does not change group profit, because the fee is income in one entity and a cost in the other. And the receivable and payable only cancel because both sides used the same rate on the same balance. If NL BV had booked the last invoice a month late, the columns would not tie, and that difference is exactly what an agent should find and explain before the close.

How does FX translation fit in?

Translation follows the rules in FRS 102 Section 30 (and IAS 21 for IFRS reporters). Assets and liabilities go in at the closing rate. Income and expenses go in at the rate on the transaction date, where an average rate for the period is an accepted approximation unless rates moved sharply. The difference goes to other comprehensive income, and many groups show it as a translation reserve.

Continue the example. NL BV started the year with net assets of €500,000, which were £420,000 at the opening rate of £0.84. It made a profit of €100,000, which is £85,000 at the average rate. At year end its net assets of €600,000 are £516,000 at the closing rate. The translation difference is £516,000 minus £420,000 minus £85,000, a gain of £11,000 in other comprehensive income. It is not trading profit, and it should not reach the operating line.

FX on intercompany balances inside the entities is a different matter. A euro loan from UK Ltd to NL BV creates real exchange gains and losses in UK Ltd's own profit and loss, which the consolidation keeps unless the loan forms part of the net investment in NL BV.

Where AI helps, and where the controller decides

Splitting the group close between agents and the controller
TaskAgentsController
Pulling trial balancesRead every entity ledger on a scheduleConfirms the entity list and periods
Group chart mappingProposes mappings for new accountsApproves the group structure
Intercompany matchingMatches invoices and balances both ways, every dayDecides on disputed or unexplained items
EliminationsPrepares the elimination entries with the evidenceReviews and approves
FX translationApplies closing and average rates, computes the reserveSets rate policy and sources
Ownership changesFlags acquisitions, disposals and minority stakesDecides the accounting treatment
Group reportingExplains movements against last month and budgetSigns off and presents

The line is the same as for any accounting work. Agents take what is high volume and checkable. The controller keeps policy, estimates and anything that needs a view on substance over form.

What do Thred's agents do with consolidation work?

Thred is a team of AI agents that handle daily work for finance teams and accounting firms, on your existing accounting software, under the rules your team sets. For a group, that means the agents work in every entity ledger at once.

The Bookkeeper keeps the record up to date in each entity, so both sides of an intercompany recharge are booked in the same period. On Exact Online, The Bookkeeper scans each administration for intercompany mismatches, suspense balances, duplicates and VAT-code errors, and The Accountant runs the period checklist per administration. The Accountant prepares the elimination and correction entries, which appear as approval cards in Exact Online before anything is posted. The Treasurer keeps the group cash view current across entities and currencies. The Analyst monitors performance and variance at group level and explains what moved. The Connector finds context in your connected tools, such as the email where a recharge was agreed. The CFO is your finance lead, when you have none, and brings it together for the board.

On Exact Online the agents read and write journal entries, relations and matches with two-way sync. On Xero, Thred's Xero agent reads and creates records in each organisation, so intercompany is clean before your consolidation app or spreadsheet runs. See Thred Layer for how the agents work on your ledgers.

Frequently asked questions

What is an AI consolidation tool?

It is software that does the repetitive parts of a group close for you. It pulls trial balances from each entity, matches intercompany balances and transactions, proposes elimination entries, translates foreign entities and shows the differences it could not explain. The better tools act inside your ledgers and leave a trail for every number.

Can Xero do multi-entity consolidation?

Not natively. Each Xero organisation reports on its own, and Xero said on 23 July 2025 that work on consolidated reporting is not currently planned (checked 16 November 2026). Groups on Xero combine exports in a spreadsheet or use a consolidation app from the Xero App Store, with agents keeping each organisation clean underneath.

Does Exact Online have consolidation?

Exact Online Premium lets you work across several administrations and Exact says it can produce a cross-administration balance sheet and profit and loss from one dashboard. Full consolidation with eliminations and currency translation is a separate product, Exact Consolidation, powered by LucaNet (checked 16 November 2026).

Can intercompany elimination be automated?

Mostly, yes. Matching invoices and balances between entities and booking the mirror elimination is rule-bound work. What cannot be automated is the judgement when the two sides disagree: a missing invoice, a disputed recharge or a timing difference. An agent should find and explain those, and a person should decide.

What is the best consolidation software for SMEs?

For a group of two to ten entities, the bottleneck is rarely the report. It is clean, matched intercompany in every ledger before the report runs. Start with the ledgers you have, get intercompany matching right every month, and only then pick a reporting layer, whether a spreadsheet, a Xero app or Exact Consolidation.

Which exchange rates do you use to translate a foreign subsidiary?

Under FRS 102, assets and liabilities go in at the closing rate and income and expenses at the rate on the transaction date, where an average rate for the period is an accepted approximation unless rates moved sharply. The resulting difference goes to other comprehensive income, often shown as a translation reserve.

Sources

  1. Xero Product Ideas, consolidate multiple Xero organisations (Xero response 23 July 2025)
  2. Exact, meerdere administraties en consolidatie in Exact Online
  3. Exact, Exact Consolidation (powered by LucaNet)
  4. ICAEW, foreign currency translation under FRS 102 (helpsheet)
  5. HMRC Corporate Finance Manual CFM26220, closing rate/net investment method
  6. IFRS Foundation, IFRS 10 Consolidated Financial Statements

Read next

Where Thred comes in

Thred Layer

Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo