# How do you compare multiple Xero companies?

Compare Xero companies with a consistent reporting period, clear currency labels and an AI-assisted review that keeps missing data visible.

Published: 2026-09-18
Source: https://atso.ai/blog/xero-multi-company-management-report/

---

You can compare multiple Xero companies by pulling the same report for the same period, keeping one column per organisation and checking whether a group total is meaningful. An AI assistant can then help investigate differences, provided it can show which records support its explanation.

Atso connects business software to an AI assistant through MCP, the Model Context Protocol. Its Xero connector can read several connected organisations in one conversation. The useful result is a management review that preserves the boundaries between companies and makes missing information visible.

## What problem should a multi-company report solve?

A multi-company report should answer one management question across a defined set of businesses. Start with the decision you need to make, such as which company needs an expense review, rather than requesting every report available.

The [Xero community's consolidation discussion](https://productideas.xero.com/forums/967133-reports-tax/suggestions/44960413-reporting-ability-to-consolidate-multiple-xero-o) includes owners asking for a view across separate organisations. That request covers several different jobs. A monthly comparison, a lender's reporting pack and statutory consolidated accounts need different levels of preparation.

For an operating review, write down the companies, period and measures first. A reasonable starting set is revenue, cost of sales, gross profit, operating expenses and net profit. Keep the original report names and labels beside any interpretation. If two companies classify expenses differently, that is a question for the finance team before it becomes a ranking of performance.

## How should you prepare the comparison?

Use an agreed period and report basis, then verify that each organisation's source report reflects them. Matching the dates alone does not make two businesses comparable.

Before asking the assistant to explain a variance, check the following:

| Check | What to record | Why it matters |
| --- | --- | --- |
| Organisations | Names and connection identifiers | Prevents comparing the wrong businesses |
| Period | Exact start and end dates | Avoids mixing a full month with a partial month |
| Currency | Currency for every column | Prevents adding unlike amounts |
| Report basis | Basis supported by the source report | Keeps the comparison consistent |
| Completeness | Every requested company returned or explicitly unavailable | Separates missing data from a genuine zero |
| Retrieval time | When each result was pulled | Shows when a later correction may change the answer |

Use a closed period if the question concerns a completed month. For a month still in progress, say that clearly. An explanation based on unfinished bookkeeping should remain provisional even when the arithmetic is correct.

## What does Atso's Xero group report actually return?

Atso's group Profit and Loss tool returns a separate company column and a status for the total. This is a reporting boundary built into the connector, rather than a judgement left entirely to the wording of your prompt.

Our first-hand implementation detail is the total status: `complete`, `partial` or `omitted`. A missing company can leave a partial result. Different company currencies prevent a simple combined total. The company columns also carry their currency and retrieval time.

Those labels describe data coverage. They do not certify the books or perform accounting adjustments. A complete same-currency total can still include sales between two companies in the group. It therefore needs the right label when shared with somebody expecting consolidated accounts.

[MCP's architecture](https://modelcontextprotocol.io/docs/learn/architecture) explains how an AI application connects to servers that provide tools and context. In this workflow, Atso supplies the business records through those tools. The assistant's narrative remains something you review against the records.

## What should you ask your AI assistant?

Ask for the comparison first and an explanation second. This makes it easier to catch a wrong company, period or subtotal before a confident narrative is written around it.

Here is a suggested prompt, not a record of a customer conversation:

> List the Xero organisations I have connected. For the companies I select, compare Profit and Loss for 1 August 2026 to 31 August 2026. Show each company separately, including currency, retrieval time and availability. Preserve the total's completeness status. Do not convert currencies or assume intercompany eliminations. Identify three differences worth investigating and explain what additional records would help check them.

Once you have verified the table, choose one difference. Ask the assistant to retrieve the relevant records for that organisation and period. Request a short list of possible explanations, with a clear separation between an observed amount and a hypothesis about why it changed.

Keep the follow-up narrow. “Explain this expense movement” is easier to verify than “tell me everything wrong with the group”. If the relevant records cannot be retrieved, retain that question in the review rather than filling the gap with an estimate.

## How should you handle missing companies and mixed currencies?

Keep unavailable companies visible and leave mixed-currency totals uncombined. A blank result and a zero result mean different things.

Consider this invented coverage example:

| Organisation | Currency | Result | Management action |
| --- | --- | --- | --- |
| Example North | NZD | Available | Review its figures |
| Example South | NZD | Unavailable | Restore access and rerun |
| Example Australia | AUD | Available | Compare separately |

This table contains no customer data and is not an Atso screen. It illustrates the questions a reviewer should ask. You cannot describe the available companies as the whole group. You also cannot add the AUD and NZD columns without a documented currency treatment.

When one company fails, continue useful work on the available information while keeping the scope explicit. Rerun the missing part before distributing a group-wide conclusion. Save the period and coverage notes alongside the report so that another person can reproduce the review.

## When should you use a dedicated consolidation tool?

Use a dedicated accounting workflow when you need currency translation, intercompany eliminations, mapped accounts or a formal reporting pack. A conversational comparison is useful for investigation, but those requirements need their own controls.

The [Xero App Store's reporting category](https://apps.xero.com/us/function/reporting) includes products for consolidation, forecasting and financial reporting. Assess those options against the actual deliverable your accountant or finance team needs. Atso can serve the separate task of asking follow-up questions across connected accounts.

For the connection steps, read [connecting Claude to multiple Xero organisations](/blog/claude-multiple-xero-organisations/). For the broader concept, see [MCP for business software](/blog/mcp-server-for-business-software/). You can [open Atso](https://app.atso.ai/) to connect your accounts, then begin with a single comparison you can check against the source reports.