Why Your QuickBooks Balance Doesn’t Match Your Bank Balance

One of the most confusing things for a business owner using QuickBooks Online is opening the software and realizing that the balance shown in QuickBooks doesn’t match the balance in the bank account.

It’s easy to assume something is wrong.

Sometimes there is. But there are also perfectly normal reasons the two balances may be different.

The important question is whether your QuickBooks account has been properly reconciled and whether the transactions recorded in QuickBooks accurately reflect what happened in the bank account.

1. There Are Transactions That Haven’t Cleared the Bank Yet

QuickBooks records transactions based on when they are entered into the accounting system. Your bank balance reflects transactions that have actually cleared the bank.

Those aren't always the same thing.

For example, you may have recorded a payment to a vendor in QuickBooks, but the payment hasn't cleared your bank account yet. Until it does, the balances may be different.

That difference by itself doesn't necessarily indicate a problem.

2. Transactions Are Missing From QuickBooks

A transaction may appear on your bank statement without being properly recorded in QuickBooks.

This can happen when a bank-feed connection is interrupted, a transaction is accidentally excluded, or activity is entered outside the normal bookkeeping process.

Bank fees, interest charges, automatic payments, and other small transactions are particularly easy to overlook.

3. There Are Duplicate Transactions

The opposite problem can happen too.

A transaction may be recorded manually and then added again through the bank feed. Payments and deposits can also be duplicated when transactions aren't properly matched.

Duplicate transactions affect both the account balance and your financial reports, so simply adjusting the ending balance isn't the right solution.

The underlying duplicate needs to be identified and corrected.

4. A Transaction Was Recorded for the Wrong Amount

Sometimes the transaction exists in both places but the amounts don't agree.

A check may have been entered incorrectly. A deposit could have been recorded at its gross amount even though a payment processor deposited a net amount after fees. Or a transaction may simply contain a data-entry error.

These differences are exactly the type of issue the reconciliation process is designed to identify.

5. Previously Reconciled Transactions Were Changed

Suppose an account was successfully reconciled several months ago. Later, someone changes or deletes one of the transactions included in that reconciliation.

The current bank activity may look perfectly normal, but QuickBooks can now show a discrepancy because previously reconciled information has changed.

When that happens, the problem may need to be traced back to an earlier period.

6. You're Comparing Different Balances

QuickBooks Online may display a bank balance based on information received through the bank feed as well as a QuickBooks balance based on transactions recorded in the accounting system.

Those numbers serve different purposes.

A bank-feed balance matching your online banking balance doesn't necessarily mean the bookkeeping itself is accurate.

What Does It Mean to Reconcile an Account?

Reconciliation is the process of comparing the transactions recorded in QuickBooks with the transactions shown on your bank or credit card statement.

The goal is to verify that the activity agrees and explain legitimate differences, such as outstanding transactions.

That's why reconciliation should be part of a consistent monthly bookkeeping process, not something that happens only when the numbers look wrong.

Should You Just Make an Adjustment So the Balances Match?

Usually, no.

Creating an adjustment simply to force the numbers to match can hide the underlying problem. The difference could represent a duplicate transaction, missing expense, incorrectly recorded deposit, deleted transaction, or another bookkeeping issue.

The goal isn't simply to make two numbers look the same. It's to make sure the accounting records are accurate.

Blue Walney Bookkeeping & Advisory provides monthly bookkeeping, QuickBooks Online support, reconciliations, financial reporting, and cleanup and catch-up bookkeeping for small businesses and professional services firms.