cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
churchwarden-all
Level 1

Deleted reconciled journal entry. How to correct so reconciliation can continue?

I revised a journal entry for a bank deposit where each split had been recorded as a separate bank deposit rather than one entry for the deposit followed by a list of splits matching the total on the bank statement. This involved deleting the individual bank deposits and changing the first entry to match the total.

I made the mistake of not reversing the reconciliation before deleting the lines so I can't proceed with reconciliation until I have fixed this problem.

Is there any way around this without going back and reinstating the journal in it's original form and then repeating the changes after cancelling the reconciliation on the lines before deleting them?  

Solved
Best answer January 07, 2024

Accepted Solutions
Jelayca V
QuickBooks Team

Deleted reconciled journal entry. How to correct so reconciliation can continue?

I can see that you have taken the initiative to manually re-reconcile the bank transactions, which is a great step forward, church. Your dedication to resolving this issue is commendable. 

 

Before reconciling an account, it is important to review the beginning balance in QuickBooks. This is the amount in the account at the start of the period you are reviewing. It is essentially a checkpoint that ensures you are starting with accurate numbers. If you are unable to zero out the balance upon reconciling, it is possible that there is a discrepancy in the beginning balance. Therefore, you should check the beginning balance first before undoing all the reconciled transactions.

 

Remember that even small changes can unbalance your accounts, so it's crucial to unreconcile one transaction at a time to minimize the impact. If you need to start over completely, it's best to reach out to your accountant since only accountants can undo entire reconciliations. 

 

When you know what you need to change, here's how to edit and unreconcile the transaction:

 

  1. Go to Transactions and select Chart of accounts.
  2. Find the account holding the transaction. Then select Account history.
  3. Select the transaction you want to unreconcile to expand the view.
  4. Review the check column. If the transaction is reconciled, you’ll see an R.
  5. 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.
  6. Select Save and close the account history.

 

Moreover, I suggest reaching out to your accountant to have you get help. This can get tricky and they know how to handle the next steps. Don't have an accountant? We can help you find one.

 

Moreover, I'll add this link to help you fix past reconciliation problems: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Don't hesitate to reach out to us anytime if you have further questions about reconciliation in QuickBooks. The Community is always here to help. Take care!

View solution in original post

3 REPLIES 3
CamelleT
QuickBooks Team

Deleted reconciled journal entry. How to correct so reconciliation can continue?

I know how you can correct the deleted reconciled journal entry, church.

 

There's no other way around but to recreate the deleted transactions. Use the details in the Audit log.

 

After adding the transactions, manually reconcile the entries. Here's how:

 

  1. Click the Gear icon on the upper right corner and select Chart of Accounts.
  2. Select the bank account and click Account history under the Action column.
  3. Click the area under the Checkmark column to reconcile entries and mark them with an R
  4. Hit Save

 

Then, you can now proceed with your reconciliation

 

Moreover, I'll add this link to help you fix past reconciliation problems: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

I'll be here to back you up if you need further assistance in reconciling. Just drop a reply below. Take care!

churchwarden-all
Level 1

Deleted reconciled journal entry. How to correct so reconciliation can continue?

Thank you for your prompt reply. I have reversed all the corrections I had made and manually re-reconciled the bank transactions. I still get a reconciliation error but can't relate this to the journal entry that it references. All the bank deposits are reconciled. 

I have attached a screenshot - it shows the reconciliation error summary. The second line doesn't make sense - why is the difference between 11 and -574.17 = 11.00? Have all my changes confused QB? Have you any suggestions? Should I re-enter this journal entry from scratch?

 

Jelayca V
QuickBooks Team

Deleted reconciled journal entry. How to correct so reconciliation can continue?

I can see that you have taken the initiative to manually re-reconcile the bank transactions, which is a great step forward, church. Your dedication to resolving this issue is commendable. 

 

Before reconciling an account, it is important to review the beginning balance in QuickBooks. This is the amount in the account at the start of the period you are reviewing. It is essentially a checkpoint that ensures you are starting with accurate numbers. If you are unable to zero out the balance upon reconciling, it is possible that there is a discrepancy in the beginning balance. Therefore, you should check the beginning balance first before undoing all the reconciled transactions.

 

Remember that even small changes can unbalance your accounts, so it's crucial to unreconcile one transaction at a time to minimize the impact. If you need to start over completely, it's best to reach out to your accountant since only accountants can undo entire reconciliations. 

 

When you know what you need to change, here's how to edit and unreconcile the transaction:

 

  1. Go to Transactions and select Chart of accounts.
  2. Find the account holding the transaction. Then select Account history.
  3. Select the transaction you want to unreconcile to expand the view.
  4. Review the check column. If the transaction is reconciled, you’ll see an R.
  5. 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.
  6. Select Save and close the account history.

 

Moreover, I suggest reaching out to your accountant to have you get help. This can get tricky and they know how to handle the next steps. Don't have an accountant? We can help you find one.

 

Moreover, I'll add this link to help you fix past reconciliation problems: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Don't hesitate to reach out to us anytime if you have further questions about reconciliation in QuickBooks. The Community is always here to help. Take care!

Need to get in touch?

Contact us