Quick answer

QuickBooks Online reconciliation problems usually start with one number that does not match: the beginning balance, the statement ending balance, or a transaction changed after it was reconciled. Open the Reconcile Discrepancy Report, correct the transaction at fault, and reconcile again. Do not force the balance with an adjusting entry until you have reviewed every discrepancy.

What each QuickBooks Online reconciliation problem means

QuickBooks Online compares your register to a bank or credit card statement. When the two disagree, the wording on screen tells you which part of the chain broke. Match the message to the right problem before you edit anything.

What you seeWhat it meansStart with
"Your account isn't ready to reconcile yet. Your beginning balance is off by..."A transaction from a past reconciliation was changed, deleted, voided, moved, or unreconciled, so the previous ending balance changed.Steps 2 and 3
The ending balance difference will not reach $0.00The ending balance, date, or transactions in the period do not match the statement.Step 5
Previously reconciled transactions show as unclearedSomeone unreconciled them, or a reconciliation was undone.Steps 2 and 6
A transaction cannot be edited, or a password is requestedThe books are closed on or after that transaction date.Step 8

Symptoms that point to a reconciliation problem

  • The reconciliation screen blocks you before it starts with a beginning balance alert.
  • A transaction you reconciled last month shows a blank or C in the checkmark column instead of an R.
  • The reconciliation report no longer matches the bank statement even though the period was completed.

Common causes, ranked by how often they occur

  1. An incorrect opening balance. If the opening balance never matched the bank when tracking started, every later reconciliation is off by the same amount.
  2. A reconciled transaction was edited, deleted, voided, moved, or unreconciled. That changes the last ending balance and the next beginning balance.
  3. A bank feed transaction was undone and sent back to pending. Un-categorizing a downloaded transaction breaks the chain.
  4. A transaction was reconciled manually outside a reconciliation. Marking an entry as R in the register adds it to the beginning balance without appearing on a reconciliation report.
  5. An old transaction was added late. Entries dated before the last reconciliation's end date unsettle an already-balanced period.
  6. Duplicate or missing transactions. A charge imported twice, or a bank fee never entered, leaves the ending difference non-zero.
  7. The wrong ending balance or date was entered. One typo at the start produces an unreachable difference.

What "locked reconciliation" really means. QuickBooks Online does not lock one reconciliation. A "locked" reconciliation is usually a closed period (a lock date under Account and settings → Advanced) or a user whose role does not allow undo. See steps 6 through 8.

Before you correct a reconciliation

  • Collect the bank or credit card statements for the period, including the page showing that day's opening balance.
  • You need admin rights to edit reconciliations. Undoing a full reconciliation is limited to the primary admin or an accountant with the right access — see QuickBooks Online user roles and permissions.
  • Write down the exact amount the beginning balance is off by. Every change you find should add up to that number.
  • Clear uncategorized bank feed items first; transactions left in For review cannot be reconciled. See bank feed problems in QuickBooks Online.

Protect your records first. Undoing a reconciliation is irreversible and permanently deletes that period's reconciliation reports and attachments. Download the reports and attachments before you start, and export a fallback copy using QuickBooks Online data backup options.

How to fix QuickBooks Online reconciliation problems

1

Isolate the exact discrepancy

Go to All apps → Accounting → Reconcile and select the account. If the beginning balance is off, note the amount in the alert. If you are already inside the reconciliation, read the difference box. A specific figure like 12.47 gives you a search target; a large number usually means a wrong ending balance or a missing transaction.

2

Work through the Reconcile Discrepancy Report

Select the We can help you fix it link in the alert to open the report, which lists each changed transaction and what happened. Correct the items one at a time:

  • Amount changed or moved: open the transaction, restore the amount or account to match the statement, then save.
  • Unreconciled in register: click the checkmark until it shows R again, or reconcile the account again using the same ending date and balance as the last reconciliation. Only the second method records the correction on a reconciliation report.
  • Reconciled in error: click the checkmark until it is blank or shows C, then save, so it can be cleared in the correct period.
  • Deleted: recreate the transaction exactly as the report shows, then mark it R in the register.

Keep going until the Total discrepancy difference reads $0.00.

3

Search the audit log for deleted or voided transactions

Deleted and voided transactions often do not appear in the discrepancy report. Go to Settings → Audit log, filter by the account and the period since your last completed reconciliation, and look for delete or void events. Press Ctrl + F and search for "deleted".

The audit log keeps details for two years, so use it to recreate the entry with the same date, amount, and account. Audit log basics are covered in the QuickBooks report troubleshooting guide.

4

Find manually reconciled transactions outside the cycle

Go to Settings → Chart of accounts, select View register for the account, and filter by reconcile status. Look for entries marked R with a date after your last completed reconciliation. Those were reconciled by hand and sit in the beginning balance without a report. If one does not belong in the period you are fixing, unreconcile it using step 6.

