Skip to main content
February 17, 2022
Question

Why 'Cleared Balance' in my reconciliation report appears to be taken at the curent date ( 17 Feb) and Statement ending balance is taken at the reconciliation date 30 Jun

  • February 17, 2022
  • 1 reply
  • 0 views
So the reconciliation difference is incorrect as statement balance does not include the transactions dated after the reconciliation date 30 June 2021, where cleared balance does because it is taken on current date of 17 feb 2022. Basically I can't reconcile.

1 reply

February 17, 2022

I know it can be difficult when you can't reconcile your account, Ire Return. I'm here to help sort this out.

 

Someone may have modified the transactions and made the cleared balance show on the current date. I'd suggest using the Audit Log feature to verify this. I'll show you how:

 

  1. Go to the Gear icon and then select Audit Log.
  2. Use the fields on the page to choose the appropriate UserDate, or Events filter to narrow the results.
  3. Select View in the History column to open the audit history. 

 

For more details about this feature, please see this article: Use the Audit Log in QuickBooks Online.

 

In addition, when reconciling your accounts, you compare what you recorded with your bank statement to make sure everything is accurate. I'd suggest modifying the cleared balance to ensure it matches the statement.

 

If you encounter an issue on your bank or credit card statement, you can easily fix this by following the steps shared in this article:  Fix Mistakes on your Financial Statement.

 

Once you're ready to reconcile your QuickBooks accounts, I encourage browsing these articles to ensure your record is accurate:

 

 

I'm only a post away if you need more help in reconciling your accounts in QuickBooks, Ire Return. It's always my pleasure to help you out again.