Multi-entity consolidation for QuickBooks Online
Roll up every entity, match both sides of your intercompany balances, and draft the eliminations against one consolidated chart of accounts. Your controller approves. Nothing migrates.
| Entity | Ownership | Currency | Intercompany balance | Counterparty | Status |
|---|---|---|---|---|---|
Harbor Ridge LLCParent · Delaware | Parent | USD | 184,200 | Clearwater Holdings | Matched |
Clearwater HoldingsSubsidiary · acquired Jun 2025 | 65% | USD | 31,900 | Oakline Construction | Matched |
Oakline ConstructionSubsidiary · Texas | 100% | USD | 248,700 | Harbor Ridge LLC | Sides disagree · 3,500 |
Cedar Mill LtdSubsidiary · United Kingdom | 100% | GBP | £24,840 | Harbor Ridge LLC | Matched |
| 7 more entities | 365,280 | 7 pairs | All matched | ||
What is multi-entity consolidation in QuickBooks Online?
Why QuickBooks Online alone cannot consolidate
Each QuickBooks Online company closes fine on its own. The difficulty starts where two companies have to agree: the management fee one entity invoiced and the other expensed, the loan one carries as a receivable and the other as a payable, the payroll one entity ran and three entities share. Those balances have to be matched and removed before the group numbers mean anything.
QuickBooks Online has no view across companies. QuickBooks Online Advanced's Spreadsheet Sync adds the entities together in a spreadsheet and stops there. Intuit puts automated intercompany eliminations in Intuit Enterprise Suite, which Intuit describes as "a new category of software distinct from our QuickBooks Online and Desktop products."
So the consolidation moves to a workbook. One person owns it, the mappings live in their head, and every month the eliminations are rebuilt by hand from exports. It works until an entity is added, a currency changes, or that person is on leave at close.
The entities are not the problem. The space between them is.
How Finlens consolidates QuickBooks Online entities
Four steps, every month. Your team touches it once, at approval.
Reads every entity
Connects to each QuickBooks Online company and maps its chart of accounts to one consolidated structure. New accounts are flagged, not guessed.
Matches intercompany
Pairs both sides of every intercompany balance across entities and currencies, and flags the pairs that disagree with the difference shown.
Drafts the entries
Elimination and translation entries drafted against the consolidated chart of accounts, with the source transaction on every line.
You approve
Nothing is applied to the consolidation until a named reviewer signs off. Pairs that disagree stay open until both sides agree.
Finlens compared with spreadsheets and an ERP migration
The two routes most groups on QuickBooks Online are offered, against the one that keeps the ledger where it is.
| Criteria | Spreadsheet | ERP migration | Finlens on QuickBooks |
|---|---|---|---|
| Time to first consolidation | Weeks, then rebuilt monthly | Typically six months to a year | Same day |
| Intercompany eliminations | By hand | Automated after setup | Matched and drafted |
| Where the ledger lives | QuickBooks | A new system | QuickBooks, unchanged |
| Changes to entity charts of accounts | None | Every entity | None |
| Audit trail | Formulas only | Depends on the system | Source on every line |
| If you leave | Unaffected | Migrate again | Unaffected |
Finlens reads each entity through the standard QuickBooks Online API. Eliminations live in the consolidation layer; your entity files and their charts of accounts are not changed.
Eliminations, currencies and partial ownership
The items a controller checks first are the ones that cross entity lines. Management fees charged from the parent to each subsidiary. Shared payroll run by one entity and recharged to three. Inter-entity loans with interest accruing on both sides. Finlens treats each of these as a pair: the invoice in one file and the bill in the other, the receivable and the payable, the income and the expense. When both sides agree, the elimination is drafted. When they do not, the pair is flagged with the difference, and nothing is eliminated until someone resolves it.
Foreign-currency entities are translated into the reporting currency at the rates you set for the period: closing rate for the balance sheet, average rate for the income statement, with the translation adjustment drafted to equity, as ASC 830 requires for an entity whose functional currency is its local currency. The entity's own QuickBooks Online file keeps its functional currency untouched.
Ownership is effective-dated. A 65% subsidiary consolidates in full, with the 35% non-controlling interest (the share you do not own) shown separately in equity and in the income statement. An entity acquired on the 14th of the month is consolidated from that date, not from the first. When ownership changes, you change the date on the record and the roll-up follows.
Every elimination traces back to its source document
A consolidation is only as good as how fast you can answer "where did this number come from?" for someone who did not build it.
Both sides on one screen
The invoice in one entity and the bill in the other, side by side, with the difference shown if there is one. No tab-switching between company files.
Source on every line
Every line of every elimination links to the originating transaction in its QuickBooks Online file. The number is never further than one click from its document.
Named approver, timestamp
Who approved it, when, and what it looked like at the time. The consolidation can be reproduced months later by someone who was not in the room.
Frequently asked questions
What groups on QuickBooks Online ask before they consolidate with Finlens.
Not on its own. Each QuickBooks Online company is a separate file with its own chart of accounts. QuickBooks Online Advanced can group companies in Spreadsheet Sync and run a combined report in Excel, but it does not match intercompany balances or create eliminations. Consolidation with eliminations is a separate product in Intuit's lineup, Intuit Enterprise Suite.
No. Finlens reads each QuickBooks Online company through the standard API and consolidates above them. Elimination and translation entries live in the consolidation layer; nothing migrates and nothing in the entity files is re-mapped.
There is no fixed ceiling. Finlens is built for groups from two entities up to several dozen, with mixed currencies and partial ownership. Bring your structure to the demo and we will roll it up in front of you.
No. Finlens drafts every elimination and translation entry; a named reviewer approves each one before it is applied to the consolidated statements. Pairs whose sides disagree stay open and are never eliminated automatically.
Ownership percentages are effective-dated on each entity. A partly owned subsidiary consolidates in full, with the non-controlling interest calculated and presented separately in equity and in the income statement. Mid-year changes apply from the date you set.
Bring two entities to a 30-minute call
We roll them up live against your own chart of accounts, and tell you straight if your structure does not fit.
Book a demo