Tech for CFO
Start free

Category guide

Consolidation software for QuickBooks Online

A good consolidation tool should do the work for you, not hand you another spreadsheet. Here is what to look for, and how Tech for CFO approaches it.

Why consolidation is worth getting right

QuickBooks Online runs one company's books beautifully and cannot combine entities into group financials at all. The usual answer is a fragile month-end spreadsheet that re-maps charts of accounts and nets intercompany by hand. Purpose-built consolidation removes the rebuild and the error risk that come with doing group reporting in a workbook.

What to look for

  • Combines multiple QuickBooks companies into one set of group financials
  • Handles intercompany eliminations rather than double-counting
  • Supports non-controlling interests where ownership is partial
  • Keeps each entity's books intact while producing the group view
  • Refreshes as the underlying company files change

Go deeper

Guides on QuickBooks consolidation

Practical, in-depth playbooks on consolidation for QuickBooks Online — how it works, where it breaks, and how to get it right.

Read the guides Browse all apps

Common questions

What makes a good QuickBooks consolidation tool?
It should connect directly to QuickBooks Online, read your live ledger, use a read-only connection, and produce a result you can act on rather than another export to clean up.
Do I need to leave QuickBooks?
No. A good consolidation tool works on top of QuickBooks Online, so your books stay where they are.
Can QuickBooks Online consolidate multiple companies?
No. Each QuickBooks Online company is a self-contained ledger, 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 using classes or locations — which defeats the point of separate legal entities with their own tax IDs and audit trails. Combining separate QuickBooks companies takes either a spreadsheet or purpose-built consolidation software.
What does consolidation software for QuickBooks Online actually do?
Four things the spreadsheet makes you do by hand: it connects to every QuickBooks Online company and reads each trial balance automatically, maps each entity's local accounts to one group chart of accounts, eliminates intercompany activity so the group is not counting sales it made to itself, and produces a consolidated balance sheet and P&L that stays current as the underlying books change.
How do I combine exports from several QuickBooks companies?
Manually, the sequence is: export each entity's trial balance for the period, paste them side by side, map every local account to a common group line, post elimination entries for intercompany balances and transactions, then total. It works for two or three entities with little intercompany activity. It degrades quickly as entities, intercompany volume, and currencies increase — each new entity adds a mapping and a set of eliminations to rebuild every close.
What is data consolidation for QuickBooks Online?
Pulling financial data out of several QuickBooks Online companies and combining it into one reporting set. The hard part is not the pulling — it is that entities which grew up separately rarely share a chart of accounts, so the data has to be mapped to a common structure before it can be added together, and the transactions entities did with each other have to be removed.
How are intercompany transactions eliminated in a consolidation?
Every transaction between your own entities — a sale from one to another, an intercompany loan, a management fee — appears twice in the combined numbers and has to be removed so the group is not booking revenue or profit from selling to itself. Both sides have to be identified and matched. This is where hand-built consolidations most often break, and unreconciled intercompany balances are a common audit finding.
Do all my entities need the same chart of accounts?
Not identical, but they do need a stable mapping to a common group structure. Define the group chart of accounts once and map each entity's local accounts to it, rather than re-deciding the mapping every period. Entities keep their own books; the mapping is the asset to maintain.

Further reading on consolidation