Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group | Last updated: October 27, 2026

Key Takeaways

• Match the exact QuickBooks reconciliation symptom, such as an off balance, shifted beginning balance, or deleted transaction, to the specific fix instead of following generic steps.
• Beginning-balance errors usually trace back to a prior-period transaction that was edited, deleted, or unreconciled after the reconciliation closed, so use the Reconcile Discrepancy Report and Audit Log to locate and correct the source.
• QuickBooks Online allows a full-period undo from the Reconciliation History screen, while QuickBooks Desktop only supports undoing the most recent reconciliation session one period at a time.
• Deleted or edited reconciled transactions can be recovered through the Audit Log or Audit Trail, then re-entered with original details and manually marked reconciled before you re-run the affected period.
• Condesa Financial provides expert QuickBooks reconciliation cleanup and ongoing fractional-CFO oversight when DIY fixes fall short.

Get QuickBooks Reconciliation Help From Condesa Financial

QuickBooks Reconciliation Help: Start With Your Symptom

Use this index to jump straight to the section that matches what you see on your screen.

• The Difference At The End Of The Session Will Not Reach $0.00 → See “What To Do When Your QuickBooks Reconciliation Doesn’t Balance”
• The Beginning Balance Is Wrong Or Has Shifted → See “Why Is My Beginning Balance Wrong On Reconciliation In QuickBooks?”
• A Reconciliation Was Finished By Mistake → See “How To Undo A Reconciliation In QuickBooks Online And Desktop”
• A Reconciled Transaction Was Deleted Or Edited → See “How To Fix A Deleted Or Edited Reconciled Transaction In QuickBooks”
• Uncleared Transactions Are Lingering From Prior Periods → See “How To Clear Uncleared Transactions In QuickBooks Online And Desktop”
• The Balance Sheet Does Not Match The Bank Reconciliation → See “Why Does My Balance Sheet Not Match My Bank Reconciliation?”

How To Do Bank Reconciliation In QuickBooks Online

Most users can follow a straightforward seven-step path to complete a clean reconciliation in QuickBooks Online. If you already tried these steps and still cannot close, move to the symptom sections that follow.

1. Go to All Apps > Accounting > Reconcile (or Settings Gear > Reconcile).
2. Select the account from the Account dropdown.
3. Confirm the last statement ending date shown matches your prior statement.
4. Enter the ending balance and ending date from your current bank statement.
5. Click Start Reconciling and check off each transaction that appears on the bank statement.
6. Confirm the Difference field reads $0.00.
7. Click Finish Now, then Done.

QuickBooks Online automatically saves a reconciliation report when a reconciliation is finished. You can access past reports via Accounting > Reconcile > History By Account. If the clean path worked, you are finished. If it did not, continue to the relevant symptom section. One of the most common issues is a beginning balance that has shifted.

Why Is My Beginning Balance Wrong On Reconciliation In QuickBooks?

A shifted beginning balance creates one of the most disruptive reconciliation failures because you cannot overwrite it manually. You must correct the transactions or opening balance that feed the beginning balance. QuickBooks Online calculates the beginning balance from the ending balance of the prior completed reconciliation, so any change to a prior-period transaction after it was reconciled affects every subsequent period.

The most common causes of a QuickBooks beginning balance error include:

• A reconciled transaction was edited, deleted, voided, or moved after the reconciliation closed.
• A transaction was unreconciled manually in the register.
• The account’s opening balance entry was entered incorrectly or changed.
• Transactions were entered with the wrong date, placing them in a prior reconciled period.

Fix In QuickBooks Online: When the beginning balance is off, QuickBooks Online displays an alert. Selecting the fix option opens the Reconcile Discrepancy Report, which lists every transaction that changed since the last completed reconciliation. The report also shows when each change occurred and what type of change it was.

For each flagged transaction, the report shows a Change Type column (amount or account changed, unreconciled, reconciled in error, or deleted). A View option opens the full change history. Because these changes affect prior periods, correct each transaction in the period it belongs to instead of forcing the current reconciliation. After you resolve all flagged items, confirm the Reconcile Discrepancy Report shows $0.00 and select Resume Reconciling.

For deeper investigation, open the Audit Log via Gear Icon > Tools > Audit Log. The Audit Log records every transaction create, edit, void, and delete with a date, time, and user name and retains events for two years. Filter by date range and user to isolate the change. The difference between a transaction’s current values and its earliest audit log entry often reveals the exact mistake.

Fix In QuickBooks Desktop: Open Banking > Reconcile, select the account, and click the Locate Discrepancies link that appears when the beginning balance warning shows. This opens the Reconciliation Discrepancy Report, which lists transactions cleared in earlier reconciliations that were subsequently changed or deleted.

For the Audit Trail, go to Reports > Accountant & Taxes > Audit Trail and filter by account and date range. The Audit Trail shows the state of each transaction before and after the change. An entry dated after the transaction was reconciled indicates that the transaction changed after reconciliation.

