Skip to main content
T
Talha Mughal
February 10, 2021
Question

Opening Balance difference in Reconciliation

  • February 10, 2021
  • 1 reply
  • 0 views

Hi,

 

I have a query about reconciliation. I just took over 1 of my client's book and while i start reconciliation, it shows the entry deleted. I checked the bank statement and that particular entry was not appeared in the bank statement. I think that's why ex employee deleted the entry after reconciliation. Now entry is deleted and I also don't want to create that entry because it is not in bank statement. How to resolve the issue?

1 reply

R
RCV
February 10, 2021

I know reconciliation can be challenging at times. I got your back and let's get through this, Talha Mughal.

 

We can undo the reconciliation for the affected month to fix the bank balance on the next reconciliation. When you know what you need to change, here's how to edit and unreconcile the transaction:

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Find the account holding the transaction. Then tick View register. 
  4. Choose the transaction you want to unreconcile to expand the view.
  5. Review the check column. If the transaction is reconciled, you’ll see an “R.”
  6. Select the checkbox. This changes the letter in the box. Keep selecting it until the box is blank. This removes the transaction from the reconciliation.
  7. Press Save.
  8. Close the account register.

Your accounts should now be balanced and accurate. To learn more about this one see the Undo or remove transactions from reconciliations in QuickBooks Online article. You can also check out the Fix issues the first time you reconcile an account in the QuickBooks Online article to troubleshoot the reconciliation issue.

 

Feel free to visit our Reconciliation page for more insights about reconciling your bank account with QuickBooks.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. Have a great day. 

T
Talha MughalAuthor
February 10, 2021

Hi Sir,

 

Thanks for your answer. I can't find the transaction as it is already deleted from the register itself. Please find the photo to check.

AlexV
AlexV
February 10, 2021

Thanks for the screenshot, Talha Mughal!

 

The reason why there's an opening balance difference is that the deleted entry was reconciled. We need to undo the entire reconciliation for the affected month for us to fix this. Reach out to your account to undo them at once or do it manually.

 

Once done, you can reconcile the account again. Here's the reconcile workflow in QuickBooks to make sure that your books are accurate.

 

Comment again here if you have additional questions. Take care!

Terms & ConditionsAccessibility statement