Xero Consolidation: Software, Limitations and How-To

Xero cannot do consolidations natively: each legal entity is a separate Xero organisation, and there is no built-in group report. To consolidate multiple Xero organisations you use Excel, Xero consolidation software such as Joiin, Fathom, Spotlight Reporting or dataSights, or a Power BI model, each handling account mapping, intercompany eliminations and currency conversion.

Can Xero do consolidations?

Not natively. Xero treats each legal entity as its own organisation and subscription. That suits compliance, because a trading company and a trust should not share a ledger, but it leaves group finance teams without a combined P&L, balance sheet or cash flow.

Consider a group with an operating company, a property holding entity and a trust. Each month the finance manager exports reports from each, pastes them into a master workbook, eliminates intercompany transactions, converts foreign currency and produces group statements. The business is not complicated; the process is, because Xero has no consolidation feature. Consolidated reporting has long been one of the most requested features on Xero's product ideas forum.

Can Xero consolidate two related company financials?

Not inside Xero. Even for two related companies, you need to export or connect both organisations, map their accounts, eliminate transactions between them (loans, management fees, recharges) and combine the results. For two entities with similar charts of accounts, a well-built spreadsheet is often enough. Once intercompany activity is frequent or you need reports more than monthly, software is usually worth it.

1. Method 1Manual ExcelExport, map, eliminate and sum. Works for 2-3 entities.
2. Method 2Xero consolidation softwareJoiin, Fathom, Spotlight, dataSights. Automated pulls and eliminations.
3. Method 3Power BI or Google SheetsFlexible, combines other systems, needs technical skills.
4. Method 4Custom consolidation layerFor groups mixing Xero with other ledgers or complex rules.

Method 1: Manual Excel consolidation

1. 1Export ReportsP&L and Balance Sheet from each entity
2. 2Map AccountsAlign charts of accounts across entities
3. 3Eliminate ICRemove intercompany transactions
4. 4Currency ConvertApply exchange rates if needed
5. 5ConsolidateSum into group totals

1. Export from each organisation: Profit and Loss (accrual) for the period and Balance Sheet at period end.
2. Build a master template: a tab per entity, a mapping table, an eliminations sheet and a consolidation tab.
3. Eliminate intercompany balances: if Entity A owes Entity B $50,000, A's payable and B's receivable must cancel.
4. Convert currency where needed: closing rates for balance sheet items, average rates for P&L items.

Manual works when you have two or three entities with similar charts, monthly or quarterly reporting and a strong Excel user. It breaks down when you need weekly views, intercompany activity is frequent, currencies multiply, or the person who built the workbook leaves.

Method 2: Xero consolidation software

Purpose-built apps connect to each Xero organisation and automate data pulls, mapping and eliminations.

	Strengths	Best for	Impact
Joiin	Straightforward group P&L, balance sheet and cash flow, intercompany eliminations, multi-currency	Groups wanting simple setup	Simple
Fathom	KPI dashboards, forecasting, consolidation, connects to Xero, QuickBooks and MYOB	Advisory and KPI analysis	Analysis
Spotlight Reporting	Large entity counts, consolidated forecasting, templates	Franchise and multi-site networks	Scale
dataSights	Xero data into Power BI and Excel with automated refresh	Teams standardising on Power BI	Power BI
Translucent	Multi-currency, intercompany matrix, drill-down	Multi-currency groups	FX

Check current pricing, entity limits and features on each vendor's website and the Xero App Store, and run a free trial against a month you have already consolidated manually.

How to choose consolidation software for Xero

• Entity count and growth: will the tool scale as you add entities?
• Elimination handling: rule-based eliminations and mismatch flags.
• Currency: closing and average rate handling to match your policy.
• Other ledgers: if part of the group runs MYOB or another ERP, confirm the tool connects to both.
• Outputs: board packs, management reports, forecasts and drill-down to transactions.

Can you push data to Fathom from MYOB?

Fathom connects to MYOB through its built-in integration instead of a manual push: add the company in Fathom, choose MYOB and authorise access. That makes Fathom one option for groups split between Xero and MYOB. Confirm which MYOB products Fathom supports and test account mapping before relying on it.

