Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
A
admin289
October 21, 2025
Question

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

  • October 21, 2025
  • 1 reply
  • 13 views

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.

1 reply

C
CharmieHQuickBooks Team
QuickBooks Team
October 21, 2025

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.

J
Jayson_EQuickBooks Team
QuickBooks Team
October 22, 2025

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.
Terms & ConditionsAccessibility statement