Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
t-epperson
Level 1

Bank statement and transactions match in QBO, but I still have a difference of $66.61 when reconciling. How can I fix this? What am I missing?

 
1 Comment 1
Bryan_M
QuickBooks Team

Bank statement and transactions match in QBO, but I still have a difference of $66.61 when reconciling. How can I fix this? What am I missing?

I appreciate you for making sure that your bank and QuickBooks statements match to each other, which is very important when reconciling transactions, @t-epperson. Then, to your main issue with the $66.61 difference during reconciliation, there are several reasons why this occurs.

 

The reasons are explained below: 

 

  • Someone entered an incorrect ending balance at the start of the reconciliation.
  • There are missing or duplicate transactions in QuickBooks.
  • Someone entered transactions into QuickBooks that haven't cleared your bank yet.

 

The first step in fixing this is to review the opening and beginning balances and make sure it is the same as your real-life account. Here's how:

 

  1. From the Accounting tab, select the Chart of accounts.
  2. Find the account you try to reconcile. Then, View register.
  3. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
  4. Take note of the date and balance. If you forgot to enter an opening balance, here's how to manually enter an opening balance later.

 

After that, go back to the reconciliation page, check the ending balance. If it's incorrect you can change it by clicking the Edit info tab above the amount that is not balanced. Once done, save it.

 

For the proceeding steps after editing the information, you can visit this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

If you want to streamline and make sure the accuracy of your books, you can reach out to QuickBooks Live Expert Assisted.

 

Never hesitate to return here if you need additional assistance with reconciling your account in QuickBooks by leaving a comment below. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us