How to choose financial consolidation software for Xero, QuickBooks and Zoho Books groups

Short answer: Choose consolidation software by testing it against the parts of your group that break the spreadsheet: mixed ledgers, foreign-currency entities, intercompany balances and the board-pack deadline. A tool that handles your hardest entity and your messiest month will handle the rest.

This guide is for finance teams whose entities run on Xero, QuickBooks Online or Zoho Books. It covers when to move off spreadsheet consolidation, the criteria to test, the questions to ask any vendor, and where spreadsheets, Fathom, Joiin and ScaleXP each fit. ScaleXP publishes this guide; competitor details come from each vendor's own website and were checked on October 15, 2026.

When a group outgrows spreadsheet consolidation

A spreadsheet consolidation stops being fit for purpose when the work of rebuilding it each month takes longer than reviewing the result. The entity count alone is a weak signal. A group of three entities in three currencies with daily intercompany recharges is harder to consolidate than six single-currency entities that never trade with each other.

The common triggers are:

• Mixed ledgers. An acquisition brings a QuickBooks Online or Zoho Books entity into a Xero group, and each month starts with exports in different formats.
• Foreign-currency entities. Someone has to source average and month-end rates, apply them correctly to the P&L and balance sheet, and explain the translation difference.
• Intercompany volume. Recharges, management fees and intercompany loans have to be matched and eliminated by hand, and the differences are investigated at the last minute.
• Board and lender deadlines. The group pack waits on the slowest entity, and late adjustments mean re-running every linked tab.
• Review and audit questions. Nobody can quickly show which adjustment changed a number, or which version of the workbook the board saw.
• Key-person risk. One person understands the workbook's logic.

If two or more of these apply, software usually pays for itself in review time rather than preparation time. For what consolidation software does, see financial consolidation software.

The evaluation criteria that matter

Each criterion below is something you can test in a trial on your own data, rather than a feature to tick off a brochure.

Entity count and group structure

Check the published entity limit and whether it changes with currencies. Fathom, for example, publishes two limits: up to 300 entities in a consolidated group, and up to 50 for multi-currency consolidation. Ask how partially owned subsidiaries, holding companies with no trading ledger and dormant entities are handled.

Mixed ledgers: Xero, QuickBooks Online and Zoho Books

Confirm that every ledger you run today has a direct connection, and ask how an entity on an unsupported system is added. A trial balance upload is the usual route, so ask who maintains it and how often it refreshes. Also ask how quickly a change posted in each ledger reaches the consolidation, since sync timing can differ by ledger.

Multi-currency and rate sources

Ask where the exchange rates come from, which rate applies to the P&L and which to the balance sheet, and whether you can override rates for a month to match what your auditors expect. Check how the translation difference is shown in the consolidated reports.

Intercompany eliminations

Find out how intercompany accounts are identified, whether eliminations are applied by account or by value, and how a mismatch between two entities is surfaced. Ask whether the eliminated amounts can be shown in their own report column, so a reviewer can see what was removed.

Chart-of-accounts mapping

Entities rarely share one chart of accounts. Test how long it takes to map each entity to a group format, what happens when a subsidiary adds a new account, and whether one mapping can be copied across entities. Check tracking categories (Xero), classes and locations (QuickBooks Online) and reporting tags (Zoho Books) if you report below entity level.

Budgets and forecasts

Ask whether you can load a group budget, roll up entity budgets, or both, and how many budget versions you can compare in one report. If you budget non-financial metrics, check that they can sit in the same report as the consolidated actuals.

Board-pack output

Ask what the board actually receives: a PowerPoint or PDF pack, a shared online view, an Excel export, or all three. Check whether commentary and charts refresh when the numbers change, so the pack is not rebuilt each month.

Audit trail of adjustments

Group adjustments such as goodwill, non-controlling interests and acquisition entries sit outside any one subsidiary. Ask where they are recorded, who can change them, and whether you can export the transactions behind a consolidated figure for your auditors.

CRM data and SaaS metrics, if relevant

Subscription groups often report ARR, MRR and churn alongside the consolidated accounts. Ask whether the tool calculates these from invoices across entities, or only reads them from a billing system, and whether HubSpot or Salesforce pipeline data can sit next to the group numbers.

Pricing model

