← All articles

QuickBooks Reconciliation Will Not Balance: A Practical Checklist

By Derek J. Hartsfield, CFO · Published October 18, 2026 · Last reviewed October 19, 2026

When a reconciliation ends with a difference, the instinct is to keep clicking until it goes away. A short, ordered checklist gets to the answer faster and leaves your books right.

1. Confirm the starting point

The beginning balance on the reconciliation screen should equal the ending balance on last month’s statement. If it does not, something that was reconciled has since been changed or deleted. Review the reconciliation report from the prior month to see what moved.

2. Check the statement dates and the ending balance

Make sure the statement ending date and balance you entered match the statement exactly. A transposed digit is a surprisingly common cause.

3. Look for duplicates

Scan the register for two entries with the same date and amount. They often come from a bank feed importing a transaction that was already entered by hand.

4. Compare amounts, line by line

Tick each statement line against the register. Look for transposed digits, such as 450 entered as 540, and for deposits recorded gross when the bank deposited net of fees.

5. Look for missing items

Bank charges, interest, and automatic withdrawals are often absent from the books. Add each one from the statement with the correct category.

6. Check transfers and credit card payments

A payment to a credit card or a transfer to savings should be recorded as a transfer between accounts, not as an expense. If it was categorized as an expense, profit is understated and both accounts are wrong.

7. Check for voided or deleted items

A transaction removed after a reconciliation can leave the account off by exactly that amount. A difference that matches a single transaction is a strong clue.

3. Look for the difference in size

The amount of the difference is a clue. A difference equal to a single transaction suggests that one entry is missing, duplicated or entered in the wrong direction. A difference of exactly twice a transaction suggests a deposit entered as a payment, or the reverse. A difference with transposed digits, such as 450 versus 540, is usually a typing error divisible by nine.

4. Check for changes to reconciled transactions

If the opening balance is wrong, a reconciled transaction was edited, voided or deleted after it was cleared. The reconciliation discrepancy report shows these changes. Restoring the transaction to what it was when reconciled usually restores the balance.

5. Review what is left uncleared

Look at the uncleared items in the register that are older than the statement period. Items that never cleared the bank may be duplicates, voided checks or entries that belong in a different account.

6. Do not accept the adjustment

QuickBooks offers to post a reconciliation adjustment to make the totals agree. The adjustment brings the screen to zero and leaves the error in the books, and it appears as an unexplained entry later. Locating the cause is the correct answer.

When to stop and ask for help

If the difference persists after these steps, or if several months do not agree, the cause is often older than the current month. We trace the first month that fails and work forward so every account agrees to its statement, with each correction supported.

Questions we hear most often

Can I undo a reconciliation and start over? Yes, and it is often the cleanest path when the opening balance is wrong. Undoing it returns the transactions to uncleared so they can be matched again against the statement.

Why did it balance last month and not this month? Something changed. A prior transaction was edited, a new transaction was entered in the wrong period, or a feed added an item that was already recorded.

A note on credit cards and loans

The same checklist applies to credit card and loan accounts, with one addition. Interest, annual fees and finance charges appear on the statement even when no one entered them. They are the most common reason a card reconciliation is off by a small, odd amount. Record each one with the correct expense account and the card issuer as the vendor.

What not to do

Do not accept the adjustment QuickBooks offers at the end. It hides the error instead of fixing it, and it makes the next month harder to reconcile. If the checklist does not locate the difference, stop and trace it back to the first month where the account stopped agreeing with the statement.

Some differences take hours to find in a file that has grown messy. That is work we do every day, and we document each correction so you can see what changed and why.

* The $99 starter covers one bank or credit card account in QuickBooks Online with fewer than 100 transactions in one month. Transactions are categorized and the account is reconciled for that month. Starter rate available through the date shown on the home page.