QuickBooks Desktop Beginning Balance Changed: Find the Edited Cleared Transactions

QuickBooks Desktop warns that your beginning balance changed; our engineers show how to trace the warning to the exact transactions behind it.

QuickBooks Desktop derives a reconciliation's beginning balance from every transaction ever cleared on that account. Change one after the fact and the next reconciliation opens with a warning. The message quotes the amount of the drift but never names the transaction. Our engineers chase that number to its source with two built-in reports, then decide whether to correct history or reconcile past it.

The warning traces back to cleared history

Each completed reconciliation stores its ending balance inside the file. When you start the next one, the program totals every cleared transaction dated on or before the last statement and compares the sum with the stored figure. A mismatch produces the warning. Three edits cause nearly every case. Someone changed the amount or account of a cleared transaction, deleted a cleared transaction, or removed a cleared checkmark by hand in the register. The reconcile window itself never triggers it; something outside that window touched history.

Prepare the file before you hunt

  1. Make a full backup first: open the File menu, choose Back Up Company, then Create Local Backup, and keep it untouched until you finish.
  2. Switch to single user mode from the File menu. Register entries must not change while you compare reports.
  3. Pull the last bank or card statement and note its ending balance and date.
  4. Write down the drift amount the warning quotes. The report you run next should total exactly that figure, which confirms you found everything.

Which report finds the offending transactions?

  1. Open the Banking menu, choose Reconcile, and select the account. Do not fill in the statement details yet. Click Locate Discrepancies.
  2. Click Discrepancy Report. QuickBooks lists cleared transactions changed after their reconciliation, grouped under the statement they belong to, each with the net amount of its change. The Reports menu carries the same report under Banking, Reconciliation Discrepancy.
  3. Click Previous Reports and open both the summary and the detail for the most recent reconciliation. The detail is your evidence; compare it against the statement itself before changing anything.

How do you correct each kind of change?

The report tells you which of three fixes applies.

  • Deleted transaction: re-enter it exactly as the statement shows it, with the original date, payee, amount, and account. Open the account register, type a c in the checkmark column on that line, and save. The recalculated beginning balance snaps back to the stored figure immediately.
  • Removed checkmark: open the register and retype the c on the affected line. Nothing else in the entry changes.
  • Edited amount: check the statement. If the new figure is wrong, restore the original amount and the entry drops off the discrepancy report. If the new figure is right, leave the transaction alone and read on.

Sometimes it is safer to reconcile through the difference

An edit can be correct even when it breaks the beginning balance. A corrected amount, a late bank fee, or a reclassified transfer can all be legitimate after the fact. The Locate Discrepancies window offers Undo Last Reconciliation, and each undo un-clears a full month of entries. One undo, for a change inside the most recent statement, is cheap. Five, reaching back through half a year, multiply both the work and the risk.

When the change is older or the edit was right, start the reconciliation anyway and accept the drifted beginning balance. Absorb the difference with one adjusting entry dated inside the current period, clear it against the statement, and explain the drift in the memo. A small, documented, one-off difference is cleaner than a rebuilt history. That call is bookkeeping judgment as much as software repair, and our notes on reconciliation practice and the month-end close walk through the trade-offs.

What if the discrepancy report comes back empty?

The report reads from the audit trail. A condense, an audit trail removal, or a rebuild after damage can strip the history it depends on. The warning still fires because the stored balances still disagree, but the report has nothing to list. Open the File menu, choose Utilities, then Verify Data. If Verify finds problems, or if cleared checkmarks flip on their own, the fault sits in the data rather than the bookkeeping. That is deeper than any reconciliation workaround reaches. Damaged cleared flags and broken transaction links need repair at the file level, the kind of work handled by specialist QuickBooks Desktop file repair.

Signs the repair worked

  • The Begin Reconciliation window opens with no warning, and the beginning balance matches the statement's opening balance.
  • The Reconciliation Discrepancy report comes back empty.
  • After you tick the current statement's items, the difference field reads 0.00.
  • The following month's reconciliation opens clean, with no drift message.

Keep the backup until the next clean reconciliation, then retire it.

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.