I just discovered a deposit that was entered twice in error and also applied to the same customer account twice in error. The bank reconciliation has been done with one of the deposits clearing and the other remaining outstanding (disclaimer: I do not do the bank rec for our company :( ). My question is how do I removed this outstanding deposit from the check register and from the customer account without messing up the bank reconciliation? The duplicate deposits were made in April and we are now reconciled through June.
If the accounts are properly reconciled then one of these deposits has not been marked as cleared. Open the deposit that is not cleared. Right click and select Delete Deposit. Otherwise you cannot edit/delete the extra payment.
Now go to customer register and select the payment or sales receipt reflecting this. Delete this also. Refer to the customer Open Balance to ensure you are at correct balance and that there are no other lingering outliers.
Welcome to the Community, Txroofer.
I'm here to share some information regarding removing duplicate deposits in QuickBooks Desktop.
To remove the outstanding deposit in QuickBooks Desktop you'll need to undo the reconciliation from June to April and locate the duplicate deposit so you can delete it.
Or, you can process a mini reconciliation to correct the Beginning Balance in the Begin Reconciliation window.
To know more about the mini reconciliation process, check out this article: Fix beginning balance issues in QuickBooks Desktop.
I'm leaving you some recommended articles below. It contains information on what steps you need to take before reconciling your account in QuickBooks Desktop. Also, it provides more insights about the reconciliation process:
Feel free to get back to me if there's anything else I can help you with. I'll be around to keep helping. Have a good day!
@Txroofer said "one of the deposits clearing and the other remaining outstanding"
Why in light of the description that one of the extra deposits was NOT reconciled would you suggest undoing a previous reconciliation? The extra is extra, and if left in place will show up on the reconciliation list forever until removed or voided.