Short answer
QuickBooks Online does not support consolidated group financial statements natively. Each QBO subscription is a single company — there's no built-in way to combine multiple companies into one consolidated P&L, balance sheet, or cash flow, or to eliminate intercompany transactions across them. To run group consolidated reports from QuickBooks, you need either a manual Excel process or a consolidation platform that connects to QBO via API.
If your group runs multiple entities through separate QuickBooks Online subscriptions — whether a US parent with international subsidiaries, a holding structure, or multiple trading entities — you’ll hit this limitation quickly. QuickBooks is excellent at managing a single company’s books. Running the group is a different problem. This article covers what QuickBooks can and can’t do for multi-entity reporting, what the manual workaround actually involves, and how BrizoConsol connects directly to your QBO companies to produce proper consolidated statements.
What QuickBooks Can and Can’t Do for Group Reporting
Before assuming everything requires an external tool, it’s worth understanding exactly where QuickBooks’ capabilities end.
| What QuickBooks Online can do | What QuickBooks Online can’t do |
|---|---|
| Produce full P&L, balance sheet, and cash flow for a single company | Combine financials from multiple QBO subscriptions into one consolidated report |
| Handle multi-currency within a single QBO subscription | Translate foreign entity financials at group-level exchange rates (closing vs average) |
| Show a “Business Overview” dashboard across multiple companies (QBO Advanced) | Produce consolidated financial statements — the Business Overview shows KPIs side by side, not combined group figures |
| Connect to third-party consolidation software via API | Eliminate intercompany transactions across companies |
| Export trial balance data for use in external consolidation | Calculate NCI, CTA, or goodwill for group accounting purposes |
💡 The Business Overview feature is not consolidation. QuickBooks Online Advanced includes a Business Overview dashboard that displays financial metrics from multiple companies simultaneously. This is useful for monitoring individual entities — but it presents entity-level KPIs side by side, not combined into a single group figure. Revenue from Company A and Company B appears as two separate numbers, not one consolidated total. Intercompany transactions are not eliminated. This is an aggregated view, not a consolidated one.
QuickBooks Online vs QuickBooks Desktop
The consolidation limitation applies to both QuickBooks versions, but the workaround differs:
QuickBooks Online (QBO): Cloud-based, API-accessible. Consolidation platforms including BrizoConsol connect to QBO via a secure OAuth integration — pulling trial balance and transaction data automatically without manual exports.
QuickBooks Desktop: Local installation with limited API access. Desktop users typically need to export trial balance data manually (as CSV or Excel) and import it into the consolidation platform. BrizoConsol supports Excel import as a data source, which covers Desktop-based entities alongside cloud-connected ones.
If your group has a mix of QBO and Desktop users — or QBO and other accounting software — a consolidation platform that accepts both API feeds and Excel imports handles the full entity set without requiring migration to a common platform.
The Manual Workaround — and Its Specific Failure Points
The standard manual approach for QuickBooks groups is to export trial balances from each QBO company (Reports → Trial Balance → select date range → export) and combine them in Excel. The process:
- Export trial balance from each QBO company — each export includes sub-account rows and subtotal rows that need to be cleaned before the data is usable
- Map each entity’s account names and codes to a common group structure in a spreadsheet
- Apply exchange rates manually to foreign entity figures
- Identify intercompany transactions from each company’s ledger and post elimination journals in the spreadsheet
- Aggregate all entities into a consolidated worksheet
- Rebuild the P&L and balance sheet from the consolidated data
🚩 QuickBooks-specific failure points in this process:
Sub-account structure: QBO exports trial balances with parent accounts and sub-accounts on separate rows. The subtotal rows for parent accounts are not actual transactions — they’re display formatting. If these aren’t stripped before aggregation, accounts are double-counted in the consolidation.
Account type inconsistency: QBO uses account types (Income, Cost of Goods Sold, Expense, Other Income, etc.) that determine where an account appears in reports. If two QBO companies use the same account name but different account types, the mapping to the group COA needs to handle both types — otherwise a “Miscellaneous Income” account in Company A (classified as Income) and the same account in Company B (classified as Other Income) may map to different group lines.
No built-in intercompany identification: QBO has no mechanism to tag intercompany transactions for elimination. Identifying which transactions are intercompany requires manually cross-referencing each company’s ledger — a process that scales very poorly with entity count.
Running Consolidated Statements from QuickBooks Using BrizoConsol
BrizoConsol connects to QuickBooks Online via API — pulling trial balance data from each QBO company into a single consolidation environment. The connection is set up once; data flows in automatically at each reporting period.
1 Connect your QuickBooks Online companies Each QBO company is connected to BrizoConsol via secure OAuth — the standard QuickBooks authorisation flow. Once connected, BrizoConsol pulls the trial balance, chart of accounts, and transaction detail directly. For QuickBooks Desktop entities, trial balance data is imported via Excel alongside the API-connected companies.
2 Map each company’s accounts to a group chart of accounts Each QBO company has its own account names, codes, and sub-account hierarchy. In BrizoConsol, you map each account — including sub-accounts — to a common group COA. AI-assisted mapping suggests classifications based on account names and types, which you review and confirm. The group COA becomes the single structure from which all consolidated reports are generated, regardless of how each QBO company organises its own chart.
COA mapping example — QuickBooks sub-account handling QBO Company A: “Sales” → sub-accounts “Sales:Product Revenue” and “Sales:Service Revenue”
QBO Company B: “4000 – Revenue”, “4100 – Consulting Fees”
QBO Company C: “Revenue – Products”, “Revenue – Services”
Group COA mapping:
All product/revenue accounts → “Group Revenue – Products”
All service/consulting accounts → “Group Revenue – Services”
Sub-accounts in QBO are mapped individually — the consolidation doesn’t inherit QBO’s parent/child structure, only the values.
3 Configure exchange rates for the reporting period For companies with foreign functional currencies, you set the closing rate (for balance sheet items) and average rate (for P&L items) in BrizoConsol. These are published centrally and applied consistently across all entities — eliminating the rate inconsistency that creates intercompany mismatches in manual processes. Currency translation adjustments are calculated automatically and allocated to group equity.
4 Post intercompany elimination entries BrizoConsol supports group-level eliminations (a single debit and credit posted at the consolidation layer) and entity-pair eliminations (specifying which company generated the income and which carries the expense). Common eliminations for QuickBooks groups include intercompany management fees, intercompany loans and interest, and intercompany sales where one company is a customer of another within the group.
5 Generate consolidated reports With COA mapping applied, exchange rates set, and eliminations posted, BrizoConsol generates the consolidated P&L, balance sheet, and cash flow. Drill-down from any group line shows each company’s contribution, and from there to the underlying account detail. Reports are available in the platform, exportable as PDF, or schedulable for automatic delivery.
Worked Scenario: Three QuickBooks Companies, One Consolidated P&L in USD
Group structureUS HoldCo (United States, USD) — parent, 100% owner of UK OpCo and SG OpCo
UK OpCo (United Kingdom, GBP) — trading entity
SG OpCo (Singapore, SGD) — trading entity
Intercompany transaction: US HoldCo charges both UK OpCo and SG OpCo a $5,000 USD management fee each per month ($10,000 total).
In BrizoConsol:
- All three QBO companies connected via API
- Sub-accounts from each QBO export mapped individually to the group COA
- UK OpCo’s GBP figures translated at GBP/USD closing rate (balance sheet) and average rate (P&L); CTA recorded in group equity
- SG OpCo’s SGD figures translated at SGD/USD closing and average rates
- Two elimination entries: Dr Management Fee Income (US HoldCo) $5,000 / Cr Management Fee Expense (UK OpCo) $5,000; same for SG OpCo
Output: a consolidated P&L in USD showing the group’s actual third-party revenue and costs, with management fees eliminated and all foreign figures translated at the correct rates. Drill-down on any line shows each company’s contribution in both functional currency and USD.
What BrizoConsol Requires from Your QuickBooks Setup
- Each entity needs its own QBO subscription — BrizoConsol connects one QBO company at a time; entities sharing a subscription are treated as one entity
- QuickBooks Online (not Desktop) for API connection — Desktop users can participate via Excel trial balance import
- Books should be closed before extraction — BrizoConsol pulls whatever is in QBO at the time of the sync; unapproved transactions or unreconciled accounts will flow through as-is
- Sub-account mapping needs to be complete — every sub-account in each QBO company needs a group COA mapping; unmapped sub-accounts are flagged before the consolidation runs
- Excel import available for non-QBO entities — entities on Xero, MYOB, Zoho Books, or no cloud accounting software can be included via Excel trial balance import alongside the QBO-connected companies
BrizoConsol connects directly to QuickBooks Online — pulling trial balance data from all your QBO companies, mapping accounts (including sub-accounts) to a group COA, handling multi-currency translation, and producing consolidated P&L, balance sheet, and cash flow. Learn more or see it in action →