Does XO Report have a one-click consolidation report?

No — XO Report provides the cell-level multi-organization data layer; you build the consolidation workbook in Excel. This is the right tool for accountants and CFOs who already have (or want to build) a consolidation template. It is NOT a replacement for a dedicated consolidation platform if you need automated equity-pickup, automated FX retranslation, or audit-grade consolidation reporting.

How many Xero organizations can I connect to one subscription?

Up to 50 organizations on the Max plan per subscription (Solo = 1, Lite = 3, Pro = 10, Max = 50) per the published pricing page. For a multi-entity group with five to fifty subsidiaries the Pro or Max plan fits; for groups beyond 50 orgs on one subscription, contact sales for Enterprise.

Does XO Report handle FX consolidation automatically?

No. Each Xero organization reports in its own base currency. FX rates are applied in Excel cells — typically one FX-rate cell per entity, per as-of date (Balance Sheet) or per period (P&L). The convention is to keep a separate FX-rate table on its own sheet and reference it from each entity column. XO Report does not retrieve historical FX rates; source those from your treasury system or an FX-rate data provider.

What about equity-method investments and minority interests?

These are Excel-side adjustments. XO Report returns the entity-level Net Income via XO.PROFIT and entity-level Balance Sheet figures via XO.BALANCE. Apply the equity-method ownership percentage to the relevant entity column manually, or compute it formulaically against an ownership-percentage cell. Minority-interest carve-outs follow the same pattern — XO Report provides the entity data, the workbook applies the structure.

How fast does a multi-entity workbook refresh in practice?

Multi-entity workbooks refresh on demand via the task pane Refresh button or workbook recalculation. Large consolidation grids complete in seconds in normal use — fast enough to keep the workbook interactive while you adjust FX rates, eliminations, or period boundaries.

Xero Consolidation in Excel — Multi-Entity Reporting

What it is

Group consolidation is the process of combining financial statements across multiple legal entities into a single set of statements that represents the group as one economic unit. For a CFO running a multi-country holding company, it is the most-consulted internal report — the basis for board reporting, investor updates, treasury decisions, and compliance filings.

Xero runs each organization as a separate set of books, in its own base currency, with its own chart of accounts. There is no native cross-organization consolidation report. Group reporting is therefore an Excel discipline in every Xero-driven holding company — every period, finance teams pull each entity's P&L and Balance Sheet into a master workbook, apply FX rates, post intercompany eliminations, and roll up.

Why analysts want it in Excel

Excel is the only realistic surface for group consolidation. The master workbook needs entity columns, FX-rate cells, elimination adjustments, opening-equity tie-outs, board-reporting templates, and commentary panels — none of which exist in any single SaaS accounting tool. Even firms running expensive consolidation platforms typically operate them by exporting back into Excel for the final pack.

Live multi-entity data in Excel transforms this monthly slog into an on-demand refresh. The structure of the consolidation workbook — entity columns, GL account rows, FX cells, elimination columns — is set once and reused every period. Only the underlying balances refresh from Xero. CFOs gain a real-time group view that no longer waits for the close calendar to align across entities.

For accounting firms serving multi-entity clients, the same template scales: one consolidation model per client structure, refreshed against each client's connected Xero organizations at the click of a Refresh button.

Why the manual method breaks

Log into each Xero organization, export the P&L and Balance Sheet, paste into the master workbook entity column — repeat for every entity, every period, every reporting cycle.
Entity-by-entity exports lose the live link to the source ledger the moment they hit Excel; late journals in any entity invalidate the entire group pack.
FX-rate adjustments are typed in by hand against export totals; any FX-rate change requires re-keying every entity's translated balance.
Intercompany account reconciliation is manual — match entity A's intercompany receivable against entity B's intercompany payable, line by line, with no automated tie-out.
Version control across five-plus entity exports becomes a nightmare; the wrong export attached to the wrong column quietly breaks the group balance sheet.
Audit-trail reconstruction requires keeping every export file forever — most firms simply accept that prior-period reconstruction is impractical.

The live add-in method

Honest positioning: XO Report does not have a one-click consolidation report. There is no XO function called XO.CONSOLIDATE, no task pane wizard for group reporting, no built-in FX-translation engine. What XO Report provides is the cell-level multi-organization data layer that makes a real consolidation workbook possible — your consolidation logic stays under your control.

The pattern. Use =XO.ORG() to spill the list of every connected organization with their Org IDs. Place each entity in its own column in the consolidation workbook. Pull entity-level Net Income with XO.PROFIT, account-level balances with XO.BALANCE. Combine across columns with Excel SUM for the group total. Apply FX rates and intercompany eliminations in dedicated columns you control.

This is the right tool for accountants and CFOs who already have (or want to build) a consolidation workbook template — XO Report is the data layer, your workbook is the consolidation engine. It is NOT a replacement for a dedicated consolidation platform if your needs include automated equity-pickup, automated FX retranslation against historical rates, or audit-grade consolidation reporting.

