Your bank statement says $12,847.33. QuickBooks® says $11,203.19. That $1,644.14 gap keeps you from closing the month, filing accurate sales tax, and presenting clean books to your accountant. A bank reconciliation discrepancy in QuickBooks® means your register balance and your actual bank balance do not match — and every day you leave it unresolved, the error compounds with new transactions. This guide walks you through finding the root cause, fixing it step by step, and preventing it from ever happening again. Need immediate help? Call +1-888-550-4779. Fees apply.
What Is a Bank Reconciliation Discrepancy?
A bank reconciliation discrepancy occurs when the ending balance in your QuickBooks® check register does not match the ending balance on your physical or digital bank statement for the same date range. This mismatch can appear as a single large variance or dozens of small differences that add up to a frustrating total. Discrepancies prevent you from completing the reconciliation process, which means your financial reports — Profit & Loss, Balance Sheet, Cash Flow — all contain inaccurate data.
Common manifestations include: the Beginning Balance field in QuickBooks® Reconcile does not match your statement's opening balance; transactions appear in QuickBooks® but not on your bank statement (or vice versa); cleared transactions suddenly show as uncleared; or previously reconciled periods now show differences. Each symptom points to a different root cause, and fixing the wrong symptom wastes hours.
Why Does the Reconciliation Show a Discrepancy?
- Deleted or modified reconciled transactions: Someone edited, deleted, or voided a transaction that was already marked cleared in a past reconciliation — the most common cause.
- Duplicate entries: The same deposit or check was recorded twice in QuickBooks®, inflating your register balance.
- Missing transactions: Bank fees, interest, automatic withdrawals, or wire transfers posted to your bank but never entered in QuickBooks®.
- Incorrect opening balance: The beginning balance in QuickBooks® was entered wrong during initial setup, and every subsequent reconciliation carries the error forward.
- Bank feed import errors: Automatic bank downloads mis-categorized transactions, split them incorrectly, or imported pending transactions that later changed amounts.
- Manual check numbering gaps: A handwritten check was cashed for a different amount than recorded, or a check number was skipped in the register.
- Credit card vs. bank account confusion: Transactions were posted to the wrong account in QuickBooks®, so one account is overstated and the other understated.
- Journal entries affecting bank accounts: An adjusting journal entry debited or credited your bank account directly, bypassing the normal transaction flow.
Step-by-Step Fix Guide
1 Run the Reconciliation Discrepancy Report
The Reconciliation Discrepancy Report is your diagnostic starting point — it shows exactly which transactions changed after reconciliation.
- In QuickBooks® Desktop, go to Reports → Banking → Reconciliation Discrepancy.
- Select the bank account showing the discrepancy and the date range of your last successful reconciliation.
- Review the report for any transactions marked as Deleted, Modified, or Voided after reconciliation.
- Note the transaction dates, amounts, and payees — you will need to re-enter or restore these.
- In QuickBooks® Online, use Reports → Reconciliation Reports and filter by account and period.
2 Locate Deleted or Changed Transactions
The Audit Trail reveals who changed what and when — essential for finding the transaction that broke your reconciliation.
- Go to Reports → Accountant & Taxes → Audit Trail (Desktop) or Reports → Audit Log (Online).
- Set the date range to cover your last three reconciled periods.
- Filter by the affected bank account and look for events labeled Delete, Edit, or Void.
- Compare the original transaction details (before change) against your bank statement PDFs.
- If you find a deleted reconciled transaction, re-enter it with the exact original date, amount, and payee, then mark it as cleared in the reconciliation window.
3 Identify Duplicate or Missing Transactions
Duplicates inflate your balance; missing items deflate it. Both create reconciliation gaps that are easy to miss without systematic comparison.
- Open your bank account register in QuickBooks® (Chart of Accounts → Bank Account → View Register).
- Sort by amount (click the Amount column header) and scan for identical amounts on the same or adjacent dates.
- For duplicates: Delete the extra entry that lacks a matching bank statement line item.
- For missing items: Compare every line on your bank statement against the register. Look for bank fees, interest earned, automatic ACH withdrawals, and debit card purchases.
- Enter missing transactions using + New → Bank Deposit or + New → Expense, matching the exact bank statement date and amount.
4 Correct the Beginning Balance
An incorrect beginning balance is a structural error — every subsequent reconciliation builds on this wrong foundation.
- Navigate to Accounting → Reconcile (Online) or Banking → Reconcile (Desktop).
- Select the affected bank account. The Beginning Balance field auto-populates from your last reconciliation.
- Compare this number to your bank statement's opening balance for the same period.
- If they differ, the problem is in a prior period. Click Locate Discrepancies (Desktop) or History by account (Online).
- Work backward month by month until you find the first period where beginning balances diverged. Fix that period first — all later periods depend on it.
5 Fix Bank Feed Import Issues
Bank feeds save time but introduce their own category of errors — pending transactions, split misassignments, and duplicate imports.
- Go to Banking → Bank Feeds → Bank Feeds Center (Desktop) or Transactions → Bank Transactions (Online).
- Review transactions in the For Review tab. Look for splits that don't match your actual purchases.
- If a downloaded transaction was split across multiple categories incorrectly, click Undo and re-categorize it properly.
- Check for pending transactions that downloaded early — these often change amounts when they clear. Delete pending duplicates and wait for the cleared version.
- Disconnect and reconnect the bank feed if import errors persist: Edit Account → Disconnect, then Connect Account with fresh credentials.
6 Undo and Re-Reconcile Problem Periods
When individual transaction fixes don't resolve the gap, you must rebuild the reconciliation from the ground up.
- In QuickBooks® Desktop, go to Banking → Reconcile → Undo Last Reconciliation. In Online, go to Accounting → Reconcile → History by account → Undo.
- Undo reconciliations one period at a time, working backward from the most recent, until you reach the period where the discrepancy first appeared.
- Re-reconcile that period from scratch: enter the correct ending balance, check off cleared transactions one by one, and verify the difference field shows $0.00.
- Move forward period by period, ensuring each reconciliation closes with zero difference before proceeding.
- Print or PDF each completed reconciliation report for your records — this creates an audit trail.
Prevention Checklist
Maintain Reconciliation Integrity
- Reconcile every bank and credit card account monthly, without exception
- Restrict user permissions so only authorized personnel can edit or delete reconciled transactions
- Enable Closing Date password protection: Edit → Preferences → Accounting → Company Preferences → Set Closing Date
- Review the Audit Trail report quarterly for unauthorized changes
- Match bank feed downloads against statements before accepting them into the register
- Use consistent naming conventions for payees to avoid duplicate vendor records
- Reconcile credit card accounts separately — never mix them with checking accounts
- Back up your company file before each reconciliation in case you need to undo
Frequently Asked Questions
Need Expert Help with QuickBooks®?
Our independent technicians fix QuickBooks® issues remotely. Free diagnosis on every call.
📞 Call +1-888-550-4779 — Free Diagnosis⚠️ Disclaimer: InstantDesk Support is an independent, third-party technical support provider. We are not affiliated with Intuit Inc. or QuickBooks®. For free official support, visit quickbooks.intuit.com.