Why your QuickBooks balance and bank statement may not match

You open QuickBooks, check your bank account, and see two different numbers. Before changing anything, identify exactly which balances you are comparing.

A bank statement, a downloaded bank balance, and the balance recorded in your books can describe different moments or different sets of transactions. A difference is a reason to investigate. By itself, it does not tell you which entry, if any, needs correcting.

Start with the same account, the same date, and a clear description of the two figures. Then work toward an explanation supported by the records.

First, name the two numbers

Write down where each amount appears and the date it represents. In particular, distinguish:

• The ending balance on a bank statement for a specific period.
• A balance supplied through a connected bank feed, which may reflect the last download rather than this moment.
• The balance in the QuickBooks account register, based on recorded activity.

Intuit notes that a connected account’s home-page balance can come from the most recent download, while a manually maintained account reflects entered transactions. The label and screen matter, so include them when asking for help. A screenshot can be useful through an agreed private channel, but do not include passwords or unnecessary account details. Read Intuit’s explanation of displayed balances.

Comparing today’s balance with last month’s statement ending balance will not answer whether last month was reconciled correctly. First bring the dates into alignment.

A timing difference can explain a mismatch

In the fictional example above, the September 30 statement shows $5,000 while the books show $4,800. The $200 check explains the entire difference because it was recorded in the books on September 29 but had not cleared the bank when the statement closed.

Deleting that check just to make the displayed totals equal would remove a real recorded payment.

Your situation may have a different explanation. Use the example to understand the question, not to diagnose your account.

Check for missing, repeated, or changed activity

A useful review looks at the underlying transactions rather than only the difference between two totals. Questions to bring to your bookkeeper include:

• Are there downloaded transactions still waiting for review?
• Was the same transaction entered manually and then added again from a download?
• Is there a recorded payment or deposit that has not cleared the bank?
• Are the statement ending date and ending balance correct?
• Has anything changed in a previously reconciled period?

Intuit identifies duplicates, incorrect statement information, and transaction differences as possible sources of reconciliation problems. It also explains that changing or deleting previously reconciled transactions can affect a later beginning balance. These are possibilities to check, not instructions to delete or reverse entries. See Intuit’s ending-balance guidance and beginning-balance guidance.

Downloaded does not mean reconciled

A bank connection brings information into the workflow. Reconciliation is a separate comparison of the transactions recorded in QuickBooks with the bank or credit card statement for a defined period. Intuit’s preparation guidance calls for the statement and the period’s transactions to be ready for review. Read Intuit’s reconciliation guide.

A completed reconciliation should account for the statement transactions and resolve the reconciliation difference. It does not mean every current balance on every screen must always be identical. An outstanding check, for example, may remain in the books after the statement period ends.

Avoid the tempting quick fix

Do not change an opening balance, remove a transaction, or enter an unexplained adjustment solely to make two numbers agree. A correction should explain what happened and preserve a reliable record of the business activity.

If a change would affect an already reconciled period, or you cannot explain the difference, stop guessing and ask the person responsible for your books to review it. Intuit specifically advises consulting an accountant before accepting an unexplained reconciliation difference through an adjusting entry.

Keep the statement available, then ask how it should be shared. Do not send bank credentials or financial documents through a public contact form.

Need help understanding the difference? Ask Hilinaʻi about QuickBooks support. For a first message, a simple description of the issue and the period involved is enough to start the conversation.

This guide is general bookkeeping information, not a diagnosis of your records or individualized tax, legal, or financial advice. Product details should be confirmed against the current QuickBooks Online interface before publication.

When the records need a closer lookRequest a conversation →