Rebuilding Bank Reconciliations After a QuickBooks Repair or Condense

A repair or condense can flip cleared transactions back to uncleared; our engineers rebuild every affected period so the audit trail stays defensible.

A file repair or a condense can leave the books looking whole and still undo one quiet piece of state: the cleared flag on bank transactions. Every cheque and deposit sits in the register, but QuickBooks now believes none of them cleared. The balance sheet agrees with itself and not with your statements, and the next reconciliation opens against a beginning balance that matches nothing.

Our engineers rebuild reconciliations after every major repair and condense. The work is methodical rather than clever, and the order matters: snapshot first, diagnose second, then re-reconcile the damaged periods oldest first against the saved statements.

Snapshot the file before you start

Take a full backup and keep it outside the working folder. Note the last statement date that reconciled cleanly, and save the most recent reconciliation report if Reports > Banking > Previous Reconciliation still opens it. Confirm the Audit Trail preference is turned on under Edit > Preferences > Accounting, because the discrepancy report is far more useful with users and timestamps attached. Run a Verify too; a file that still fails Verify needs professional QuickBooks file repair before reconciliation work starts.

That backup is your first rollback point.

Which transactions lost their cleared flag?

Two reports carry the diagnosis. The Reconciliation Discrepancy Report, under Reports > Banking, lists transactions added, deleted, or edited since the last reconciliation, together with the statement date each change touches. The Locate Discrepancies button in the Reconcile window opens the same report.

Then run a Custom Transaction Detail report on the bank account, filtered to Cleared = No, dated from the last clean statement to today. Compare it line by line against the statement. The total of the flipped lines should equal the gap between the Reconcile window's beginning balance and the statement's ending balance, which is a tidy arithmetic check that nothing else is wrong.

Reading the Reconciliation Discrepancy Report

Group the report by statement date and it tells you which periods have to be redone. A deleted line means the transaction itself is gone. An edited line usually means the transaction survived but its amount, date, or payee changed. An added line is often the repair's own work, such as a rebuilt split, and may be correct apart from its flag.

Do not re-enter anything yet. Check the register first, because the usual finding in a post-repair file is that the entry exists and only its flag was reset. Re-entering a transaction that is already there doubles it, and the duplicate will surface in every later period.

Rebuild one period at a time, oldest first

Each period's beginning balance is the previous period's ending balance, so start at the earliest damaged month and move forward. Open Banking > Reconcile, enter the statement date and ending balance exactly as printed, and tick only the items the statement shows as cleared. Service charges and interest go in only if the statement shows them and they are not already recorded.

The Difference field must read 0.00 before you click Reconcile Now. If it will not close, stop. Never force a match by editing an old transaction's amount or date, and never plug the gap with a journal entry; both moves write fresh lines onto the discrepancy report and push the problem into the next month.

If the Accountant Edition is available, Undo Last Reconciliation under the Banking menu resets a half-finished period so it can be re-ticked from a clean sheet.

Save each reconciliation report as a PDF the moment it completes. QuickBooks keeps only the newest report on screen, and the saved PDF is what makes the rebuilt period defensible.

Carry the ending balance forward

When you open the next period, the beginning balance in the Reconcile window must equal the prior statement's ending balance. If it does not, stop and diagnose before ticking anything; rerun the Cleared = No filter across the gap dates.

If the damage followed a condense of an oversized company file, there is one extra wrinkle. Pre-cutoff detail is typically summarized into a journal entry, and that entry sits uncleared in the register. Reconcile it against the last pre-cutoff statement's ending balance so it is marked cleared and the first live period opens at the right figure.

Where are the rollback points?

Hold the backup from before the first period, plus one taken after each successful month. If a period refuses to balance and the cause is not obvious, restore the most recent good backup, confirm the previous period's report still matches its statement, and start the stubborn period again. A restore is an inconvenience. A forced reconciliation is a defect in the audit trail.

What does a clean outcome look like?

Every affected period reconciles to a zero difference, and each has a saved report filed with its statement. The current period's beginning balance equals the latest statement's ending balance. The Reconciliation Discrepancy Report stops producing lines for the rebuilt dates. The register's running balance agrees with the bank's own figure.

Add a short note of who rebuilt each period and when. Statements plus matching reconciliation reports, produced in order with no edited transactions underneath, are exactly what an auditor or a tax authority wants to see, and a rebuilt reconciliation holds up as long as the paper trail is complete.

Keep going

Your Desktop doesn’t have to end when Intuit says so.

Start with the master survival guide, or jump straight to the fix you need.