To verify or correct an opening balance in QuickBooks Online, go to Accounting > Chart Of Accounts > View Register. The first entry should be an Opening Balance Equity transaction. If the amount is wrong, correct it directly in the register and save. An incorrect opening balance shifts every subsequent reconciliation by the same amount.

As Intuit’s QuickBooks Community guidance states: “If you can’t find the source of the discrepancy, don’t force an adjustment just to close the reconciliation. An unexplained adjustment hides a real error that will compound in future months.”

For more on diagnosing reconciliation errors by type, see Condesa’s companion guide: QuickBooks Bank Reconciliation Support: Fix Errors Fast.

Fix Your Beginning Balance With Condesa

What To Do When Your QuickBooks Reconciliation Doesn’t Balance

An end-of-session difference that will not reach $0.00 represents a different failure mode from a beginning-balance mismatch. You usually see this when the reconciliation screen shows a stubborn difference even after you check every item.

The most common causes include:

• The ending balance was keyed incorrectly at the start of the session.
• A bank fee or interest charge appears on the statement but was not entered in QuickBooks.
• A duplicate transaction was recorded in QuickBooks.
• A transaction exists in QuickBooks but has not yet cleared the bank, which creates a timing difference.
• A transposed amount, such as $1,254 entered as $1,524.

In QuickBooks Online: Select Edit Info in the reconciliation window to review and correct the ending balance or ending date without changing individual transactions. To add a missing bank fee or interest charge, enter it directly from the reconciliation screen so it lands in the open period.

A transaction that appears in QuickBooks but has not yet cleared the bank should be left unchecked rather than deleted. It is likely in transit and will appear on the next statement. After each correction, re-check the Difference field against $0.00.

In QuickBooks Desktop: Enter missing fees or interest with the correct date before you return to the reconciliation screen. Leave timing differences uncleared and allow them to resolve in the following period.

QuickBooks Online’s “Add Adjustment And Finish” option creates an expense or income transaction to close a non-zero difference. Intuit’s guidance states that this option belongs only on small, untraceable rounding amounts, never on a real discrepancy.

How To Undo A Reconciliation In QuickBooks Online And Desktop

Undoing a completed reconciliation is one of the most consequential recovery actions in QuickBooks, and QuickBooks Online and Desktop handle it very differently.

QuickBooks Online — Full-Period Undo: Only three roles can perform the one-step undo: Primary Admin, In-house Accountant, or an accountant connected through QuickBooks Online Accountant. As of Intuit’s 2026 QuickBooks Online Product Update, Undo Reconcile is available to any Primary Admin without requiring the Accountant user role.

The path is: All Apps > Accounting > Reconcile > History By Account. Select the account and date range, locate the reconciliation, open the Action column dropdown, and select Undo. A warning message appears. Check the confirmation checkbox and select Undo Reconciliation, then Done.

Two critical consequences apply. First, undoing a period also rolls back every reconciliation completed after it, not only the selected month. Second, the undo permanently deletes that reconciliation’s report and attachments. Download anything you need before you proceed. After the undo, every transaction in that period returns to an unreconciled state, while the transactions themselves remain intact.

If only one or two transactions need fixing instead of a full period, you can unreconcile individual transactions from the register. Go to Accounting > Chart Of Accounts > View Register, filter to the relevant period, and click each transaction’s reconciled status (the R in the checkmark column) until it is blank, then save.

If no one at the company holds a qualifying role, invite an accountant through Manage Users under the gear icon on the Accounting firms tab by entering their email address. Once connected, the accountant can perform the full-period undo in a single action.

QuickBooks Desktop — One-Session Undo: In QuickBooks Desktop Accountant and Enterprise Accountant editions, the path is straightforward. Back up the company file, open Banking > Reconcile, select the account, and choose Undo Last Reconciliation, then confirm the prompt.

This action returns every transaction from the most recent reconciliation session to an uncleared state and restores the previous beginning balance. The critical limitation is that Desktop can only undo one reconciliation session at a time, working backwards. A mistake three months old requires undoing three sessions and redoing each one in sequence.

QuickBooks Desktop Pro, Premier, and non-accountant Enterprise editions lack the one-click undo command. The manual alternative is to open the account register, select each transaction from the affected session, and clear the checkmark in the reconcile column so the status returns to blank or cleared. Work from a printed or PDF copy of the original reconciliation report so you know exactly which items belonged to that session.

After any undo in either product, re-check the balance sheet because undoing a reconciliation changes prior-period reports. For a broader decision tree on QuickBooks errors by type, see QuickBooks Error Troubleshooting: A Decision Tree By Symptom.

Undo Your Reconciliation With Expert Help

How To Fix A Deleted Or Edited Reconciled Transaction In QuickBooks

A deleted or edited reconciled transaction affects both the register balance and the beginning balance of every subsequent reconciliation. Deleting a transaction removes it from the register and every report and can break a reconciliation that already included it. Voiding keeps the transaction in the books with its amount set to zero, preserving the audit trail.

In QuickBooks Online: Open the Audit Log via Gear Icon > Tools > Audit Log. Filter by date range and, if known, by user. The log displays the date of each change, the user who made it, and the original transaction details.

