You open QuickBooks, check your bank account, and immediately notice something that does not look right: the balances don’t match.
Maybe the difference is only a few dollars. Maybe it is hundreds or even thousands. Either way, seeing one balance in QuickBooks and another at your bank can make you wonder whether your bookkeeping is accurate at all. The good news is that a difference does not automatically mean your books are completely wrong. The balance shown by your bank and the balance recorded in QuickBooks can differ for several legitimate reasons. But a persistent difference can also point to missing transactions, duplicates, reconciliation problems, or bookkeeping that has fallen behind.Quick Answer:If your QuickBooks balance doesn’t match your bank account, start by checking for outstanding transactions, missing or duplicate entries, incorrectly categorized bank-feed activity, reconciliation discrepancies, and changes to previously reconciled transactions.
Why Your QuickBooks Balance and Bank Balance Can Be Different
Before trying to fix anything, it helps to understand that your bank and QuickBooks are not necessarily showing the exact same type of balance. Your bank shows activity that has actually reached the bank. QuickBooks reflects the transactions recorded in your accounting file. That means timing alone can sometimes create a temporary difference. For example, you might record a check in QuickBooks today even though the recipient does not deposit it for several days. QuickBooks already knows about the payment, but your bank does not. That type of difference can be completely normal. The problem is when the difference cannot be explained.1. You Have Outstanding Checks or Deposits
One of the simplest reasons for a balance difference is that a transaction has been entered into QuickBooks but has not yet cleared your bank. Examples may include:- Checks that have not been deposited
- Payments that are still processing
- Deposits that have not posted
- ACH transactions still in transit
- Pending debit card purchases
2. Transactions Are Missing From QuickBooks
Another common cause is simply that something appearing on the bank statement was never properly recorded in QuickBooks. This can happen with:- Bank fees
- Automatic subscriptions
- Loan payments
- Merchant processing fees
- Interest charges
- Automatic transfers
- Owner withdrawals
- Deposits entered into the wrong account
3. You Have Duplicate Transactions
Duplicates are another common reason QuickBooks balances become inaccurate. For example, suppose an expense was manually entered into QuickBooks. Later, the same transaction downloads through the bank feed and is added again instead of being matched to the existing transaction. Now QuickBooks contains the expense twice even though the bank only processed it once. Duplicates can happen when:- A bank transaction is added instead of matched
- Transactions are manually imported more than once
- A bank connection is reconnected
- Sales or deposits are entered through multiple workflows
4. A Previously Reconciled Transaction Was Changed
This one can be especially frustrating because your books may have reconciled perfectly in the past. Then suddenly your next reconciliation starts with the wrong balance. That can happen when a transaction from a previously reconciled period is later:- Deleted
- Voided
- Edited
- Moved to another account
- Changed from reconciled to unreconciled
Be Careful With Old Reconciled Transactions
If you find a transaction from a previously reconciled month that appears incorrect, don’t immediately delete it just to make today’s numbers match. Changing historical transactions without understanding what happened can create additional reconciliation and reporting problems.5. The Opening Balance Was Entered Incorrectly
If the account has never reconciled correctly, the problem may go all the way back to when the account was first created in QuickBooks. An incorrect opening balance means QuickBooks started tracking the account from the wrong number. Every transaction entered afterward may be perfectly accurate, but your balance can still remain off because the starting point was incorrect. This is especially worth checking when:- You recently started using QuickBooks
- You migrated from another bookkeeping system
- You connected an existing bank account
- You imported historical bookkeeping records
- The account has never reconciled successfully
6. Bank Feed Transactions Were Added Instead of Matched
Bank feeds can save a tremendous amount of bookkeeping time, but they still need to be reviewed correctly. QuickBooks may download a transaction that has already been recorded elsewhere in the system. In many cases, the correct action is to match the downloaded transaction to the existing record rather than creating another transaction. Repeatedly clicking “Add” without reviewing the transaction can create duplicates and eventually throw off your balances and financial reports.7. Transfers Were Categorized as Income or Expenses
Transfers between business accounts deserve special attention. Suppose you move $5,000 from your business checking account into your business savings account. Your business did not earn another $5,000. You simply moved money from one asset account to another. If one side of that transfer is incorrectly categorized as income or an expense, your reports can become distorted even though the actual cash movement was legitimate. The same issue can occur with credit card payments and certain loan transactions when the bookkeeping treatment does not match what actually happened.8. Your Bookkeeping Hasn’t Been Reconciled Regularly
A balance discrepancy becomes much harder to diagnose when several months have passed since the last reconciliation. Instead of looking through 30 days of transactions, you may suddenly be reviewing hundreds of entries across multiple bank accounts and credit cards. That is where a simple reconciliation issue can turn into a bookkeeping cleanup project. If you’ve fallen several months behind, our guide How to Catch Up on Your Books Step by Step walks through the process of getting your records current again.How to Find the Difference Between QuickBooks and Your Bank
If your balances do not match, resist the temptation to simply create an adjustment to force the numbers together. Instead, work through the discrepancy systematically.- Get the actual bank statement. Use the official monthly statement rather than relying only on the current online banking balance.
- Check the statement ending balance and date. Make sure you are comparing the same account and the same reporting period.
- Review the beginning balance. If the beginning balance is already wrong, investigate the previous reconciliation or opening balance before moving forward.
- Match deposits and withdrawals. Compare the bank statement against the transactions recorded in QuickBooks.
- Look for missing transactions. Identify activity appearing at the bank that does not appear in QuickBooks.
- Look for duplicates. Check whether transactions appear more than once in QuickBooks.
- Review older reconciled activity. Determine whether a previously reconciled transaction was changed or deleted.
- Reconcile until the difference reaches zero. Once legitimate timing differences and errors have been accounted for, your reconciliation should balance.
Don’t Force QuickBooks to Match Your Bank
This deserves its own section because it can create bigger problems later. When a reconciliation is off, it can be tempting to enter an adjustment just to make the difference disappear. But the discrepancy is telling you something. If the real problem is a duplicated $2,000 expense, for example, adding another adjustment does not correct the duplicate. It simply introduces another transaction into the books. Your bank account may appear reconciled afterward while your Profit & Loss Statement or Balance Sheet remains incorrect. The goal isn’t simply to make QuickBooks display the same number as your bank. The goal is to understand why the numbers were different and correct the underlying bookkeeping.When a Balance Difference May Signal a Bigger Bookkeeping Problem
An occasional timing difference isn’t necessarily concerning. But you may have a larger bookkeeping cleanup issue if:- Several bank or credit card accounts don’t reconcile
- You haven’t reconciled in several months
- There are large numbers of uncategorized transactions
- Your QuickBooks balance is significantly different from the bank
- You frequently find duplicate transactions
- Your previous reconciliation suddenly changed
- Your Profit & Loss Statement doesn’t look right
- You don’t trust the numbers in QuickBooks