How to Fix a QuickBooks Reconciliation That Won't Balance

A reconciliation that will not balance almost always comes down to one of four things: a transaction in QuickBooks that is not on the statement (or the reverse), a duplicate, an edited or deleted transaction that was already reconciled, or a wrong beginning balance carried over from last month. The difference figure at the bottom of the reconciliation screen has to reach zero before QuickBooks lets you finish. Here is how to find what is throwing it off and fix it without guessing, plus the one adjustment you should only make as a last resort.

Why won't my QuickBooks reconciliation balance?

Your reconciliation will not balance because the transactions QuickBooks thinks cleared do not add up to the change on your statement. In practice the cause is one of four: a transaction is missing from QuickBooks, a transaction is entered twice, a previously reconciled transaction was later edited or deleted, or the beginning balance no longer matches the bank. QuickBooks shows the gap as the Difference, and it will not close the reconciliation until that number is 0.00. The work is not fixing QuickBooks, it is finding which of those four applies and correcting the underlying transaction.

Start by checking the ending balance and statement date you typed in. A surprising share of unbalanced reconciliations are simply a mistyped ending balance or the wrong statement period, and correcting that clears the difference in one step.

How do I find the difference in a QuickBooks reconciliation?

Subtract the cleared balance QuickBooks shows from your statement's ending balance, then look for a single transaction that equals the difference. If the difference is $84.19, sort the reconciliation window by amount and scan for an $84.19 item you either checked off by mistake or failed to check off. A difference that matches one transaction exactly is the most common and easiest case: you either cleared something the bank has not posted, or left something uncleared that did post.

When no single transaction matches, the gap is usually two or more items or a rounding error hiding a duplicate. At that point it helps to pull the register out into a worksheet. You can export the account register to a spreadsheet, sort by amount, and eyeball two identical rows on the same date far faster than scrolling the reconciliation screen. Duplicates jump out when the data is sorted.

What is the reconciliation discrepancy report?

The Reconciliation Discrepancy report lists every transaction that was changed after it had already been reconciled, which is the single most common reason a beginning balance goes wrong. In QuickBooks Desktop you open it from Reports, then Banking, then Reconciliation Discrepancy, and choose the account. It shows the transaction, the reconciled amount, the changed amount, and the difference, sorted by statement date. Anything on this report was edited, deleted, or voided after a past reconciliation, and each one shifts your current beginning balance by its amount.

QuickBooks Online does not have that exact report, but the equivalent move is to open the account history and look for reconciled transactions (marked R) whose amounts no longer match the bank. Fixing those restores the beginning balance so the current month can balance.

How do I fix a beginning balance that is wrong?

Fix a wrong beginning balance by finding the changed transaction that caused it and restoring the transaction, not by editing the balance directly. Run the discrepancy report (or scan reconciled transactions in QuickBooks Online), identify the item that was edited, deleted, or unreconciled after it cleared, and put it back the way the bank reported it. If someone deleted a reconciled check, re-enter it and mark it reconciled. If an amount was changed, change it back. The beginning balance is calculated from every previously reconciled transaction, so correcting the one that moved is what makes it right again.

If the wrong beginning balance appeared right after an imported statement, the cause is often a duplicate or a mismatched opening balance rather than an edited transaction. That specific case, and how to unwind it, is covered in detail in our guide to fixing a wrong opening balance after a QBO import.

How do duplicate transactions cause a reconciliation to be off?

A duplicate makes the cleared balance overstate or understate the real activity by the amount of the doubled transaction, so the difference will equal that amount (or a sum that includes it). Duplicates usually come from two places: a bank feed that re-imported a transaction you had already entered by hand, or importing the same statement twice. The fix is to delete the extra copy, not to uncheck it, because an unchecked duplicate still sits in the register and will break next month too.

Before you delete, confirm which copy the bank actually reported so you keep the real one. Reviewing transactions carefully before you add them from a feed or an import prevents most of these, and our walkthrough on how to review imported bank transactions before adding them shows how to catch a duplicate at the point of import instead of at reconciliation.

Should I force a reconciliation to balance?

Only force it once you have genuinely accounted for the difference and it is a small, explainable amount like a bank fee or interest you forgot to enter, and even then it is better to enter that transaction than to force it. QuickBooks offers an Enter Adjustment option that posts the leftover difference to a Reconciliation Discrepancies expense account and closes the reconciliation. That clears the screen, but it hides the real problem: the adjustment sits on your books as an unexplained expense, and if the cause was a duplicate or a missing deposit, forcing it makes the error permanent.

Use the adjustment as a last resort for a stubborn difference of a few cents from rounding, and always enter real bank fees, interest, and service charges as their own transactions instead. If the difference is more than trivial, keep hunting for it. A forced reconciliation is a note to your future self that something was never explained.

Why does my reconciliation break when I use PDF statements?

It breaks when the data entered from the statement does not match the statement exactly, usually because transactions were keyed in by hand and a date, amount, or line was missed. The reconciliation compares QuickBooks to the statement, so any transcription slip shows up as a difference. Converting the statement to a QBO file instead of typing it removes that whole class of error, because every posted transaction, date, and amount is read straight from the PDF. If you are entering statements manually to reconcile, a PDF bank statement to QuickBooks converter gets the numbers into QuickBooks matching the statement to the penny, so the reconciliation ties out on the first pass.

This matters most for catch-up work across many months. When you batch convert a stack of statements, each one imports with its own totals, so you reconcile month by month against clean data rather than fighting a difference that traces back to a typo three months ago.

How do I stop my reconciliation from breaking again?

Lock down three habits. Reconcile every account monthly so a discrepancy surfaces while it is small and recent, not a year later. Never edit or delete a transaction that has been reconciled; if something is wrong, correct it with a new dated transaction so the reconciled history stays intact. And import clean data instead of retyping, so the numbers in QuickBooks match the bank from the start. Most reconciliations that will not balance are last month's shortcut catching up with you, and the steps above trace almost every difference back to its source. For the underlying workflow, our guide to bank reconciliation from PDF bank statements walks through reconciling a full period from the statement itself, and the QuickBooks month end close checklist shows where reconciliation sits in the wider close.