# Step 1: list all connected organizations (spills into a table)
=XO.ORG()
# Returns 2 columns: OrgID (shortcode like "!abc123"), OrgName

# Step 2: side-by-side Net Income per entity
# Assumes A2 = Entity 1 Org ID, A3 = Entity 2, A4 = Entity 3,
# C1 = period start date, D1 = period end date
| Line item    | Entity 1 (A2)              | Entity 2 (A3)              | Entity 3 (A4)              | Group       |
| Net Income   | =XO.PROFIT(A2, $C$1, $D$1) | =XO.PROFIT(A3, $C$1, $D$1) | =XO.PROFIT(A4, $C$1, $D$1) | =SUM(B2:D2) |

# Step 3: side-by-side Balance Sheet account (Cash, account 1000)
# E1 = as-of date; pass E1 in both start and end slots per the
# As-of pattern for Balance Sheet accounts.
| Account      | Entity 1 (A2)                          | Entity 2 (A3)                          | Entity 3 (A4)                          | Group       |
| Cash (1000)  | =XO.BALANCE(A2, "1000", $E$1, $E$1)    | =XO.BALANCE(A3, "1000", $E$1, $E$1)    | =XO.BALANCE(A4, "1000", $E$1, $E$1)    | =SUM(B3:D3) |

# FX translation pattern (entity in EUR, group in USD):
# F1 = USD/EUR FX rate as of E1
| Cash USD     | =B3*$F$1                               | (etc — multiply each entity column by its own FX rate cell)

XO.ORG()is the foundation: it spills a list of every connected Xero organization with its Org ID. Reference each entity's Org ID by cell — typically locking them with absolute references ($A$2, $A$3) so formulas drag cleanly across the entity columns.

For P&L lines, XO.PROFIT returns Net Income for the date range; XO.BALANCE on a specific account code returns its activity over the same range. For Balance Sheet lines, XO.BALANCE with from = to returns the as-of-date balance. The Group column is a plain Excel SUM across the entity columns.

Intercompany eliminations.Add a dedicated elimination column (between the entity columns and the Group column). Type in the elimination amount manually after confirming each entity's intercompany balance reconciles — XO Report does not detect or auto-eliminate intercompany balances. The discipline of typing eliminations is itself the audit trail.

FX translation.Each Xero organization reports in its own base currency. Apply FX rates in dedicated cells (one rate per entity, one rate per as-of date for Balance Sheet, one rate per period for P&L). The convention is to translate each entity column to the group reporting currency with a separate translated-column block.

Related docs

Frequently asked questions

Does XO Report have a one-click consolidation report?: No — XO Report provides the cell-level multi-organization data layer; you build the consolidation workbook in Excel. This is the right tool for accountants and CFOs who already have (or want to build) a consolidation template. It is NOT a replacement for a dedicated consolidation platform if you need automated equity-pickup, automated FX retranslation, or audit-grade consolidation reporting.
How many Xero organizations can I connect to one subscription?: Up to 50 organizations on the Max plan per subscription (Solo = 1, Lite = 3, Pro = 10, Max = 50) per the published pricing page. For a multi-entity group with five to fifty subsidiaries the Pro or Max plan fits; for groups beyond 50 orgs on one subscription, contact sales for Enterprise.
Does XO Report handle FX consolidation automatically?: No. Each Xero organization reports in its own base currency. FX rates are applied in Excel cells — typically one FX-rate cell per entity, per as-of date (Balance Sheet) or per period (P&L). The convention is to keep a separate FX-rate table on its own sheet and reference it from each entity column. XO Report does not retrieve historical FX rates; source those from your treasury system or an FX-rate data provider.
Can I do intercompany eliminations in the consolidation workbook?: Yes, but eliminations are user-managed. Place an elimination column between your entity columns and the Group column, and type in the elimination amount after confirming each entity’s intercompany balance reconciles. XO Report does not detect, match, or auto-eliminate intercompany balances. The discipline of typing eliminations is the audit trail for the consolidation.
What about equity-method investments and minority interests?: These are Excel-side adjustments. XO Report returns the entity-level Net Income via XO.PROFIT and entity-level Balance Sheet figures via XO.BALANCE. Apply the equity-method ownership percentage to the relevant entity column manually, or compute it formulaically against an ownership-percentage cell. Minority-interest carve-outs follow the same pattern — XO Report provides the entity data, the workbook applies the structure.
How fast does a multi-entity workbook refresh in practice?: Multi-entity workbooks refresh on demand via the task pane Refresh button or workbook recalculation. Large consolidation grids complete in seconds in normal use — fast enough to keep the workbook interactive while you adjust FX rates, eliminations, or period boundaries.