How to Use Claude Cowork to Build a Consolidated Xero Report Across Multiple Organisations

If you manage more than one Xero organisation — whether you're running a group of related entities or handling a portfolio of clients at an accounting firm — you already know Xero's dirty little secret: on its standard plans, there's no native way to consolidate reporting across orgs. (Xero's new Ultra plan, launched in Australia in July 2026, includes consolidated reporting.)

You want a single P&L. Xero gives you five tabs.

The standard workaround is tedious and familiar: log into each org, navigate to the report, export it, paste it into a master spreadsheet, reconcile the columns, fix the date formats that somehow never match, and repeat every month. If you're doing this for three entities, it's annoying. For ten, it's a part-time job.

Claude Cowork offers a better path. Here's how to use it to pull reports from multiple Xero organisations and assemble a consolidated view — no manual copy-pasting required.

What Claude Cowork actually does

Cowork is Anthropic's desktop AI agent, available through the Claude Desktop app on macOS and Windows. Unlike a regular chat interface, Cowork can act: it accesses your local file system, browses the web, executes multi-step tasks, and uses MCP connectors to interact with external services — all triggered by plain-language instructions.

The practical implication for finance work: you describe the outcome you want, and Cowork figures out the steps and executes them. You can step away and come back to finished work.

If your organisation policy does not allow you to download external software, you might want to check out how you can create custom reports the old school way. That does not require you to download anything.

The Setup

Update, September 2026: Anthropic announced on 16 September that Cowork is merging into the main Claude app. Pro and Max accounts get the change first, then Team and Free. The separate Cowork tab and the Cowork name are being retired, but your chats, projects, artifacts, connectors and skills carry over. If you don't see a Cowork tab, just ask Claude for the task and read "Cowork" below as "Claude".

Before you run anything, a few things to have in place:

1. Claude Desktop (macOS or Windows) on a paid plan: Pro, Max, Team or Enterprise. On Team and Enterprise, your admin controls access. Open the app and hand Claude the task. If your account still shows a Cowork tab, use that.
2. A destination folder. Create a folder on your machine — something like /Reports/Xero-Consolidation/ — and point Cowork at it. This is where your exports and the final output will live.
3. Your Xero logins. Cowork needs a browser to navigate Xero. By default it uses its own built-in browser in the desktop app, with nothing to install. Sign in to Xero once and it remembers the login across sessions. Or install Claude in Chrome, which works in your own Chrome with the accounts you're already signed in to. Anthropic's help centre strongly advises against using the built-in browser to manage or take actions involving sensitive information, so read its safety guidance before you point it at financial data.

Step-by-step: Building the Consolidated Report

Step 1: Tell Cowork what you want

Start with a clear task description. Something like:

"I need a consolidated Profit & Loss report for the last completed quarter (April to June 2026) across three Xero organisations: [Org A], [Org B], and [Org C]. Log into each one, export the P&L for that period as an Excel file, save each file to my Xero-Consolidation folder, then combine them into a single Excel spreadsheet with one row per account line, summed across all three orgs. Label each source column by org name."

Cowork will interpret this, plan the steps, and show you its approach before running. Review it, then let it go.

Step 2: Cowork navigates each Xero org

Using its browser (the built-in one, or Claude in Chrome if you've installed it), Cowork will open Xero, navigate to each organisation's Reports section, pull up the Profit & Loss, set the date range, and export. It saves each file to your designated folder.

This is the part that normally takes 15-20 minutes of repetitive clicking per org. Cowork runs through it while you're doing something else.

Step 3: Cowork builds the consolidation

Once all exports are saved locally, Cowork will process the files — aligning account codes and line item names, handling any naming inconsistencies between orgs, summing balances where accounts match, and building a clean combined spreadsheet.

If you want an eliminations column (for intercompany transactions), include that in your original instruction. Cowork won't know to add it unless you ask.

Step 4: Review and adjust

Cowork surfaces its reasoning throughout the task, so you can see exactly what it did and where it made judgment calls. If an account name in Org B doesn't match Org A, it should flag it rather than silently miscategorise it, but spot-check the mapping.

You can jump in mid-task to steer it — for example, if the chart of accounts differs meaningfully between entities and you want specific mapping rules applied.

What this is good for (and what it isn't)

Good for:

• Ad-hoc consolidations when you need a quick cross-org view
• Month-end consolidations where you're doing it manually today
• Situations where the chart of accounts is reasonably consistent across orgs
• Firms running a moderate number of client entities who want to move faster without building bespoke tooling

Less suited for:

• Highly complex group structures with multi-currency eliminations and minority interests — this needs a purpose-built consolidation, not an ad-hoc agent session
• Organisations where the chart of accounts diverges significantly and requires careful manual mapping
• Bespoke needs with complex business logic like non-conventional business periods

There are ways to help Cowork over these challenges – providing all the organisational context required, cleaning up inconsistent chart of accounts, systemizing bespoke business logic, etc.

They might take some time to set up but they do provide compounding benefits in the long-run.

The recurring reporting problem

Cowork is excellent for getting a consolidated report done today. If this is a monthly requirement, you no longer have to re-run the same prompt by hand, because Cowork can run a saved task on a schedule. There is a catch. Scheduled tasks run remotely, but a task that needs local files or apps only runs locally, and can't be tied to a folder on your computer. The export-to-folder workflow above needs local files, so it would fall into that second group. Xero also launched its own connector for Claude in May 2026. It is read-only, so Claude can answer questions from your live Xero data but can't change anything in your books, and it connects to one Xero organisation at a time. For quick questions across all of them, here's how we use Claude across multiple Xero organisations in Ask Cheet. Either way, the agent works out the report afresh on each run, so you might run into inconsistent output structure across different instances.

For extremely complex reports, there's a ceiling on how much you can reliably automate through general-purpose desktop instructions before you'd rather have something built specifically for your reporting logic.

That's where Cheetah comes in. If you're managing multiple Xero entities and producing the same consolidated reports month after month, it makes more sense to have those reports built to your exact spec once, and delivered instantly on demand — rather than orchestrating a Cowork session each time. Cheetah reports can also run on a schedule with rolling periods like "last month", and arrive by email as a Google Sheet link with a one-click Excel download. Intercompany eliminations, FX translation and mapped group structures are built once, not re-interpreted on every run. See scheduled reports and multi-entity consolidation.

The two approaches aren't mutually exclusive: Cowork is useful for exploration and one-offs; a custom-built solution handles the recurring work cleanly, reliably and deterministically.

The bottom line

On its standard plans, Xero's cross-org reporting gap isn't going away. Until then, Claude Cowork is a genuinely useful stopgap — it removes most of the manual effort from pulling and combining reports, without requiring any development work. If you've been living in a spreadsheet every month trying to piece together a group view, it's worth spending twenty minutes setting this up and seeing what it does.

The instructions don't have to be perfect on the first try. Describe what you want, watch the first run, adjust, and iterate. That's exactly what Cowork is designed for.

---

Updated 20 September 2026: Anthropic is merging Cowork into the main Claude app, so I added a note on that and updated the setup steps (all paid plans, and the built-in browser alongside Claude in Chrome). I also rewrote the recurring reporting section to cover scheduled tasks and the read-only Xero connector, and made clear that the missing consolidation is on Xero's standard plans.