5

Fix an out-of-balance ending difference

When the beginning balance is correct but the difference will not clear: confirm the ending balance and date using Edit info; categorize every downloaded feed transaction for the period; combine split deposits through Undeposited Funds so one bank deposit matches the statement; enter missing fees and interest; review entries not on the statement and remove only obvious duplicates; then compare anything that is close but slightly off, such as a payment with a wrong date or amount.

6

Unreconcile a single transaction correctly

Open Chart of accounts → View register, find the transaction, and click the checkmark until it cycles from R to C to blank. Save, then reconcile the account again. This changes the beginning balance for the next reconciliation, so only remove a transaction when you are certain it caused the discrepancy. Unreconciling one entry does not undo the whole period.

Undoing a full reconciliation is a last resort. It cannot be reversed, it deletes the reconciliation report and attachments, and undoing one period also undoes every later reconciliation on that account. Download the reports first and get your accountant's sign-off before you continue.

7

Undo the whole reconciliation only if nothing else works

Sign in as the primary admin. Go to All apps → Accounting → Reconcile, then History by account. Find the reconciliation, open the Action dropdown, and select Undo. Read the warning, tick the confirmation box, select Undo reconciliation, then Done. The period is now unreconciled and you redo the statement. If the books are closed on that date, finish step 8 first.

8

Remove the lock when a closed period blocks the fix

If QuickBooks asks for a password or warns that the transaction cannot be changed, open Settings → Account and settings → Advanced. In the Accounting section, select Edit next to Close the books. Move the closing date back before the period you are fixing, or turn the setting off, then save. When the correction is done and the period is reviewed, set the closing date again.

9

Reconcile the account again and finish cleanly

Go back to Reconcile, select the account, and enter the statement ending balance and date. Check off the transactions that appear on the statement. When the difference shows $0.00, select Finish now, then Done. Save the reconciliation report as the clean record for the corrected period.

When to undo, unreconcile, or adjust

SituationRight correctionWhy
One transaction was cleared by mistakeUnreconcile that transaction in the registerOnly that entry changes.
A reconciled transaction was edited or moved in errorRestore the transaction to match the statementRepairs the balance without touching the reconciliation.
The whole statement is wrong because of many errorsUndo the reconciliation, then redo itClean start, but irreversible and deletes reports.
A small unexplained difference remains after reviewAdjusting entry, ideally with your accountantForces a balance, so it must be small and confirmed as an error.

Adjusting entries are not a repair tool. QuickBooks only offers the adjusting entry after you review the reconciliation. If the difference is large, recurring, or unexplained, stop and involve your accountant instead of forcing the account to balance.

Verify the fix

  1. Open the saved reconciliation report and compare the ending balance to the bank statement.
  2. Confirm the next period's beginning balance matches the ending balance of the completed one.
  3. Reopen Reconcile and check that the beginning balance alert is gone.
  4. Open Settings → Audit log and confirm your corrections were recorded under your user name.

If the reconciliation still will not balance

Stop editing and get a second set of eyes before making more changes. Common reasons a reconciliation stays broken are a bank statement error, a missing prior-period reconciliation, or damage from a Desktop-to-Online conversion. Ask the bank for a corrected statement, and have your accountant review the opening balance before you adjust anything.

If you cannot open reconciliation history or the account is read-only, that is an access problem, not a bookkeeping one. Document each change and avoid repeated undo attempts.

Prevention

  • Reconcile every account monthly. Small monthly checks beat a year-end rebuild.
  • Do not change a reconciled transaction without correcting the reconciliation that covers it.
  • Categorize bank feed items before you reconcile, and never leave transactions in For review at month end.
  • Enter old or missing transactions before you complete a period, not after.
  • Set a closing date after each reviewed period so accidental changes need a password, and keep an accountant on the account for undoing reconciliations and adjusting entries.

Frequently asked questions

Can I undo a reconciliation in QuickBooks Online?

Yes, with limits. You can unreconcile individual transactions from the register. Undoing an entire reconciliation is limited to the primary admin or an accountant with the right access, is irreversible, and deletes the associated reports and attachments.

Why is my beginning balance off when I reconcile?

A reconciled transaction from an earlier period was edited, deleted, voided, moved, unreconciled, or manually reconciled. That changed the previous ending balance, which became this period's beginning balance. The Reconcile Discrepancy Report lists most of these changes and how to fix each one.

How do I find a deleted transaction that was reconciled?

Open Settings → Audit log, filter by account and date, and look for delete events. Deleted transactions cannot be restored, so use the details to recreate the entry, then mark it R in the register to put it back into the reconciled balance.

Should I use an adjusting entry to make the reconciliation balance?

Only as a last resort for a small, confirmed error after reviewing every transaction. An adjusting entry forces the account to balance and can hide a real mistake. For anything larger than a minor fee, ask your accountant first.

Sources & further reading