Can Xero do consolidations?

Not on its standard plans. Every Xero organisation is a separate ledger, Xero’s reports stop at the organisation boundary, and there is no built-in step that combines two organisations into one consolidated P&L or balance sheet. The exception is new: Xero Ultra, a plan Xero launched for Australian businesses in July 2026, includes multi-entity consolidation through Syft Advanced, which Xero describes as working alongside Xero rather than within it, with its own login. Outside Ultra, consolidated reporting for a group on Xero happens in a spreadsheet or in a tool that reads each organisation and rolls the results up.

Everything said here about Xero and Syft comes from Xero’s own website, product ideas forum and developer documentation, checked on 12 October 2026. Xero’s plans differ by country and change often, so check anything decisive against Xero’s current page for your region.

Does Xero have built-in consolidation?

Xero’s core accounting product does not consolidate across organisations, and Xero has said it is not building that. A request to “combine the reporting between more than one Xero org” has sat on Xero’s product ideas forum since 2012 with 278 votes. In July 2025 Xero’s community manager replied that “work on developing consolidated reporting is not currently planned”, and pointed people to apps in the Xero App Store.

Within one organisation Xero handles a lot, including multi-currency invoicing, payments and currency gains and losses. What it does not do in its standard plans is take several organisations, map their accounts to one group structure, translate them into one presentation currency and add them up. That is what people searching for consolidated Xero reports, consolidated accounts in Xero or a consolidated profit and loss in Xero are usually after, and it is the part that sits outside the ledger.

What is Xero Ultra, and does it consolidate?

Xero Ultra is a new Xero plan for growing businesses with more complex finance functions, and it is the first Xero plan to include multi-entity consolidation. It was reported as launched for Australian businesses on 8 July 2026, and on 12 October 2026 the Ultra page existed on Xero’s Australian site but not its UK, New Zealand or US sites.

According to that page, consolidation in Ultra comes from Syft Advanced, “a powerful reporting, forecasting and planning platform that connects directly to your Xero data”. Three details on the page are worth knowing before you plan around it:

• It “works alongside Xero — not within it”, and you receive a separate Syft login after upgrading. The consolidated view lives in Syft, not in Xero’s own reports.
• Ultra “includes consolidation for up to five entities, with the option to add more as your business grows”. The page does not say what adding more costs.
• You connect your Xero organisations by selecting “Add Entity”, and the consolidated view is then built automatically, with Xero’s onboarding team available for setup.

The Ultra page does not describe how intercompany eliminations or foreign currency are handled in the consolidation, and it did not show a price when we checked. Syft’s standalone product does describe eliminations, non-controlling interest and foreign currency in detail; our Syft Analytics comparison summarises what Syft says it does. Ask Xero which of those Syft features come with the Ultra plan before assuming they all do.

Does Analytics powered by Syft consolidate my entities?

No. Xero acquired Syft — the acquisition was announced on 17 September 2024 — and has since built Syft’s technology into Xero’s own analytics. Xero announced a global launch of those analytics in January 2026: dashboards, cash flow projections up to 180 days, AI-generated summaries and business health scorecards. None of that is multi-entity.

Xero says so itself. Its analytics comparison page sets Syft against Xero Analytics feature by feature, and lists multi-entity consolidations as included in Syft and excluded from Xero Analytics. So the analytics inside your Xero subscription work one organisation at a time, like the rest of Xero’s reporting.

Syft itself is a different matter. Xero offers its partners — accountants and bookkeepers — access to Syft for clients on eligible Xero business plans at no extra cost, with the Syft plan following the client’s Xero plan. If your accountant already uses Syft, ask them whether your plan’s version includes consolidation; it may be the cheapest route to a consolidated report you do not run yourself.

Can tracking categories replace consolidation?

Only if your “entities” are really divisions of one company. Tracking categories tag transactions within a single Xero organisation, so a business that runs several branches or product lines through one ledger can report each one separately and the whole together. That is report grouping inside one ledger, not consolidation across ledgers.

Tracking categories cannot reach across organisations. If each company in your group has its own Xero organisation — which separate companies with their own tax registrations and bank accounts generally need — tracking categories in one organisation know nothing about the others. They are also limited: Xero’s API documentation states that an organisation can have at most two active tracking categories, and four including archived ones. Putting several legal entities into one organisation to make tracking categories work trades a reporting problem for a bookkeeping and tax one.

How do groups on Xero consolidate today?

They use one of three approaches: a spreadsheet, a dedicated consolidation or reporting tool, or — in Australia, and now — Xero Ultra.

A spreadsheet is the right answer more often than vendors admit. Export each entity’s trial balance or reports, map them to a group structure, translate any foreign entities and sum. For a small, stable, single-currency group with one owner of the workbook, it is fast, free and transparent. It breaks on structural change, currency and key-person risk, which our Excel versus software comparison covers in detail.

Dedicated tools read each Xero organisation through Xero’s API and consolidate above the ledger. Syft, Spotlight Reporting and Fathom all do intercompany eliminations and budgeting or forecasting, and some take entities from ledgers other than Xero. We have compared ourselves honestly with each: Syft Analytics, Spotlight Reporting and Fathom.

APBuddy Reporting is one of those tools, and narrower than most. It consolidates the P&L and balance sheet across a group’s Xero organisations in one reporting currency, and checks whether each entity’s books actually closed — late postings, duplicates across entities, accounts that went quiet. It does not perform intercompany eliminations today; they are on our roadmap, not in the product. It reads from Xero and writes nothing back.

What should you check before choosing a consolidation tool?

Check how it handles the five things that make consolidated Xero reporting go wrong, whatever tool or workbook you end up with.

Intercompany eliminations. If entities trade with or lend to each other, a consolidation that only adds up will double-count. Decide whether you need eliminations in the tool, or whether intercompany is light enough to handle in an adjustments layer. Keeping intercompany in dedicated accounts in every entity helps either way.

Chart of accounts mapping. Entities rarely share a chart of accounts, so every tool maps them to a group chart. The question is what happens to an account nobody has mapped yet: it should drop out of the totals visibly, not silently. Our guide on mapping charts of accounts across Xero entities explains how to test for this.

Foreign currency. Average rate for the P&L, closing rate for the balance sheet, a translation reserve for the difference — and the rates stored per period, so a restated month reproduces. See how foreign currency works when consolidating Xero entities.

Entity changes mid-year. An acquired entity counts only from the date control passed, and a closed or migrated one must keep contributing its history. Xero knows none of this, so the tool has to. See consolidating when an entity is acquired, closed or migrated mid-year.

Errors that cross entity boundaries. A journal posted in two entities looks fine in each ledger and is wrong in the group total. Reviewing entities one at a time will not find it; see finding duplicate journals across Xero entities.

Which approach fits your group?

Decide on what your group looks like over the next twelve months, not on which tool has the longest feature list.

If you have a handful of entities in one currency, little intercompany and a workbook that reconciles, stay in Excel. If you are in Australia, want consolidation from Xero itself and five entities is enough, Xero Ultra is worth pricing — but confirm with Xero how it handles eliminations and currency, because its plan page does not say. If you need statutory-style consolidation with eliminations, minority interests or acquisition accounting, choose a tool that does those today, such as Syft, Spotlight or Fathom.

And if your group is on Xero, intercompany is light or handled elsewhere, and the question you keep failing to answer is whether this month’s group figure is complete and final, that is what APBuddy Reporting is built for. The quickest way to judge it is against a month you have already closed.