Freeze the period
Choose the latest completed bank statement and note its exact ending date and balance.
QuickBooks cleanup guide
QuickBooks doesn’t match your bank. Start here.
Quick answer
A mismatch usually comes from an incorrect opening balance, missing or duplicate activity, transactions marked cleared incorrectly, or entries recorded in the wrong account. Compare one statement period at a time before changing anything.
Signs to look for
- The difference changes from month to month
- Old transactions remain unreconciled
- A bank-feed item appears beside a manually entered copy
- The reconciliation opening balance is already wrong
What to do next
Find the first break
Work backward until you find the earliest month whose reconciliation or ending balance no longer agrees.
Review before editing
List missing, duplicate, or incorrectly cleared items. Avoid deleting entries until you understand what created the difference.
Where TrainedBooks fits
TrainedBooks can analyze imported QuickBooks activity for categorization gaps, possible duplicates, and reconciliation questions so you have a focused issue list before choosing a cleanup.
The current QuickBooks Online integration imports Purchases and Deposits for analysis. It does not write transactions back, move money, file taxes, or replace a licensed professional.
Frequently asked questions
Should my QuickBooks balance always equal my online bank balance?
Not at every moment. Pending transactions and timing differences can make current balances differ. For reconciliation, compare QuickBooks with the ending balance and date on the completed bank statement.
Should I force a reconciliation adjustment?
Only after you understand the difference. An adjustment can make the screen balance while leaving the underlying missing or duplicate activity unresolved.
Does TrainedBooks change my QuickBooks records?
No. The current connection is read-only and does not write transactions back to QuickBooks Online.