Interested in hearing how others handle this situation:
We received a payment advice file from a customer outlining the 350+ invoices they are paying. The last 24 rows of the file show they are taking credits for previously paid invoices. These appear to be system generated transactions that appear to have been administrative changes to the PO and should have no impact on us.
The customer’s portal doesn’t give us much information, but it does show that their system generated a credit to be taken on 1/6/26 and an offsetting payment for that credit will be made on 3/1/26. The transactions net to $0…eventually.
The problem is that the cash that hits the bank is $123,456 - credits, but the credits will be offset in two months.
My question is what is the best way of handling this?
I do not want to find a random invoice to short pay as that is a tracking nightmare. Is there a way to create a $0 invoice to apply the credits to now and then apply the offsetting payment later? Should I enter the cash receipt amount as the total amount received less the erroneous credits?
Any help or suggestions are greatly appreciated.
Note: The endless list of people at the customer who can’t do anything about it cannot be fixed.
