Fix Beginning Balance in QuickBooks Desktop Reconciliation

When the beginning balance on a QuickBooks Desktop reconciliation stops matching the ending balance of the last one, a transaction you already reconciled has been changed, deleted or unreconciled. Desktop will not let you type a correct figure over it. You find the transaction that moved, put it back the way the statement says, and the beginning balance corrects itself. Three built-in reports find it, usually in under ten minutes.

Last updated August 2026.

Why the beginning balance changed on its own

It did not change on its own. QuickBooks calculates the beginning balance by adding up every transaction currently marked as reconciled in that account. It is a running total, not a stored number, so anything that alters a reconciled transaction alters the total. The reconciliation you completed in March was correct when you finished it; something touched one of its transactions afterward.

Four actions do it, and only one of them looks like editing:

• The amount or date was edited. A correction made months later to a transaction that had already been reconciled.
• The transaction was deleted. Very common during a duplicate cleanup, when whoever was tidying could not see that the entries were reconciled.
• It was moved to a different account. The register it left no longer counts it.
• The reconciled status was cleared. Clicking the checkmark column in the register changes an R to blank with no warning and no confirmation.

That last one accounts for more of these than people expect, because nothing on screen announces it. Someone scrolling a register with a trackpad clears a checkmark, and the account stops balancing from that month forward.

Run the Reconciliation Discrepancy report first

This is the report built for exactly this problem, and it should always be your first move. Go to Reports, then Banking, then Reconciliation Discrepancy. Choose the account from the Account dropdown and select OK. QuickBooks lists every reconciled transaction in that account that has been changed since the last reconciliation, showing the original amount, the current amount and the date of the change.

Read it as a list of suspects rather than a list of errors. Some entries on it will be legitimate corrections that someone made for good reason. Compare the total difference QuickBooks reports against the amounts on the report: one line, or two lines that sum to it, is almost always the answer. When a single line matches your difference exactly, you are done looking.

Check the Previous Reconciliation report

Go to Reports, then Banking, then Previous Reconciliation. This shows the account as it stood the last time it balanced, which gives you a clean reference point to compare against. Pick the last reconciliation that was correct and select the detail version so you can see the individual transactions rather than just the summary totals.

The value here is a known-good snapshot. If the Reconciliation Discrepancy report came back empty but the beginning balance is still wrong, comparing this report line by line against the current register will show you what is present now that was not present then, or the reverse. It is slower than the discrepancy report, which is why it is second, but it catches things the first report cannot see.

Use the Audit Trail when several people work in the file

Run Reports, then Accountant and Taxes, then Audit Trail. Set the Account filter to the account you are reconciling. Leave the transaction date From field blank and set the To date to your statement date, then set the Entered or Modified filter to run from the date the last reconciliation was created through to today.

Those filters are the whole trick. Without them the Audit Trail is thousands of rows of noise; with them it is a short list of exactly who changed what in that account since the account last balanced. In a multi-user file this is usually faster than either of the other two reports, because it tells you who to go ask rather than leaving you to guess at intent.

Fixing what you find

Correct the transaction back to what the bank statement says. If it was edited, restore the original amount and date. If it was deleted, re-enter it with its original details and mark it reconciled in the register by clicking the checkmark column until an R appears. If it was moved, move it back. If the reconciled status was cleared, set it back to R.

Do this in the register rather than through the reconcile window, and change one thing at a time. Reconciliations are cumulative, so a second uncontrolled edit made while chasing the first one leaves you with two differences and no way to tell which change caused which. After each correction, reopen the reconcile screen and look at the beginning balance again.

Where a whole period has gone wrong rather than a single transaction, Desktop lets you step backward. Go to Banking, then Reconcile, then Undo Last Reconciliation, select Continue and then OK. That returns the account to its state before that reconciliation so you can redo it once the underlying transactions are right. Undo one period at a time and stop as soon as the beginning balance matches. The broader version of this decision is covered in the guide to undoing a reconciliation in QuickBooks.

The forced adjustment that keeps coming back

