There are two ways to consolidate multiple entities in QuickBooks Online: via a manual export to a spreadsheet or by using an external tool like LiveFlow FP&A, which eliminates manual work.
QuickBooks Online is available in three tiers: Standard, Advanced (with Spreadsheet Sync), and Intuit Enterprise Suite, each with different levels of multi-entity support, though none provide true native consolidation.
This article details two methods for consolidating multiple entities in QuickBooks Online and its trade-offs, so you can decide whether to keep using QuickBooks workarounds, automate on top of QuickBooks with LiveFlow FP&A, or consider moving to Flow ERP as your entity count and complexity grow.
Key takeaways
The challenge: QuickBooks Online doesn't provide true native multi-entity consolidation, so every method requires some workaround
Two solutions: manual report exports and spreadsheet-based consolidation, or automated consolidation with LiveFlow FP&A
The limitations: QuickBooks doesn't automate intercompany eliminations, currency conversion, or cross-entity account mapping
Finance teams that automate consolidation with LiveFlow FP&A report saving 25 hours per month on close-related work
What is multi-entity consolidation?
Multi-entity consolidation is the process of combining the financial statements of two or more legal entities into a single set of reports that reflects the group's overall financial position, after eliminating intercompany transactions.
Can QuickBooks Online consolidate multiple entities?
No, QuickBooks Online does not have native multi-entity consolidation capabilities. Instead, finance teams using QuickBooks must export reports from each entity, manually reconcile inconsistent charts of accounts, manually convert currencies, and paste everything into a spreadsheet.
This essentially creates a combined report, not a consolidated financial statement. True consolidation eliminates intercompany balances and produces roll-ups that reflect what the group actually owns and owes.
Which QBO consolidation method is right for you?
If you… | Use this method |
|---|---|
Have 2–3 entities, low complexity, minimal intercompany activity | Manual QBO export to spreadsheet |
Want live, automated consolidation without leaving QBO | LiveFlow FP&A |
Have a growing entity count, complex eliminations, or ERP-level needs | Flow ERP |
Who uses multi-entity QBO consolidation?
Multi-entity QBO consolidation comes up across a handful of industries where businesses grow by adding locations, entities, or portfolio companies — without necessarily outgrowing QuickBooks for day-to-day accounting. Here's how the challenge plays out by vertical.
Construction groups
Construction operators often structure each project or subsidiary as its own LLC for liability and tax purposes, which means separate QBO company files for every entity. At close, the finance team has to pull reports from each file, reconcile inconsistent account names across entities, and manually eliminate intercompany activity before anything rolls up cleanly. The more entities, the longer the close cycle stretches. LiveFlow FP&A is the consolidation layer construction finance teams use to automate that roll-up without leaving QBO.
Healthcare operators
Dental service organizations, multi-location therapy practices, and other healthcare operators typically run separate books for each clinic or practice entity for compliance or ownership-structure reasons. That means tracking revenue, COGS, and provider costs across entities that may have different chart of accounts conventions, billing cycles, and cost centers. Getting to a consolidated P&L that reflects the whole group requires manual reconciliation that compounds with each additional site. LiveFlow FP&A gives healthcare operators a real-time consolidated view across all clinic entities, mapped once and refreshed automatically.
Private equity portfolio companies
PE firms and their portfolio companies need consolidated reporting across the entities they own, accounting for varying ownership percentages and holding structures, and almost always on a tight reporting timeline. QBO works fine at the entity level, but rolling up financials across a portfolio in QuickBooks means exporting from every company file and rebuilding eliminations in a spreadsheet each reporting cycle. LiveFlow FP&A is the tool PE-backed finance teams use to automate consolidation across portfolio entities and produce board-ready reports without manual rebuilds at every close.
Franchise groups and multi-location operators
Franchise operators often run each location as a separate legal entity or cost center, with consolidated reporting required by franchisors, lenders, or internal leadership. The challenge in QBO is that location-level books don't roll up natively: you're exporting, mapping, and stacking reports by hand, and any mid-period reclass at the location level means redoing the consolidation. LiveFlow FP&A connects to each entity's QBO file, maps accounts across locations once, and keeps the consolidated view up to date without requiring a manual rebuild each month.
How to consolidate multiple entities in QuickBooks Online
Step 1: Set up your chart of accounts
Before you export anything, standardize your chart of accounts across every entity. Account naming mismatches break your consolidated P&L at the roll-up stage, and no amount of spreadsheet work can fix it downstream. Every step that follows — GL mapping, eliminations, budget vs. actuals — depends on this foundation being consistent.
Your account standardization checklist
Work through each of these before onboarding a new entity:
Account names: Use identical naming conventions across every entity, no exceptions
Account numbers: Assign a consistent numbering scheme (e.g., 4000s for revenue, 5000s for COGS)
Parent-child hierarchy: Define rollup structure so sub-accounts feed the right summary lines
Entity-specific accounts: Flag accounts unique to one entity so they don't distort group totals
Fiscal periods: Confirm all entities share the same close calendar
Account creation governance: Designate one owner who approves all new accounts going forward
Build a master chart of accounts
Create a master chart of accounts that all entities map to. LiveFlow's GL mapping guidance walks through exactly how to structure this. Teams that standardize before they scale avoid the rework that compounds with every new entity that comes online.
Step 2: Link your entities
Linking your entities in QuickBooks Online means exporting reports from each company file separately and stitching them together in a spreadsheet. There's no native connection between company files, regardless of your QBO tier.
Here's the process:
Confirm each entity uses a consistent chart of accounts, date range, and report format
Verify you have admin access to every company file
Export or sync reports from each entity — one at a time
Map accounts across entities in your spreadsheet
Manually eliminate intercompany transactions
Rebuild the consolidated view for every reporting period
Every additional entity adds more spreadsheet maintenance. With 10, 20, or 50 entities, this workflow becomes its own close task.
And your reporting layer is only as current as your last export. The moment a source book changes, your consolidated view is stale — with no automated refresh, no audit trail, and no built-in eliminations to catch intercompany noise.
Step 3: Customize reporting preferences across every entity
Before you export anything, every entity's QuickBooks Online report settings must match exactly. A single misaligned filter — wrong basis, different period, or inconsistent column selection — means your consolidated numbers won't tie out, and you'll spend hours hunting the gap instead of closing the books.
QuickBooks helps you standardize report views, but it doesn't apply consolidation logic. Eliminations, intercompany adjustments, and currency conversions still live in your spreadsheet layer.
Settings to align in each entity before export
Setting | What to standardize |
|---|---|
Report basis | Choose cash or accrual. This must match across all entities. |
Reporting period | Select the same start and end date on the same fiscal calendar |
Column structure | Ensure same grouping by month, quarter, or total |
Class/location filters | Apply filters consistently or remove them entirely |
Currency assumption | Make sure your base currency is locked; conversion handled externally |
Account naming | Exact GL names and numbers across every entity |
If these settings differ, your consolidation will not tie out
Period mismatches create timing differences that look like errors
Mixed cash/accrual bases make line items incomparable
Inconsistent class filters drop or double-count transactions
Different account names break your mapping table entirely
Once settings align, select Combine Reports in Excel. QuickBooks exports each entity as a separate worksheet, and your consolidation work starts from there.
Step 4: Generate consolidated reports
When you consolidate multiple entities in QuickBooks Online, QuickBooks gives you entity-specific Balance Sheets, Income Statements, and Cash Flow Statements, but it doesn't assemble the finished report for you.
This data is provided as a set of entity-level tabs. Those tabs are not a live consolidated reporting model. To turn them into one, you export to Excel or Google Sheets and do the work yourself.
That work includes:
Stacking trial balances across entities
Mapping accounts where names or numbers don't match
Correcting sign conventions (debits vs. credits, income vs. expense presentation)
Building roll-up formulas for consolidated totals
Applying intercompany eliminations manually
Validating that your balance sheet and P&L totals tie out after eliminations
Most teams need the following outputs from this process:
Consolidated P&L
Consolidated balance sheet
Cash flow statement
Entity-by-entity variance view
Management pack exports for stakeholders
Step 5: Perform manual adjustments
Once your reports are assembled, you'll need to manually calculate and apply eliminations to ensure you don't double-count revenue, expenses, or balances across the consolidated view.
What manual adjustments typically include
Finance teams making these adjustments at close are usually working through some combination of the following:
Intercompany revenue and expense eliminations: Entity A bills Entity B for shared services; the revenue and expense must be removed from the consolidated view to prevent double-counting.
Due-to and due-from balances: Intercompany receivables and payables that net to zero at the consolidated level but need to be cleared line by line.
Shared service allocations: Costs distributed across entities that need to be reclassified before consolidation.
Foreign-currency translation adjustments: If entities operate in different currencies, exchange-rate fluctuations create translation variances that must be accounted for separately.
Reclassifications: Account mapping corrections where GL codes don't align across entities.
Ownership-related entries: Minority interest adjustments if you're consolidating partially owned subsidiaries.
Manual consolidation in Google Sheets or Excel
Consolidating multiple entities in QuickBooks Online using a spreadsheet is a workable approach for small, simple structures, but it requires disciplined setup and consistent maintenance to remain reliable.
Here's what a realistic manual consolidation workflow looks like:
Export each entity's trial balance or P&L from QuickBooks Online into a separate tab in the same workbook. Name each tab clearly (e.g., "Entity A — TB," "Entity B — TB").
Build an account mapping tab that standardizes GL account names across entities. Different entities often use slightly different naming conventions, so this step is non-negotiable.
Create a roll-up tab that pulls mapped balances from each entity tab using SUMIF or VLOOKUP formulas and aggregates them into a single consolidated view.
Add an eliminations tab to remove intercompany transactions — loans, management fees, intercompany sales — that would otherwise double-count across the consolidated view.
Add a currency tab if needed. If entities report in different currencies, apply period-end exchange rates to balance sheet accounts and average rates to income statement accounts before rolling up.
Build review checks — variance columns, balance checks (assets = liabilities + equity), and intercompany reconciliation flags — so errors surface before the report goes out.
Set version-control rules. Date-stamp every export, lock completed tabs, and designate one owner for the master workbook.
When spreadsheet consolidation still works
This approach is workable when you have a small number of entities (typically fewer than five), minimal intercompany activity, low reporting frequency, and a finance team that actively maintains the model.
It starts to break down when you add multiple currencies, frequent reclassifications, investor reporting, board packs, or more than 10 entities. When it does break down, it usually shows up in one of these ways:
Broken or outdated formulas after a new account is added
Stale exports that don't reflect late journal entries
Duplicate or misnamed tabs across reporting cycles
No clear ownership of the master workbook, leading to conflicting versions
The audit trail problem
Once your consolidation outgrows a simple model, the spreadsheet itself becomes the liability. When adjustments live in disconnected files, the audit trail disappears, and there's no version history, preparer/reviewer workflow, or link back to the source data. If books change after you've finished eliminations, you'll have to start over.
We hear versions of the same problem constantly: "We export every entity, fix eliminations in Excel, and then redo the whole thing when one entity's books get updated." That cycle is the real cost of manual consolidation.
Multi-entity consolidation with LiveFlow FP&A
When your consolidation model starts requiring more time to maintain than it saves, LiveFlow FP&A replaces the manual export-and-map cycle with live, connected financial data. LiveFlow FP&A solves the core problem of consolidating multiple entities in QuickBooks Online by connecting directly to your QBO data, mapping accounts once, and delivering a live consolidated view inside Excel or Google Sheets.
How LiveFlow FP&A handles consolidation, step by step
Here's exactly what the workflow looks like once you connect LiveFlow FP&A to your QuickBooks entities:
Connect each entity. Link all QBO company files to LiveFlow FP&A. Each entity stays independent in QuickBooks — LiveFlow reads the data without changing your source records.
Map accounts once. Use the account mapping layer to align GL names across subsidiaries. Different naming conventions across entities don't break the roll-up.
Automate the roll-up. LiveFlow FP&A aggregates P&L, balance sheet, and cash flow data across all entities into a single consolidated view.
Apply intercompany eliminations. Flag intercompany transactions so they're excluded from the consolidated output automatically.
Handle multi-currency. Set your reporting currency and LiveFlow FP&A applies exchange rates across entities — no manual conversion in spreadsheets.
Refresh live data. Your consolidated report updates automatically inside Excel or Google Sheets. Share it with stakeholders and it stays current.
Drill down without switching files. Investigate any line item across any entity without opening individual QBO company files.
Manual consolidation vs LiveFlow FP&A
Manual QuickBooks export | LiveFlow FP&A | |
|---|---|---|
Data refresh | Manual re-export every time | Live, automatic |
Account mapping | Repeated each period | Configured once |
Intercompany eliminations | Manual spreadsheet adjustments | Automated |
Multi-currency support | Manual conversion formulas | Built-in exchange-rate handling |
Time required per month | 20–30+ hours | Under 1 hour |
Drill-down capability | Open each entity file separately | Inline, no file switching |
See how to close faster without rebuilding your spreadsheet workflows: book a demo.
When to consider a multi-entity ERP instead of QuickBooks
If QuickBooks itself is the bottleneck due to growing entity count, complex eliminations, or close timelines that keep slipping, Flow ERP is built for exactly this. It consolidates entities in real time, auto-calculates intercompany eliminations, and keeps every entity's books in sync. And because Flow connects accounting to FP&A in one platform, you can query your financials any way you want instead of being limited to fixed report templates.
Frequently Asked Questions
Can you consolidate multiple companies in QuickBooks Online?
QuickBooks Online does not provide native multi-entity consolidation. You export reports from each company file separately and combine them manually in Excel or Google Sheets, then apply your own intercompany eliminations and account mapping.
How do construction companies consolidate multiple entities in QuickBooks Online?
Construction groups managing multiple LLCs or project entities typically export reports from each QBO company file and consolidate manually in Excel — a process that breaks down as entity count grows. LiveFlow FP&A connects directly to each QBO entity, automates the roll-up, and applies intercompany eliminations so construction finance teams get a live consolidated view without rebuilding it every close cycle.
Can a multi-site healthcare group use QuickBooks Online for consolidation?
Multi-site healthcare groups (DSOs, clinic operators, multi-location practices) can use QuickBooks Online for individual-entity accounting, but QBO doesn't natively consolidate entities. Finance teams in healthcare typically use LiveFlow FP&A to automate the consolidation layer, giving operators a real-time view of revenue, COGS, and cash across all clinic entities without manual exports.
What are the biggest limitations of consolidating multiple entities in QuickBooks?
QuickBooks Online doesn't automate intercompany eliminations, multi-currency conversion, or cross-entity account mapping — all three have to be handled manually in spreadsheets. For growing multi-entity businesses, this means rebuilding the consolidation from scratch at every close cycle. LiveFlow FP&A adds the automation layer QBO is missing.
When should a multi-entity business move from QuickBooks to a full ERP?
When QBO itself becomes the bottleneck. Signs include a growing entity count with complex intercompany transactions, slipping close timelines, or the need for real-time consolidated reporting that spreadsheet workflows can't sustain. Flow ERP solves what QuickBooks can't: it consolidates multiple entities in real time, auto-calculates intercompany eliminations, and keeps every entity's books in sync without a single spreadsheet.
—
About LiveFlow
LiveFlow builds AI-native finance software for growing, multi-entity businesses. LiveFlow offers two products. Flow ERP is an AI-native ERP designed for multi-entity physical businesses, including franchise, construction, healthcare, food and beverage, and multi-location retail. It is the only AI-native ERP that unifies the general ledger, AP/AR, and FP&A in a single platform, with built-in accounting agents that automate manual work. LiveFlow FP&A automates financial consolidation, reporting, and budgeting on top of existing accounting software such as QuickBooks and Xero.
