Call Now: 1-800-583-0148

QuickBooks Multi-Entity & Consolidations During Cleanup (How to Get It Right)

Misclassified transactions? Learn the CPA-designed method to reclassify categories, classes, and locations in QuickBooks-without breaking history or reconciliations.

Call Me Back

Multi-entity accounting is hard enough when books are clean-add a backlog and it gets messy fast. If you manage multiple LLCs, subsidiaries, or locations in QuickBooks Online, a proper cleanup must standardize charts, reconcile Due To/Due From, and document elimination entries before preparing consolidated financials. This guide explains the CPA-designed process we use on multi-entity QuickBooks cleanups: fix intercompany balances, align charts and classes, reconcile every account to statements, and produce a consolidation worksheet with eliminations and workpapers. When we’re done, you’ll have CPA-reviewed entity books, a clear roll-up, and a period-lock so history stays clean-then you can move into a predictable monthly close across all entities.

What “Good” Multi-Entity Looks Like

  • tickStandardized Chart of Accounts across entities (same names/codes/parents)
  • tickDue To/Due From pairs that mirror exactly between entities (no orphan balances)
  • tickIntercompany revenue/expense identified and eliminated in consolidation
  • tickEntity books reconciled (banks/loans/CC) with $0 recon differences
  • tickConsolidation worksheet with eliminations and tie-outs to each entity TB
  • tickCPA review completed; period lock set on each finalized month

Step 1 - Standardize the Chart & Dimensions

  • tick Create a master COA and map each entity’s accounts to it (Before → After).
  • tick Align classes/locations if used for department or region views.
  • tick Freeze the structure before you start reclass or recon so reports align.

Step 2 - Reconcile Each Entity (Bank/Credit/Loan)

  • tick Complete month-by-month reconciliations to statements for every entity.
  • tick Clear Undeposited Funds and suspense to zero; fix stale checks/deposits.
  • tick Confirm AR/AP Aging equals GL totals in each entity before consolidation.

Step 3 - Fix Intercompany (Due To / Due From)

  • tickInventory balances: For each entity pair (A ↔ B), export intercompany detail (bills, invoices, loans).
  • tickMirror balances: If Entity A shows Due From B = $25,000, Entity B must show Due To A = $25,000.
  • tickTrue-up entries: Post adjusting JEs in each entity with dated memos and links to support (loan agreements, bill/invoice chains).
  • tickSet policy: going forward, create an intercompany SOP (who books which side, when).

Step 4 - Identify Intercompany Sales/Expenses

  • tick Pull Transaction Detail by Account for revenue and expense accounts across entities.
  • tick Tag transactions that cross entities (management fees, rent, shared payroll, recharges).
  • tick Summarize by counterparty to build elimination schedules.

Step 5 - Build the Consolidation Worksheet (Outside QBO)

Because QuickBooks Online keeps entities separate, prepare consolidation outside QBO (Sheets/Excel):

Tabs to include:

  • tickEntity_TBs - each entity’s trial balance post-cleanup
  • tickMappings - COA alignment to master structure
  • tickIntercompany - Due To/Due From roll-forward by pair
  • tickElims - eliminations list (IC revenue/expense, IC COGS, loans)
  • tickConsolidated_TB - sum of entities minus eliminations = consolidated balances
  • tickVariance_Note - narrative explaining material changes post-cleanup

Step 6 - Post Eliminations

  • tick Keep elimination entries in the consolidation workbook-not in the entity ledgers.
  • tick If you must present consolidated financials from software, use a reporting tool (e.g., Google Sheets/BI) fed by entity TBs + Elims tab.
  • tick Retain workpapers with references to invoices/bills/agreements.

Step 7 - Multi-Currency Considerations

  • tick Lock exchange rates per period for consistency.
  • tick Re-measure monetary items at period-end; document FX gains/losses.
  • tick Eliminate intercompany balances after FX remeasurement for the period.

Step 8 - CPA Review & Period Locks

  • tick A CPA reviews reconciliations, Due To/Due From mirrors, elimination schedules, and the consolidated TB.
  • tick Lock each entity’s period after review; document the clean-as-of date.

Mini Case Example

A holding company with 3 LLCs had mismatched Due To/Due From and duplicated management fees. We standardized the chart, reconciled all banks, mirrored intercompany balances, and built an elimination schedule (fees and intercompany interest). After CPA review, the consolidated TB matched entity books less eliminations and we locked the year—lender package approved.

Preventing Future Multi-Entity Drift

  • tick SOP: designate the booker of intercompany entries and monthly cutoff date.
  • tick Monthly IC roll-forward: confirm pairs mirror before close.
  • tick Use consistent document titles (e.g., “IC-MgmtFee A→B”).
  • tick Close calendar includes Consolidation Day with CPA check.

Ready to Clean Up Multi-Entity QuickBooks and Consolidate Correctly?

We’ll fix intercompany, reconcile every entity, and deliver a CPA-reviewed consolidated TB with eliminations.

Get My Cleanup Quote

Frequently Asked Questions

QBO keeps entities separate. Prepare consolidation in a worksheet/BI tool fed by each entity’s TB and documented eliminations.

Rebuild the detail (bills/invoices/loans), then post true-up JEs so each pair mirrors. Document with memos and links to support.

No-post eliminations in the consolidation worksheet. Entity ledgers should reflect legal books; eliminations are reporting-only.

Re-measure monetary items at period-end first; then eliminate intercompany balances using the period’s rates. Keep an FX workpaper.

Yes. After cleanup, we provide CPA-reviewed entity reports, the consolidated TB, elimination schedules, and a variance note-ready for lenders or investors.

View all answers in our full QuickBooks Cleanup FAQ →

Ready to fix the past and close this month?

Get a CPA-reviewed QuickBooks cleanup with a firm timeline.

Get My Cleanup Quote

Explore