Fixing a QuickBooks Reconciliation Beginning Balance That No Longer Matches

When a QuickBooks reconciliation beginning balance stops matching last month's ending balance, trace the change and repair only the months affected.

You open Begin Reconciliation and the starting figure is not the figure you finished with last month. QuickBooks Desktop did not miscount. A transaction that was already cleared changed after the fact, and the software recomputed every month since. The fix is narrow: find the changed item, restore it, and re-reconcile only the statement periods it touched.

What does a changed beginning balance mean?

The beginning balance is the sum of every transaction in the account carrying a cleared status of R. It moves only when a cleared transaction is edited, deleted, or added after the statement closed. Our engineers most often find a reconciled check deleted during a cleanup, an amount changed on a cleared entry, or a transaction re-dated across a statement boundary. Restoring an old backup over the live file produces the same symptom.

Each change quietly restates every later month. The mismatch in dollars is usually the net of the changes, which is a useful check that you have found them all.

Before you start

Make three preparations, in this order.

  1. Save the previous reconciliation detail. Under Reports, go to Banking, then Previous Reconciliation, select the account and the last statement period, and print it to PDF. This report is your only reliable source for re-entering a deleted transaction exactly as it stood.
  2. Back up the company file. Use File, then Back Up Company, then Create Local Backup. Keep the backup until the account agrees again.
  3. Switch to single-user mode from the File menu so nobody edits the account while you work. Write down the dollar difference between the two balances before changing anything.

Find the change with the Reconciliation Discrepancy report

  1. Open the Begin Reconciliation window from the Banking menu, select the account, and click Locate Discrepancies. The same report sits under Reports, Banking, Reconciliation Discrepancy.
  2. Set the date range wide: from the first month you suspect trouble, or a year back, through today.
  3. Read the results by statement period. The report lists cleared transactions that were later changed, with the user name and the date of each change.
  4. Add up the listed changes. If the net equals your balance difference, the list is complete. If it does not, widen the dates, or open the Audit Trail under Reports, Accountant & Taxes, and filter it to the account.

One limit is worth knowing. The report reads the audit trail, and older releases let you switch the trail off. Changes made while it was off will not appear.

Repair the transaction, not the whole account

Work one listed item at a time.

For an edited transaction, open it, restore the original amount, date, or account, and save. Then check the Clr column in the account register. If the edit knocked the status off R, set it back to R.

For a deleted transaction, re-enter it from the PDF you saved, matching amount, date, payee, and account exactly. Open the register from the chart of accounts, find the new entry, and type R in the Clr column. Marking it R restores the balance arithmetic without dragging the item into the current statement's uncleared list.

If the edit was legitimate, meaning the original entry was genuinely wrong, do not restore it. Accept the restated beginning balance and re-reconcile from the affected month forward instead. Only the statement periods named in the report need that work. Undo Last Reconciliation, in the Begin Reconciliation window, steps back one statement at a time, so reserve it for months whose math must genuinely be redone.

Signs the repair worked

  • The Begin Reconciliation window shows a starting balance equal to last month's ending balance, to the penny.
  • Entries you marked R do not appear among the current month's uncleared items.
  • The Difference field reaches 0.00 when you finish the current statement.
  • A rerun of the discrepancy report lists only your own repairs, once each, under your user name.
  • If you re-entered a transaction, reprint that older statement period's detail so your filed copies match the file.

If the workaround is not enough

Sometimes the report comes back empty while the balance is still wrong. The audit trail may have been off, the change may predate your range, or the file may be damaged. Run Verify Data under File, Utilities. Where Verify reports damage, or where dozens of changed items span many months, manual repair stops being dependable. Damaged reconciliation records call for QuickBooks Desktop file repair for damaged transactions rather than more report work.

Keeping reconciled periods closed

Most mismatches we see begin with good intentions: a cleanup, a duplicate removed, a small correction. Reconcile every month, keep the PDF of each finished statement, and use user permissions to keep delete rights away from daily entry work. Our engineers have written separately about the month-end close and reconciliation practice. Treat a reconciled month as closed, and this problem rarely returns.

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.