How to Consolidate Multiple Entities in Xero
When a group runs separate Xero organisations, consolidation usually means pulling each entity into one reporting model, mapping accounts into a shared structure, posting eliminations and group adjustments, and reviewing consolidated results before publishing the month-end pack.
Quick answer
The practical process is to standardise the chart of accounts, export or sync each entity into one model, post elimination and adjustment entries in the spreadsheet, then publish the consolidated pack on a repeatable close cadence.
Key points
- Consolidation is mostly a reporting process, not just an export step.
- The harder work is aligning accounts, intercompany activity, and timing.
- The close gets faster when entity data arrives in one repeatable format.
Start with a common reporting structure
If each Xero entity has a different chart of accounts or inconsistent naming, consolidation quickly turns into a mapping project. Finance teams usually define a group reporting structure first so each ledger can roll up to the same categories.
This does not always require identical charts in every entity, but it does require a clear mapping table that finance can reuse every month.
Pull each entity into one reporting layer
Teams typically bring trial balance, P&L, balance sheet, budget, or transaction-level data from each Xero organisation into a spreadsheet, BI model, or reporting workflow. The point is to work from a single consolidation file rather than manually flipping across entities.
Once the source data lands in a consistent structure, consolidation becomes a repeatable refresh instead of a month-end copy-and-paste marathon.
Handle eliminations and adjustments deliberately
Intercompany balances, management fees, internal sales, and group-only reclasses are where consolidated numbers can go wrong. Teams usually maintain a separate adjustments layer so they can preserve entity actuals while still showing the right group view.
That also makes review easier because leadership can see the difference between underlying entity performance and consolidation-only entries.
Plan for FX and close timing
If the group spans currencies or different close calendars, the process needs extra structure. Finance teams generally agree on the exchange rates, the cut-off for entity submissions, and the review order before month end rather than during it.
Even when the accounting stays inside each Xero file, the reporting layer needs a clear rule for translation and version control.
What usually slows teams down
The biggest drag is inconsistent data arriving late. Entity leads may export different reports, use slightly different date filters, or send files with manual tweaks that are hard to audit.
A second issue is rebuilding the same management pack from scratch every month instead of having one model that only needs fresh data and current adjustments.
Practical next step
A cleaner monthly consolidation workflow
Agree the group reporting structure and entity mappings.
Refresh source data from every Xero organisation into one model.
Post eliminations and group adjustments in a separate layer.
Review entity versus consolidated results before publishing.
Reuse the same reporting pack and delivery process next month.
FAQs
Can I consolidate multiple businesses just by exporting reports from Xero?
Do I need identical charts of accounts in every entity?
What is the hardest part of the process?
See the workflow in action
Reduce the manual work around group reporting
Msasa helps finance teams pull multi-entity Xero data into one repeatable workflow so mappings, adjustments, and reporting are easier to manage.
Related guides
Reporting workflows
How to Get Xero Data into Google Sheets
See the common ways finance teams move Xero data into Google Sheets for reporting, models, and operational workflows, plus how to reduce manual exports over time.
Performance reporting
How to Create a Budget vs. Actual Report in Xero
Learn how finance teams approach budget versus actual reporting with Xero data, what makes a variance report useful, and when to extend the workflow beyond standard reporting.
Revenue analytics
How to Turn Xero Invoice Data into a Revenue Dashboard
Learn how finance teams transform invoice data from Xero into a useful revenue dashboard, including the right source fields, metrics, and workflow design decisions.