Method 3: Power BI or Google Sheets

Connecting Xero to Power BI, directly or through a connector such as dataSights, gives full control: scheduled refresh across all organisations, consistent mappings, custom dashboards and the ability to combine Xero with payroll, CRM or operational data.

The trade-off is skills and maintenance. Across our consultants' careers building data platforms in BHP and Rio Tinto environments, the lesson held: Power BI is extremely capable, and it rewards teams who want to build, not teams who need an answer by Friday. G-Accon and similar tools do the same for Google Sheets at lower complexity.

Method 4: A custom consolidation layer

Some groups outgrow apps: entities on different ledgers, complex ownership percentages, recurring management fee allocations or the need for a single source of truth across finance and operations. A custom layer pulls each ledger through its API, maps accounts to a group chart, applies elimination and allocation rules, and feeds Power BI or board packs. AI can prepare intercompany matches and flag mismatches overnight, with a person approving adjustments. Our guide to month-end close automation for multi-entity groups covers this pattern.

Choosing the right approach

What's your primary constraint?

• Two or three similar entities, monthly reportingManual Excel with a disciplined template
• Want simple consolidation quicklyJoiin or similar consolidation app
• Need KPI analysis and forecastingFathom
• Large multi-site or franchise networkSpotlight Reporting
• Power BI skills and other systems to combinedataSights or a direct Power BI model
• Mixed ledgers or complex group rulesCustom consolidation layer

The real comparison is time against money. Count the hours your team spends each month, plus the risk of key-person dependency and audit questions at short notice.

• Monthly hours on exports and pastingLargely removed
• Intercompany mismatchesFlagged before close
• Dependency on one spreadsheet ownerReduced
• Group reports availableOn demand, not once a month

A four-week implementation roadmap

1. Week 1Audit and prepareDocument entities, compare charts of accounts, list intercompany relationships
2. Week 2Connect and configureLink organisations, map accounts, configure eliminations and access
3. Week 3Run in parallelCompare against the manual process for one period, fix discrepancies
4. Week 4Go live and automateSchedule reports, train the team, document and retire the old workbook

Week 1: list every organisation and who has admin access, export and compare charts of accounts, document which entities transact with each other, identify eliminations (loans, management fees, inventory transfers) and currency exposure. This often surfaces duplicate supplier codes and intercompany balances that do not match.

Week 2: connect each organisation (admin access needed), verify sync, review mappings, configure elimination rules and user access.

Week 3: the step people skip and regret. Check group totals, eliminations, currency and entity coverage against your manual figures. Common issues are different periods, cash versus accrual settings and missing entities.

Week 4: schedule reports, train others to read them, document the setup and stop updating the old spreadsheet.

Common Xero consolidation pitfalls

Intercompany balances that don't match. A shows it owes B $47,000; B shows $52,000. Usually an invoice was missed, dated differently or GST applied differently. Fix it in the source organisations and run intercompany reconciliation before month-end.

Chart of accounts inconsistencies. "6100 Motor Vehicle Expenses" in one entity and "6150 Vehicle Operating Costs" in another. Standardise charts or use mapping.

Different reporting periods. Calendar months in one entity, four-week periods in another. Align them or normalise.

Currency methodology. Under AASB 121, balance sheet items generally use the closing rate and income and expenses the transaction-date or an average rate. Document your policy and configure the tool to match.

Australian compliance considerations

Tax consolidated groups. If your entities form an income tax consolidated group, the head company lodges one income tax return for the group. Consolidation apps are for management reporting, not tax lodgement, and tax consolidation notifications are generally handled outside standard Xero workflows. Work with your tax agent.

Statutory financial statements. Large proprietary companies and other reporting entities may need consolidated financial statements under the Corporations Act 2001, prepared under AASB 10. Management consolidation tools help, but statutory accounts need accountant review.

GST groups. Related entities can form a GST group, with the representative member lodging one BAS. Intercompany transactions still need tracking.

How Solve8 can help

For groups that outgrow apps, we build consolidation layers that pull Xero, MYOB and other ledgers, apply your elimination and allocation rules, and prepare intercompany matches for a person to approve, running on your infrastructure in Australia. See our data and BI service and system integration, or talk to our team.