QuickBooks Online Advanced added multi-company reporting features in late 2024, generating significant attention from accounting professionals managing complex client structures. The question for controllers and fractional CFOs is a practical one: do these features close the gap, or are there still meaningful limitations that affect the close workflow?
This article gives an honest, detailed answer based on what the features actually do, not what the marketing says they do.
QuickBooks Online Advanced allows you to create a "company group" and generate consolidated P&L and balance sheet reports across up to 10 company files. The reports pull from each entity's chart of accounts, sum the balances, and present a combined view. You can map accounts across entities that use different chart of accounts structures.
This is a genuine improvement over the previous state, where there was no native consolidation functionality at all. For simple structures (two or three entities with similar charts of accounts, identical currencies, and no intercompany activity), this feature may be sufficient for management reporting purposes.
The Advanced plan now includes a dashboard view that shows key metrics (revenue, expenses, profit) across all entities in a group at a glance. This is useful for high-level monitoring but is not a substitute for detailed consolidated financial reporting.
QuickBooks Online has improved shared payroll functionality, allowing a single payroll setup to cover employees across multiple entities. This is an operational efficiency improvement but is not directly related to financial consolidation.
The consolidated reports feature sums the balances from each entity. It does not identify or eliminate intercompany transactions. If entity A charged a $30,000 management fee to entity B, the consolidated P&L will show $30,000 of management fee income (in entity A) and $30,000 of management fee expense (in entity B), a $30,000 overstatement of both revenue and expense.
For groups with regular intercompany activity (management fees, shared services, intercompany loans, intercompany rent), the consolidated reports produce inflated numbers that overstate both revenue and expense by the total volume of intercompany flows. This is not a minor rounding issue; for many multi-entity structures, intercompany transactions represent 20–40% of total gross revenue before elimination.
The consolidated reports feature does not apply IAS 21 translation methodology. If you have entities in different functional currencies, the feature either converts at a single spot rate or simply aggregates in local currency, neither of which produces technically correct consolidated financials under IFRS or the equivalent ASPE treatment in Canada.
Specifically, the feature does not: translate assets and liabilities at the closing rate, income and expenses at the period-average rate and equity at historical rates, calculate or record the cumulative translation adjustment (CTA), or produce OCI disclosures related to currency translation.
Depending on your QuickBooks Online edition and region, some schedules can run inside QuickBooks (QuickBooks Online Advanced, for example, can create depreciation schedules and post monthly depreciation), and in editions with recurring transactions a fixed entry can repeat each month. What QuickBooks does not do is run the multi-entity close around those schedules: tie each prepaid, deferred revenue, fixed asset, loan, and lease schedule to the balance sheet account it supports, reconcile the schedule to the ledger balance in every entity, record who reviewed and signed off each one, and carry the adjusted figures into consolidation and reporting. The consolidated reports feature has no awareness of whether each entity's schedule entries have been posted or reconciled. It reports whatever is in the books, adjusted or not.
There is no audit trail for consolidation-level adjustments in QuickBooks Online. When an auditor asks for support behind the consolidated figures, there is no workpaper within QuickBooks that shows the entity-level figures, the adjustments applied, and the resulting consolidated balances. That documentation has to be maintained outside QuickBooks.
Adjusting entries made to produce correct consolidated financials (accruals, eliminations, reclassifications) are not written back to the entity-level QuickBooks files by the consolidation feature. This means the QuickBooks balances and the correct adjusted balances remain two different things, and every reconciliation has to account for that gap.
The practical test: Ask your auditor to review a consolidated report produced directly from QuickBooks Online Advanced. Their first question will be: where are the intercompany eliminations, and where is the audit trail behind the adjustments? The answer, currently, is: those don't exist in the native tool.
Before you move to an ERP: if the problem is the close rather than the day-to-day transactions, a close layer on QuickBooks Online may be enough. See what a formal close on QuickBooks Online looks like.
Fynease Automate fills those gaps on top of QuickBooks Online: intercompany elimination, IAS 21 translation, prepaid expense, deferred revenue, fixed asset, loan and lease schedules, and adjusting entries written back to each entity.
See how it works → Start free trial| Situation | Recommendation |
|---|---|
| 2–5 entities, same currency, minimal intercompany, under $10M revenue | Stay on QuickBooks Online and add a transformation layer for close automation |
| 5–20 entities, mixed currency, active intercompany, $5–30M revenue | Stay on QuickBooks Online: the transformation layer closes the gap at a fraction of NetSuite's cost |
| 20–50 entities, global operations, complex ownership structures, $30–100M+ revenue | Evaluate NetSuite or Sage Intacct: the operational complexity justifies ERP investment |
| Full accounting department, dedicated controller, audit committee, board reporting | NetSuite territory: the control environment requires ERP-level auditability |
The key insight is that the gap between QuickBooks Online Advanced and NetSuite for multi-entity reporting is not primarily a technology gap. It is a workflow gap. Most of what NetSuite does for multi-entity consolidation can be replicated with the right process and tooling (such as Fynease Automate) on top of QuickBooks Online, at a fraction of the cost and without a 6-month implementation project.
The companies that should genuinely consider NetSuite are those whose operational complexity has grown beyond what a transformation layer can address: typically 20+ entities, multiple countries with different tax regimes, manufacturing with complex inventory, or transaction volumes that create performance limitations in QuickBooks Online. For the $5–30 million multi-entity company on QuickBooks Online, the right answer is almost always to fix the close process, not replace the accounting system.
Partly. QuickBooks Online Advanced lets you create a company group and generate consolidated profit and loss and balance sheet reports across up to 10 company files, with account mapping across different charts of accounts. For simple structures with similar charts, one currency, and no intercompany activity, that may be enough for management reporting. The consolidated reports do not, however, eliminate intercompany transactions, apply IAS 21 currency translation, check that each entity's schedules have been posted and reconciled, or keep an audit trail for consolidation adjustments.
No. The consolidated reports feature sums the balances from each entity and does not identify or eliminate intercompany transactions. If entity A charges entity B a management fee, the consolidated report shows that amount as both income and expense, overstating revenue and expense by the full volume of intercompany flows. Groups with management fees, shared services, intercompany loans, or intercompany rent need to handle eliminations outside the native tool.
When operational complexity has grown beyond what a transformation layer on top of QuickBooks Online can address: typically 20 or more entities, multiple countries with different tax regimes, manufacturing with complex inventory, or transaction volumes that create performance limitations in QuickBooks Online. A full accounting department with an audit committee and board reporting also points to an ERP. For a $5 to $30 million multi-entity company, the better answer is usually to fix the close process rather than replace the accounting system.
Fynease Automate connects to QuickBooks Online, runs your prepaid expense, deferred revenue, fixed asset, loan, and lease schedules, consolidates multiple entities, applies IAS 21 FX translation, eliminates intercompany, and writes adjusting entries back. Every close, automatically.
See Fynease Automate Start free trial