How to consolidate multiple QuickBooks files into one group view

If you own more than one company, you almost certainly have more than one QuickBooks file — and no single place where the group exists as one business. Each file closes on its own rhythm, charges the others rent or management fees, and tells you its own little story. None of them tells you the story.

Consolidation is the discipline of combining those separate books into one set of group statements, as if the group were a single company. Done right, it answers the question every owner quietly carries: how did the whole thing actually do last month?

What consolidation actually involves

• —Aligning the charts of accounts — "Revenue" in one file and "Sales income" in another must roll up to the same group line.
• —Aligning periods — a group view only makes sense when every entity is measured over the same window, even if their close dates drift.
• —Eliminating intercompany activity — rent, management fees and loans between your own companies are not real group revenue or expense, and must be removed.
• —Translating currencies, if any entity keeps books in a different currency.
• —Checking that everything still balances — in each entity and in the combined view.

The eliminations are where most owner-built consolidations quietly go wrong. If your property company charges your operating company $8,000 of rent each month, a naive sum overstates group revenue by $96,000 a year — money the group charged itself.

The three ways owners actually do this

Option one: the spreadsheet. Export trial balances from each file every month, map accounts by hand, maintain an eliminations tab. It works — until it doesn't. The mapping rots as bookkeepers add accounts, formulas break silently, and the person who built it becomes a single point of failure. Expect a day or two of someone's time per month, forever.

Option two: hire the work. An accountant or fractional CFO can own the consolidation. The output is professional and someone is accountable for it. The going market rate for fractional CFO engagements is US$3,000–7,000 per month, and the deliverable usually arrives well after month-end — useful for looking back, less useful for acting now.

Option three: software that reads your books. Tools connect to each QuickBooks or Xero file (read-only), map accounts, post eliminations by rule, and produce the group view continuously. The trade-off to scrutinise here is trust: you should be able to trace any group number back to the underlying entity transactions, and the tool should refuse to paper over books that don't reconcile.

Questions to ask before trusting any group number

• —Can I click from a consolidated figure down to the source transactions in the original file?
• —Are intercompany eliminations listed explicitly, pair by pair — or buried in an adjustment line?
• —What happens when an entity's books are out of balance: does the tool flag it, or smooth it over?
• —Is the access read-only, and can I revoke it from my accounting platform at any time?

Whatever path you choose, the standard is the same: a group view you would be comfortable handing to your bank or your investors, with a receipt behind every number. That standard is exactly what Composenz was built to meet — each entity stays in its own QuickBooks or Xero, and the group arrives composed, every Monday.