How to Combine Reports from Multiple QuickBooks Online Companies: Every Method Compared
How to Combine Reports from Multiple QuickBooks Online Companies: Every Method Compared
QuickBooks Online cannot combine or consolidate reports from multiple companies natively. Each QuickBooks Online company is a completely separate account with its own subscription, its own chart of accounts, and its own reports. There is no built-in way to run a Profit and Loss, Balance Sheet, or Cash Flow statement across two or more QBO companies at once, and no way to merge two QBO company files into one. Intuit's official guidance is to export each company's reports and combine them manually in Excel or Google Sheets, applying your own account mapping and intercompany eliminations along the way.
That leaves four real options for combining reports from multiple QuickBooks Online companies: (1) export each company's reports and merge them by hand in Excel or Google Sheets; (2) use Spreadsheet Sync (available on QBO Advanced and QuickBooks Online Accountant) to pull data from multiple companies into one workbook (a data pipe, not a consolidation); (3) switch to QuickBooks Desktop Enterprise, which has a built-in Combine Reports feature; or (4) use third-party consolidation software such as FinBoard.ai that connects to every QBO company and automates account mapping, eliminations, and consolidated reporting. For any group that needs consolidated financials monthly, rather than once a quarter after heroic spreadsheet effort, consolidation software is the standard answer. The rest of this article covers what each method actually delivers, where each one breaks, and how to choose.
Why QuickBooks Online Cannot Consolidate on Its Own
QuickBooks Online was designed as single-entity accounting software. Every company file is an isolated database: separate login context, separate chart of accounts, separate customers, vendors, classes, and reports. Even if you own five entities and pay for five subscriptions under one Intuit login, QBO treats them as five strangers. There is no "consolidated" report type, no cross-company report builder, and no concept of a parent-subsidiary relationship anywhere in the product, on any plan, including Advanced.
People often search for how to "merge two QuickBooks files." It is worth being precise: merging (collapsing two company files into one set of books) is not supported in QBO at all. The only path is migrating transactions from one company into the other, and that is a one-time data conversion project, not reporting. Combining reports (keeping entities separate but producing group-level statements) is what most multi-entity owners actually need, and it always happens outside QuickBooks Online. The four methods below are the complete set of ways to do it.
Method 1: Export Each Company and Combine Manually in Excel or Google Sheets
This is the default method and Intuit's own recommendation. It costs nothing beyond the subscriptions you already pay for, works on every QBO plan, and requires no new tools. Here is the workflow that experienced controllers follow:
Standardize or map the charts of accounts. Decide on a master chart of accounts for the group and document how every account in every entity rolls up into it. If "Software Subscriptions" in Entity A is "SaaS Tools" in Entity B, the mapping table is what keeps the consolidation honest.
Run the identical report in each company. Same report type (say, Profit and Loss), same date range, same accounting basis (accrual or cash) in every entity. Export each one to Excel.
Paste each export into a combining workbook. One column (or one tab) per entity, with account rows aligned to the master chart of accounts.
Apply the account mapping. Reclassify each entity's lines into the master structure, usually with SUMIF or lookup formulas keyed off the mapping table.
Identify and eliminate intercompany activity. Find every transaction between group entities (management fees, intercompany sales, loans, shared payroll recharges) and post offsetting entries in a dedicated eliminations column so that internal activity nets to zero in the group view.
Sum across and tie out. Consolidated = sum of entities + eliminations. Verify each entity column ties exactly back to that company's own QBO report before anyone sees the result.
Repeat every single period. Exports go stale the moment they are downloaded, so every close means fresh exports, re-pasting, re-checking formulas, and re-doing eliminations.
Where the Manual Method Breaks
Manual combination works, right up until the group grows past two or three entities or anyone asks for numbers more than quarterly. The failure modes are predictable:
Chart-of-accounts drift. Entities add, rename, and reorganize accounts constantly. Every unmapped new account either drops out of the consolidated report or lands in the wrong line, and nobody notices until the totals stop tying.
Eliminations by hand. Nothing in the spreadsheet flags an intercompany invoice for you. Missed eliminations overstate group revenue and expenses; auditors and lenders find them eventually, usually at the worst time. (For the mechanics, see our practical guide to intercompany eliminations.)
Version chaos. "Consolidation_June_FINAL_v3(2).xlsx" is a punchline because it is real. Multiple people editing a shared workbook with fragile formulas is how a pasted-over SUMIF quietly corrupts a board deck.
Quarterly cadence, not monthly. When each consolidation costs one to three days of a controller's time, most teams quietly downgrade from monthly to quarterly consolidated reporting. That means running a multi-entity business three months at a time on entity-level guesswork.
Verdict: fine for two entities, identical charts of accounts, no intercompany activity, and an annual or quarterly cadence. Beyond that, the spreadsheet is the biggest risk in your close.
Method 2: Spreadsheet Sync (QBO Advanced and Accountant)
Spreadsheet Sync is an Excel add-in included with QuickBooks Online Advanced and QuickBooks Online Accountant. It creates a live, refreshable connection between Excel and QBO, and, importantly for multi-entity owners, it can pull data from multiple companies into a single workbook, including a multi-company Profit and Loss pull. Refreshing the workbook re-fetches current data, which removes the export-and-paste step from Method 1.
What Spreadsheet Sync is not is a consolidation tool. It is a data pipe. It will happily lay five companies' P&Ls side by side, but it will not:
Map accounts. If entities use different charts of accounts, the rows don't line up. You still build and maintain the mapping layer yourself in Excel.
Post eliminations. Spreadsheet Sync has no concept of intercompany transactions. Every elimination is still a manual formula you write, maintain, and defend.
Handle currency, minority interest, or drill-down. Foreign-currency subsidiaries, partial ownership, and "what is inside this number?" questions are all on you.
Verdict: a genuine upgrade over raw exports if you are already paying for QBO Advanced. It fixes the copy-paste problem while leaving the actual consolidation logic (mapping, eliminations, tie-outs) exactly as manual as Method 1.
Method 3: QuickBooks Desktop Enterprise Combine Reports
QuickBooks Desktop Enterprise is the one QuickBooks product with a built-in consolidation feature. Its Combine Reports from Multiple Companies tool merges up to a few company files into combined statements (Balance Sheet, Profit and Loss, Statement of Cash Flows, and Trial Balance) exported into Excel. It is the reason "just use Desktop" still appears in forum answers.
The catch is in the merge rule: accounts combine only if they have exactly the same name, the same account type, and sit at the same hierarchy level in every file. "Marketing Expense" in one company and "Marketing & Advertising" in another produce two separate lines in the combined report. In practice this forces you to police identical charts of accounts across every entity forever. And the feature still doesn't perform intercompany eliminations, so those remain manual adjustments in the exported Excel file.
Why moving to Desktop is not the answer in 2026: the direction of travel is unambiguous. Intuit stopped selling new QuickBooks Desktop Pro and Premier subscriptions to new US customers back in 2024, and its investment has been in QuickBooks Online ever since. Migrating a group of cloud companies to a locally-installed, file-based product means giving up bank feed workflows, browser access, accountant collaboration, and the QBO app ecosystem, all to gain a same-name-only report merger. That solves a reporting problem by creating an infrastructure problem. For companies already on Desktop Enterprise, Combine Reports is a legitimate stopgap; adopting Desktop for it is moving backwards.
Verdict: workable only if you are already on Desktop Enterprise, keep rigidly identical charts of accounts, and accept manual eliminations in Excel afterward.
Method 4: Third-Party Consolidation Software
Purpose-built consolidation tools connect directly to each QuickBooks Online company via the QBO API, pull the underlying data continuously, and produce consolidated statements on demand. This is the standard answer for any group that treats consolidated reporting as a monthly deliverable rather than an annual project, and it is why an ecosystem of tools exists in this space. We compare the leading options in our roundup of the top 5 tools for consolidation in QuickBooks Online.
Capabilities vary widely, so evaluate against this checklist:
Automatic account mapping. The tool should map each entity's chart of accounts to a group structure, and flag new or renamed accounts automatically instead of letting them silently fall out of the report.
Intercompany eliminations. Detection and elimination of intercompany transactions, with an auditable record of exactly what was eliminated and why, not a black-box adjustment.
Multi-currency translation. Correct rate types per statement (period-end for balance sheet, average for P&L) if any subsidiary keeps books in another currency.
Drill-down to transactions. Every consolidated number should open up to the entity, account, and source transactions behind it. A consolidated figure you cannot drill into is a figure you cannot defend.
All three statements. Many tools consolidate the P&L convincingly and quietly fall apart on the Balance Sheet and Cash Flow, a gap we dissect in consolidated cash flow reporting in QuickBooks Online.
Audit trail. Who changed a mapping, when, and what it affected. If the answer lives in someone's memory, it is not a control.
Verdict: the only method that makes an accurate monthly consolidated close routine. The trade-off is a subscription cost, typically far less than the controller hours the spreadsheet was consuming.
All Four Methods Compared
Method | Effort per Close | Accuracy Risk | Monthly Cadence Feasible? | Handles Eliminations? | Cost |
|---|---|---|---|---|---|
Manual Excel / Google Sheets | High: hours to days, every period | High: mapping drift, formula errors, missed eliminations | Rarely; most teams slip to quarterly | Only by hand | Free (paid in staff time) |
Spreadsheet Sync (QBO Advanced) | Medium: refresh replaces exporting, logic still manual | Medium-high: same manual mapping and eliminations | Possible for simple groups | No, data pipe only | Included with QBO Advanced / Accountant |
Desktop Enterprise Combine Reports | Medium: automated merge, manual cleanup | Medium: accounts merge only on exact name + type + level; no eliminations | Yes, if charts of accounts stay identical | No, manual in Excel afterward | Desktop Enterprise subscription + move off cloud |
Consolidation software (e.g., FinBoard.ai) | Low: continuous sync, on-demand reports | Low: automated mapping, eliminations, tie-outs to source | Yes: monthly, weekly, or on demand | Yes, automated with audit trail | Software subscription |
Which Method Should You Pick?
A simple decision rule: if you have two entities, matching charts of accounts, no intercompany activity, and a quarterly cadence, the manual method is genuinely fine. If you are already on QBO Advanced and just want to stop re-exporting, Spreadsheet Sync earns its keep. If you are already on Desktop Enterprise, use Combine Reports as a stopgap, but don't migrate to Desktop for it. The moment you need monthly consolidated statements, eliminations, more than three entities, or multi-currency, consolidation software stops being optional and becomes the control environment your group reporting runs on.
How FinBoard.ai Combines Multiple QuickBooks Online Companies
FinBoard.ai was built specifically for this problem: multi-entity groups running on QuickBooks Online who need consolidated reporting without the spreadsheet. Each QBO company connects once via the official Intuit integration and syncs continuously: no exports, no refresh buttons, no stale data.
AI-assisted account mapping aligns every entity's chart of accounts to a single group structure, and flags newly created accounts the moment they appear so nothing falls out of the consolidation unnoticed.
Intercompany eliminations are matched and eliminated automatically, with a ledger of every elimination entry so you can show an auditor exactly what was removed and why.
Consolidated P&L, Balance Sheet, and Cash Flow: all three statements, multi-currency aware, reconciled back to each entity's own QuickBooks reports so the group numbers always tie to the source.
Drill-down on every number, from a consolidated total to the entity, account, and individual transactions behind it. The question "what is in this number?" gets answered in seconds, not with another export.
The practical difference is cadence: what used to be a quarterly spreadsheet project becomes a consolidated view that is simply always current. If your team is combining QuickBooks Online companies by hand today, try FinBoard.ai: connect your entities and see your first consolidated report in minutes.
Frequently Asked Questions
Can I merge two QuickBooks Online companies into one file?
No. QuickBooks Online has no merge function for company files. Your options are to migrate one company's transactions into the other (a one-time data conversion project) or to keep the companies separate and combine their reports outside QBO using one of the four methods above.
Does QuickBooks Online have a built-in consolidation feature?
No, on no plan, including QuickBooks Online Advanced. Every QBO company is a separate account, and Intuit's official guidance is to export each company's reports and combine them manually in Excel or Google Sheets, or to use a third-party consolidation app.
Can Spreadsheet Sync consolidate multiple QuickBooks Online companies?
Spreadsheet Sync (QBO Advanced and Accountant) can pull data from multiple companies into one Excel workbook, but it is a data pipe, not a consolidation tool: it performs no account mapping and no intercompany eliminations. Those steps remain fully manual.
What is the cheapest way to combine reports from multiple QuickBooks companies?
Manual export to Excel or Google Sheets is free in software cost but expensive in controller time: typically hours to days per close, with real error risk from mapping drift and missed eliminations. For groups reporting monthly, consolidation software usually costs less than the staff hours it replaces.
Do I need intercompany eliminations if my companies trade with each other?
Yes. Any revenue, expense, loan, or balance between group entities must be eliminated in consolidation, or the group's revenue and expenses are overstated and ratios are distorted. No QuickBooks product automates this. It is either done by hand in Excel or by consolidation software.
