QuickBooks reconciliation not matching? Learn how to fix reconciliation discrepancies in QuickBooks and call +1-866-513-4656 for expert help.
Few things disrupt a bookkeeper's workflow more than a reconciliation balance that refuses to align with the bank statement. If you are facing this issue right now, you are in the right place. Reconciliation discrepancies in QuickBooks can occur because of deleted transactions, incorrect opening balances, duplicate entries, or errors introduced during bank feed imports. This guide covers every major cause and provides clear, actionable fixes for both QuickBooks Desktop and QuickBooks Online. If you need immediate, hands-on help, call +1-866-513-4656 and speak with a certified QuickBooks professional.
How do I fix QuickBooks reconciliation not matching? Step-by-step fixes for reconciliation discrepancies in QuickBooks. Call +1-866-513-4656 now.
Why Is QuickBooks Reconciliation Not Matching?
Understanding the root cause is the first step. Below are the most common reasons reconciliation discrepancies appear.
1. Deleted or Edited Transactions After Reconciliation Once a transaction is marked as reconciled, editing or deleting it changes the reconciled balance without reversing the prior period close. This is the most frequent cause of a running discrepancy that grows over time.
2. Duplicate Transactions Manual entries combined with auto-imported bank feed transactions often create duplicates. Two entries for the same payment inflate your QuickBooks balance and throw off the match.
3. Incorrect Opening Balance If the opening balance entered during initial setup or a new reconciliation period does not exactly match the bank's closing balance from the prior period, every subsequent reconciliation will be off by that same amount.
4. Transactions Posted to the Wrong Account A payment recorded against the wrong bank account will cause one account to show a discrepancy while the other appears balanced. This is easy to miss without a detailed review.
5. Bank Feed Timing Differences or Errors Pending transactions, bank-side adjustments, or fees that post after your statement date can create temporary differences that look like errors but resolve in the next cycle.
How to Fix Reconciliation Discrepancies in QuickBooks Online
Step 1: Locate the Reconciliation Discrepancy Report
Go to Reports > search "Reconciliation Discrepancy" and select the account. This report lists every transaction that was changed, deleted, or added after a previous reconciliation. Review each flagged item carefully.
Step 2: Correct or Restore Problem Transactions
Open the flagged transaction from the report. If it was incorrectly edited, restore the original amount and re-save. If it was deleted by mistake, re-enter it and mark it as cleared manually during your next reconciliation.
How to Undo a Reconciliation in QuickBooks Online
Go to Accounting > Reconcile. Select the account and click History by account. Find the reconciliation period you need to undo and click Undo. QuickBooks Online will unmark all cleared transactions for that period, allowing you to start that reconciliation fresh without losing your data.
How to Fix Reconciliation Discrepancies in QuickBooks Desktop
Step 1: Run the Reconciliation Discrepancy Report
Navigate to Reports > Banking > Reconciliation Discrepancy. Select the account and run the report. This will highlight every transaction modified after being reconciled, including the type of change made and the dollar impact.
Step 2: Correct a Previous Reconciliation in QuickBooks Desktop
Go to Banking > Reconcile and select the account. Click Undo Last Reconciliation to reverse the most recent period. Make the necessary corrections, then re-reconcile the account from that period forward. For older periods, you may need to work backward through multiple cycles.
Prevention Tips
- Reconcile monthly without skipping periods to catch errors early
- Never delete or edit a previously reconciled transaction; use a journal entry to correct instead
- Always verify the opening balance matches the prior period closing balance before starting
- Review bank feed matches carefully before accepting them in bulk
- Run the Reconciliation Discrepancy Report after every close to catch changes immediately
- Limit user permissions to prevent unauthorized edits to reconciled transactions
Frequently Asked Questions
Q1. Where is the reconciliation discrepancy report in QuickBooks Online?
Go to Reports, type "Reconciliation Discrepancy" in the search bar, and select the relevant bank account to generate the report.
Q2. How do I undo a reconciliation in QuickBooks Online?
Navigate to Accounting, click Reconcile, select History by account, find the period, and click Undo.
Q3. How do I fix reconciliation discrepancies in QuickBooks Desktop?
Run the Reconciliation Discrepancy Report under Reports > Banking, identify the altered transaction, and use Undo Last Reconciliation to correct and re-reconcile.
Q4. Why does my beginning balance keep changing in QuickBooks?
The beginning balance changes when a previously reconciled transaction is edited or deleted. Use the Reconciliation Discrepancy Report to find the exact change.
Q5. Can I correct a reconciliation from a prior year in QuickBooks?
Yes. In QuickBooks Desktop, use Undo Last Reconciliation repeatedly until you reach the affected period. In QuickBooks Online, use History by account and undo the specific period. Always consult an accountant before adjusting closed periods.
Need Help Right Now?
Reconciliation errors can compound quickly and affect your financial reports, tax filings, and cash flow visibility. If the steps above have not resolved your issue, do not wait. Call +1-866-513-4656 to connect with a QuickBooks-certified professional who can diagnose and resolve your reconciliation discrepancy quickly and accurately.