Why Doesn’t My QuickBooks Bank Balance Match My Bank?

When your QuickBooks bank balance doesn’t match what your bank shows, it doesn’t automatically mean your books are wrong. Outstanding checks, deposits in transit, unreviewed bank-feed transactions, and duplicate entries can all create differences.

What matters isn’t whether the two numbers match. It’s whether you can explain why they don’t.

First, Make Sure You’re Comparing the Right Balances

QuickBooks Online shows more than one balance, and they don’t measure the same thing. For connected bank accounts, QuickBooks typically displays two figures, although the layout and terminology can vary by interface version:

• Bank balance: The most recent balance QuickBooks received from your bank through the bank feed. If the connection hasn’t updated recently, this figure may be out of date.
• In QuickBooks: The balance calculated from transactions recorded in your QuickBooks bank register, including checks and deposits that haven’t cleared. Transactions awaiting review don’t affect this figure unless already recorded.

Two other balances matter:

• Your bank’s posted balance: The balance based on transactions the bank has posted. It may differ from the available balance, which can include pending activity or holds. Use posted transactions and a consistent cutoff date when investigating differences.
• Your reconciled balance: The bank statement ending balance you’ve verified through a reconciliation, accounting separately for uncleared items.

Before you go looking for an error, confirm you’re comparing the same type of balance as of the same date.

A $1,500 Difference That Doesn’t Mean Anything Is Wrong

Say your business has $20,000 in its bank account. Yesterday you wrote a $1,500 check to a subcontractor and recorded it in QuickBooks, but the subcontractor hasn’t deposited it yet.

Both numbers are correct. QuickBooks reflects the check you wrote; the bank hasn’t deducted it because it hasn’t cleared. That’s an ordinary timing difference, not an error.

Seven Reasons the Balances Don’t Match

1. Outstanding Checks

Checks recorded in QuickBooks but not yet cleared by the bank reduce your QuickBooks balance before they reduce the bank’s posted balance. That’s normal when the checks are legitimate. A check outstanding for months deserves a closer look: it may have been lost, voided, or never mailed.

2. Deposits in Transit

You may have recorded a customer payment or deposit in QuickBooks before it appears on your bank statement. That’s another legitimate timing difference. But a deposit that remains outstanding unusually long may have been recorded without ever being made.

3. Transactions Waiting in the Bank Feed

Transactions in the bank-feed review queue (often labeled “For review” or “Pending”) have reached QuickBooks but haven’t necessarily been recorded in your books. Adding a new transaction affects “In QuickBooks”; matching it to an existing entry generally does not add another transaction. A backlog is a common reason the figures drift apart.

4. Missing Transactions

A bank transaction may not be recorded in QuickBooks at all. Examples include service charges, interest, electronic withdrawals, automatic loan payments, and activity during a disconnected bank feed.

5. Duplicate Transactions

Suppose you manually entered a $2,400 vendor payment, then later added the same payment from the bank feed instead of matching it. QuickBooks could show $4,800 in payments even though only $2,400 left the bank.

Identify the duplicate carefully before removing anything. The entry that looks redundant may be linked to a bill or vendor record; deleting the wrong one creates another problem.

6. Transactions Recorded in the Wrong Account, Amount, or Date

A payment can be assigned to the wrong bank account, recorded in the wrong amount, or dated incorrectly. Even an otherwise valid transaction with the wrong date can throw off period-end balances. Verify the details against the bank statement before changing anything.

7. Previously Reconciled Transactions Were Changed

Editing, deleting, or changing the reconciliation status of a previously reconciled transaction can make a later reconciliation’s beginning balance disagree with the prior statement. The cause may be months old. QuickBooks’ reconciliation discrepancy report and audit log can help show what changed, when, and by whom.

A Connected Bank Feed Isn’t the Same as Accurate Books

The bank feed is a tool for bringing bank activity into your bookkeeping workflow. It doesn’t do the bookkeeping. Unreviewed transactions, incorrect matches, and duplicate additions can all exist in a connected account. Having your bank linked to QuickBooks doesn’t mean your books are right. For product-specific instructions, see Intuit’s official QuickBooks support center.

QuickBooks Bank Balance Doesn’t Match? Start With These Seven Checks

If your QuickBooks bank balance doesn’t match the bank’s posted balance, use this checklist before making corrections:

1. Match the dates. Compare posted bank activity and QuickBooks using the same cutoff date.
2. Match the balance types. Identify the bank-feed balance, “In QuickBooks” register balance, and any completed reconciliation balance.
3. List outstanding checks and deposits. Separate legitimate timing differences from unexplained amounts.
4. Review bank-feed transactions. Examine the “For review” or “Pending” queue; check for missing entries, duplicate additions, and incorrect matches before accepting anything.
5. Check the bank register. Verify amounts, dates, bank accounts, and potential duplicates against bank records.
6. Verify the last completed reconciliation. Compare its statement ending balance to the actual statement and review items carried forward.
7. Investigate any beginning-balance discrepancy. Use the reconciliation discrepancy report and audit log before touching prior-period transactions.

If a difference is still unexplained, leave the existing records in place and keep investigating rather than entering an adjustment just to make the numbers agree.

Three Things Never to Do Just to Make the Balances Match

Don’t force a reconciliation. An unexplained adjustment hides an error instead of fixing it.

Don’t delete transactions without investigating them. An apparent duplicate may be a legitimate payment or an entry tied to a bill, invoice, or other transaction.

Don’t casually change previously reconciled transactions. You can create new discrepancies in periods already closed.

A correct reconciliation explains the difference. It doesn’t just make it disappear.

When Should You Ask a Bookkeeper for Help?

An occasional timing difference is normal. But recurring unexplained differences, old outstanding transactions, duplicates, or reconciliation beginning balances that don’t agree with prior statements can point to a deeper problem.

• You haven’t reconciled your accounts for several months.
• Your reconciliation beginning balance no longer matches the prior statement.
• Your bank-feed transactions have accumulated without review.
• You’re tempted to enter an unexplained adjustment just to make the numbers match.
• You can’t confidently rely on your cash balance when making business decisions.

At Main Line Bookkeeping LLC, we help owners identify discrepancies, clean up QuickBooks Online records, and establish reliable monthly reconciliation procedures.

Frequently Asked Questions

The Bottom Line

If your QuickBooks bank balance doesn’t match, first identify the balance types and timing differences. Your QuickBooks register balance and bank balance don’t always have to be identical. But you should always be able to explain why they’re different.

When you clear your bank feed regularly, verify what’s recorded, and reconcile every month, your cash numbers become something you can actually run your business on.