How to Consolidate Multiple QuickBooks Companies

If you run more than one QuickBooks Online company, at some point you need one combined picture: a group balance sheet and P&L that treats your separate legal entities as a single business. QuickBooks won't do this for you—each company file is its own island. This is the step-by-step of consolidating multiple QuickBooks companies, whether you do it by hand or with software.

The steps are the same either way. What changes is how much of it you do manually and how often it breaks.

Can QuickBooks Online consolidate multiple companies?

Not across company files. Each QuickBooks Online company is a self-contained ledger with its own chart of accounts, and there is no native feature that reaches across companies to combine their balances. QuickBooks' own "consolidated" reporting only works when every entity lives inside one company file, separated by classes or locations—which defeats the purpose of having separate legal entities with their own tax IDs, their own audit trails, and in many cases their own owners.

So combining separate QuickBooks companies means doing the work outside QuickBooks: in a spreadsheet, or in software built for it. The steps below are what that work actually consists of.

Step 0: Decide which entities belong in the group

Before any mechanics, settle the scope. An entity you control—generally above 50% ownership—gets fully consolidated: 100% of its assets, liabilities, revenue and expenses join the group, with the outside owners' share carved back out as non-controlling interest. An entity you merely influence, typically 20–50%, does not get consolidated at all; it sits on the balance sheet as a single equity-method investment line.

Getting this wrong is expensive to unwind, because it changes every downstream number rather than one of them. Settle it once, write down the ownership percentage and the method for each entity, and revisit it only when ownership actually changes.

Step 1: Standardize a group chart of accounts

Consolidation falls apart at the start if your entities don't share a common structure. Entity A's "Sales – Services" and Entity B's "Consulting Revenue" have to roll up to the same group line, or the combined P&L is meaningless.

Define one group chart of accounts—the structure the consolidated statements will use—and map each entity's local accounts to it. You don't have to change how each entity keeps its own books; you just need a mapping that says "this local account belongs to this group line." Do this once and maintain it, rather than re-deciding it every month.

Two rules keep the mapping from rotting. First, map to the group account, never to another entity's account—otherwise the group structure quietly becomes whatever the largest entity happens to use. Second, make new accounts fail loudly: an unmapped account should stop the consolidation, not silently drop out of it. The most common quiet error in a hand-built roll-up is a subsidiary adding an account mid-year that no VLOOKUP ever picks up.

Step 2: Pull each entity's trial balance

For each QuickBooks company, get the trial balance for the period—every account and its ending balance. By hand, that's an export per entity. The problem isn't the export itself; it's that you're doing it every close, and a single wrong period or a missed adjusting entry throws off the whole group.

Use the trial balance rather than the P&L and balance sheet separately. The trial balance is the one report that has to prove itself: debits equal credits, every account present, nothing rounded away in a summary view. If an entity's export doesn't balance before it joins the group, nothing downstream will.

Connecting your companies to consolidation software for QuickBooks Online removes this step entirely—it reads each entity's live trial balance directly, so the group is always built from current numbers rather than from whatever was exported on the day someone got to it.

Step 3: Combine the exports and map them

This is the step people mean when they search for combining or consolidating QuickBooks Online exports. Line up each entity's trial balance side by side and translate every local account to its group account using the mapping from Step 1.

Doing it in a workbook, the durable shape is one tab per entity holding the raw export exactly as QuickBooks produced it—untouched, so it can be re-pasted when an entity re-closes—plus a separate mapping tab and a summary that reads through the mapping. The version that fails is the one where the mapping is typed directly onto the entity tabs, because a re-paste destroys it and nobody notices until the totals move.

Now you have a combined set of numbers: every entity added together. But combined is not the same as consolidated. A combined view double-counts everything your entities did with each other, which is why the next step exists.

Step 4: Eliminate intercompany activity

This is the step that makes consolidation genuinely different from addition, and the step most likely to go wrong. Anything your entities did with each other has to be removed so the group doesn't count it as external activity:

• Intercompany receivables and payables—if Entity A owes Entity B, those balances cancel at the group level.
• Intercompany sales and cost—revenue one entity booked selling to another isn't group revenue.
• Intercompany loans and interest.
• The parent's investment in a subsidiary, eliminated against the subsidiary's equity.

Done by hand, these eliminations are a month-end hunt through the books to find both sides of every intercompany transaction. It's tedious and it's where the group most often fails to tie out. There's a better way to run it—see intercompany eliminations in QuickBooks.

One check worth building in: a correct elimination of a fully intercompany transaction removes both sides together, so it should not move consolidated net income. If it does, either you eliminated one side only, or you are looking at unrealized profit on inventory the group still holds—the one legitimate exception, and the one that gets missed.

Step 5: Translate currency, if needed

If any entity reports in a different currency, translate it before it joins the group: closing rate for balance sheet accounts, average rate for the P&L, historical rates for equity, with the difference landing in a cumulative translation adjustment in equity. Skip this and your group balance sheet won't balance.

The failure mode here is not the method, it's the rate source. Rates buried in cells go stale, and a stale rate misstates an entire entity without producing an error anywhere. Keep the rates on their own tab with the date and source next to each one, so a wrong number is visible rather than inferred.

Step 6: Allocate non-controlling interest

If you own less than 100% of a consolidated entity, the group has taken in all of its results and now has to hand the outside owners' share back: their portion of net income on the P&L, their portion of equity on the balance sheet.

Order matters. NCI is calculated on the subsidiary's results after intercompany profit is eliminated, not before. Reversing the two produces a figure that looks perfectly plausible and is wrong by exactly the eliminated margin—which is why it survives review.

Step 7: Produce and review the group statements

With everything scoped, mapped, combined, eliminated, translated and allocated, you can produce the consolidated balance sheet, P&L, and a group cash position across entities. Review it the way you'd review any close:

• Does the consolidated trial balance still balance?
• Do the eliminations net to zero, other than any deliberate unrealized-profit adjustment?
• Does group cash equal the sum of the entity bank balances, less intercompany transfers in transit?
• Did every account in every entity's export land somewhere in the group structure?
• Does consolidated equity move only by net income, distributions, contributions and the translation adjustment—and nothing else?

That last one is the strongest single check in a consolidation. Equity has a small number of legitimate reasons to move. Anything else that reaches it came from a mistake somewhere upstream, and finding it now is much cheaper than finding it in the audit.

The honest summary

Every step above is doable in a spreadsheet. The reason companies move off the spreadsheet isn't that it can't consolidate—it's that steps 2, 4, 5 and 6 have to be redone perfectly every single period, by one person, with no margin for error, on a deadline. Nothing accumulates: last month's work doesn't carry forward and doesn't get better, so twelve closes are twelve independent chances to make a new mistake.

Software encodes the mapping and the eliminations once and applies them consistently, which turns a multi-day exercise into a review. That is the whole value proposition, and it is worth exactly as much as the number of entities and the volume of intercompany activity you have—which is why two entities that barely trade with each other genuinely don't need it, and five that do genuinely can't do without it.

For the bigger picture on choosing a tool, start with the complete guide to consolidation software for QuickBooks Online, or compare the best QuickBooks consolidation options.