What to Do When Your Reconciliation Won't Balance

A reconciliation that won’t hit $0.00 is frustrating, but the cause is almost always one of a small number of common issues — it’s rarely something exotic.

Why this happens

• A transaction was entered twice (often a bank-feed duplicate of something already entered manually).
• A transaction is missing entirely — never entered in QuickBooks at all.
• An amount or date was entered incorrectly.
• The opening balance for this reconciliation doesn’t match the true ending balance of the last one.
• A bank fee, interest charge, or interest earned wasn’t recorded.

Steps to fix it

1. Resist the urge to force it to zero. QuickBooks will offer to post an adjustment — don’t accept it until you’ve actually looked for the real cause.
2. Check for duplicates first — sort transactions by amount to spot two identical entries close together.
3. Verify your opening balance against the ending balance of your last successfully reconciled statement. If they don’t match, the real problem is in an earlier period.
4. Compare line by line against the statement for anything with a slightly different amount or date than what’s in QuickBooks.
5. Confirm fees and interest are recorded — these are the most commonly missed line items, especially on interest-bearing accounts.

When to get help

If the difference is a specific, unusual amount that doesn’t obviously match any single transaction, or if you’ve checked all of the above and still can’t find it, it’s worth having a second person review the account — a fresh set of eyes often spots what’s easy to miss after staring at the same numbers.