Consolidated reporting turns separate Xero organisations into one group-level view. The arithmetic is straightforward; the difficult part is making each entity comparable and keeping the process repeatable every month.
Key takeaways
- ✓Standardise periods and account mappings before combining balances.
- ✓Keep source, mapping, adjustments, and presentation layers separate.
- ✓Treat intercompany eliminations as controlled journal-style adjustments.
- ✓Make refresh status and reconciliation checks visible to reviewers.
What consolidated reporting needs to solve
Each Xero organisation has its own chart of accounts, reporting preferences, tracking options, and potentially its own base currency. A consolidation process must translate those differences into a consistent group reporting structure.
The goal is not simply to add several profit and loss reports together. A dependable consolidation should preserve an audit trail from the group total back to the entity and source account.
The six building blocks
A workable multi-entity model usually contains six layers. Keeping them separate makes exceptions easier to identify and changes easier to review.
- 1
Entity source data
Bring each organisation into a consistent table with entity, account, period, and amount fields.
- 2
Group account mapping
Map every local account to a standard group line, retaining unmapped accounts as visible exceptions.
- 3
Period alignment
Use the same month-end boundaries and clearly document any entities with different financial years.
- 4
Currency translation
Define the rate used for income statement, balance sheet, and equity items, then preserve the source rate.
- 5
Elimination adjustments
Record intercompany balances and transactions in a separate controlled table rather than overwriting source data.
- 6
Group presentation
Build the management P&L, balance sheet, cash view, and KPI pages from the controlled consolidation table.
Design the workbook for review, not just calculation
A good consolidation workbook makes status obvious. Reviewers should be able to see which entities refreshed successfully, which accounts are unmapped, whether the balance sheet balances, and whether intercompany differences remain.
Avoid formulas that point directly into differently shaped entity tabs. Normalise each source into a consistent table first, then use stable group codes for calculations and presentation.
- One source table per entity or one combined source table with an entity field
- A version-controlled account mapping table
- A separate adjustments and eliminations table
- A control page showing refresh times and reconciliation differences
- Presentation tabs that contain no manual source-data edits
Handling tracking categories
Xero tracking categories can represent departments, locations, cost centres, or other operating dimensions. They are useful when the group needs both entity reporting and a cross-entity operational view.
Create a second mapping layer when entities use different labels for the same concept—for example, “Consulting” in one entity and “Advisory” in another. The consolidation should retain both the original option and the group reporting label.
A practical monthly control checklist
Automation removes repetitive movement, but it does not remove accounting judgment. Keep the review process explicit.
- Confirm every entity is refreshed through the same reporting date
- Investigate unmapped or newly created accounts
- Reconcile entity totals back to their Xero reports
- Review currency rates and translation adjustments
- Match intercompany receivables and payables before elimination
- Lock or archive the final reporting pack after approval