How to change deposit from a past reconciliation

Gator1 · ‎12-07-2018

Several reconciliations were completed using the bank dumped deposit instead of matching with the itemized quickbooks deposit leaving it open. For example QB created a blank deposit on 7/20 with no customer payments. It should have matched the Actual Deposit (inclusive of linked customer payments) My problem is that if I delete the duplicate deposit then it will delete the payment made to the customer and then it will appear the invoice was never paid.

So my BIG question is how do I delete the original deposit and then post the right deposit if it has already been reconciled?

Anonymous · ‎12-07-2018

I see this is your first post so I'd like to welcome you to the Community, Gator1,

I can help you correct your reconciled deposits in QuickBooks Desktop.

You're on the right track with deleting those duplicate transactions. Once removed, you can now add the right deposit to the invoice using the Receive Payments option to prevent it from being open or unpaid. Let me show you how to do that:

Open the invoice.
At the top section of the transaction, click on Receive Payments.
On the Customer Payment window, select the correct deposit.
Click Save & Close.

Check out this article to know more about recording invoice payments in QuickBooks Desktop: Record a Payment for an Invoice

After you modify a reconciled transaction it automatically gets unreconciled, so you'll need to run a mini-reconciliation to save the changes in your bank register. You may refer to this article for the complete steps: Reconcile Previously Deleted and Re-entered Checking or Credit Card Transactions

That should point you in the right direction, Gator1. Please get back to me if you need further assistance with QuickBooks. You got me here to figure things out for you. Have a great day!

qbteachmt · ‎12-07-2018

If you have a DEP that includes payments flowing through UF, then deleting the DEP puts the PMNT back in UF, for you to select it, again. You don't need to Delete it, most times. Open it and use the Payments Icon to select the Payments that are still waiting here. Remove any line that shows as Income ("bank dumped"). The deposit should end as the same amount and will not unreconcile.

AdrianG001 · ‎06-07-2019

All you can do is unreconciled each month going back, and do them over again.

Regards,

Adrian

QuickBooks Cloud Consultant | Apps4Rent

Topics

Training

Community

Resources

How to change deposit from a past reconciliation