If the beginning balance has been wrong by the same odd amount every month for a year, look for an old forced adjustment before you look for anything else. When someone finishes a reconciliation with a difference still on screen, QuickBooks posts a balancing journal entry to an expense account named Reconciliation Discrepancies. The screen clears, and the entry stays in the books forever.

Open that account's register and read the entries. Each one is a period where a real difference was papered over rather than investigated, and each one sits inside every beginning balance calculated afterward. If the original cause was missing transactions, the adjustment is also hiding real income or real expenses from the profit and loss, and from whatever tax return was built on it. Deleting the adjustment reopens the original difference, which is uncomfortable but is the only honest starting point.

When the transactions were never there at all

Sometimes the discrepancy report is empty, the Audit Trail is quiet, and the beginning balance is still wrong. In that case nothing changed; the transactions the statement is built from were never entered. This is the normal outcome when an account was set up partway through the year, or when someone stopped entering transactions for a few months and picked up again later.

Desktop cannot read a PDF statement at all, so the fix is to convert those statements into a .qbo (Web Connect) file and import them through File, then Utilities, then Import, then Web Connect Files. Manual imports carry no 90 day limit, which is why this route works for a prior year when a bank feed cannot reach back that far. Work oldest month first and reconcile each one before starting the next, so a difference is caught against a single month instead of against a year. You can convert a bank statement to QuickBooks in a few minutes, and the whole rebuild sequence is set out in the guide to importing old bank statements into QuickBooks.

Firms that run this same check across dozens of client files every month generally stop doing the matching by hand and move it into dedicated account reconciliation software, keeping QuickBooks as the ledger of record rather than the place the investigation happens.

Preventing the next one

Two habits remove most repeat occurrences. Close the books through the last reconciled date, under Edit, then Preferences, then Accounting, then Company Preferences, and set a closing date password. Anyone trying to change a transaction before that date then has to enter the password, which turns a silent edit into a deliberate decision.

The second is to reconcile every account every month, even quiet ones. A savings account touched twice a year still drifts, and a discrepancy found against one month of activity takes minutes to trace. The same discrepancy found eleven months later means reading a year of register entries to locate it.

Frequently asked questions

Can I edit the beginning balance in QuickBooks Desktop?

No. The beginning balance is calculated from the transactions currently marked as reconciled in that account, so there is no field to overwrite. You change it by correcting the underlying transactions. On a first reconciliation, edit the account's opening balance entry instead.

What report shows what changed since my last reconciliation?

The Reconciliation Discrepancy report, at Reports, then Banking, then Reconciliation Discrepancy. Select the account and QuickBooks lists every reconciled transaction that has been edited, deleted or unreconciled since the last time the account balanced, with the original and current amounts.

Why is my beginning balance off by the same amount every month?

Almost always an old forced adjustment. When a reconciliation is completed with a difference still showing, QuickBooks posts a balancing entry to an account called Reconciliation Discrepancies. That entry is included in every beginning balance calculated afterward, so the same figure repeats indefinitely.

Does undoing a reconciliation delete my transactions?

No. Undo Last Reconciliation only clears the reconciled status on those transactions and reverses the reconciliation itself. The transactions stay in the register with their dates and amounts intact, so you can correct what is wrong and reconcile the period again.

How do I fix a beginning balance on a first reconciliation?

There is nothing to compare against yet, so the problem is the opening balance rather than a changed transaction. Set it to the closing balance from the statement that ends the day before your start date. The full process for both Desktop and Online is in the guide to changing the beginning balance in QuickBooks Online.

Can QuickBooks Desktop import a PDF bank statement to fill the gaps?

No. QuickBooks Desktop has no PDF path at all and reads .qbo Web Connect files for bank imports. Convert the PDF statement to .qbo first, then import it through File, then Utilities, then Import, then Web Connect Files. Only QuickBooks Online reads PDF statements directly, and only in English under 350 KB.

Related guides

More on this workflow: reconcile bank statements in QuickBooks, fix a reconciliation discrepancy, the QuickBooks bank reconciliation report, and converting a bank statement for QuickBooks Desktop.