Three methods for consolidating multiple entities in QuickBooks Online

‍

There are three practical ways to consolidate multiple entities in QuickBooks Online, and only one of them eliminates most of the manual work.

If you're managing two or more entities in QuickBooks, you already know the friction: exporting reports from each company file, pasting them into a workbook, hunting down mismatched account names, and doing it all over again next month. According to LiveFlow's ERP Market Shift Survey, 78% of finance teams export data to spreadsheets — and 75% cite waiting on data from other systems as a leading cause of close delays.

This article walks through the trade-offs of each method in plain language, 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

• QuickBooks Online doesn't provide true native multi-entity consolidation — every method requires some workaround

• The three methods are: manual report exports, spreadsheet-based consolidation, and automated consolidation with LiveFlow FP&A

• The biggest limitation is that 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

Consolidating multiple entities in QuickBooks Online

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.

If you're managing a construction group with multiple LLCs, a healthcare group running separate clinic books, or a franchise operator tracking P&L by location, you already know the friction. Every close cycle means exporting reports from each entity, reconciling inconsistent charts of accounts, manually converting currencies, and pasting everything into a spreadsheet that's already out of date by the time you share it.

That's a combined report — not a consolidated financial statement. The difference matters: true consolidation eliminates intercompany balances and produces roll-ups that reflect what the group actually owns and owes.

The sections below walk through all three methods for consolidating multiple entities in QuickBooks Online, with clear guidance on where each one breaks down and when it's time to move on.

Consolidating multiple entities in QuickBooks Online: what works

QuickBooks Online does not create true consolidated financial statements natively. That's the most important thing to understand before you build any multi-entity reporting workflow around it.

Standard QBO gives you separate books for each entity. Combining them into a single consolidated report requires manual exports, spreadsheet work, and your own judgment on eliminations and currency conversion. The process doesn't break entirely — but it breaks in specific, costly ways.

The 3 QuickBooks-native paths for multi-entity consolidation

Each path has real trade-offs:

• Standard export-and-combine works for small, single-currency businesses with simple structures. It falls apart fast when you add entities, currencies, or intercompany transactions.

• QuickBooks Online Advanced Spreadsheet Sync reduces some manual steps by pushing data directly into Google Sheets or Excel, but eliminations and currency conversion still land on your team.

• Intuit Enterprise Suite introduces a shared chart of accounts and more structured consolidation, but it's a separate product tier with a significantly higher price point.

Before choosing a path, make sure your chart of accounts is mapped consistently across all entities — naming mismatches are the most common reason consolidations break downstream.

Consolidating multiple entities in QuickBooks Online

Standard QuickBooks Online does not provide native multi-entity consolidation. What most finance teams call "consolidation" in QBO is actually a manual reporting workaround: exporting individual entity reports, then combining and reconciling them outside the product in a spreadsheet.

QuickBooks was built for single-entity accounting. When multi-entity teams use it, they end up owning the consolidation work themselves — account mapping, intercompany eliminations, currency conversion, and version control all happen manually.

The steps you'll follow depend on which QBO tier you're using:

• Standard QBO — export reports per entity, combine in Excel or Google Sheets

• QuickBooks Online Advanced with Spreadsheet Sync — sync live data into Google Sheets, then consolidate manually

• Intuit Enterprise Suite — limited multi-entity features, still requires manual elimination work

Step 1: Set up your chart of accounts

If your chart of accounts is inconsistent across entities, your consolidation will always be manual.

Account standardization is the foundation of every step that follows: GL mapping, roll-ups, intercompany eliminations, budget vs. actual reporting, and cross-entity comparisons. Skip it, and you'll spend every close cycle remapping the same accounts by hand.

Why it matters before you scale

When two entities use different names for the same revenue account — say, one calls it "Product Revenue," and another calls it "Sales - Products" — your consolidated P&L breaks. You can't roll up what doesn't match. This is one of the most common reasons consolidating multiple entities in QuickBooks Online stays stuck in spreadsheets long after a team has outgrown that workflow.

Your account standardization checklist

Work through each of these before onboarding a new entity:

1. Account names: Use identical naming conventions across every entity, no exceptions

2. Account numbers: Assign a consistent numbering scheme (e.g., 4000s for revenue, 5000s for COGS)

3. Parent-child hierarchy: Define rollup structure so sub-accounts feed the right summary lines

4. Entity-specific accounts: Flag accounts unique to one entity so they don't distort group totals

5. Fiscal periods: Confirm all entities share the same close calendar

6. 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

Consolidating multiple entities in QuickBooks Online is not a single-click process — and for most finance teams, it's still largely manual.

Standard QuickBooks Online has no native multi-entity consolidation. You export reports from each company file separately, then stitch them together in Excel or Google Sheets.

QuickBooks Online Advanced includes Spreadsheet Sync, which lets you pull data from multiple company files into a connected spreadsheet. It reduces some manual export work, but each entity still requires its own subscription and company file, and you're still building your consolidation logic inside a spreadsheet.

Here's what the process looks like in practice:

1. Confirm each entity uses a consistent chart of accounts, date range, and report format

2. Verify you have admin access to every company file

3. Export or sync reports from each entity — one at a time

4. Map accounts across entities in your spreadsheet

5. Manually eliminate intercompany transactions

6. 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, 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

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—your consolidation work starts from there.

Step 4: Generate consolidated reports

Consolidating multiple entities in QuickBooks Online means QuickBooks gives you the raw ingredients — Balance Sheets, Income Statements, and Cash Flow Statements, separated by entity — but it doesn't assemble the finished report for you.

What you actually get is 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

