Neglected
Dear Sir ,

I have a collection of payments from several clients,as well many of invoices for them , I have summed the payments for each client to be as one payment in order to cover several Invoices .

My Question now , by excel How can I distribute the payment based on the due date of invoices " Oldest to newest " to settle it ,Knowing that maybe the payment closed full or part of the bill.



My Case

1-Payment
Customer Name Payment
A 5,000$
B 3,000$

2-Invoices

Customer Name Invoice No Invoice Amount Bill Date Solution / I looking for it
A 5 3,000$ Jan 2016 3,000
A 6 2,300$ Feb 2016 2,000

So, please note regarding invoice 5 ,300$ not taken because the payment from customer A was only 5,000$ so there is remaining balance from invoice 5 =300$ will settle in next payment

Your cooperation is highly appreciated

Best Regards
Ala'a Khalil