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.
admin289
Level 1

Deleted cash payment/invoice and the cash payment is showing as a discrepany in bank rec. Fix???

First, I am using QB Desktop.  I deleted an invoice and cash payment that was for the incorrect amount (I used an estimate) and then set up the payable and cash payment with the correct amount.  I should have just adjusted both and would not have an issue now.  While trying to reconcile the August bank statement, the cash payment is showing on the previous reconciliation discrepancy report and as an open item on my bank rec.

 

How do I get rid of the previous reconciliation amount?  It truly is not a valid transaction.  When I look back at July's reconciliation detail, the amount is not there so I cannot do a mini reconciliation.

 

Can I just reconcile since I know what it is?  What will QB do with that reconciling difference?

 

Any help would be appreciated.

2 Comments 2
CharmieH
QuickBooks Team

Deleted cash payment/invoice and the cash payment is showing as a discrepany in bank rec. Fix???

Deleting and recreating a previously reconciled transaction will cause discrepancies, Admin.

 

When this happens, QuickBooks does not automatically reverse the reconciliation. It marks the deleted transaction as Deleted and includes the amount in the Previous Reconciliation Discrepancy Report for the bank account you're reconciling.

 

The discrepancy amount represents the deleted cash payment, while the recreated transaction is the open item in your August reconciliation.

 

To resolve discrepancies from July, you have to locate the recreated transaction and correct its date. This allows you to proceed with the mini reconciliation.

 

If the transaction is not too far, and if you have copies of your bank statements to verify that the adjustment will not disrupt your financial year records. You can undo the last reconciliation to help you start fresh if the mini reconciliation is still unsuccessful. Before taking this step, I recommend consulting your accountant to maintain accurate financial records.

 

Please note that the amount from your previous reconciliation will not appear in the July Reconciliation Detail report, since the transaction has been deleted.

 

While you can reconcile without clearing the discrepancies, it is not recommended, as it can be confusing when reviewing reports in the future. Clearing discrepancies is essential to maintaining accurate records.

 

If you need further assistance, please feel free to reply to this thread. The Community team is always here to support you.

Jayson_E
QuickBooks Team

Deleted cash payment/invoice and the cash payment is showing as a discrepany in bank rec. Fix???

Hi admin289,

 

I'm following up to see if the solution we provided worked for you. Did it resolve your issues, or are you still experiencing difficulties?

 

We'll be glad to assist further if you need any more help.

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

Need to get in touch?

Contact us