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 keeps each company in its own file, so consolidation happens outside it, in a workbook or a close tool. The steps are the same either way:
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.
Fynease Automate consolidates your QuickBooks Online entities, eliminates intercompany, applies IAS 21 translation, and brings in entities on other ledgers through CSV or Excel import.
See how it works → Start free trialA 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, all assets and liabilities translate at the closing rate, income statement items translate at the transaction-date rates (a period-average rate is the usual practical approximation), and equity is commonly carried at historical rates. The resulting translation difference goes to other comprehensive income, not through the P&L. (Historical rates for non-monetary items such as fixed assets belong to a different step: recording foreign currency transactions in the entity's own functional currency, not translating its statements for consolidation.) 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 days every month. For 15–30 entities, it can dominate the close calendar. Most of that time is spent on reconciliation and error-checking, not analysis.
HoldCo reports in Canadian dollars. OpCo US reports in US dollars and pays HoldCo a monthly management fee of USD 10,000. HoldCo also lent OpCo USD 100,000 last year. For the month, the average rate is 1.35 CAD per USD and the closing rate is 1.36.
The income statement: translate, then eliminate. OpCo's results translate at the average rate. The management fee is revenue in HoldCo and an expense in OpCo, so it comes out of both lines at the group level.
| CAD | HoldCo | OpCo (USD) | OpCo at 1.35 | Elimination | Consolidated |
|---|---|---|---|---|---|
| Revenue | 13,500 | 100,000 | 135,000 | (13,500) | 135,000 |
| Expenses | 5,000 | 70,000 | 94,500 | (13,500) | 86,000 |
| Net income | 8,500 | 30,000 | 40,500 | 0 | 49,000 |
The elimination does not change the group's net income; it stops revenue and expenses being counted twice. Without it, the group would report CAD 148,500 of revenue for a month in which it sold CAD 135,000 to outside customers.
The balance sheet: reconcile before you eliminate. HoldCo booked the loan receivable at CAD 133,000, the rate on the day it lent the money (1.33), and never revalued it. OpCo carries a payable of USD 100,000, which translates at the closing rate to CAD 136,000.
| Intercompany loan, CAD | HoldCo receivable | OpCo payable | Difference |
|---|---|---|---|
| As booked | 133,000 | 136,000 | 3,000 |
| After HoldCo revalues at 1.36 | 136,000 | 136,000 | 0 |
Eliminate first and the consolidated balance sheet carries a CAD 3,000 difference that nobody can explain. The fix belongs in HoldCo's own books: the receivable is a US-dollar balance, so it is revalued at the closing rate, with an unrealized foreign exchange gain of CAD 3,000 in HoldCo's income statement. Then both sides agree and the loan eliminates to zero.
One step remains. OpCo's translated balance sheet will not balance on its own, because its assets and liabilities are at the closing rate while its equity and results are not. That difference is the translation adjustment, and it goes to other comprehensive income. How the translation adjustment is calculated, with an example →
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 (this is what Fynease Automate is) 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.
Only partially. QuickBooks Online Advanced has a consolidated reports feature that pulls multiple companies into a single report view, but it does not eliminate intercompany transactions, apply IAS 21 foreign currency translation, check that each entity's schedules have been posted and reconciled, or produce an audit trail for consolidation adjustments. For two or three same-currency entities with no intercompany activity it may be enough. For anything more complex, consolidation has to happen in a separate process above the entity-level books.
A proper consolidation follows five steps in order. First, put each entity's books on an accrual basis with prepaids, deferred revenue, depreciation, and interest adjusted. Second, identify every intercompany relationship and confirm both sides are recorded. Third, translate any entity with a different functional currency under IAS 21. Fourth, aggregate the line items and apply elimination entries at the consolidated level. Fifth, produce consolidated statements that trace back to entity figures, adjustments, translations, and eliminations.
Usually not. NetSuite handles intercompany elimination, multi-currency, and consolidated reporting natively, but it costs $30,000 to $80,000 or more per year, takes three to six months to implement, and is typically suited to companies above $20 to $30 million in revenue with a full accounting team. A transformation layer that connects to QuickBooks Online via API, applies accrual schedules, eliminations, and IAS 21 translation, and produces consolidated statements can solve the problem at the QuickBooks layer.
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