
Consolidated Trial Balance in Xero: How to Build One Across Entities
Adding up the trial balances is easy. Proving the total makes sense is the real job.
The auditor's request list for a five-company group has a line that looks routine: trial balance by entity and in total, as at 30 June. Someone exports five trial balances from Xero, pastes them into five tabs and sums them on a sixth. Then the questions start. Why does one company show a revenue account the others don't? Why does one subsidiary's year to date cover only three months? And why, once the US dollar column is filled in, do the debits and credits no longer agree?
A consolidated trial balance in Xero isn't hard to add up. What's hard is a total that everyone can trust. This post covers how to build one across entities: what goes in each column, where it breaks, and the checks that prove it's right.
Why a consolidated trial balance isn't the companies added up
A trial balance is the list of every account in the ledger with its balance, debits on one side and credits on the other. In a single company the two sides always agree, which is the whole point of it. It's the raw material for the accounts, and the first thing an auditor or a group accountant asks for.
A group version has to do more than sum. Each company keeps its own chart of accounts, its own currency and sometimes its own financial year. The companies also owe and charge each other, which a group total has to remove. Done properly, a multi-entity trial balance is a small pipeline:
- Each company's trial balance, exactly as Xero has it, in its own currency.
- Each account mapped to a group account.
- Each company translated into the group's reporting currency.
- A combined total: the companies added together.
- Eliminations for the balances between them.
- A consolidated total: combined, less eliminations.
Most spreadsheet versions jump from step 1 to step 4, and that's where the questions come from.
What Xero gives you
Xero's trial balance runs for one organisation at a time. Xero's own reports, including Xero Analytics, don't combine organisations, and Xero's answer on its product ideas board in July 2025 was that consolidated reporting is "not currently planned".
Inside one organisation, the report is solid. In July 2026 Xero added a Trial Balance by Date Range report, so you can see movement over any period, not just as at a date. Xero's API returns the trial balance for one organisation and one date, with four value columns: the month's debits and credits, and the debits and credits for the financial year to date.
That's enough to build from. Every column a group trial balance needs can be derived from those four, one organisation at a time.
The method
Lay out each company as a block of columns, side by side, with the group's accounts down the page:
- Movement pair. Debit and credit for the month.
- Year-to-date pair. Debit and credit for the financial year so far. For balance sheet accounts this is the closing balance. For profit and loss accounts it's the year's activity.
Keep both pairs. The movement pair answers "what happened this month?", which is what a group accountant reviewing the close wants. The year-to-date pair is what ties to the balance sheet and what the auditor reconciles.
Each company's block stays in its own currency first. Next to it sits a translated block in the group's reporting currency. To the right come the combined total, an eliminations column and the consolidated total. Every figure in the combined column is a formula over the company columns, so anyone can trace a group number back to the company and the Xero account it came from.
Want the group view without the pasting? Cheetah builds consolidated reports on top of Xero, with each company's numbers kept traceable to its own ledger.
Where the difficulty actually lives
Every company has its own chart of accounts
One company calls it "Sales – Retail", another "Revenue: Shop" and a third splits it across three accounts. The group needs one row. That means an account map: a table that sends each company's account to a group account, with the company's own code and name kept alongside so nothing loses its origin.
The map is where errors hide. A bookkeeper adds a new account in March and nobody updates the map, so that balance quietly vanishes from the group total. The fix is a check that runs every time: any account with a balance and no mapping is listed, with its amount, and the mapped total is compared with the unmapped total for every company. We cover keeping a map like this alive across several charts of accounts in multi-entity Xero reporting.
Accounts with no balance disappear
Xero's trial balance leaves out accounts with a nil balance. That's tidy for one report and awkward for a template. An account that had a balance last month and none this month drops out, every row below it moves up, and a spreadsheet that looks things up by row position starts reading the wrong numbers.
Build the group view by matching account codes, never by row position. And treat an account that disappeared as worth a glance, not as a formatting problem.
Year to date means each company's own year
Xero resets the year-to-date columns at each organisation's own financial year start. If the parent's year ends in December and a subsidiary's ends in March, the subsidiary's year-to-date profit at 30 June covers three months while the parent's covers six. Add them together and you get a number that describes no period at all.
For balance sheet accounts this doesn't matter: a closing balance is a closing balance. For profit and loss accounts it does. The answer is to build the group's year to date from the monthly movements, summed over the group's own year, and to treat the company's own year-to-date figure as the thing you check against, not the thing you report. The same issue shows up when a company joins part-way through the year, which we go through in consolidating a mid-year acquisition.
Currencies break the balance
Each company balances in its own currency. Translation is where the debits and credits stop agreeing, because group reporting translates different lines at different rates. Balance sheet balances use the closing rate on the reporting date. Profit and loss lines use an average rate for the period, because the income and costs came in across the period, not on the last day.
Take a subsidiary that reports in euros, with a profit for the year of €50,000, opening equity of €250,000 and net assets of €300,000. Translate the profit at an average rate of 1.05 and it's $52,500. Translate everything on the balance sheet at the closing rate of 1.10 and net assets are $330,000, while the opening equity comes to $275,000. Equity plus profit is $327,500. The trial balance is out by $2,500.
That $2,500 isn't an error. It's the translation difference, the effect of the rate moving during the year, and it belongs on its own line in equity, usually called the translation reserve. (Real builds translate share capital at the rates when it was issued, which changes the number but not the point.) What it must never be is an unlabelled balancing figure or a rounding account. If it sits on a named line and is calculated as exactly the gap between the two rates, the translated trial balance balances by construction, and a sudden jump in that line tells you a rate or a balance is wrong. For more on why Xero can't do this translation itself, see Xero multi-currency reporting.
Combined isn't consolidated
A parent lends a subsidiary $200,000. The parent shows a receivable, the subsidiary a payable. Add them together and the group appears to owe itself $200,000. Management fees, recharges and the parent's investment in each subsidiary all work the same way.
Keep eliminations in their own column rather than editing the company figures. The combined column then still ties to each company's Xero ledger, the consolidated column shows the group, and the eliminations column is the bridge between them. When the two sides of an intercompany balance don't agree, which is common, the difference is visible rather than buried. Our guide to intercompany eliminations in Xero covers matching the two sides, and the intercompany FX difference covers what's left when they're in different currencies.
Debits and credits sit on one side
Xero shows each account's balance on one side only: a net debit or a net credit. Across a group, the same group account can be a debit in one company and a credit in another, for example a bank account that's overdrawn in one company only.
Decide once how the combined column works. Netting each group account to one side gives a cleaner trial balance. Keeping each company's figure on the side Xero shows it makes it easier to trace back. Either way, the totals must still agree, and the choice should be the same every month.
What a reliable build looks like
- Xero's figures, untouched, per company. Movement and year-to-date pairs in each company's own currency, exactly as its Xero trial balance shows them.
- A tie-out to Xero for every company. The recomputed debit and credit totals equal the total Xero reports for that organisation, checked on every run. If they differ, the report says so before anyone reads it.
- One account map, matched by code. Any account with a balance and no mapping is listed with its amount.
- The group's year, built from movements. Not the companies' own year-to-date figures added together.
- Rates you can see and change. Closing and average rates in their own tab, with the source noted, and a translation difference on a named line.
- Combined, eliminations, consolidated. Three columns, so the group figure always reconciles to the sum of the companies.
- No missing companies. If one organisation's Xero connection has lapsed, the run stops rather than producing a group total with a company missing.
Where Cheetah fits
Cheetah builds custom reports on top of Xero, and trial balances across entities are a regular request. For one multi-currency group, we built a workbook with a tab for every company. Each tab shows the movement and year-to-date pairs from that company's Xero trial balance, in its own currency. The report recomputes every total and checks it against the total Xero reports, warning on any difference. If any company's Xero connection is missing, the run stops and names it.
The group-level steps sit in our consolidation builds. They translate profit and loss lines at each month's average rate and the balance sheet at the closing rate. The rates sit in an exchange rate tab you can overwrite, and the translation reserve is a named line, so the group balance sheet balances by construction. Everything arrives as a Google Sheet with formulas you can trace and an Excel download, and it refreshes from Xero whenever you run it.
If your group trial balance is still five exports and a sum on a sixth tab, Cheetah might be worth a conversation.
The short version
A consolidated trial balance in Xero is a pipeline, not a sum: each company's trial balance as Xero has it, mapped to group accounts, translated, combined, and then eliminated. Xero runs the trial balance one organisation at a time, so the group view is always built outside it.
Most of the work goes into the checks. Tie every company back to its own Xero total. List every unmapped account. Build the group's year from monthly movements. Put the translation difference on a named line, and keep eliminations in their own column. For the wider choice of how to build group reports, see our guide to consolidation software for small groups and Xero Custom Reports: 4 Ways to Build Them in 2026.
Frequently asked questions
- Can Xero produce a consolidated trial balance?
- No. Xero's trial balance runs for one organisation at a time, and its own reports, including Xero Analytics, don't combine organisations. Xero's response on its product ideas board, in July 2025, was that consolidated reporting is not currently planned. To get a trial balance across several companies you either export each one and combine them in a spreadsheet, or pull each organisation's trial balance through Xero's API and build the combined view outside Xero.
- What is the difference between a combined and a consolidated trial balance?
- A combined trial balance adds the companies' balances together, account by account. A consolidated trial balance goes one step further and removes what the companies owe and charge each other, such as intercompany loans, management fees and investments in subsidiaries. Keeping the two as separate columns means the combined figures still tie to each company's own trial balance, and every elimination is visible on its own.
- Why doesn't my consolidated trial balance balance after currency translation?
- Because group reporting translates different lines at different rates. Balance sheet balances use the closing rate on the reporting date, profit and loss lines use an average rate for the period, and equity often uses the rates when it arose. Each company balances in its own currency, but once its lines are translated at different rates the debits and credits no longer agree. The gap is the translation difference, and it belongs on its own named line in equity (often called the translation reserve), not in a rounding account.
- How do you check a multi-entity trial balance is complete?
- Tie every company's column back to its own Xero trial balance: the recomputed debit and credit totals should equal the total Xero reports for that organisation. Then check that the combined column is exactly the sum of the company columns, that no account with a balance is missing from the account map, and that debits equal credits at every stage, with the translation difference as the only named balancing line.

A finance professional turned product builder, Jarvin has built hundreds of reports by hand and knows what financial and operational reporting demands: customisability, auditability, scalability, and security. Having automated that work reliably, he's now helping advisory firms and finance teams do the same.