AP and Cash issue - An invoice was paid once by check and a second cash ACH sent after the check didn't clear, then the vendor refunded the overpayment

Question

We paid an invoice three months ago by paper check for say, $100. The check didn't arrive to the vendor, and so we then paid the invoice by ACH for $100. The ACH cleared, and then they also received and cashed the check. When the vendor realized they were paid twice, they sent us back $100. So our AP shows correctly with $100 invoice, and $100 payment. We now have $100 cash received that needs to be addressed. 
 Using the AP module, how do get AP to show up correctly, and also get cash on the GL to show up $100 cash received? 
 Thanks.

bethbowers · Accepted Answer

Your AP would actually be correct if it showed $100 invoice and $200 payment, wouldn't it? If it only shows $100 payment, right at this moment you don't need to do anything to have GL be correct. 
 If you want to show all of the activity, every last little bit of it, you would do another payment on the invoice so that the balance was -100. Then you would do a positive adjustment to the invoice to some holding account to zero it out. 
 Then on the AR side, you would do a cash receipt using the CASH customer and posting to the same holding account, so the holding account would net to 0.

Kevin M · Answer

Reversing the check before doing the ACH should do that, although the reversal date may not match when the $100 was received. 
 If you really want to, I suppose you could do a manual payment (to a GL account of your choosing) on the day they cashed the check, then negative manual payment (to the same GL account) when receiving the money back.

Sage 100

AP and Cash issue - An invoice was paid once by check and a second cash ACH sent after the check didn't clear, then the vendor refunded the overpayment

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING