cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Why don't ending and cleared balances do not match?

Hi,

I don't understand why the ending and cleared balances don't match. The beginning month balance in QB matches the bank statement. There are four deposits in both QB and the bank statement and the totals match. There are four debits in both QB and the bank statement and the totals match. The bank balance matches QB cleared balance. The ending balance is $60 higher. I don't understand where the difference comes from. 

Solved
Best answer September 11, 2020

Best Answers
Highlighted
QuickBooks Team

Why don't ending and cleared balances do not match?

Hi ABC1236,

 

Thank you for making sure that your transactions in QuickBooks match the transactions in your bank statement. We'll trace this $60 difference in your reconciliation, and I'll explain about the Cleared Balance as well.

 

Since we're also sure that the Begining and Ending Balances are correct, let's go back to your Reconcile window and make sure you only clear (put a checkmark) the transactions that belong to the reconciliation period.

 

Clearing transactions dated outside the period will change the Cleared Balance and will cause a difference. That balance should always equate to the Ending Balance after clearing all transactions.

 

In the screenshot below, I'm reconciling my April transactions.

 

 

I'm just right here if you have other questions with your reconciliation. Have a good one!

View solution in original post

6 Comments
Highlighted
QuickBooks Team

Why don't ending and cleared balances do not match?

Let's work hand in hand to fix the differences in your account, ABC1236. 

 

There are some reasons why this occurs, which may cause damage data, and we can fix this by performing the Verify data and Rebuild utility tools in QuickBooks Desktop. This way, it'll return to its default order and automatically fixes minor company record data issues. The Verify Data utility identifies any potential data damage issues, while the Rebuild Data utility repairs data in your company file.  

 

If the program is in multi-user mode, you need to change to single user mode (Go to File -> Switch to Single User Mode). It is very important that you have to create a backup copy of your company file before running Verify and Rebuild Data.   

 

Verify Data:  

 

  1. Press the File menu.  
  2. Choose Utilities from the drop-down option.   
  3. Select Verify Data.  
  4. Tap Ok to continue.  

 

Note: If the verify process is successful, you are done. In case it fails due to some problem, QuickBooks will notify you to run Rebuild data.  

 

Rebuild Data:  

 

  1. Click the File tab at the top. 
  2. Select Utilities from the drop-down option.  
  3. Choose Rebuild Data.  
  4. Click Ok on Rebuild has completed.     

 

When the verify/rebuilding data finished, we can close and reopen your file to revamp it. Or restart your computer to refresh your QuickBooks data.   

 

However, if the issue persists after doing the steps above, I suggest contacting our QuickBooks Desktop Support Team. They'll be able to pull up your account in a secure environment and help you navigate using one of their tools. 

  

Let me know how everything goes by leaving a comment below or if there's anything else I can help you. I'm always around to help you out. Take care!

Highlighted
Level 2

Why don't ending and cleared balances do not match?

I found the verify data option from the utilities group. The Verify data function did not find any issues with the data, so the rebuild utility tool was not needed.

I contacted help through a chat session and was provided some standard instructions for finding discrepancies and reconciliation. I read the instructions and ran some of the reports, but found nothing and didn't expect to. I do this work for a small business and it was a slow month. As mentioned in the previous post, there were only a few debits and credits, the beginning balances matched and the cleared balances matched. 

I don't really understand where the $60 difference came from when I am the only one who uses Quickbooks. 

My only option is pay the $300 cost for support out of my own pocket for QB support. 

Is there anything from QB which clearly explains the difference between cleared and ending balance and how they can differ when the beginning balance is the same and all the credits and debits match. 

Highlighted
QuickBooks Team

Why don't ending and cleared balances do not match?

Hi ABC1236,

 

Thank you for making sure that your transactions in QuickBooks match the transactions in your bank statement. We'll trace this $60 difference in your reconciliation, and I'll explain about the Cleared Balance as well.

 

Since we're also sure that the Begining and Ending Balances are correct, let's go back to your Reconcile window and make sure you only clear (put a checkmark) the transactions that belong to the reconciliation period.

 

Clearing transactions dated outside the period will change the Cleared Balance and will cause a difference. That balance should always equate to the Ending Balance after clearing all transactions.

 

In the screenshot below, I'm reconciling my April transactions.

 

 

I'm just right here if you have other questions with your reconciliation. Have a good one!

View solution in original post

Highlighted
Level 2

Why don't ending and cleared balances do not match?

 

Your response was totally unhelpful. My original question was that my beginning balance in QB matches the bank statement. The bank statement ending balance matches the QB cleared balance. I have four debits and four credits in the QB journal. The four debit entries match and equal bank statement debit total. The four credit entries do the same.

 

The QB ending balance is $60 higher than the QB cleared balance. 

 

I am the only one who uses QB.  I have no idea where to look for the $60 discrepancy.

 

Highlighted
QuickBooks Team

Why don't ending and cleared balances do not match?

Thanks for getting back here in the thread @ABC1236.

 

The best way to locate the discrepancy of $60 on your QuickBooks Desktop account is to contact our QuickBooks Support. Also, please provide them your bank statement. In that way, they can compare the transaction that is entered on your QuickBooks and your financial institution statement.

 

Please follow these steps on how to contact our QuickBooks Support:

 

  1. Go to the Help menu.
  2. Choose the QuickBooks Desktop Help tab.
  3. Enter your concern.
  4. Click the Contact Us button.
  5. Select Continue.
  6. Choose either Start messaging or Get a callback.
  7. Fill up all the information needed.
  8. Click Submit or Confirm my call.

 

I'd also recommend visiting this article to make sure we address your inquiry on time: Support hours and types.

 

You might want to use the Previous Reconciliation report so you can review your past reconciliation, you can refer this link for more information: Get reports for previous reconciliations in QuickBooks Desktop.

 

If you have additional questions, please don't hesitate to leave a message in the comment section. I'm always around here in the Community to help. Take care, and have a good day.

Highlighted
Level 2

Why don't ending and cleared balances do not match?

My apologies. You did help me understand what I needed to understand. 

Need to get in touch?

Contact us