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: there's no native way to consolidate reporting across orgs.

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

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

1. Claude Desktop with Cowork enabled. You'll need a paid Claude plan (Pro or Max). Open the desktop app, switch to the Cowork tab.
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 will use your browser session (via Claude in Chrome) to navigate Xero. You'll need to be logged into the relevant organisations, or have the credentials ready.

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 period January to March 2025 across three Xero organisations: [Org A], [Org B], and [Org C]. Log into each one, export the P&L for that period as a CSV, 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 Claude in Chrome, 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 CSV 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 CSVs — 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'll flag it rather than silently miscategorise it.

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 proper consolidation accounting, not automation
• 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. But if this is a monthly requirement, you're going to be re-running the same prompt every cycle. That works for most reports, but 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.

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

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.