Short answer
Xero doesn't support consolidated group financial statements natively. Each Xero organisation is a single entity — there's no built-in way to combine multiple organisations into one consolidated P&L, balance sheet, or cash flow, or to eliminate intercompany transactions across them. To run group consolidated reports from Xero, you need either a manual Excel process or a consolidation platform that connects to Xero via API.
If you’re running multiple businesses through separate Xero organisations — subsidiaries, holding structures, regional entities — this limitation becomes apparent quickly. The question “what does the group look like this month?” can’t be answered from Xero alone. This article covers what Xero can and can’t do for multi-entity reporting, what the manual workaround involves, and how a dedicated consolidation platform like BrizoConsol solves it by connecting directly to your Xero organisations.
What Xero Can and Can’t Do for Group Reporting
It’s worth being precise about Xero’s actual capabilities before assuming everything requires an external tool.
| What Xero can do | What Xero can’t do |
|---|---|
| Produce full P&L, balance sheet, and cash flow for a single organisation | Combine financials from multiple organisations into one consolidated report |
| Handle multi-currency within a single Xero organisation | Translate foreign entity financials at group-level exchange rates (closing vs average) |
| Track intercompany invoices within the platform | Eliminate intercompany transactions across organisations at consolidation |
| Generate report packs across multiple organisations (separate, not combined) | Produce a single group P&L or group balance sheet that nets down to one set of figures |
| Connect to third-party consolidation software via API | Calculate NCI, CTA, or goodwill for group accounting purposes |
Xero’s Report Pack feature (available through Xero HQ for accounting practices) batches reports across multiple organisations — but it produces separate entity reports side by side, not combined figures. It is a reporting aggregation tool, not a consolidation tool. If you need one set of group financial statements with intercompany eliminations applied, it cannot produce that.
The Manual Workaround — and Why It Breaks Down
The most common approach for Xero users without a consolidation tool is to export trial balances or P&L reports from each Xero organisation into Excel and manually combine them. For two entities with no intercompany trading and the same currency, this is manageable. For anything more complex, it deteriorates quickly.
The manual process typically looks like this:
- Export trial balance or management accounts from each Xero organisation (each in a different format, with different account codes)
- Map each entity’s accounts to a consistent group chart of accounts in a spreadsheet
- Apply exchange rates manually to convert foreign entity figures to the group reporting currency
- Identify intercompany transactions from each entity’s ledger and post elimination journals
- Combine all entities into a single consolidated worksheet
- Rebuild the P&L, balance sheet, and cash flow from the combined data
- Check that the balance sheet balances and investigate any unexplained differences
🚩 Where this breaks down in practice: Each entity’s Xero COA is different — account names, account codes, and groupings vary. When an entity adds a new account in Xero mid-year, it doesn’t automatically appear in the group mapping, so it either lands in the wrong group line or disappears from the consolidated P&L entirely. Exchange rates applied manually are inconsistently sourced across entities. Intercompany transactions are hard to identify without a systematic approach. And there’s no audit trail — if an auditor asks how you derived a specific consolidated figure, tracing it through a multi-sheet Excel model is time-consuming and error-prone.
Running Consolidated Statements from Xero Using BrizoConsol
BrizoConsol connects directly to Xero via API — pulling trial balance data from each Xero organisation into a single consolidation environment. You set up the group structure once; the data flows in automatically at each reporting period.
Here’s how the process works end to end:
1 Connect your Xero organisations Each Xero organisation is connected to BrizoConsol via secure OAuth — the same authentication flow Xero uses for all third-party integrations. Once connected, BrizoConsol can pull trial balance data, chart of accounts, and transaction details directly. No CSV exports, no manual file uploads.
2 Map each entity’s accounts to a group chart of accounts Each Xero organisation has its own account structure. In BrizoConsol, you map each entity’s accounts to a common group COA — the structure that all consolidated reports are built from. AI-assisted mapping suggests classifications based on account names, which you review and confirm. New accounts added to any Xero organisation are flagged for mapping before the next consolidation runs.
COA mapping example AU entity account: “4000 – Sales – Domestic” → maps to Group COA: “Revenue – Domestic”
SG entity account: “REV-LOCAL” → maps to Group COA: “Revenue – Domestic”
UK entity account: “4100 – Turnover” → maps to Group COA: “Revenue – Domestic”
All three flow into the same consolidated revenue line, regardless of the naming convention in each Xero organisation.
3 Set exchange rates for the reporting period For entities with foreign functional currencies, you configure the closing rate (for balance sheet items) and average rate (for P&L items) for each period. These are set centrally in BrizoConsol and applied consistently across all entities — eliminating the rate inconsistency that causes intercompany mismatches in manual processes. Currency translation adjustments (CTA) are calculated automatically and recorded in group equity.
4 Post intercompany elimination entries BrizoConsol supports two elimination methods. For simple, recurring eliminations (management fees, intercompany loans), you can post at group level — a single debit and credit that removes both sides from the consolidated result. For eliminations where entity-level attribution matters (partial ownership, NCI present), you use entity-pair elimination — specifying which entity generated the income and which carried the expense, so each entity’s contribution to the group is accurate net of the intercompany charge.
5 Generate consolidated reports With COA mapping applied, exchange rates set, and eliminations posted, BrizoConsol generates the consolidated P&L, balance sheet, and cash flow — with drill-down from any group line to the entity contribution behind it, and from the entity contribution to the underlying account. Reports can be viewed in the platform, exported as PDF, or scheduled for automatic delivery to defined recipients.
Worked Scenario: Three Xero Entities, One Consolidated P&L in SGD
Group structureSG HoldCo (Singapore, SGD) — parent, holds 100% of AU OpCo and 80% of UK OpCo
AU OpCo (Australia, AUD) — trading entity
UK OpCo (United Kingdom, GBP) — trading entity, 20% minority interest
Intercompany transaction: SG HoldCo charges AU OpCo a $12,000 SGD management fee for the month.
In BrizoConsol:
- All three Xero organisations are connected and syncing trial balance data
- AU OpCo’s AUD figures are translated at the AUD/SGD closing rate (balance sheet) and average rate (P&L)
- UK OpCo’s GBP figures are translated at the GBP/SGD closing and average rates; CTA is calculated and posted to group equity
- The SGD 12,000 management fee is eliminated: Dr Management Fee Income (SG HoldCo) / Cr Management Fee Expense (AU OpCo)
- UK OpCo’s results are split 80% to group / 20% to NCI in the consolidated statements
The output: a consolidated P&L in SGD showing the group’s actual external revenue, costs, and profit — with the management fee eliminated, AU OpCo’s AUD figures translated, UK OpCo’s GBP figures translated and NCI separated. Drill-down on any line shows each entity’s contribution in both functional currency and SGD.
What BrizoConsol Requires from Your Xero Setup
A few practical notes before connecting:
- Each entity needs its own Xero organisation — BrizoConsol connects one organisation at a time; entities sharing a Xero organisation are treated as one entity
- Xero must be the active accounting system — BrizoConsol pulls from Xero’s live data; it doesn’t work from Xero exports or archived organisations
- Your Xero data quality affects consolidation quality — uncoded transactions, unreconciled bank accounts, or journals posted without proper account codes will flow through to the consolidation as-is
- Excel import is available as a fallback — for entities not on Xero (or on QuickBooks, MYOB, or Zoho Books), trial balance data can be imported via Excel alongside the Xero-connected entities
BrizoConsol connects directly to Xero — pulling trial balance data from all your Xero organisations, mapping accounts to a group COA, handling multi-currency translation, and producing consolidated P&L, balance sheet, and cash flow in one platform. Learn more or see it in action →