The review burden here is real. Every late journal entry, entity reclass, or account-name mismatch forces rework — and you're doing it inside a static spreadsheet that goes stale the moment something changes upstream.

According to LiveFlow's ERP Market Shift Survey, 78% of finance teams export data to spreadsheets, and 75% cite waiting on data from other systems as a leading cause of close delays. That might seem like a workflow problem, but the QuickBooks multi-entity consolidation process is working exactly as designed.

The next section covers manual adjustments and eliminations, where the rework compounds.

Step 5: Perform manual adjustments

Eliminations are where manual consolidation of multiple entities in QuickBooks Online most often breaks down. QuickBooks doesn't automate intercompany eliminations — every adjustment has to be identified, calculated, and entered by hand, usually in a spreadsheet that's already one export behind.

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; both sides must be removed from the consolidated view so revenue and expense aren't double-counted

• 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 differences create translation variances that need to be captured separately

• Reclasses: account mapping corrections where GL codes don't align across entities

• Ownership-related entries: minority interest adjustments if you're consolidating partially owned subsidiaries

The audit trail problem

When these adjustments live in disconnected spreadsheets, the audit trail disappears. There's no version history, no preparer/reviewer workflow, and no link back to the source data. If books change after you've finished eliminations, you 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. The next section covers what that looks like when you move it into a structured spreadsheet workflow — and where LiveFlow FP&A changes the equation entirely.

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 a disciplined build and consistent maintenance to stay reliable.

Here's what a realistic manual consolidation workflow looks like:

1. 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").

2. 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.

3. Create a roll-up tab that pulls mapped balances from each entity tab using SUMIF or VLOOKUP formulas, aggregated into a single consolidated view.

4. Add an eliminations tab to remove intercompany transactions — loans, management fees, intercompany sales — that would otherwise double-count across the consolidated view.

5. 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.

6. Build review checks — variance columns, balance checks (assets = liabilities + equity), and intercompany reconciliation flags — so errors surface before the report goes out.

7. 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.

Manual consolidation risks

78% of finance teams already rely on spreadsheets to transfer data between systems — but exporting data is not a consolidation strategy. It's a starting point that compounds risk at scale.

Watch for these failure points:

• 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

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 — so your consolidated reports refresh automatically, eliminations are tracked consistently, and close timelines shrink.

Multi-entity consolidation with LiveFlow FP&A

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 — no manual exports required.

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:

1. 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.

2. 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.

3. Automate the roll-up. LiveFlow FP&A aggregates P&L, balance sheet, and cash flow data across all entities into a single consolidated view.

4. Apply intercompany eliminations. Flag intercompany transactions so they're excluded from the consolidated output automatically.

5. Handle multi-currency. Set your reporting currency and LiveFlow FP&A applies exchange rates across entities — no manual conversion in spreadsheets.

6. Refresh live data. Your consolidated report updates automatically inside Excel or Google Sheets. Share it with stakeholders and it stays current.

7. Drill down without switching files. Investigate any line item across any entity without opening individual QBO company files.

Manual consolidation vs LiveFlow FP&A

If your team is still copying QBO reports into a master spreadsheet each month-end, you're rebuilding the same consolidation from scratch every close cycle. That's the workflow LiveFlow FP&A replaces.

See how to close faster without rebuilding your spreadsheet workflows: book a demo.

Two paths forward for consolidating multiple entities in QuickBooks Online

Consolidating multiple entities in QuickBooks Online comes down to one decision: is QuickBooks still the right foundation, or has it become the bottleneck?

Both paths are valid. The right one depends on your entity count, close complexity, and the amount of manual work you're absorbing each month.

Path 1: Stay on QuickBooks, add the consolidation layer it's missing

If QuickBooks still works for your day-to-day accounting, LiveFlow FP&A gives you the consolidation, reporting, and budgeting layer QuickBooks doesn't include natively.

With LiveFlow FP&A, you get:

• Live, multi-entity consolidated financials pulled directly from QuickBooks Online

• Automated intercompany eliminations

• Board-ready, real-time dashboards, departmental P&L, cash flow forecasting, and budget vs. actuals

• 100+ reporting templates built for finance teams, ready to connect to your data

LiveFlow FP&A customers report saving an average of 25 hours per month on reporting tasks. That's real time back during close.

Path 2: Move to a purpose-built multi-entity ERP

If QuickBooks itself is now the bottleneck due to growing entity count, manual eliminations, currency complexity, or close timelines that keep slipping, Flow ERP is built for exactly this.

Flow ERP is a multi-entity system designed to close in real time. Migration from QuickBooks Online takes under 2 minutes, with all dimensions and attachments intact; books go live in 11 days or less; and the platform handles 100K+ transactions with no data degradation.

If you want to keep QuickBooks, LiveFlow FP&A gives you the consolidation layer it's missing. If QuickBooks itself is the problem, Flow ERP gives you a system built to replace it.

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.

Why do CPAs avoid QuickBooks Online for multi-entity consolidation?

QuickBooks Online forces CPAs to rebuild consolidations manually at each close cycle, including exporting each entity separately, mapping accounts by hand, and applying eliminations in spreadsheets, with no audit trail or automated refresh.

What is the difference between consolidated and combined financial statements?

Consolidated statements eliminate intercompany transactions and show the group's true financial position. Combined statements stack entity reports together without eliminations, which double-counts intercompany activity and distorts group totals.

How do you consolidate subsidiaries you own more than 50% of?

Full consolidation combines 100% of the subsidiary's financials with the parent company's books, then eliminates all intercompany transactions. Proportionate consolidation adds only your ownership percentage of assets, liabilities, revenue, and expenses—used when you want to avoid full consolidation despite majority ownership.