Xero Multi-Entity Consolidation: What Native Xero Gives You, And What It Doesn't

If your group runs more than one entity on Xero, you already know how this ends. Navigating across Xero organisations to export P&L. Piecing them together in one spreadsheet. Reusing a template someone built two years ago that nobody fully trusts. An eliminations tab held together with SUMIFs and a prayer. And a group P&L that's accurate enough — until someone asks a real question about it.

Multi-entity consolidation is one of those problems that quietly eats a finance function. Each individual entity is fine. The data is in Xero. The chart of accounts isn't even that bad. But the moment you need a single, clean group view — with intercompany eliminated, comparatives sensible, and the layout matching how the business is actually run — you're back in Excel.

This post is about why that happens, what Xero does and doesn't give you natively, and what a usable group reporting setup actually requires.

What "consolidation" actually means in a Xero group

Before getting into Xero specifics, it's worth being precise about what consolidation is. For most groups it's three jobs stacked on top of each other:

Aggregation. Adding up the same line item across entities so the group P&L and balance sheet show combined revenue, combined expenses, combined assets, combined liabilities.

Elimination. Removing intercompany transactions and balances so they don't get double-counted. Sales from one entity to another, the receivable on one side and the payable on the other, dividend distributions inside the group, intercompany loans — none of these belong in a group view, but all of them sit on the individual entity ledgers.

Translation. If the entities sit in different currencies, restating each into the group's reporting currency at the appropriate rates. Profit and loss usually at average rates, balance sheet at closing rates, equity at historical, and the FX difference dropped into a translation reserve.

If your group is small and single-currency with no intercompany activity, consolidation is just aggregation. If it's a larger group with cross-charges, intercompany loans, and multi-currency, all three jobs apply, and they need to agree with each other.

What Xero gives you natively

Xero's consolidation story is short. There's one native path, and it only helps a narrow set of groups.

Group reports inside a single organisation. If your entities all sit inside one Xero organisation — distinguished only by tracking category — you can build a fairly good consolidated view using tracking categories and report layouts. This works for some groups, particularly franchise-style setups where each "entity" is really a location on the same legal entity. But the moment you have separate Xero organisations (different countries, different legal entities, different tax jurisdictions), tracking categories don't help you.

For separate Xero organisations — which is most real groups — there is no native consolidation feature at all. You'll hit walls quickly:

• No cross-organisation aggregation. Each Xero organisation produces its own P&L and balance sheet. There's no built-in way to combine them into a single group report.
• No intercompany eliminations. Even if you've combined the data elsewhere, Xero won't remove intercompany sales, intercompany payables, or intercompany loans. You either eliminate manually after the fact, or you tag intercompany accounts in some convention and eliminate by hand.
• No account mapping. If different entities have different chart-of-account structures — and almost every group with separate jurisdictions does — there's no native way to map them onto a common group structure. You're either renaming accounts to match, or doing the mapping outside Xero.
• No FX translation. No CTA-aware, rates-by-period translation. If your group is multi-currency, all of this happens in Excel.
• No group layout, commentary, KPIs, or tracking-category overlays at the group level. Everything that makes management accounts useful is absent for a multi-org group view.

The honest summary: if your group fits inside a single Xero organisation, tracking categories get you most of the way. If your group spans multiple organisations, you're rolling consolidation yourself — Xero doesn't have a feature for that.

And it isn't arriving soon. The most-voted Xero product idea on this topic — a 13-year-old request to consolidate multiple Xero organisations, now sitting at 265 votes — was formally moved to "Accepted" by Xero in mid-2025, with the accompanying note that "work on developing consolidated reporting is not currently planned." Xero's position is that customers should use third-party apps for this. Notably, Xero acquired Syft (a consolidation reporting tool) in 2024 but hasn't merged that capability into the core product. The practical takeaway: native group consolidation is not on Xero's roadmap.

The workarounds people actually use

In practice, most groups on Xero consolidate using one of three workarounds.

The Excel approach. Pull each entity's trial balance into a tab, build a mapping sheet, build an eliminations tab, build a consolidation tab, and have a pivot or set of formulas produce the group P&L and balance sheet. This is the most common approach and the most fragile. The model works until someone adds an account, or there's a new intercompany type, or an FX rate gets stale. Then it doesn't.

