Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Nicolet31
Level 3

Deleted deposit - that was reconciled

We had a deposit transaction that was previously reconciled 2 months ago.  It was deleted and another transaction was created.  I found this out on the Reconciliation Discrepancy report.   My reconciliation is off by this amount now.  Can I do a right click reconcile on the transaction and fix everything?  If not how to I go about fixing this deleted and re-added transaction?  

Solved
Best answer June 28, 2023

Best Answers
Carneil_C
QuickBooks Team

Deleted deposit - that was reconciled

Good to see you here in the Community, @Nicolet31. I'll lay down a few steps to fix issues with transactions you've reconciled in the past. 

 

Since you need to modify those transactions, you'll want to do a mini-reconciliation that uses an "off-cycle" to make corrections. However, this needs professional advice from your accountant to ensure the best process to handle these amounts.

 

Here's how: 

 

  1. From the Banking menu, select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
  5. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
  6. Ensure the Difference field shows $0.00, then select Reconcile Now.

 

From there, QuickBooks asks if you want to Create a Payment Check or a Bill to Pay Later. You can follow this article with a detailed process: Reconcile previously deleted and re-entered checking or credit card transactions.

 

We have various reports in QuickBooks Desktop where you can review your past reconciliations: Get reports for previous reconciliations, which gives you details that can help you find discrepancies and other issues.

 

Please know that you're always welcome to tag my name in the comment section if you need further assistance or have other questions. about bank reconciliation.

View solution in original post

5 Comments 5
Carneil_C
QuickBooks Team

Deleted deposit - that was reconciled

Good to see you here in the Community, @Nicolet31. I'll lay down a few steps to fix issues with transactions you've reconciled in the past. 

 

Since you need to modify those transactions, you'll want to do a mini-reconciliation that uses an "off-cycle" to make corrections. However, this needs professional advice from your accountant to ensure the best process to handle these amounts.

 

Here's how: 

 

  1. From the Banking menu, select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
  5. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
  6. Ensure the Difference field shows $0.00, then select Reconcile Now.

 

From there, QuickBooks asks if you want to Create a Payment Check or a Bill to Pay Later. You can follow this article with a detailed process: Reconcile previously deleted and re-entered checking or credit card transactions.

 

We have various reports in QuickBooks Desktop where you can review your past reconciliations: Get reports for previous reconciliations, which gives you details that can help you find discrepancies and other issues.

 

Please know that you're always welcome to tag my name in the comment section if you need further assistance or have other questions. about bank reconciliation.

Nicolet31
Level 3

Deleted deposit - that was reconciled

Thank you that fixed it for me.  

LieraMarie_A
QuickBooks Team

Deleted deposit - that was reconciled

You're welcome, @Nicolet31.

 

I'm glad my colleague were able to provide the information you needed. If you have any further questions or need additional assistance, feel free to ask. We're here to help!

Nicolet31
Level 3

Deleted deposit - that was reconciled

I do have another one.  We have transaction from last year that should have been reconciled and were not.  I think at the time there was a glitch with the date in QB.  When I reconciled July 2022 some transaction didn't get reconciled for that month.   Is there a way to reconcile them now to clear them out?  

DebSheenD
QuickBooks Team

Deleted deposit - that was reconciled

Hi there, @Nicolet31.

 

I’ve seen that you’ve posted multiple times with the same concern in the Community space. My colleague already handled this for you. You can visit this link to view her recommendation: https://quickbooks.intuit.com/learn-support/en-us/banking/reconcilation-from-last-year/01/1280205#M9....

 

If you need more information about managing your company, feel free to visit our Support page. It contains ways and tips to make sure everything is accurate and organized.

 

Keep safe always!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us