How to Consolidate Multiple QuickBooks Companies

Guide by RankerToolAI · Updated November 2026 · Based on Intuit's and each vendor's published help, feature and pricing pages, not a hands-on test. See our methodology.

Disclosure: this page contains affiliate links, including to Joiin. We may earn a commission if you buy through them, at no extra cost to you. Read our disclosure.

Quick Answer

Standard QuickBooks Online plans report one company at a time. Intuit's own answer for groups is Intuit Enterprise Suite, which adds consolidated reports and eliminations; on Desktop, Desktop Enterprise can combine reports from several company files. For everyone else: two simple companies fit in a spreadsheet, and for three or more, foreign subsidiaries or monthly board packs, connect the companies to an app such as Joiin (from $23/mo billed annually, eliminations included).

Try Joiin free for 14 days →Full Max plan, no credit card. Affiliate link.

Why QuickBooks Online Can't Do It on Its Own

Each QuickBooks Online subscription is one company with its own chart of accounts, and its reports only run inside that company. Answers on Intuit's own community forum say it plainly: QuickBooks permits one company per subscription and the standard plans have no feature to consolidate transactions and reports across companies.

Classes and locations don't fix this. They split one company's figures by department or branch. If your group has separate legal entities, each with its own balance sheet and tax registration, they need separate company files, and the consolidation has to happen somewhere else.

The Four Options at a Glance

OptionBest forEliminationsMain catch
Intuit Enterprise SuiteGrowing multi-entity businesses ready to move up from QuickBooks OnlineYes, built inA bigger product and a platform move, not an add-on
QuickBooks Desktop EnterpriseU.S. groups already on Desktop EnterpriseIntercompany transactions on Platinum and Diamond onlyU.S. only; files must share one Desktop version; needs Microsoft Office
SpreadsheetTwo companies with simple, similar booksManual, every monthBreaks as accounts, entities or currencies are added
Consolidation app (e.g. Joiin)Groups on standard QuickBooks Online plans, or on mixed ledgersSet once, reused monthlyAn extra subscription priced by number of companies

Intuit Enterprise Suite

Intuit Enterprise Suite is Intuit's multi-entity product. Intuit's help article lists consolidated reports including a Consolidated Profit and Loss, Balance Sheet, Cash Flow Statement and Trial Balance, plus consolidated A/R and A/P aging, sales by customer and transaction reports. Users with access to two or more companies can filter the consolidated view by company, shared dimension or transaction origin.

Intuit also documents multi-entity eliminations and journal entries, intercompany transactions (marked "IC" in reports) and mapping charts of accounts by name or through a shared chart of accounts. If your group is outgrowing QuickBooks Online and you want everything in one Intuit system, start here. Pricing is not shown on those help pages, so get a quote from Intuit before comparing it with the options below.

QuickBooks Desktop Enterprise

On the desktop side, Intuit's multi-company page says Desktop Enterprise can manage multiple companies from a single dashboard with combined reporting and intercompany transaction tracking. Three conditions apply, per that page:

  • To consolidate reports from multiple company files, the files must all be on the same version of QuickBooks Desktop Enterprise.
  • The feature requires Microsoft Office 2013-2019 or Microsoft 365.
  • Intercompany transactions are only available on the Platinum and Diamond subscriptions.

Intuit also notes Desktop Enterprise is not available outside the U.S. If you run QuickBooks Pro or Premier, or a subsidiary sits outside the U.S., use one of the next two methods.

The Spreadsheet Method

For two companies with similar charts of accounts, a spreadsheet works:

  1. In each company, run the Trial Balance report for the same period end and accounting method (accrual or cash).
  2. Export each report to Excel and paste it into its own tab.
  3. Map every account to one group chart of accounts with a lookup column.
  4. Add an eliminations column that reverses intercompany sales, management fees, loans and balances.
  5. Sum the mapped columns plus eliminations to get the consolidated trial balance, then build the P&L and balance sheet from it and check the balance sheet still balances.

Our free consolidation Excel template sets this up for you, with eliminations and balance checks built in. The problem is upkeep: every new account breaks the mapping, every month needs fresh exports, and eliminations are typed in by hand. Once you have three or more companies, a foreign subsidiary or a board that wants a monthly pack, the spreadsheet usually costs more in time than an app costs in fees.

Using Joiin With QuickBooks Online

Joiin connects directly to QuickBooks Online. Its QuickBooks page describes consolidating multiple QuickBooks Online companies into group reports with intercompany eliminations, multi-currency options and budgets and forecasts, with data kept in sync automatically. Setup follows the same logic as the spreadsheet, done once:

  1. Start a free trial (14 days on the Max plan, no credit card).
  2. Connect each QuickBooks Online company.
  3. Map each company's accounts to one group reporting structure.
  4. Set eliminations for your intercompany accounts.
  5. Choose the reporting currency (multi-currency needs Pro or Max) and run the consolidated P&L, balance sheet, cash flow and trial balance.
CompaniesJoiin monthlyJoiin annual (per month)
1$28$23
2$36$29
5$70$57
10$111$92
20$167$139

USD, joiin.co/pricing, checked November 14, 2026. Unlimited users, reports and clients. Use our consolidation cost calculator to compare with other tools.

For a company still on QuickBooks Desktop, Joiin doesn't list a direct Desktop connection; its "unplugged" reporting works from spreadsheet data instead. Read our full Joiin review for plan details.

Consolidate your QuickBooks companies

Connect them to Joiin's 14-day Max trial, no credit card, and compare the consolidated totals with your spreadsheet.

Start a Free Joiin Trial →

Affiliate link. We may earn a commission at no extra cost to you.

Groups With QuickBooks and Other Ledgers

Acquired subsidiaries often keep their own system, and overseas companies may run software that suits their country. Joiin also connects to Xero, Sage, MYOB, FreeAgent, Zoho Books, Pennylane and Fortnox, so a U.S. parent on QuickBooks Online and an Australian subsidiary on Xero can report together without migrating either. See Joiin vs Fathom and our best consolidation software list if you're comparing tools.

FAQ

Can QuickBooks Online consolidate multiple companies?

Not in the standard plans. Each QuickBooks Online subscription covers one company, and its reports run inside that company. Intuit Enterprise Suite, Intuit's multi-entity product, adds consolidated reports such as a consolidated P&L, balance sheet, cash flow and trial balance. On other plans, groups combine reports in a spreadsheet or connect the companies to a consolidation app such as Joiin.

Can QuickBooks Desktop combine reports from multiple company files?

QuickBooks Desktop Enterprise can combine reports from multiple company files, according to Intuit's multi-company page. The files must be on the same version of Desktop Enterprise and the feature needs Microsoft Office 2013-2019 or Microsoft 365. Intercompany transactions are only available on the Platinum and Diamond subscriptions.

Does Joiin work with QuickBooks?

Joiin connects directly to QuickBooks Online. Its QuickBooks page describes consolidation of multiple QuickBooks Online companies with intercompany eliminations, multi-currency options, budgets and forecasts, with data kept in sync automatically. Joiin also connects to Xero, Sage, MYOB, FreeAgent and other ledgers, so a group doesn't have to run every company on QuickBooks.

How much does it cost to consolidate QuickBooks companies with Joiin?

Joiin prices by the number of companies. On November 14, 2026 its pricing page listed $36/mo for two companies billed monthly ($29/mo billed annually), $70/mo for five ($57 annually) and $111/mo for ten ($92 annually), in USD, with unlimited users. There is a 14-day free trial of the Max plan with no credit card.

Related

Joiin · 14-day free trial, no card · from $23/mo billed annually
Start Free Trial →