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?
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.
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.