AR :Matching Unknown Payment to Invoices

Unknown Payments from Customers without payment advise

There are times when there are payments from customers without the payment advise. Without the details, it will pose a problem when performing the "applying receipts" function as one do not sure which invoices the payment is for.

There is an Excel add-in named Solver which could be useful in situations like this.

It can help facilitates the trial and error matching of a list of invoices against the payment amount. This approach could also be useful for the performing "netting" and cleaning up of accounting schedules.  Example as per attached UNKNOWN RECEIPTS file

PS: Do note that there might be bank TT charges deducted

Download File