cancel
Showing results for 
Search instead for 
Did you mean: 
office-derwoodbi
Level 1

How do I reconcile a bank account when the entry that is causing problems has been deleted? QB will not give me access to the deleted journal entry.

The JE was in July.  Now on the bank rec for Jan. it shows up as an uncleared item.  QB will not let me see the item because it has been deleted.  If it has been deleted, why is it showing up?  
3 Comments 3
MariaSoledadG
QuickBooks Team

How do I reconcile a bank account when the entry that is causing problems has been deleted? QB will not give me access to the deleted journal entry.

I'll help you fix the deleted entry, Office. 

 

The transactions may have been recreated that's why it is showing in January. You'll want to run the Uncleared transaction report to check if the item is showing or not. 

 

To run the report, you can follow the steps outlined below:

  1. Go to the Transactions menu, then select Chart of Accounts.
  2. Choose the correct account. 
  3. Under the Action column, click the drop-down around and select Run reports.
    uncleared.PNG

 

If the uncleared transactions are not supposed to be in your books then you can delete them. However, if this entry is needed to fix the problem, you can recreate it instead. 

 

Apart from this, learn how you can handle bank reconciliation in QuickBooks Online. Check out these helpful articles if you're experiencing issues:

 

Drop your comment anytime below if you need further assistance with reconciliation. Remember, the Community is always here to assist with all your needs.

office-derwoodbi
Level 1

How do I reconcile a bank account when the entry that is causing problems has been deleted? QB will not give me access to the deleted journal entry.

The problem is that it is not a reconciled item.  The entry was made in July, and it was deleted in July.  Was able to reconcile July thru Dec with no problem, it was not listed.  Now in Jan. it is showing up as an uncleared item that I cannot access because it was deleted.  If it was deleted - why is it showing up??  

 

Why would I want to recreate an entry that was deleted because it was wrong?  How does recreating it cancel the item that was deleted?  

MsNorthPND18
QuickBooks Team

How do I reconcile a bank account when the entry that is causing problems has been deleted? QB will not give me access to the deleted journal entry.

I understand the importance of reconciling your bank transactions in QuickBooks Online (QBO). 

 

If you have reviewed your transactions and confirmed that it was incorrect, there's no need to recreate them. However, if you accidentally recreated the transaction, you have the option to delete it.

 

All of the transactions will show to be reconciled on your existing entries. The transactions should not show once deleted since they're no longer in your books. Kindly review all the transactions in your register to verify if you've recreated them.

 

If this was an accident, recreate the transaction exactly as it appears on your discrepancy report. Here's how:

 

  1. Select + New.
  2. Select the correct form (invoice, sales receipt, expense, etc).
  3. Fill out the form and select Save and Close.
  4. Go to Bookkeeping or Accounting, then select Chart of Accounts.
  5. Find the account that you put the transaction into and select View Register.
  6. Find the transaction and select it to expand the view.
  7. Select the box in the checkmark column until you see an R. This manually reconciles the transaction.
  8. Select Save. If you still see an alert the next time you reconcile, open the discrepancy report. The deleted transaction may still be on the list, but the difference should be $0.00. It won't affect your reconciliation.

 

After you review everything on the discrepancy report, the Total Discrepancy Difference on the report should be US $0.00. Check the beginning balance again in QuickBooks. It should match the beginning balance on your bank statement. Select Resume reconciling to continue reconciling.

 

For future guidance, you can check out this article: Manually add transactions to account registers in QuickBooks Online.

 

You can always add a comment below if you have any other questions about reconciliation transactions. I'm always here to help. Have a great day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us