If you manage three or more QuickBooks Online company files, you already know the routine. Month-end comes. You export a trial balance from each entity. You open the master Excel file. You paste the numbers in, check that everything balances, manually identify the intercompany transactions, enter the eliminations, and rebuild the consolidated P&L, balance sheet, and cash flow statement from scratch.
Then you do it again next month.
This article explains why multi-entity consolidation in QuickBooks Online is harder than it should be, what a proper consolidation process looks like, and why you don't need to migrate to NetSuite to get it right.
QuickBooks Online is a transaction-recording system. It is excellent at what it does: capturing sales, expenses, bank transactions, and payroll across a single company file. What it was not designed to do is aggregate those transactions across multiple legal entities, eliminate intercompany flows, translate foreign currencies to a reporting currency, and produce a consolidated set of financial statements.
QuickBooks Online Advanced introduced a "consolidated reports" feature in 2024 that allows you to pull multiple companies into a single report view. It is a useful starting point for simple structures. But it has material limitations that matter for anyone doing real consolidation work:
For simple holding structures with two or three identical-currency entities and no intercompany activity, the native feature may be sufficient. For anything more complex, it falls short.
A consolidation that stands up to audit review and gives management accurate financial information requires several things to happen in a specific sequence.
Before you consolidate anything, each entity's books need to be on an accrual basis. That means prepaid expenses are amortized correctly, deferred revenue is recognized on the right schedule, fixed assets are depreciated, and loans have correct interest accruals. If you consolidate raw QuickBooks trial balances before making these adjustments, your consolidated financials are wrong before they even start.
Intercompany transactions come in several forms: loans between entities, management fees, shared services allocations, intercompany sales, and rent charges from a property entity to operating entities. Each one needs to be identified, recorded consistently on both sides, and eliminated in the consolidation. A management fee charged by the holdco and paid by the opco needs to show up as income in holdco's books and expense in opco's books — then both entries need to be eliminated when you consolidate so the consolidated entity shows neither.
If any entities operate in a different functional currency from the reporting currency, you need to translate their financial statements before consolidation. Under IAS 21, monetary assets and liabilities translate at the closing rate, non-monetary items translate at the historical rate, and income statement items translate at the average rate for the period. The resulting translation difference goes to other comprehensive income, not through the P&L. QuickBooks Online does not do any of this automatically.
Once entity financials are adjusted and translated, you aggregate all line items and then apply the elimination entries. A proper consolidation journal entry for intercompany elimination looks exactly like a standard journal entry — debit one account, credit another — except it only exists at the consolidated level, not in any entity's books.
The consolidated P&L, balance sheet, and cash flow statement should be traceable back to entity-level figures, adjustments, translations, and eliminations. An auditor reviewing your consolidation should be able to follow every number from the consolidated statement to its source, with a clear explanation of every adjustment made.
The Excel reality check: Done manually in Excel, a proper consolidation for 5–10 entities takes a skilled controller 1–3 days per month. For 15–30 entities, it can take a full week. Most of that time is spent on reconciliation and error-checking, not analysis.
NetSuite is an excellent platform for multi-entity consolidation. It handles intercompany elimination, multi-currency, and consolidated reporting natively at the ERP level. It also costs $30,000–$80,000+ per year in licensing, requires a 3–6 month implementation, and is typically appropriate for companies above $20–30 million in revenue with a full accounting team.
The question for a $5–20 million multi-entity company on QuickBooks Online is not "should I switch to NetSuite" but "can I solve this consolidation problem at the QuickBooks layer without rebuilding my entire financial stack." In most cases, the answer is yes — with the right transformation layer sitting between QuickBooks and your financial outputs.
A transformation layer connects to your QuickBooks Online entities via API, pulls the trial balance data, applies your accrual schedules (prepaids, deferred revenue, depreciation, accrued interest), runs your intercompany eliminations based on rules you define, applies IAS 21 translation where applicable, and produces a consolidated set of financial statements — all traceable back to source entries.
The key difference from a native QuickBooks consolidation report is that the adjustments happen before the consolidation, not as an afterthought. The output is not a raw report but a transformed, adjusted, elimination-applied view of your combined entities — with every adjustment documented and reversible.
For entities not on QuickBooks Online (QuickBooks Desktop companies, subsidiaries on different accounting systems, or holdcos that don't need a full accounting subscription), trial balance or GL transaction data can be imported via CSV and consolidated alongside your QuickBooks Online entities. This alone can save significant QuickBooks subscription costs for companies with 10+ entities in the structure.
Fynease Automate connects to QuickBooks Online, runs your accrual schedules, consolidates multiple entities, applies IAS 21 FX translation, eliminates intercompany, and writes adjusting entries back — every close, automatically.
See Fynease Automate Join waitlist