The most common causes are an incorrect beginning balance, transactions that were changed or deleted after a prior reconciliation, duplicate or missing entries, wrong dates or amounts, and bank feed transactions that were matched or added incorrectly. Finding the cause usually starts with running the Reconciliation Discrepancy Report. QuickBooks shows a difference in bank reconciliation when the cleared transactions in your register don’t add up to your bank statement’s ending balance.
During reconciliation, QuickBooks compares two figures:
Your statement’s ending balance (what the bank reports)
Your cleared balance (the total of the transactions you’ve checked off in QuickBooks)
The Difference field at the bottom of the screen shows the gap between them. You can only click Finish Now when that difference is $0.00. Any other number means something in your books doesn’t match the bank’s records.
1. The Beginning Balance Doesn’t Match Your Statement
If the beginning balance on the reconcile screen differs from the ending balance on your previous statement, something changed after your last reconciliation. This is the most frequent culprit.
2. Cleared Transactions Were Edited, Deleted, or Voided
Changing the amount, date, or account of a transaction that was already reconciled breaks the link to your prior statement. Deleting or voiding a cleared transaction does the same.
3. Duplicate Transactions
Duplicates often appear when you enter a transaction manually and the same item also arrives through a bank feed. Both end up in the register, so your book total is overstated.
4. Missing Transactions
Bank fees, interest, ATM withdrawals, automatic payments, and direct deposits are often not entered. If it’s on the statement but not in QuickBooks, you’ll see a difference.
5. Transposition and Data Entry Errors
Typing 540 instead of 450 creates a difference divisible by 9. This is a classic sign of a transposed number.
6. Wrong Dates
A transaction dated outside the statement period won’t appear when you expect it, or may show up on the wrong statement.
7. Deposits Entered Individually Instead of Grouped
If your bank shows one combined deposit but QuickBooks lists several separate payments, the totals can match while the lines don’t. Use Undeposited Funds and group payments into one deposit to mirror the bank.
8. Bank Feed Matching Problems
Incorrectly matched, excluded, or categorized feed transactions can leave the register out of sync with the bank.
9. Opening Balance Equity or Uncategorized Entries
Large unexplained amounts sometimes trace back to old opening balance entries or transactions posted to the wrong account.
Step 1: Compare the Beginning Balance
Confirm the beginning balance on the reconcile screen equals your prior statement’s ending balance. If it doesn’t, address that first.
Step 2: Run the Reconciliation Discrepancy Report
In QuickBooks Desktop, go to Reports > Banking > Reconciliation Discrepancy (or access it from the reconcile screen if a discrepancy is detected). In QuickBooks Online, run the Reconciliation Reports from the Reports menu and review prior reconciliations. This report shows transactions that were changed or removed since you last reconciled, with the amount of each change.
Step 3: Review the Difference Amount
Look at the number itself:
Difference pattern
Likely cause
Exactly equals one transaction
That item is missing, duplicated, or wrongly checked
Divisible by 9
Transposed digits
Exactly double a transaction
A duplicate or an item checked in the wrong column
Matches a fee or interest amount
Bank charge or interest not recorded
Step 4: Check Each Transaction Against the Statement
Go line by line. Verify amounts, dates, and whether each deposit and payment is correctly marked as cleared.
Step 5: Look for Duplicates and Missing Entries
Sort the register by amount or date to spot duplicates, and add any statement items not yet in QuickBooks.
Step 6: Review the Account Register for Changes
Look for transactions edited after the last reconciliation, especially older ones.
Wrong beginning balance: Review the Discrepancy Report, then correct or restore altered transactions. If needed, undo the last reconciliation and redo it.
Duplicates: Delete the extra entry, or exclude the duplicate feed transaction.
Missing items: Add the bank fee, interest, or payment with the correct date and account.
Wrong amount or date: Edit the transaction to match the statement.
Grouped deposits: Move payments to Undeposited Funds and create one combined deposit.
Persistent small difference: After exhausting the steps above, some users post an adjustment entry. Use this as a last resort and discuss it with your accountant, because it can hide a real error.
QuickBooks allows you to enter an adjustment that forces the difference to zero, posting the amount to an adjustment expense or income account. It’s tempting, but it doesn’t fix the underlying problem. Use it only for small, understood differences, and only after confirming nothing else is wrong.
Reconcile every month, right after your statement arrives.
Never edit reconciled transactions unless you understand the impact.
Match bank feed items carefully instead of adding duplicates.
Record recurring fees and interest promptly.
Use Undeposited Funds for customer payments.
Keep a clean chart of accounts and avoid posting to the wrong bank account.
Review the Discrepancy Report whenever the beginning balance looks off.
Tracking down a stubborn discrepancy can take hours, especially when it spans several months or involves a damaged file. If you’d like expert, step-by-step guidance on fixing your QuickBooks bank reconciliation, call 1-866-513-4656 and get help finding and correcting the cause.
Why is my QuickBooks reconciliation off by a small amount?
Small differences usually come from a transposed number, a missed bank fee, rounding, or a single duplicate entry. Compare the difference to individual transactions to pinpoint it.
Why is my beginning balance wrong in QuickBooks?
Something was changed, deleted, or voided in a previously reconciled period. The Reconciliation Discrepancy Report shows what changed.
Can I undo a bank reconciliation?
Yes. Both QuickBooks Desktop and QuickBooks Online allow you to undo a previous reconciliation, though the exact steps and availability vary by version. Check Intuit’s current guidance before doing so.
What if my reconciliation difference is zero but my balance still looks wrong?
Check that you’re reconciling the correct account and statement period, and review uncleared items that may be dated incorrectly.
Is it safe to use the adjustment entry?
It’s acceptable for tiny, explained differences, but it can mask mistakes. Review with your accountant if you use it regularly.
Why do bank feed transactions cause reconciliation problems?
Feeds can import duplicates, or a transaction may be added instead of matched to an existing entry, inflating or misstating your register.
How often should I reconcile?
Monthly is the standard. More frequent reconciliation, such as weekly for high-volume businesses, makes errors easier to catch.
A reconciliation difference means your QuickBooks cleared balance doesn’t match your bank statement.
Start by checking the beginning balance and running the Reconciliation Discrepancy Report.
Common causes: edited or deleted cleared transactions, duplicates, missing fees, transposed numbers, and bank feed errors.
Use the difference amount as a clue to narrow down the problem.
Avoid forcing the balance with an adjustment unless the cause is understood.