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.

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.

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.

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.

Step 3: Combine and map

Line up each entity's trial balance and translate every local account to its group account using the mapping from Step 1. 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.

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, with the difference landing in a cumulative translation adjustment in equity. Skip this and your group balance sheet won't balance.

Step 6: Produce and review the group statements

With everything mapped, combined, eliminated, and translated, 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 it tie out, do the eliminations net to zero, does the group cash match the sum of the entity bank balances minus intercompany?

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, and 5 have to be redone perfectly every single period, by one person, with no margin for error. Software encodes the mapping and eliminations once and applies them consistently, which turns a multi-day exercise into a review.

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.