Third-party consolidation tools. Tools like Joiin, Konsolidator, Spotlight Reporting, Fathom, and Syft have features for combining Xero organisations, applying eliminations, and producing group reports. Each has trade-offs. Some are excellent at the standard structures and inflexible if your group has anything unusual. Some are built around fixed report layouts. Some struggle with intercompany handling beyond the simple cases. For a group whose structure looks like the brochure, these tools work well. For groups whose reporting needs to bend to their own logic, they often hit the same ceiling Xero does — just a higher one.

Internal BI builds. Some larger groups pull all the Xero data into a warehouse and rebuild consolidation logic in Power BI, Looker Studio, or a similar tool. Powerful, and expensive. Useful if you have the technical capability in house. Not realistic for most accounting firms or finance functions.

None of these are wrong. Which one is right depends on how complex your group is and how much your reporting needs to look like your reporting.

What good Xero group reporting actually requires

After building a fair number of these, the patterns are consistent. A consolidated reporting setup that survives contact with reality has roughly seven moving parts.

1. A group chart of accounts that's separate from any entity's chart. Each entity keeps its own accounts the way it needs them — for local tax, audit, and operations. The group has its own master structure that the entities map into. That mapping is explicit, lives in one place, and gets reviewed when accounts change.

2. Intercompany handling that isn't manual every month. Either intercompany accounts are flagged in the chart of accounts on each side and eliminated by rule, or intercompany transactions carry a consistent reference that the consolidation logic uses to net them off. Whichever it is, the elimination is repeatable, not redone from scratch every cycle.

3. FX translation by line type. P&L items at the average rate for the period, balance sheet items at the closing rate, equity at historical. The translation difference goes to the right place. Rates come from a single source so two reports can't disagree about what the rate was.

4. Comparatives that hold. Prior month, prior year, YTD, YTD prior year — all on the same group structure, all with the same eliminations applied historically. Adding a new entity mid-year doesn't break the prior-year comparative, because there's a defined rule for how mid-year additions get handled.

5. Tracking-category overlays at the group level. If individual entities use tracking categories for departments, locations, or business lines, the consolidated view should be able to slice by them too — not just present a single combined number.

6. A layout that looks like a management pack, not a system export. Group revenue grouped by stream. Costs grouped by function. Calculated rows for gross margin, EBITDA, and whatever else matters. Variance columns where they belong. Commentary lives next to the numbers it explains.

7. The right level of automation, with the right amount of human review. Consolidation is not a click-a-button job. There's always something — an unusual intercompany, a one-off restructure, a new entity onboarding — that needs judgement. The goal isn't to remove humans; it's to make sure the human time is spent on the judgement calls, not on rebuilding the same Excel model every month.

Where this sits relative to the rest of your management reporting

Group consolidation rarely lives on its own. It's usually the top layer of a stack that also includes proper management accounts at the entity level, budget vs actual reporting that holds up at the group level too, and a full board pack that pulls from all of it.

If you're rebuilding the entity-level reports from scratch every month, consolidation will be even more painful. Fix the layer below first, then layer the group reporting on top. Trying to automate the group view when the entity views are still manual is a path to a very polished number that nobody trusts.

Where Cheetah fits

Cheetah builds custom reporting directly on top of Xero, including multi-entity consolidation that handles real group structures — intercompany eliminations, FX translation, mapped account structures, tracking category overlays, comparatives that survive entity changes. Because it's built bespoke for your group, it doesn't force reporting into a template that fits some standard logic.

It's worth a look if your current consolidation workflow is one of: an Excel model nobody fully trusts, a third-party tool that handles 80% of what you need but not the messy 20%, or a quarterly scramble that everyone dreads. We've helped firms like Book&Entries and CAP Advisory automate exactly this kind of group reporting end-to-end for both themselves and their clients.

Group consolidation isn't an exotic problem. It's one of the oldest problems in finance. The reason it's still painful in 2026 is that the tooling has mostly been built for the standard cases, and almost no real group is a standard case. The right setup is the one that bends to your group's logic, not the other way around.