By Iris Carter-Collins, Certified QuickBooks ProAdvisor | IDCOLLINS QuickBooks Solutions
A difference between your bank balance and the balance in QuickBooks Online is a reason to investigate. It does not automatically mean money is missing. The balances can reflect different information or different points in time. Start by identifying which balances you are comparing before changing any entries.
Compare the same account and date
Your bank’s available balance, its posted balance, a statement ending balance, and the amount recorded in QuickBooks are not interchangeable. Pending bank activity and the timing of the latest download can complicate the comparison. Write down the account, date, and source of each number. That gives the review a useful starting point instead of an unexplained difference.
Separate timing differences from missing records
A check recorded in QuickBooks may not have cleared the bank yet. A deposit or fee may appear at the bank before it has been recorded correctly in your file. Downloaded activity still awaiting review also needs attention. Intuit’s guidance explains that displayed bank information can depend on the most recent download; it should not be treated as proof that all records are complete.
Review the history before forcing a match
Locate the last completed reconciliation and gather the statements that follow it. Look for duplicate entries, missing transactions, transfers recorded inconsistently, and changes to older entries. Avoid deleting an unfamiliar transaction or creating an adjustment solely to make the dashboard balances agree. A supported explanation is more useful than a number that merely looks right.
What to bring to a Book Review
Gather bank and credit card statements, the dates you believe are affected, and a short description of when you first noticed the problem. Mention a recent software migration, a new bank connection, or instructions from your accountant or CPA. Keep questions about older corrections separate from current activity so the scope can be assessed.
Experience with the work behind the balances
I have completed numerous cleanups bringing bank transactions current and properly categorized. My work with accountants and CPAs on accounting software migrations has reinforced the need to review the information behind a balance. As a Certified QuickBooks ProAdvisor, I help business owners determine what their file needs. Remote service is available nationwide.
Begin with a Book Review
A $795 Book Review is required. After the review, I’ll send you a video explaining what is needed, with cleanup pricing included in the video. Cleanup cost depends on what your file requires. I credit the $795 Book Review fee toward the cost of cleanup.
Request a Book Review to get started. Call 240-393-4137 or email info@idcollins.com.
Related reading: QuickBooks hasn’t been reconciled in months?