How to consolidate multiple QuickBooks companies and keep each entity's history straight

How do you consolidate multiple QuickBooks companies?

Each QuickBooks company file is its own set of books, so consolidation happens on top of the files: map accounts to one group chart, align periods, eliminate intercompany balances, then combine. For a client with five entities and eight years of files, the arithmetic is rarely the hard part. The hard part is knowing which file holds which entity's history, for which years, and who can still open it.

A seven-step sequence that works for most CAS engagements:

1. Inventory the files. List every company file, Online or Desktop, with the legal entity name, EIN, state of formation, fiscal year end, accounting basis, first and last transaction dates and who holds admin access.
2. Map to a group chart of accounts. Assign each account in each file to one consolidated line, and flag accounts that mix entities or carry suspense balances.
3. Align periods and policies. Agree one fiscal year end, one revenue cut-off and one capitalization threshold; note the years in which entities followed different rules.
4. Tag intercompany activity. Due-to and due-from accounts, management fees, shared payroll, intercompany sales and loans. Reconcile both sides monthly before eliminating anything.
5. Choose the consolidation layer. A controlled spreadsheet, a reporting add-on that reads each file, or a move to a multi-entity ledger. Intuit's lineup changes, so check what the client's current edition supports before buying a tool.
6. Eliminate and report. Post eliminations in the consolidation layer, never inside the entity files, and keep a tie-out workbook from each entity trial balance to the group statements.
7. Freeze the history. Before any file is archived or its subscription cancelled, take a complete export and confirm who can still open it.

What history do the company files hold?

A long-running file holds every posting since it was created, unless it was condensed, restarted or rebuilt along the way. Desktop files that were trimmed to fix performance may keep only summary balances before a cut-off date, so record that date for each file.

The ledger on its own is a narrow record. Its value rises when it links to the work behind it: invoices traced to CRM deals and project files, bills traced to purchase orders and approvals, credit memos traced to support tickets. Multi-entity groups add allocations, eliminations and close checklists that show real accounting judgment across entities, the kind of multi-step, outcome-labeled work that AI developers need to train and test agents and that rarely appears on the public web.

Build an entity history map alongside the consolidation

The entity history map is one extra table in the consolidation workbook. It records which legal entity holds which records, for which years, in which systems. It costs an hour during the file inventory and answers the first question anyone asks before a sale, a financing or a data license: who owns this, and who can sign?

Illustrative (a fictional group with placeholder names): OpCo Engineering LLC runs projects and employs most engineers from 2014 onward; ManCo Services Inc. employs finance, HR and IT staff and owns the email tenant from 2017; PropCo Holdings LLC holds leases and no staff; Acquired Survey LLC, bought in 2019 and merged in 2021, left a file covering 2012 to 2021 and an old file server. In this illustration, project records and email history sit with different entities, so a license could involve two signatures, and counsel would confirm who can authorize use of the merged company's archive.

Employment matters to ownership. Under copyright's work-made-for-hire rule, material an employee prepares within the scope of employment is generally owned by the employer, while work by an outside contractor is not unless it falls in a listed category and both sides agree in a signed writing (Copyright Office Circular 30). The employing entity is therefore a starting point, not the final answer: intercompany agreements, assignments and contracts can change it. The question on which entity owns records when employees are paid by a management company works through that structure, and an incumbency certificate is how a company later proves who may sign for each entity. This is general information, not legal, tax or financial advice. Confirm with your own counsel before acting.

Export and retention realities

Keep these generic rules in mind, and check Intuit's current documentation for the edition in use rather than relying on older forum answers.

• Report exports to spreadsheets (general ledger detail, transaction lists, customer and vendor lists) capture most ledger history; attachments, audit logs and payroll detail may need separate steps.
• For Desktop files, keep the last working version and a way to open it. A file nobody can open is not an archive.
• Before cancelling an Online subscription for an entity being folded into another file, confirm what access remains after cancellation under Intuit's current terms, and export first.
• Tax, audit, contract and litigation-hold duties vary by entity and state. Confirm them with the client's tax adviser and counsel before anything is deleted.
• A CAS team never exports, uploads or describes client records for a data license. If a license ever happens, the company prepares the data itself, under a signed agreement and the redaction rules agreed up front.

How a CAS team spots a client worth an introduction

The consolidation file inventory already answers most of the fit questions. Tick what you know:

• Peak headcount reaches 50+ full-time employees (contractors excluded), and you know which entity employs them.
• Several years of documented operations, with no condensed or restarted gaps in the core years.
• The ledger links to other systems the client runs well: CRM, project management, help desk, shared drives, email.
• The records are the client's own, not records it holds for its customers.
• An owner, CEO, CFO or other authorized representative can sign for each entity that holds records.
• The client has not already licensed the same data for AI training.

For a quick first pass, the company fit checker screens fit without asking for contact details; its result is preliminary and is not an approval. The page on who qualifies sets out the full baseline.

Pitfalls in multi-entity QuickBooks work

Referral rules that apply to CAS practices

Check professional rules before anything else. The AICPA Code's Commissions and Referral Fees Rule (ET 1.520) bars a member in public practice from accepting a commission for recommending a product or service to a client when the member or firm also performs an audit, review, certain compilations or an examination of prospective financial information for that client, and permitted commissions and referral fees must be disclosed to the client (AICPA Code of Professional Conduct, hosted by the Minnesota Board of Accountancy). State boards can be stricter. Check your firm's policy, your state board's rule and whether your firm performs attest work for the client before you register. This is general information, not legal, tax or financial advice. Confirm with your own counsel, tax adviser or professional body before acting.

Where a reward is permitted, partners earn 25% of the eligible platform fees SourceX actually collects from the referred company's licensing deals, capped at $100,000 per referred company. Rewards become payable only after the buyer pays and SourceX receives its fee; a lead, meeting or signed agreement alone does not trigger payment. The reward is funded from SourceX's fee, so the client's payment is the same either way. The referral program for client accounting services firms covers firm-level setup, and the analysis of CAS growth at Top 100 accounting firms explains why this conversation keeps coming up in CAS work.

What to say at the consolidation kickoff

Next step

Finish the entity history map, then ask the owner whether they want a screen. If they do, register as a partner and submit the client through the referral form, or share your referral link so the owner can apply at sourcex.si/apply with your credit preserved. If the group is also weighing a new ledger, read about switching to an AI-native ERP before any file is retired.