Consolidation tools are commonly priced by the number of companies connected, by plan, or both. Model your cost at today's entity count and at the count you expect in two years, and check whether consolidated groups, extra users or additional currencies cost extra.

Questions to ask any consolidation software vendor

The table below turns the criteria into questions to put to every vendor, and what a useful answer looks like.

Where spreadsheets, Fathom, Joiin and ScaleXP fit

The four options below suit different groups. The facts come from each vendor's own website or help center, checked October 15, 2026. Where a vendor does not publish a fact, the table says "Not published", which does not mean the feature is absent.

Sources: vendor and help-centre pages listed under Sources at the end of this article, checked October 15, 2026.

Spreadsheets

Spreadsheets fit a small group with one currency, few intercompany transactions and a finance lead who owns the workbook. They cost nothing to license and can model any structure. Their limits are the ones in the first section: manual exports, rates and eliminations applied by hand, version control, and no record of who changed what unless you build one.

Fathom

Fathom publishes consolidation for up to 300 entities, or up to 50 in a multi-currency group, across a wide range of ledgers including MYOB, Sage Accounting (UK) and FreeAgent. Its consolidated groups are free of charge, with pricing based on the companies connected. Its limits, as published: multi-currency consolidations with eliminations are listed as a Pro plan feature, Zoho Books is not among the integrations it lists, and Fathom describes itself as "a management reporting tool for internal reporting, rather than as a statutory reporting tool."

Joiin

Joiin publishes consolidation for "a few or unlimited entities", with chart-of-accounts mapping and eliminations on all plans, support for partially owned subsidiaries, and connections to Xero, QuickBooks Online and Zoho Books among others. It prices by the number of companies consolidated and includes unlimited users. Its limits, as published: its consolidations page does not state the source of its exchange rates, its subscription metrics come through Stripe and are not on every plan, and its pricing page shows different figures in different places, so confirm a quote directly.

ScaleXP

ScaleXP consolidates up to 50 entities across Xero, QuickBooks Online and Zoho Books into a group P&L, balance sheet and cash flow, and adds 30+ SaaS metrics and HubSpot, Salesforce or Pipedrive data at the parent. Its limits, from its own help center:

• Entity and ledger scope. The limit is 50 entities, and entities on other systems are added through a Google Sheets trial balance rather than a direct connection.
• Intercompany set-up. You identify the intercompany accounts and move or flag them; eliminations then apply at group level.
• Group adjustments. Goodwill, non-controlling interests and similar entries go into a separate adjustment entity, which ScaleXP support links to the group.
• Zoho Books timing. Changes made in Zoho Books take 1–2 hours to import, compared with a few minutes for Xero and QuickBooks.
• Journals. Revenue recognition and month-end journals are documented for Xero and QuickBooks only.
• Tracking codes. Tracking-code reporting is available for up to 75 Xero tracking codes or QuickBooks classes.

"ScaleXp has greatly reduced the time spent in merging multicompanies with multi currencies and developing overall management KPI's."

Jane, Xero App Store review, August 2022

How ScaleXP handles group consolidation

In ScaleXP, you create a parent organization and connect each subsidiary to its own Xero, QuickBooks Online or Zoho Books ledger. You then map each entity's accounts to one group P&L and balance sheet format at the parent, and Cascade from Parent copies that structure to the subsidiaries. Subsidiary results convert into the parent currency at month end. The P&L uses the average monthly rate and the balance sheet uses the rate on the last day of the month.

Intercompany accounts are moved into intercompany categories or flagged on the Eliminated Accounts page. They stay visible in each subsidiary and are eliminated at group level. Budgets can be loaded at the parent or built up from subsidiary budgets. Reports export to Excel or CSV, including the transaction detail behind a P&L, and presentations download as PowerPoint or PDF board packs. Read more on the financial consolidation software page, or see Xero and QuickBooks consolidation and Zoho Books consolidation.

Conclusion

Move off spreadsheet consolidation when mixed ledgers, currencies or intercompany volume make the monthly rebuild slower than the review. Shortlist tools on ledger coverage first, then test FX rules, eliminations and the board-pack output on your own data. Fathom and Joiin cover a wider range of ledgers. ScaleXP fits groups of up to 50 entities on Xero, QuickBooks Online and Zoho Books that also report SaaS metrics or CRM data. Compare plans on the pricing page.

Frequently asked questions