QuickBooks Reconciliation Discrepancy: How to Fix It

Quick Fix: Check for duplicate transactions, missing deposits, or bank feeds that imported transactions already manually entered. Look for transactions in the wrong month (especially around month-end).

What Causes Reconciliation Discrepancies?

When your QuickBooks balance doesn't match your bank statement, it's usually:

1. Duplicate transactions — Bank feeds imported transactions you already entered manually
2. Missing transactions — Deposits, checks, or fees that appear on the bank statement but not in QuickBooks
3. Wrong amounts — Transactions entered with incorrect dollar amounts
4. Timing differences — Transactions recorded in the wrong month (especially checks dated near month-end)
5. Previous reconciliation errors — Mistakes from prior months that carried forward
6. Outstanding transactions — Old checks or deposits that still haven't cleared

How to Find and Fix Discrepancies

Step 1: Check the Discrepancy Report

1. During reconciliation, when you see a discrepancy, click Locate Discrepancies
2. Review the Previous Reconciliation Detail Report
3. Look for any transactions marked as reconciled that have since been changed or deleted

Step 2: Look for Duplicates

1. Go to Reports → Banking → Deposit Detail
2. Set date range to your reconciliation period
3. Sort by amount and look for identical deposits on the same day
4. Check Check Detail Report for duplicate check amounts

Step 3: Review Bank Feeds

1. Go to Banking → Bank Feeds (QBO) or Banking → Bank Feed Center (Desktop)
2. Look for downloaded transactions that match manually-entered ones
3. Exclude (don't add) any duplicates you find

Step 4: Check Transaction Dates

1. Run a Reconciliation Detail Report for the problem month
2. Look for transactions dated after the statement period but cleared during it
3. Check for checks written near month-end that may have cleared earlier than expected

Common Discrepancy Scenarios

Scenario 1: Bank Feeds Created Duplicates

Problem: You manually entered a $1,500 deposit, then bank feeds imported the same deposit

Solution:

1. Go to Banking center and find the duplicate downloaded transaction
2. Select Exclude instead of Add or Match
3. The duplicate is removed from your books

Scenario 2: Missing Bank Fee

Problem: Your statement shows a $25 service fee that's not in QuickBooks

Solution:

1. Create a bank expense transaction for $25
2. Categorize as "Bank Service Charges"
3. Include it in your reconciliation

Scenario 3: Wrong Check Amount

Problem: You wrote a check for $125 but entered it as $152 in QuickBooks

Solution:

1. Edit the check transaction to show the correct $125 amount
2. The reconciliation should now balance

Prevention Strategies

Use Bank Feeds Properly

• Don't manually enter transactions if you use bank feeds
• Or, manually enter first, then Match when feeds download
• Never Add a transaction that's already in your books

Monthly Reconciliation Rules

• Reconcile monthly — Don't let reconciliations pile up
• Start with prior month — Make sure last month fully reconciles before doing current month
• Date transactions correctly — Use the date the bank processed them, not the date you wrote them

Keep Outstanding Items Clean

• Review old outstanding checks — Checks over 6 months old may be stale-dated
• Void old checks — If they're never going to clear, void them and issue new ones
• Track recurring items — Automatic payments that might be in different amounts than expected

When You Can't Find the Issue

If you've tried everything and still have a small discrepancy:

Create an Adjustment

1. During reconciliation, click Reconcile Now even with the discrepancy
2. QuickBooks will ask if you want to create an adjusting entry
3. Click Yes for discrepancies under $10
4. For larger amounts: Keep digging — there's a real error somewhere

Start Fresh (Last Resort)

1. Back up your file first
2. Undo previous reconciliations back to the last month that balanced perfectly
3. Re-reconcile month by month to find where the error started

Related Issues

• Duplicate Transactions — How to find and remove duplicate entries
• Undeposited Funds Won't Clear — Common cause of reconciliation problems
• Sync Error — Bank feed sync issues affecting reconciliation

Tired of fighting QuickBooks errors? Accounting Ketchup catches up and cleans up your books in 3–7 days. From $69/month. Get your price →