For a deleted transaction, the log shows the full transaction as it stood when it was removed. For an edited transaction, compare the current values against the earliest audit log entry. The difference shows the mistake. The correction sequence is simple. Identify the change via the audit log, re-enter or restore the transaction with the original date and amount, then manually mark it R in the register and save. If the affected period has already been reconciled, re-reconcile that period to confirm it still closes at $0.00.

In QuickBooks Desktop: Run the Audit Trail report via Reports > Accountant & Taxes > Audit Trail. Deleted transactions remain visible in the Audit Trail even though they no longer appear in the register, which often provides the only proof that a transaction ever existed.

Filter by date and user, then follow the same correction sequence. Re-enter the transaction with the original date and amount, mark it cleared in the register, and re-reconcile the affected period.

How To Clear Uncleared Transactions In QuickBooks Online And Desktop

Uncleared transactions fall into two categories. Some items are genuinely in transit and will clear on the next statement. Other items are stale entries from prior periods that never cleared the bank and never will.

In QuickBooks Online: Go to Accounting > Reconcile > History By Account and open the reconciliation report for the affected period. The report lists every transaction included in that reconciliation with its status.

For stale uncleared items, open the account register via Chart Of Accounts > View Register and review each item against the bank statement. If a transaction appears in QuickBooks but never cleared the bank, investigate whether it is a duplicate, a timing difference, or an entry that should be voided. Avoid deleting a reconciled transaction to resolve an uncleared item. Void it instead so you preserve the audit trail.

In QuickBooks Desktop: Run the Prior Reconciliation Detail Report to see what was cleared in each finished period, then compare that list against the bank statement for the affected month. For stale items, open the register, locate each transaction, and assess whether it should be voided, matched to a bank entry, or left as an open reconciling item with a documented explanation.

Why Does My Balance Sheet Not Match My Bank Reconciliation?

Beyond uncleared transactions, another common issue appears when the balance sheet does not match the bank reconciliation. The balance sheet reflects the register balance, which includes every transaction entered in QuickBooks, regardless of whether it has cleared the bank. The bank reconciliation confirms that the register and the bank statement agree.

When these two reports diverge, the usual causes include unresolved reconciliation differences carried forward from prior periods, transactions recorded in QuickBooks that were never entered in the bank, or a wrong beginning balance that has compounded across multiple periods. Resolving the underlying reconciliation discrepancy, using the Reconcile Discrepancy Report and Audit Log workflows above, provides the correct fix.

Posting a journal entry to force the balance sheet to match without identifying the source transaction leaves the real error buried and allows it to compound in future periods.

When To Fix It Yourself Vs. Get QuickBooks Reconciliation Help

A reconciliation that will not close creates real risk. Misstated books produce misstated financial statements, which feed bad tax filings. Taxpayers who discover an error after filing a federal return may need to file an amended return when income, deductions, or tax liability change, and that process can carry penalties and interest if additional tax is owed.

Beyond tax exposure, lenders and investors rely on financial statements to make credit and valuation decisions. Recurring reconciliation failures can trigger auditor scrutiny that extends well beyond a single line item. Decisions made on inaccurate numbers create real consequences for cash, growth, and compliance.

Contact Intuit support when the problem involves a product bug, a corrupted company file, a subscription or access issue, or a bank connection error. When the problem involves the books themselves, such as a beginning balance that has shifted across multiple periods, a reconciliation that was undone incorrectly, a pattern of deleted or edited reconciled transactions, or books that have not been reconciled in months, you face an accounting issue that requires accounting expertise.

Condesa Financial Group is the right escalation path when DIY efforts have stalled. Condesa is a price-competitive fractional CFO and outsourced accounting firm staffed with ex-Big 4 (EY, PwC) professionals, delivering nearshore from Panama and Mexico City. The firm works in QuickBooks Online by default, cleans up and rebuilds reconciliation processes instead of only clearing a screen difference, and pairs every accounting engagement with fractional CFO oversight that answers the harder questions a bookkeeper cannot address.

Clients in high-cost US markets such as New York, Chicago, and San Francisco typically recognize the quality-to-price difference within weeks of onboarding. Condesa is industry agnostic and geographically agnostic. Its ideal client profile ranges from roughly 1 to 100 employees, with a particular focus on companies of 50 to 100 employees or fewer.

Get A Free QuickBooks Reconciliation Review

Conclusion

Each reconciliation problem described in this guide can be diagnosed by symptom, and the Audit Log or Audit Trail usually provides the first place to look. A difference that will not reach $0.00, a beginning balance that has shifted, a reconciliation finished by mistake, or a deleted reconciled transaction each has a specific fix that does not require forcing an adjustment that hides the real error.

Unresolved differences compound into misstated books, misstated tax filings, and decisions made on unreliable numbers. When the DIY path has run out, Condesa Financial Group restores QuickBooks reconciliation to a trustworthy state.

Contact Condesa For QuickBooks Reconciliation Help