How to consolidate multiple QuickBooks Online companies into one P&L (2026)

QuickBooks Online treats every company as a separate file, and Simple Start, Essentials and Plus can't combine them into one P&L. To consolidate, you either rebuild the roll-up in Excel every month or connect each company file to a tool that maps them to one chart of accounts and rolls them up for you.

There are two partial options inside Intuit's own products. QuickBooks Online Advanced can combine reports from several companies in Excel through Spreadsheet Sync, as long as the accounts match exactly. Intuit Enterprise Suite adds real multi-entity accounting, though several of those features were still in beta as of October 2026.

Bottom line: With two or three companies in one currency and little intercompany activity, a disciplined Excel workbook or Spreadsheet Sync is enough. Once the charts of accounts differ, entities trade with each other, or you need to drill into transactions, connect each company to a tool that maps the accounts once and refreshes the consolidated P&L for you.

Can QuickBooks Online consolidate multiple companies?

Not on Simple Start, Essentials or Plus. Each company is its own subscription with its own books, and there's no consolidated report across them. What Intuit does offer depends on the tier:

• QuickBooks Online Advanced: Spreadsheet Sync. Advanced can pull the P&L, balance sheet and trial balance from several companies into one Excel workbook and combine them. Per Intuit's help article on combining reports, accounts only merge when they have the same name, the same type and sit at the same level in the hierarchy, so Intuit recommends identical charts of accounts. The article doesn't cover intercompany eliminations or currency translation.
• QuickBooks Online Accountant: multi-entity reports. Intuit has introduced consolidated P&L and balance sheet reports across client companies for accounting firms, with merged accounts and report-only elimination adjustments. Intuit says availability varies by region, and we couldn't find a US help article for it yet.
• Intuit Enterprise Suite. Intuit's mid-market product, launched in September 2024, is an upgrade from QuickBooks Online rather than an add-on. Its spring 2026 release added transaction-level intercompany eliminations. A shared chart of accounts, multi-level entity hierarchies and multi-currency consolidation were still in beta in the summer 2026 release notes, with multi-currency limited to a US-dollar functional currency for now.

If you're on Plus or Advanced today and the entities don't trade with each other, Spreadsheet Sync or a well-built workbook can carry you for a while. The rest of this page covers what to do when they can't.

How to consolidate QuickBooks companies in Excel

The manual method is the same consolidation any accountant learns, done by hand each month. AccountingTools' walkthrough of consolidation accounting covers the full close; for a management P&L it comes down to six steps:

1. Export each company's P&L for the same period and on the same basis (accrual, ideally by month, not year to date).
2. Map every account to one reporting chart of accounts. Build a mapping table: entity, account number, account name, consolidated line. This is where most errors start, because the same GL number can mean different things in different entities.
3. Stack the mapped data in one sheet and sum by consolidated line.
4. Eliminate intercompany activity. Management fees, intercompany sales and cost of sales, and loans between entities should net to zero across the group. Remove both sides.
5. Translate foreign entities into the parent's currency. Under IAS 21, income and expenses use the rate at the transaction date (an average rate is the usual practical shortcut), and balance sheet items use the closing rate.
6. Check the result. Consolidated net income should equal the sum of the entities' net income, less eliminations. If it doesn't, a mapping is wrong.

This works, and plenty of finance teams run it for years. It starts to crack in predictable places:

• Mapping drift. Someone adds an account in one company, the mapping table doesn't know about it, and the number lands in "unmapped" or, worse, in the wrong line.
• No drill-down. When the CEO asks what's in a consolidated expense line, the answer is three exports and a VLOOKUP away.
• Version confusion. Each refresh is a new export, so nobody's sure which file the board pack used.
• Time. It's a rebuild every month, and it grows with each entity you add.

If those sound familiar, our guide on when to move from Excel to FP&A software covers the tipping points.

What a connected consolidation should do

The alternative is to connect each QuickBooks Online company once and let software repeat the six steps. Whatever tool you look at, check how it handles these five things:

1. One mapping layer, per entity. You should be able to map account 6100 in Company A to "Software" and account 6100 in Company B to "Contractors" without renaming anything in QuickBooks. Ask how the tool flags new, unmapped accounts.
2. Intercompany eliminations. Some tools post elimination entries in the consolidation; others only show the intercompany balances side by side so you can see what doesn't tie. Know which one you're buying.
3. Currency. Check whether the tool translates with proper average and closing rates and a translation adjustment, or simply converts at one rate for reporting.
4. Drill-down to transactions. A consolidated line should open to the entity, then the account, then the transactions behind it.
5. Refresh. Actuals should update from each company on a schedule or on demand, without anyone exporting a file.

What about QuickBooks Desktop files?

Cloud tools can't connect to QuickBooks Desktop the way they connect to QuickBooks Online. Desktop has no cloud API. Third-party apps go through Intuit's QuickBooks Web Connector, which runs on the machine where the company file lives, or you export reports and upload them.

Most native connectors in FP&A software, Aleph's included, connect only to QuickBooks Online, so Desktop files come in by export. A few reporting tools, such as Qvinci, document support for both Desktop and Online files.

Intuit stopped selling most QuickBooks Desktop products to new US subscribers after September 30, 2024. Existing subscribers can renew, and Desktop Enterprise is still sold. If one of your entities is still on Desktop, plan a migration to Online alongside the consolidation project; it removes the export step for good.

Tools that consolidate multiple QuickBooks companies

The options split into three groups: Intuit's own products, reporting tools built for accountants and small groups, and FP&A platforms that consolidate actuals to feed a plan. Here's what each documents as of October 2026:

Capabilities are from each vendor's own site or help center. We didn't compare pricing; reporting tools tend to publish plans, and FP&A platforms are mostly quote-based. Reach Reporting, Syft (now owned by Xero), Jirav and Abacum also offer multi-entity roll-ups; Jirav's help center describes workarounds for QuickBooks, including one that turns entities into departments.

Which approach fits your group?

Match the method to what the consolidated P&L is for:

• Two or three companies, one currency, little intercompany: Spreadsheet Sync on Advanced, or a clean Excel workbook with a locked mapping table.
• An accountant or fractional CFO reporting for client groups: a reporting tool like Fathom, Spotlight or Joiin, built for many small groups at once. Our guide to FP&A software for fractional CFOs goes further.
• A statutory close with posted eliminations and currency translation: Intuit Enterprise Suite if you want to stay with Intuit, or a dedicated consolidation engine. Our comparison of multi-entity consolidation software sorts the engines from the reporting layers.
• Consolidated actuals that feed a budget and forecast: an FP&A platform such as Aleph, Cube or Datarails, so the same mapped actuals drive budget vs actual and the reforecast. See the best FP&A tools for QuickBooks for the wider list.

Where Aleph fits

Aleph connects natively to each QuickBooks Online company, along with your HRIS, CRM and billing system, and maps every company's accounts into one reporting rollup. The consolidated P&L lives in the Excel or Google Sheets model your team already uses, refreshes with a click or on a schedule, and drills down to the data underneath. AI mappings flag unmapped or misclassified accounts when a company adds a new one, which is where manual consolidations usually break.

To be clear about the limits: Aleph is a reporting and planning layer, not a statutory consolidation engine. It brings each entity's intercompany balances together so you can see which pairs don't tie, but it doesn't post elimination entries. Its currency handling converts at the rates you provide for reporting rather than performing full IAS 21 translation. QuickBooks Desktop files come in by export.

If your goal is a consolidated management P&L, budget vs actual across entities and a forecast built on it, that's the job Aleph does well. For the budgeting side, see budgeting software for QuickBooks and Excel.

Consolidate your QuickBooks companies with Aleph

Connect every QuickBooks Online company once, map the accounts once, and get a consolidated P&L that refreshes inside your own spreadsheet. Book a demo to see it on your entities.