How to consolidate multiple Xero organisations

Three ways to get one set of group reports from several Xero organisations, and how to avoid the mistakes that break them.

By the ConsoHQ editorial team. Updated 4 November 2026.

Why Xero needs a workaround

Xero is built around the organisation. Each one has its own subscription, chart of accounts, bank feeds, contacts, tracking categories and reports. You can hop between organisations under one login, which makes day-to-day bookkeeping easy, but no report adds them together.

That's a deliberate design choice, and it suits most businesses. The problem comes when a business grows into a group: a holding company with trading subsidiaries, a separate company that owns the property, a new subsidiary for an overseas market. Each is a separate legal entity, so each rightly has its own Xero organisation. But the owners, the board and the bank want to see the group as one.

That's what a consolidated financial statement does: it presents the parent and its subsidiaries as if they were a single business. To get there you need to add the companies together, remove transactions between them, and translate any foreign currencies. Xero leaves all three to you.

Before you start: three things to get right in Xero

Whichever method you choose, a little housekeeping in each organisation makes consolidation dramatically easier.

1. Line up your charts of accounts. If "Sales" is account 200 in one organisation and 4000 in another, every consolidation method needs a mapping between them. Where you can, use the same codes and names across organisations. Where history makes that impractical, keep a clear mapping table.

2. Create dedicated intercompany accounts. Set up accounts such as "Loan to Harbour Retail" and "Loan from Harbour UK", one per counterparty, in both organisations. Don't let intercompany items drift into general debtors or suspense. It's the single most useful thing you can do for clean eliminations. Our guide to intercompany reconciliation explains why.

3. Close every organisation to the same date. Consolidation compares like with like. If one company is fully reconciled to the 31st and another is a week behind, the group numbers will be wrong however good your method is.

Option 1: Export and combine in Excel

This is where almost every group starts, and for two similar organisations it's perfectly respectable.

1. Export each trial balance. In each organisation, run the trial balance at the period end and export it to Excel.
2. Give each organisation its own tab. Paste each export into its own tab and don't edit those tabs by hand.
3. Build a mapping table. List every account code from every organisation and map it to a group line: revenue, cost of sales, each overhead line, and each balance sheet line.
4. Sum by group line. Use SUMIF or a pivot table to bring each organisation's balances into a group column.
5. Translate currencies. If a subsidiary keeps its books in dollars or euros, translate its P&L at the average rate and its balance sheet at the closing rate. See our multi-currency guide.
6. Add elimination columns. Remove intercompany loans, intercompany sales and purchases, management charges and the parent's investment against the subsidiary's share capital. Our eliminations explainer shows the entries.
7. Check it. The group balance sheet must balance. Intercompany accounts should net to zero after elimination. The group trial balance should equal the sum of the organisation trial balances plus eliminations.

It costs nothing but time, and you control every step. The risks are the classic spreadsheet ones: a new account that isn't in the mapping table quietly drops out, a formula range stops a row short, an elimination is typed in rather than linked, and versions get emailed around. Our free management accounts template includes a group tab with checks built in if you want a head start.

Option 2: Pull Xero data into a spreadsheet automatically

Connectors such as LiveFlow refresh Xero data inside Google Sheets or Excel. That removes the export-and-paste step, which is where a lot of time and some errors come from. You still own the consolidation logic: mapping, eliminations, currency and checks. This option suits finance teams with a confident spreadsheet modeller who wants full control, and it's less suitable if nobody wants to maintain formulas.

Option 3: Connect a consolidation app

Apps from the Xero App Store connect to each organisation directly and do the consolidation in the app. Here's what that looks like with Joiin:

1. Connect each organisation. Start a free trial and authorise each Xero organisation. Joiin requests read-only access, so it can't change your books.
2. Create the group. Add the organisations that belong together and set an ownership percentage for any that aren't wholly owned.
3. Map accounts. Where organisations use different accounts, map them to a common group layout. You do this once.
4. Eliminate intercompany accounts. Filter the combined account list for your intercompany accounts and eliminate them between the right organisations, or at group level.
5. Turn on currencies if needed. On the Pro plan, each organisation is translated into your reporting currency.
6. Run reports and build a pack. Consolidated P&L, balance sheet and cash flow, with each organisation alongside, then a branded pack for the board.

After the first setup, the reports update as Xero updates. Month-end becomes a review rather than a rebuild.

Connect your Xero organisations to Joiin free

Which option is right for you?

Common mistakes, and how to avoid them

• Intercompany balances that don't agree. The most common cause of a group balance sheet that won't balance. Reconcile each pair of intercompany accounts before you consolidate.
• Eliminating sales but not costs. If the parent sells to a subsidiary, remove the revenue in one and the cost in the other. Removing only one side distorts group profit.
• Forgetting the investment. The parent's investment in a subsidiary and the subsidiary's share capital cancel out on consolidation. Leave them in and group net assets are overstated.
• Mixing period ends. Every organisation must be closed to the same date.
• Using Xero's own currency rates for translation without checking. Transaction currency in Xero and translation for consolidation are different things; see our multi-currency guide.
• Tracking categories that don't match. If you want group reporting by region or department, use identical option names in every organisation.

What about one Xero organisation for everything?

Some small businesses wonder whether they could avoid consolidation by putting several businesses in one organisation, separated by tracking categories. If the businesses are genuinely one legal entity, that's sensible. If they're separate companies, it isn't: each company needs its own records for tax, statutory accounts and banking, and mixing them creates real problems. Xero doesn't offer a way to merge organisations, so keep separate companies separate and consolidate for reporting. Ask your accountant if you're unsure.

A month-end checklist for Xero groups

• Every organisation reconciled and closed to the same date
• Intercompany balances agreed between each pair of organisations
• Any new accounts mapped to the group layout
• Exchange rates confirmed for foreign subsidiaries
• Group balance sheet balances and eliminations net to zero
• Commentary written for the board or owners

Compare consolidation apps in our best consolidation software for Xero guide.

Worked example: a three-organisation month-end

Harbour Group has three Xero organisations: Harbour UK (the parent), Harbour Retail and Harbour Ireland. In March, Harbour UK sold £100,000 of stock to Harbour Retail, all resold by month end, charged Harbour Ireland a £40,000 management fee, and has a £200,000 loan outstanding to Harbour Retail.

The £100,000 intercompany sale comes out of both revenue and cost of sales, and the £40,000 fee comes out of revenue and overheads. Group profit doesn't change, because the group can't make a profit by trading with itself, but revenue and costs are no longer inflated. On the balance sheet, the £200,000 loan receivable and payable cancel out, and the parent's investment cancels against the subsidiaries' share capital. The full balance sheet is in our worked example.

How accountants handle this for clients

If you're an accountant or bookkeeper with group clients, the same principles apply at scale. Standardise: give every group client the same intercompany account naming, the same close timetable and the same pack structure. Then the monthly consolidation becomes a repeatable process rather than a bespoke spreadsheet per client. Firms that do this well often turn group management accounts into a fixed-fee monthly service. Our page for accountants and bookkeepers covers the practice angle, and the best reporting software for accountants compares tools with multi-client access.

Frequently asked questions