Guides

Practical guides on getting Xero data into Excel — Power Query, trial balances, multi-organisation reporting, and more.

Consolidating Multiple Xero Organisations in One Excel Workbook

How to combine trial balances from several Xero organisations into a single Excel workbook with Power Query — the append pattern, a shared mapping table, intercompany eliminations, and where the file-based approach stops scaling.

24 August 2026

How to Connect Excel to Xero with Power Query

The three realistic ways to connect Excel to Xero with Power Query — cleaned exports, calling the Xero API directly, and querying a synced database — with a working M query for each.

17 August 2026

Getting Xero Data into Excel: Your Options Compared

A practical comparison of every way to get Xero data into Excel, from CSV exports to live Power Query connections.

7 July 2026

Xero Trial Balance in Excel with Power Query: A Step-by-Step Guide

How to get a Xero trial balance into Excel with Power Query — cleaning manual exports, building a 12-month TB from a folder of files, and connecting to a live synced database.

7 July 2026