There is no QuickBooks Online consolidated balance sheet. Each company is its own file, and the closest built-in option, Spreadsheet Sync on Advanced, stacks the balance sheets of companies whose accounts share a name and type into a spreadsheet, with nothing canceled between them. A real consolidated balance sheet needs four things removed first: what one company owes another, loans between them, the parent's investment in a subsidiary, and any profit on assets sold inside the group. What is left is the statement your lender, your buyer and you should be reading: what the whole group owns and owes to the outside world.
What consolidated means on a balance sheet
A consolidated balance sheet is a single balance sheet for a group of companies that shows only the assets it holds against the outside world and the debts it owes to the outside world, as if the group were one company. Anything one group company owes another is removed. From the outside it does not exist.
On the P&L, consolidation is mostly about not counting the same sale twice, and intercompany eliminations explained covers that side. On the balance sheet, the problem is balances that sit on both sides at once. When OpCo lends PropCo money, OpCo has an asset and PropCo has a liability. Add the two balance sheets and the group appears to own something and owe something that, from outside the group, it neither owns nor owes.
Why stacking is wrong
Three companies, one owner, one warehouse. HoldCo, which the owner holds directly, owns OpCo, a 34-person distributor. PropCo owns the warehouse OpCo works from, and the owner holds it directly too. OpCo paid $41,300 of PropCo's bills over the summer, so OpCo shows a $41,300 due from PropCo and PropCo shows a $41,300 due to OpCo. HoldCo lent OpCo $250,000 two years ago, and its $100,000 original investment in OpCo sits on HoldCo's books as an asset and on OpCo's as paid-in capital. In March, OpCo sold PropCo a forklift for $15,000 that had cost OpCo $10,000, and the forklift is still in the warehouse.
| At 30 September | Stacked | Eliminations | Consolidated |
|---|---|---|---|
| Cash | $238,500 | $238,500 | |
| Receivables from customers | $414,300 | $414,300 | |
| Due from and notes from group companies | $291,300 | ($291,300) | $0 |
| Investment in OpCo | $100,000 | ($100,000) | $0 |
| Property and equipment | $1,606,000 | ($5,000) | $1,601,000 |
| Total assets | $2,650,100 | ($396,300) | $2,253,800 |
| Payables to vendors | $318,900 | $318,900 | |
| Owed to group companies | $291,300 | ($291,300) | $0 |
| Mortgage and outside loans | $1,180,000 | $1,180,000 | |
| Total liabilities | $1,790,200 | ($291,300) | $1,498,900 |
| Equity | $859,900 | ($105,000) | $754,900 |
The stacked sheet is $396,300 too big. It shows the group with assets it does not own, because OpCo's receivable from PropCo is PropCo's liability to OpCo and the money never left the family, and with debt it does not owe, for the same reason. A lender reading the stacked version sees total liabilities of $1.79 million against equity of $859,900; the real figures are $1.50 million against $754,900. Here the ratio moves only from 2.08 to 1.99, but an analyst who sees "Owed to group companies" on a group balance sheet will send it back, and rightly.
The four eliminations
Intuit's own ERP blog, in a February 2026 piece on intercompany eliminations, lists the four types, and they map onto the balance sheet like this.
Intercompany receivables and payables are the due to and due from balances that build up when one company pays for another. OpCo's $41,300 due from PropCo is canceled against PropCo's $41,300 due to OpCo. The entry on the consolidation worksheet debits the payable and credits the receivable, and if the two do not match to the dollar, somebody's books are behind, which due to and due from accounts explained goes into.
Intercompany loans work the same way at a larger size. HoldCo's $250,000 note receivable from OpCo is canceled against OpCo's $250,000 note payable to HoldCo. Interest that has accrued on the note and not been paid is an intercompany receivable and payable as well, and gets canceled with it.
The parent's investment in a subsidiary is canceled against the subsidiary's equity. HoldCo's $100,000 investment in OpCo is the same $100,000 that appears as paid-in capital on OpCo's balance sheet, which is the example Intuit's ERP blog uses. Leave it in and the group's equity is $100,000 higher than anything the owner could sell.
Unrealized intercompany profit is the gain on an asset one company sold to another while the asset is still inside the group. OpCo booked a $5,000 profit on the forklift; PropCo carries it at $15,000. To the group, the forklift is still a $10,000 forklift, so $5,000 comes off property and equipment and $5,000 comes off retained earnings. Intuit's example uses a $15,000 inventory sale with $5,000 of unrealized profit, and the mechanics are identical. It is the elimination most small groups skip. For one forklift the damage is small. For a company that sells its own product to a sister company that stocks it, the damage is the whole margin.
The equity line
Consolidated equity is not the three equity lines added together. HoldCo's $412,400 of equity already includes its investment in OpCo, and OpCo's $208,300 includes the same $100,000 as capital. Once the investment is canceled, consolidated equity is HoldCo's equity plus PropCo's, plus OpCo's earnings since HoldCo bought it, less the unrealized forklift profit, which in the example comes to $754,900. If a minority partner owned part of OpCo, their share would appear as its own line. At this size that is rare. How to read the equity section at all is in how to read a balance sheet as a business owner.
Three routes, and where each stops
Spreadsheet Sync is the Excel add-in that comes with QuickBooks Online Advanced, at $340 a month per company as of September 2026. Intuit's help article on combining reports from multiple companies, updated in August 2026, says it can merge three report types, Balance Sheet multi-period, P&L multi-period and Trial Balance, and that "accounts get combined if they have the same name, the same type, and are at the same hierarchical level in each report". The article does not mention eliminations. In practice you open the add-in, pick the companies, pick Balance Sheet multi-period, and get a workbook with a column per company and a total; then you add the eliminations column yourself. Every company needs Advanced for its file to be included, and accounts with different names land on separate lines. Spreadsheet Sync, what it does and where it stops goes further.
The worksheet route needs no upgrade. Export each company's balance sheet to Excel on the same date, lay them side by side, and map the accounts: a table that says OpCo's Equipment and PropCo's Fixed Assets both roll to Property and Equipment. The common advice is to standardize every chart of accounts before you start, and we think that is the wrong order; a mapping table takes an hour and works today, while a chart-of-accounts cleanup across three files takes a bookkeeper a month and changes history. Add an eliminations column with the four entries above, then a consolidated column that sums across. LiveFlow's guide to whether QuickBooks can do consolidated statements notes that the eliminations "must be created manually in each entity and reconciled during close", and its May 2026 survey found 78% of finance leaders still move data between systems by manual spreadsheet export. An owner who asked the QuickBooks Community in March 2025 about consolidating 15 entities was doing exactly this, in Excel, every month.
The tool route reads each file and builds the worksheet for you. Fathom's pricing page, as of September 2026, says consolidated groups are free of charge on its plans, and Reach Reporting includes consolidation on every plan. The tools differ on whether eliminations are automatic or entered by hand, and on whether the charts of accounts must match first.
Navigator shows a consolidated and per-entity balance sheet on the base plan, read from each QuickBooks Online file without changes to the books, and every consolidated line opens to the company and the entry behind it. The eliminations that turn a stacked sheet into a consolidated one, intercompany balances, loans, investment and unrealized profit, are on the Pro plan at $499 a month. Plans are on navigatorhq.ai/pricing. It reads the books as the bookkeeper left them, so a due-from that PropCo never recorded will not net to zero in any tool, and the worksheet will say so.
Three checks on any consolidated balance sheet you are handed
Whoever built it, check three lines before you send it anywhere. Due to and due from group companies should net to zero; if a balance remains, it is either a real timing difference the bookkeeper can name or an entry one company forgot. Cash should equal the sum of the bank balances across every company on that date, because nothing about consolidation changes cash. And total outside debt should equal the sum of the loan statements from the banks; if the consolidated figure is higher, an intercompany loan is still in it. Those three checks take ten minutes. They catch most of what goes wrong. What they cannot catch is a balance sheet that was wrong in one file to begin with, an unreconciled bank account or a stale receivable, since consolidation adds up what it is given. Whether QuickBooks Online can consolidate multiple companies covers the routes for the group as a whole.
Combined or consolidated
A combined balance sheet adds sister companies together with intercompany balances removed, without a parent that owns the others. A consolidated balance sheet presents a parent and its subsidiaries as one entity, with the parent's investment canceled against the subsidiaries' equity. If the owner holds HoldCo and PropCo directly and HoldCo holds OpCo, the group statement is combined for PropCo and consolidated for OpCo. The CPA's label is "combined and consolidated". Indinero's 2026 guide notes that lenders on cross-collateralized loans ask for combined statements, and in our experience a bank with a cross-guarantee accepts either label, provided the intercompany lines net to zero and the total debt agrees with its own records.
Questions owners ask
Can QuickBooks Online create a consolidated balance sheet?
No. Each company is a separate file and no tier of QuickBooks Online reads across them. Spreadsheet Sync, included with Advanced at $340 a month as of September 2026, pulls several companies' balance sheets into one Excel workbook and adds matching accounts together, but it does not remove intercompany balances, so the result is stacked, not consolidated.
What gets eliminated on a consolidated balance sheet?
Four things: balances one company owes another, such as due to and due from accounts; loans between group companies; the parent's investment in a subsidiary, canceled against the subsidiary's equity; and profit on assets sold from one company to another that are still held inside the group. Each removes an amount from both sides so the statement shows only outside assets and debts.
What is the difference between a combined and a consolidated balance sheet?
A combined balance sheet adds the companies together with intercompany balances removed but without a parent owning the others; it suits sister companies held directly by the same owner. A consolidated balance sheet presents a parent and its subsidiaries as one, with the investment canceled against subsidiary equity. A lender with cross-guarantees usually accepts either, provided intercompany balances net to zero.
Does Spreadsheet Sync consolidate balance sheets?
It combines them. Intuit's help article, updated August 2026, says it merges Balance Sheet multi-period, P&L multi-period and Trial Balance reports from several companies, combining accounts that have the same name, type and level in each file. It does not mention eliminations, so what OpCo owes HoldCo appears as both an asset and a liability in the workbook.
Do I need the same chart of accounts in every company?
For Spreadsheet Sync, yes, or the mismatched accounts land on separate lines. For a worksheet or a tool, no. You need a mapping, a table that says OpCo's Equipment and PropCo's Fixed Assets both roll to Property and Equipment. Most groups have three to five accounts that need mapping and the rest match already.
Related
For the income statement side of the same job, intercompany eliminations explained works through management fees, rent and internal sales. If the group has a holding company at the top, holding company accounting in QuickBooks covers how the investment and the loans should be booked in the first place. And for the balances that most often refuse to net to zero, due to and due from accounts explained is the place to look.
If you would rather see the consolidated and per-company balance sheets from your own files than build the worksheet, the trial connects read-only in two clicks and needs no card: navigatorhq.ai.
You're on the list.
The next post goes to . While you wait, the free Accounting Health Check scores your own books.
Published . Last updated . Reviewed by a CFO on the Navigator team.