I had an unusual situation happen:
Regarding…
Deposit 3079:
https://geminiplasticsinc.cetecerp.com/deposit/3079/edit
A/R Payment 19934:
https://geminiplasticsinc.cetecerp.com/arpayment/19934/edit
The check on this AR payment went through the bank on December 30th and reconciled on our December bank statement. Unknown to us at the time, the check was flagged as needing approval by the payee’s bank. The person who needed to confirm approval at our customer missed the flag by the bank, so the check was automatically returned/bounced in early January.
So I need to leave the bounced check in our system to make the Bank Reconcile for December accurate. But I need to remove the check from the AR payment and enter the new check that they sent to pay the invoice.
I can not think of any way to leave the bounced check in the system so the reconcile is accurate - but remove it so we can pay the invoice with the new check that has a higher dollar amount. Any guidance for this?
I managed to come up with a strategy on my own that resolved this problem. I am sharing it here for future record: 1) Went into the associated account reconcile, clicked Open so that it could be edited. 2) Unchecked the affected Deposit number in the Account Reconcile list so that the Deposit could be edited. 3) Went into the affected Deposit and clicked the Re-Open button. 4) Went into the payment on that deposit that bounced, clicked Reopen Payment and zero’ed everything out. Eventually it asked if I’d like to remove the payment, clicked Yes. This removes the payment from the Deposit and the Invoice. 4) Created a new Payment for the deposit that went to our “Misc Income” GL for the same amount of the check that bounced later. This gets the Deposit amount back to the correct amount. 5) Went back into the account reconcile, checked the Deposit number as reconciled, and closed the reconcile again. 6) Finally, I created a check to our bank in Cetec for the date in January when the funds were returned, so that January’s reconcile will reconcile properly. 7) I can now deposit the new check as if the whole bounced check never happened.
1 Like