What "consolidate" means when you own all the companies
Consolidation is the process of adding several companies' financial statements together as if they were one business, after removing every transaction between them. The result is one balance sheet, one profit and loss, and one cash number.
The loose version is a combined report: put the P&Ls side by side and sum the columns. That is what most owners have in a spreadsheet. It is useful. It is also wrong by exactly the amount of money that moved between your companies during the month, and when your property LLC charges rent to your operating company, that amount is not small.
An intercompany transaction is any sale, fee, rent, loan or bill payment between two companies with the same owner. Rent to your own real estate LLC, a management fee to the holding company, and one company paying another's insurance are the ones we see most.
An intercompany elimination is the entry that cancels an intercompany transaction out of the consolidated view, so that revenue in one company and the matching expense in the other do not both count. The common kinds, with their journal entries, are in intercompany transactions explained for owners.
The owner is not the only reader. A bank that has lent to two of your companies against each other's assets will want statements that cover both. Indinero, an accounting firm that prepares them, notes that lenders demand combined statements for cross-collateralized loans, that sureties ask for them before bonding a contractor, and that buyers ask for them in due diligence. Each of those readers starts from the top line. If rent to yourself is sitting in revenue, the lender's growth trend, the surety's capacity calculation and the buyer's multiple are all built on a figure that is partly you paying you. Removing the intercompany is what turns a combined statement into a consolidated one, and those readers know the difference.
Why QuickBooks Online cannot do it
Intuit's design is one company file per legal entity, and Intuit's own guidance says each company needs its own QuickBooks Online subscription. You get one login and a switch-company menu. Nothing in one file knows the other exists.
LiveFlow, which sells a consolidation tool, puts it plainly: there is no built-in tool for consolidating multi-entity financials in QuickBooks Online today. When an owner asked in the QuickBooks Community in October 2023 how to get combined reporting from several companies, the answer was to standardize the chart of accounts in every file and then use Spreadsheet Sync. When another asked in March 2025 about consolidation software for fifteen entities, they were doing it by hand in Excel every month. Nobody pointed either of them to a QuickBooks feature. There isn't one. That is where Intuit Enterprise Suite starts, and it is built for a bigger company than most owners reading this run.
The four routes and what each one costs
The first route is separate subscriptions and a spreadsheet. Plus is $115 a month per company as of this writing (NerdWallet's March 2026 price check), so four companies is $460 a month, and none of it buys consolidation. The spreadsheet does that, until the bookkeeper recodes an account and the formulas quietly stop matching.
Spreadsheet Sync is an Excel add-in included with QuickBooks Online Advanced that pulls data from several company files into one workbook. Intuit's help article on combining reports says it merges only accounts that share an identical name, type and hierarchy, and it does not touch intercompany transactions. Advanced was $275 a month per company at the same price check, so three companies is $825 a month before a single intercompany entry has been canceled, plus the standardization project first.
Intuit Enterprise Suite is Intuit's step above QuickBooks Online, sold as a mid-market product with its own consolidation and, per Insightful Accountant's summer 2025 review, 48-plus built-in KPIs against ten in Advanced. It is quoted rather than list-priced, and the estimates we have seen for a two-to-five-entity business run to the low five figures a year, with an implementation measured in months. We compare it with Advanced in QuickBooks Advanced, Intuit Enterprise Suite, or a reporting layer.
The third route is a third-party reporting layer such as Fathom, LiveFlow or Reach Reporting. Fathom's tiers run from $50 to $680 a month per Capterra, with no extra charge for consolidated groups; Reach starts at $149. These do real consolidation, most handle eliminations, and nearly all are sold to accounting firms, which shows in the setup: someone maps every account in every file and keeps the mapping current.
The fourth route is a read-only roll-up: a tool connects to each file read-only, reads the ledgers as they are, maps the accounts itself, and does the arithmetic. It is the newest category, built for the owner rather than the firm.
| Route | Monthly cost, three companies | Eliminations | Charts must match |
|---|---|---|---|
| Separate files plus a spreadsheet | $345 (Plus) | By hand | No |
| Spreadsheet Sync | $825 (Advanced) | No | Yes, exactly |
| Intuit Enterprise Suite | Quoted; low five figures a year | Yes | Migration |
| Third-party reporting layer | $345 plus $50 to $680 | Usually | Mapped in the tool |
| Read-only roll-up | $345 plus the tool | Depends on the tool | No |
These are list prices at the date above. Intuit changes them often.
What breaks without eliminations: a worked example
Three files. Ops Inc. bills the customers. Property LLC owns the building and charges Ops $11,200 a month in rent. Holdings LLC sits on top and charges Ops a $6,500 monthly management fee.
In June, Ops billed customers $312,000 and had expenses of $286,400, including the rent and the fee, for a profit of $25,600. Property took in $11,200 of rent against $8,900 of mortgage interest, property tax and insurance, for $2,300. Holdings took in $6,500 against $4,100 of accounting, legal and bank fees, for $2,400.
Stack the three P&Ls and the combined report says revenue $329,700, expenses $299,400, profit $30,300. Consolidate them properly and revenue is $312,000, the only money that came from a customer, expenses are $281,700, and profit is still $30,300.
Profit does not change, which is why the combined spreadsheet survives so long: the number at the bottom looks right. Everything above it moved. Revenue is overstated by $17,700 a month, $212,400 a year, which is money you paid yourself. Net margin reads 9.2% when it is 9.7%. A lender reading revenue trend, or a buyer applying a multiple, is looking at a figure that includes your own rent.
The balance sheet is worse. Say Ops also paid Property's $4,380 insurance premium in June and booked it as money owed from Property. If Property's bookkeeper, closing six weeks later, books the same $4,380 as an insurance expense and nothing else, the combined balance sheet shows an asset no other company acknowledges. A year of small favors turns that into a "due from" balance nobody can explain, which we unpick in one company paying another's bills.
Which route fits, by entity count and staff
| Your situation | What usually fits |
|---|---|
| Two or three entities, outside bookkeeper, nobody on staff owns the numbers | Read-only roll-up, or a reporting layer your firm runs |
| Two to five entities, your firm already uses Fathom or LiveFlow | Let the firm run it; ask to see the eliminations |
| Four to ten entities, a controller on staff, charts already standardized | Spreadsheet Sync; the controller's time is the real cost |
| Five or more entities, 50-plus staff, budget for an implementation | Intuit Enterprise Suite |
| Any count, if an entity might be sold | Keep the separate files whatever else you do |
The first row is most of the owners we talk to. Two or three entities, an outside bookkeeper who closes each file in turn, and nobody whose job includes reading them together. Spreadsheet Sync is wasted on that setup, because the add-in needs someone in Excel every month who knows why the accounts did not line up, and that person does not exist. The reporting layers are built for the firm, so if your CPA already runs one, the cheapest route is to let them and ask for the elimination entries by name. Spreadsheet Sync earns its place when a controller on staff already keeps the charts identical, and even then the monthly hour in Excel is the cost that matters more than the subscription. The last row is the one owners skip. A buyer of one entity wants that entity's file on its own, with its history intact, and a roll-up that sits on top of separate files leaves that untouched.
The standard advice, and the answer the Community gave in 2023, is to standardize the chart of accounts across every file before you try to consolidate. We would push back, for a practical reason: the standardization project is the step that never finishes, because the bookkeeper has a live file to keep and the CPA has a tax return that expects the old accounts. A roll-up that maps accounts on top of the files as they are gets you a number this month, and the clean-up can follow.
None of these routes fixes bad books. If your bookkeeper closes each file six weeks after month end, the consolidated view is six weeks old too, and an account miscoded in one file is miscoded in the total. And a consolidated number hides as much as it shows: three companies at a combined $30,300 can be two healthy ones carrying a third that loses $9,000 a month. You need the per-entity view beside the total, which is the point of managing several businesses without a spreadsheet.
What a consolidated view should show every morning
Cash first, by entity and in total, with yesterday's number beside it. The total on its own is not much use, because the Monday question is usually whether the entity that runs payroll on Friday has enough in its own account, and a healthy group total can hide one company sitting at $4,100 with a $58,900 payroll due. Then profit by entity, month to date, after eliminations, so the total is money from customers and not money from yourself. Then receivables past due, by entity, because the company with the cash problem is usually the one whose customers pay slowest. Last, the intercompany balances, due-from beside due-to, so you can see whether they net to zero. A balance that grows every month is one company funding another, whatever the memo says.
Four numbers is enough. Add thirty more lines and none of them get read, and the reason to read it daily is to notice the one line that moved. Yesterday's figure beside today's is what makes that possible, and it is the piece a spreadsheet almost never has, because nobody keeps a copy of last Tuesday's tab. What the view cannot do is close the books. If the bookkeeper is three weeks behind on one file, that entity's line is three weeks old, and the page should say so beside the number rather than let a stale figure sit next to fresh ones as if they matched.
Navigator does this on top of QuickBooks Online. It connects to each company file read-only, in two clicks, no password shared, and shows a consolidated and per-entity view without a chart-of-accounts clean-up first. The base plan is $299 a month for the first entity and each additional entity is half price. Intercompany elimination is on the Pro plan at $499, and any consolidated figure opens to show which company and which entry it came from. It does not replace your bookkeeper and it is not the system of record; the files stay where they are. Tiers are on the pricing page.
Whatever you use, the test is the same. Add up the customer invoices across every file for a month and compare that with consolidated revenue. If revenue is higher, something between your companies is being counted as a sale.
Questions owners ask
Can I have multiple companies under one QuickBooks Online account?
One login, yes. One subscription, no. Each company file is its own paid subscription, and Intuit's guidance is one file per company. You switch between them from the gear menu. The files share no customers, vendors or accounts, and no report in one file can see another.
Does QuickBooks Online Advanced consolidate multiple companies?
No. Advanced adds Spreadsheet Sync, an Excel add-in that pulls several company files into one workbook. Intuit's help article says it only combines accounts with an identical name, type and hierarchy, and it does not remove transactions between your companies. It is a stacked report, not a consolidation.
Is there a multi-company discount for QuickBooks Online?
Not in the US as of this writing. Intuit has run multi-file offers in other countries and excluded the US from them. Each company file pays list price for its plan. Your accountant may have firm pricing through Intuit, so ask, but do not plan around a discount.
Do I need the same chart of accounts in every file?
For Spreadsheet Sync, yes, down to the account name and type, or the accounts land in separate rows. For a reporting layer or a read-only roll-up, no, because the tool maps accounts for you. Similar charts help, but standardizing them is not a precondition for seeing one number.
How do I see total cash across all my businesses?
Nothing inside QuickBooks Online adds it up. You open each file, read the bank balances on each balance sheet, and add them, subtracting checks that have not cleared and money one company holds for another. A tool that reads every file does the same sum each day, which is how it stays current.
Related
If the money moving between your companies is the confusing part, start with intercompany transactions explained for owners. If you are still deciding how many files to run, read one QuickBooks file per LLC, or classes. And QuickBooks Advanced, Intuit Enterprise Suite, or a reporting layer works Intuit's own options through for three and six entities.
If you want to see what your own files add up to, the trial takes about fifteen minutes to connect and needs no card: navigatorhq.ai.
Published . Last updated . Reviewed by a CFO on the Navigator team.