Reconciling Opening Balances to Your Auditor's Trial Balance After a SuperCondense Split

Opening balances in a condensed QuickBooks file can drift from your auditor's trial balance; learn which reports to compare and how to correct mapping gaps.

After a SuperCondense split reduces your QuickBooks Desktop file to a manageable size, the new working file contains transactions only from the split date forward. Everything before that date collapses into opening balances on each account. Before you resume daily bookkeeping, verify that those opening balances match your auditor's or CPA's trial balance exactly. Even a clean condense can produce small mapping discrepancies that require manual adjusting journal entries.

What Breaks or Is at Risk

The condense process summarizes historical transactions into journal entries dated at or near the split date. In a perfectly mapped file, the sum of those summarized entries equals the ending balances on the auditor's trial balance for the period immediately before the split. In practice, several things can cause drift:

• Parent/sub-account rollups. If the auditor's chart of accounts groups accounts differently than the live QuickBooks file, balances may land in a parent account that the auditor expects at the sub-account level, or vice versa.
• Class and department tracking. Condensed entries sometimes strip class detail, collapsing multiple class-specific balances into a single unclassified amount.
• Multi-currency accounts. Exchange-rate differences between the historical transaction dates and the split date can shift balances on AR, AP, and bank accounts.
• Retained earnings. The condense posts net income from prior years to Retained Earnings, but the timing of that posting may not align with the auditor's closing entries.
• Inventory asset accounts. Average-cost or FIFO layers that were condensed can produce a balance that differs from the auditor's inventory valuation.

Reports to Compare

Open the condensed file and generate the following reports as of the split date:

1. Trial Balance (Reports > Accountant & Taxes > Trial Balance). Set the date to the split date. This is the primary reconciliation document.
2. Balance Sheet Standard (Reports > Company & Financial > Balance Sheet Standard). Use the split date as the ending date. Confirm total assets equal total liabilities plus equity.
3. General Ledger (Reports > Accountant & Taxes > General Ledger). Set the date range to the split date only. This shows the individual journal entries the condense created.
4. Audit Trail if available in your edition, filtered to the split date, to see every posting the condense generated.

From the auditor's side, obtain the trial balance for the fiscal year-end or period-end immediately preceding the split date. This is the baseline every account must tie to.

Identifying Mapping Discrepancies

Export both trial balances to Excel or print them side by side. Work through the following comparison method:

• Match accounts by account number first, then by name. Note any account that exists in one trial balance but not the other.
• For each account, subtract the auditor's balance from the QuickBooks opening balance. Any non-zero difference is a discrepancy.
• Categorize each discrepancy by type: rollup difference (the balance exists but in the wrong account), missing balance (the account was skipped during condense), or valuation difference (the balance is present and in the right account but the dollar amount differs).

Common patterns our engineers see: bank account balances that match but have offsetting discrepancies in undeposited funds; accounts receivable totals that match at the summary level but differ when broken out by customer; and equity accounts where the condense posted a single retained-earnings figure that does not reconcile to the auditor's rolled-forward balances.

Creating Manual Adjusting Journal Entries

For each discrepancy, post a manual adjusting journal entry dated the split date. Use the following guidelines:

• Debit or credit the affected account to bring the QuickBooks balance in line with the auditor's balance.
• Offset the adjustment to Retained Earnings or to a dedicated clearing account if your auditor prefers a visible adjustment account.
• Add a memo such as "SuperCondense opening-balance adjustment" and reference the account or class involved.
• If class tracking is enabled, assign the correct class on each line of the adjusting entry.

After posting all adjustments, regenerate the Trial Balance and Balance Sheet as of the split date and confirm every account now ties to the auditor's figures. Lock the prior period by setting the QuickBooks closing date so no one inadvertently edits the reconciled opening balances.

Final Verification

Run a Verify Data check on the adjusted file to confirm structural integrity. If Verify surfaces errors after the adjustments, the file may need repair before you resume live work. Once Verify passes and the trial balance ties out, the condensed file is ready for ongoing use.