How to consolidate financial statements across QuickBooks and Xero

Consolidating a group of entities is straightforward when every ledger lives in the same system. It gets harder the moment your clients are split across accounting packages — one company on QuickBooks Online, another on Xero, a trust somewhere in between. This guide walks through how to produce one clean set of consolidated financial statements regardless of which package each entity uses.

Why cross-package consolidation is hard

QuickBooks and Xero structure their charts of accounts differently, use different account types, and export data in different shapes. A manual consolidation usually means exporting a trial balance from each ledger, pasting them into a spreadsheet, mapping every account by hand, and rebuilding the whole workbook every reporting cycle. It is slow, error-prone, and painful to review.

The four steps

1. Connect every ledger

Link each entity's QuickBooks or Xero file through a secure OAuth connection. There is no need to keep all your clients on one package — a single group can freely mix QuickBooks and Xero ledgers. Each connection pulls in the full chart of accounts and up to five years of period data.

2. Map each ledger to a group chart of accounts

Allocate every source account to a line in a unified group chart of accounts. This is where the two packages are reconciled: whatever an account is called in QuickBooks or Xero, it flows into a consistent group line. The mapping is saved per account, so you only set it up once — future runs apply it automatically.

3. Post consolidation adjustments and eliminations

Add consolidation adjustments and elimination journals to remove intercompany balances — loans between group members, internal sales, and investments in subsidiaries. See our guide on intercompany eliminations for the detail on which balances to remove and why.

4. Generate the consolidated statements

With ledgers mapped and eliminations posted, produce a consolidated Profit & Loss, Balance Sheet and Trial Balance — bundled into a single, print-ready PDF alongside the front cover, compilation report and notes. Comparative periods and percentage analysis come through for the whole group.

Tips for a clean consolidation

• Agree the group chart of accounts before you start mapping — it is far easier than reworking it later.
• Re-sync each ledger before a reporting run so the consolidation reflects the latest data.
• Keep intercompany accounts clearly named in each ledger so eliminations are quick to identify.
• Review the consolidated trial balance first — if it balances, the statements will too.

For an overview of the whole workflow, see consolidation reporting for QuickBooks and Xero.