Skip to content
Nummio
Menu
ProductTry it liveMigration demoPortfolio migration demoClose walkthrough
Pricing
SwitchingLeaving QuickBooksCompareCost comparisonQuickBooks Desktop alternativeQuickBooks price history
For accountants
TrustSecurityData freedomNo upsellsAI you controlSupport promise
Sign inStart free trial

Consolidating QuickBooks companies is a spreadsheet job. Here is how people actually do it.

If you have three QuickBooks Online companies and want one income statement, there is no button. There are four established ways to get there, and each one is worth knowing about before deciding whether the project is worth doing at all.

Try the portfolio demo

The four ways

1Export each company's reports and combine them by hand.
Run the P&L and balance sheet in each company, paste them side by side, add a column. Free, and it's what most owners with two or three companies do at year end. Intercompany activity, a management fee or a loan between the companies, sits in both files and has to be found and backed out by hand, or the combined revenue is overstated.
2Spreadsheet Sync, on an Advanced subscription.
Intuit's supported path: group the companies in Spreadsheet Sync and run consolidated reports into a spreadsheet. The other companies can stay on lower tiers, but the one running the sync must be Advanced. Intuit's article on it does not address eliminations; the between-company activity is still yours to remove.
Intuit, "Add company data to Spreadsheet Sync", verified
3A third-party consolidation tool.
Fathom, Syft, LiveFlow, and similar tools pull from each QuickBooks company and build a group view, some with elimination rules. They cost a subscription on top of the QuickBooks ones and the eliminations still depend on someone tagging the intercompany accounts correctly in every file.
4Intuit Enterprise Suite.
Intuit's own multi-entity product, with intercompany eliminations that remove the flagged transactions and balances from consolidated reports. It is a different product from QuickBooks Online, sales-led, and independent estimates put multi-entity deployments at $12,000 to $15,000 a year before implementation.
Intuit, "How intercompany eliminations work in Intuit Enterprise Suite", verified

Why the eliminations are the hard part

A consolidation that only adds the columns is a combined statement with the intercompany activity still in it. If Company A charges Company B a $2,000 monthly management fee, A shows $2,000 of revenue and B shows $2,000 of expense, and the group has neither. Intuit's own guidance is that each entity records its side through a clearing account for that entity pair, and that you must eliminate those activities during consolidation. In separate QuickBooks files, that means finding every one of those entries in every file, every period, and trusting that both sides were actually recorded.

QuickBooks blog, "Intercompany transactions: best practices for multi-entity accounting", verified

What changes when the ledger knows about entities

In Nummio every ledger row carries its entity, and an intercompany entry posts both sides in one transaction or not at all, so the reciprocal balances between any two entities net to zero by construction. The combined statement then eliminates against that link at report time, without adjusting either entity's books. Consolidation stops being a project and becomes a report you open. Combined versus consolidated is a real distinction, and the label is driven by your declared ownership structure, explained here.

The concession: this only helps if the businesses are in Nummio. Batch migration of a whole portfolio of QuickBooks files is included on every plan, with a completeness report and a reconciliation report per file, described on the leaving-QuickBooks page. What running the portfolio costs on each stack is on the calculator.

Run the consolidation on three sample files.

Real importer, real eliminations, real combined statement, in your browser.

Try the portfolio demo