Reconcile a Bank Account After a QuickBooks Condense Breaks the Beginning Balance
After a QuickBooks condense, a bank account's beginning balance can drop or show as changed. Here is how to get the account reconciled again.
A condense is the usual route for condensing an oversized QuickBooks company file: it removes closed transactions from before a cutoff date and folds them into summary entries. On bank and credit card accounts it has a side effect. Everything before the cutoff loses its reconciled flag, and the beginning balance in the Reconcile window drops, sometimes to zero. The register balance itself is normally still right. Here we explain what the condense actually wrote and how to restore the reconciled state in a single pass.
The entry a condense writes at the cutoff
When QuickBooks condenses a file, it deletes closed transactions dated before the cutoff and replaces them with summary journal entries dated at the cutoff. Each account gets one line carrying the net effect of everything removed. On a bank account, that line holds the combined total of every old check, deposit, payment, and transfer. The individual transactions no longer exist in the register.
In the register the bank line usually shows the word CONDENSE in its memo. It is written without the reconciled flag. QuickBooks derives an account's beginning balance from its cleared transactions, so activity that now sits in an uncleared entry stops counting. The beginning balance falls by that amount, and the Reconcile window reports a discrepancy before you have touched anything.
The beginning balance you can ignore
The beginning balance is not a stored number you can retype. It is a computed figure, rebuilt from every transaction marked cleared. Because the cleared items were deleted and summarized, the old figure cannot be recovered by editing anything in the window.
That is why the repair anchors on the statement instead. Your last pre-cutoff statement has a known ending balance, and the summary entry contains exactly the activity that produced it. Match those two to each other once, and QuickBooks rebuilds the beginning balance correctly from that point forward. The old number never needs to be restored; it is replaced by arithmetic.
Before you reconcile
Make a full backup first. From the File menu choose Back Up, then Create Backup, and store it locally. A mass reconcile touches many records at once, and you want an exit if anything looks wrong.
Switch to single-user mode from the File menu. Reconciliation locks the account, so other users cannot save into it during the pass anyway.
Gather the last statement you reconciled before the cutoff. You need its statement date and its ending balance. If you kept the list of items outstanding at that date, have it nearby as a cross-check.
Open the account register and confirm the running balance still agrees with the bank as of the statement date. If the balance itself is wrong, the reconciled flag is not the problem. Stop here and read the final section.
The one-time reconciliation
- From the Banking menu, choose Reconcile. Some editions place it on the Accountant menu. Select the affected bank account.
- Set the statement date to the date of the last statement reconciled before the cutoff.
- QuickBooks may warn that the beginning balance changed by a specific amount. Note the amount, then continue. It should match the bank line of the CONDENSE entry, which confirms the diagnosis.
- Enter the statement's ending balance exactly as printed. Leave the service charge and interest fields empty, because those items are already inside the summarized totals.
- Choose Continue. In the checks and payments list, and in the deposits and credits list, check every item that had cleared through that statement. In a condensed file this is usually the single CONDENSE entry, plus any pre-cutoff transactions that survived because they were still open. Check a survivor only if the statement shows it as cleared; genuinely outstanding items stay unchecked.
- Watch the Difference figure. When it reads 0.00, choose Reconcile Now.
- Repeat the pass for each bank and credit card account that had been reconciled before the cutoff.
Signs the account is fixed
The difference read 0.00 at the moment you finished. The register now shows an R beside the CONDENSE entry. Open a fresh reconciliation: the beginning balance equals the ending balance you entered, and no discrepancy alert appears. Run Reports, then Banking, then Reconciliation Discrepancies, and the account should return nothing. The following month reconciles against the statement alone.
If the difference will not reach zero
A residual difference means the condense did more than drop the reconciled flag. Payments sometimes unapply from old invoices because the condense broke transaction links. Items can lose their opening quantities. Post-cutoff entries are sometimes edited back before the cutoff. None of that clears up by checking more boxes.
Decline the adjustment entry QuickBooks offers. It would force the difference to zero and hide the fault underneath. Close the window without reconciling, keep the backup safe, and have the data repaired rather than adjusted. Broken links, unapplied payments, and lost item quantities are all repairable from a copy of the current file; our QuickBooks Desktop file repair service covers that work. Re-run the reconciliation afterward and it should zero out cleanly.