BOOKKEEPING & BUSINESS CLARITY · 3 MIN READ
Why Doesn’t My QuickBooks Balance Match My Bank Account?
By Hevia & Hevia CPA Firm · Published
Reviewed by Alexander Hevia, CPA, J.D., LL.M. (Taxation) —
Your QuickBooks balance may differ from your bank balance because of timing differences, missing or duplicate transactions, incorrect opening balances, or transactions recorded in the wrong account. A difference does not automatically mean the books are wrong, but it should be understood and reconciled.
The first step is to identify which balances you are comparing and the dates they represent.
Are you comparing the same account and date?
A balance downloaded from your bank, a balance in your accounting register, and a statement’s ending balance may represent different points in time. The downloaded information also depends on when the connection last updated. Intuit’s guidance on connected-account balances
For example, your books may include a check that has not cleared the bank. If the bank shows $10,000 and your records include an outstanding $800 check, the accounting balance could correctly show $9,200, assuming everything else agrees.
A reconciliation explains those differences. It does not require forcing every displayed balance to be identical at every moment.
What commonly causes unexplained differences?
Issues worth reviewing include:
- Missing activity: A transaction was not imported or recorded.
- Duplicate entries: The same activity was entered manually and added again from the bank feed.
- Incorrect starting information: The opening balance or statement information was entered incorrectly.
- Wrong dates or accounts: Activity was recorded in another period or account.
- Changes to earlier records: A previously reconciled transaction was edited or removed.
Intuit identifies incorrect statement information, uncleared activity, and missing or duplicate transactions among the causes of reconciliation differences. Intuit’s reconciliation troubleshooting
How should I investigate?
Start with the relevant bank statement and the last completed reconciliation. Confirm the account, statement date, and balances before reviewing individual transactions.
Compare dates, amounts, and descriptions. Identify legitimate outstanding items and investigate unexplained differences.
If several months are affected, work from the earliest reliable period forward. Changing a later balance without understanding the earlier problem can conceal the cause.
Should I enter an adjustment to make the difference disappear?
An unexplained adjustment should not be your first solution. A zero reconciliation difference is less useful if it was achieved by inserting an entry that does not reflect what happened.
Before changing opening balances or previously reconciled records, discuss the issue with your accountant—particularly if those records supported a filed tax return.
When should I seek help?
Professional assistance may be appropriate when the difference persists, earlier reconciliations no longer agree, or you cannot determine which entries are correct.
Hevia & Hevia CPA Firm provides bookkeeping support for businesses in Miami and South Florida, with remote services throughout Florida.
Contact our firm to discuss your records and the review needed. You can also read Do I Still Need a Bookkeeper If I Use QuickBooks?.
QuickBooks is a trademark of Intuit Inc. References are for identification and educational purposes and do not imply affiliation with or endorsement by Intuit.
FURTHER READING