Want to learn more about the platform?
Book a DemoRoll 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.
The setup behind every consolidated report for this group. Changes apply to all of them; nothing here posts to QuickBooks. To see what is affecting a particular statement, open Balance Sheet or Profit & Loss in consolidated mode.
Pair up the accounts that represent the SAME intercompany balance across entities. On the consolidated Balance Sheet and P&L, the matched minimum is netted out of both legs (any unmatched remainder stays visible). Eliminations never post to QuickBooks — they adjust the consolidated view only.
| Entity | Account |
|---|---|
| Harbor Ridge LLC | 4100 · Management fee income |
| Clearwater Holdings | 6210 · Management fee expense |
| Entity | Account |
|---|---|
| Harbor Ridge LLC | 4200 · Construction recharge income |
| Oakline Construction | 6300 · Construction recharge expense |
| Entity | Account |
|---|---|
| Harbor Ridge LLC | 4150 · Payroll recharge income |
| Cedar Mill Ltd | 6100 · Payroll recharge expense |

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.
Four steps, every month. Your team touches it once, at approval.
Connects to each QuickBooks Online company and maps its chart of accounts to one consolidated structure. New accounts are flagged, not guessed.
Pairs both sides of every intercompany balance across entities and currencies, and flags the pairs that disagree with the difference shown.
Elimination and translation entries drafted against the consolidated chart of accounts, with the source transaction on every line.
Nothing is applied to the consolidation until a named reviewer signs off. Differences stay flagged until both sides agree.
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.
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 matched amount is eliminated and the difference stays flagged on the pair 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.
Pair up the accounts that represent the SAME intercompany balance across entities. On the consolidated Balance Sheet and P&L, the matched minimum is netted out of both legs (any unmatched remainder stays visible). Eliminations never post to QuickBooks — they adjust the consolidated view only.
| Entity | Account |
|---|---|
| Harbor Ridge LLC | 4100 · Management fee income |
| Clearwater Holdings | 6210 · Management fee expense |
| Entity | Counterparty entity | Kind | Posted | Amount |
|---|---|---|---|---|
| Harbor Ridge LLC | Clearwater Holdings | Invoice | 3/1/2026 | $12,500.00 |
| Clearwater Holdings | Harbor Ridge LLC | Bill | 3/3/2026 | $12,500.00 |
| Harbor Ridge LLC | Oakline Construction | Invoice | 3/12/2026 | $248,700.00 |
| Oakline Construction | Harbor Ridge LLC | Bill | 3/14/2026 | $245,200.00 |
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.
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.
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.
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.
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. Where the two sides of a pair disagree, the difference is flagged and is never cleared 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 demoEvery fixed asset on one register, with the monthly depreciation entry drafted for approval.
Related feature Deferred revenue automationService periods read from invoices and Stripe, the recognition schedule built, and the journal reviewed before it posts.
Related feature Stripe revenue recognitionCharges, fees, refunds and payouts read from Stripe and recognized per period, gross of fees.
Manage Finances with Ease
Get started in minutes, no setup fees, no contracts.