Why Is My QuickBooks Balance Different From My Bank Balance?

Jul 17, 2026

Convert your bank statement to Excel now

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

Upload your bank statement

Short answer: Your QuickBooks balance differs from your bank because the two numbers measure different things. QuickBooks shows every transaction you have entered, while the bank shows only what has actually cleared. The six usual causes are uncleared or outstanding transactions, duplicate entries from the bank feed, timing differences at the end of the month, manual transactions that were never matched, a wrong beginning balance, and bank fees or interest you have not recorded yet. On any single day the two will rarely match to the penny, and that alone is not a problem. The number that has to match is the reconciled balance as of a statement date.

This confuses a lot of business owners because QuickBooks shows two different balances in the first place, and neither one is guaranteed to equal what the bank app says right now. Understanding which balance you are looking at solves most of the panic before you even start hunting.

The two balances QuickBooks shows you

In QuickBooks Online, the Bank Register shows a running QuickBooks balance, which is the sum of every transaction you have entered, cleared or not. Separately, the banking screen shows a Bank Balance, which is what QuickBooks last pulled from the bank feed. These two are almost always different, and that difference is the money that is in transit: checks you wrote that have not been cashed, deposits that have not settled, and card charges that have not posted. So the first step is to stop comparing the QuickBooks register total to the live bank app, because they are not supposed to be equal on a random Tuesday.

The comparison that matters is a reconciliation: you take a bank statement with a fixed ending date and ending balance, and you check off everything in QuickBooks that also appears on that statement. When the cleared transactions in QuickBooks add up to the statement ending balance, the account is reconciled, and any leftover gap is money genuinely in transit or a real error.

The six reasons your QuickBooks balance does not match the bank

CauseWhat it looks likeHow to fix it
Uncleared transactionsChecks or deposits entered but not yet clearedNormal; they clear over the next few days
Duplicate entriesSame charge from the feed and a manual entryFind and delete the duplicate
Timing at month endA payment posts a day into the next monthReconcile to the statement date, not today
Unmatched manual entriesA transaction typed in that never matched the feedMatch it or exclude the duplicate side
Wrong beginning balanceThe opening balance was set wrong at setupCorrect the opening balance equity entry
Unrecorded fees or interestMonthly service fee or interest not enteredAdd it during reconciliation

What are outstanding or uncleared transactions?

Outstanding transactions are payments and deposits you have recorded in QuickBooks that have not yet cleared the bank. A check you mailed sits in your register the day you write it, but it does not leave your bank until the vendor deposits it, which can be a week later. During that gap your QuickBooks balance is lower than the bank balance by the amount of the check. Deposits work the other way: a deposit in transit raises your QuickBooks balance before the bank posts it. This is the single most common reason for a difference, and it is not an error at all. It resolves itself as the items clear.

How do I find a duplicate transaction in QuickBooks?

Duplicates usually happen when a transaction is entered manually and then the same transaction comes through the bank feed and is added again instead of matched. To find them, open the Bank Register, sort by date, and look for two identical amounts on or near the same day. In the For Review tab, QuickBooks often suggests a Match rather than Add when a manual entry already exists, so accepting the match instead of adding prevents the duplicate. If one already slipped through, delete the extra entry, not the one that is reconciled. Duplicates overstate both your income or expense and throw the balance off by the doubled amount.

Why does a wrong beginning balance throw everything off?

When a bank account is first set up in QuickBooks, you enter an opening balance, and QuickBooks posts the other side of that entry to an account called Opening Balance Equity. If the opening balance was typed in wrong, or dated on the wrong day, every reconciliation after that will be off by the same fixed amount no matter how carefully you match transactions. The tell is a difference that never changes: the same dollar figure is off month after month. Fixing it means correcting the original opening balance entry so it equals the actual bank balance on the day you started tracking the account, then clearing out the Opening Balance Equity account with your accountant.

How do I reconcile so the balances match?

Reconciliation is the process that proves your books match the bank as of a statement date. Open Reconcile in QuickBooks, pick the account, and enter the statement ending date and ending balance from your bank statement. Then check off each transaction in QuickBooks that appears on the statement. As you go, the Difference figure at the top should move toward zero. If it reaches zero, the account is reconciled and the remaining gap versus today is just transactions in transit. If it will not reach zero, the difference is the size of your problem, and it points you at a missing transaction, a duplicate, or a wrong amount. Working from the full statement is far easier when the statement is a spreadsheet, so many bookkeepers first convert the PDF statement to Excel and sort by amount to spot the odd entry fast.

If you keep your books in QuickBooks and want the whole statement to import cleanly rather than typing missing transactions by hand, you can turn the statement into a QuickBooks-ready file and bring in the entire period at once, which is the fastest way to close a gap caused by history that never came through the feed.

When a difference is actually fine

A difference between your QuickBooks balance and your live bank balance is normal every single day, because of transactions in transit. What is not fine is a reconciliation that will not tie out to a statement ending balance, or a difference that stays exactly the same every month, which signals a beginning-balance or duplicate problem. The goal is not for the two numbers to match every day. The goal is for every statement to reconcile to zero, so you know the books are complete and correct as of each month end. Once you separate those two ideas, the mystery usually disappears. For a broader workflow on getting statement data ready to reconcile, see our guide on categorizing transactions from a bank statement.

Ready to convert your bank statement?

Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.

Convert to Excel now

Free to try, no credit card required

Z tej samej rodziny narzędzi