by excel How can I distribute the payment based on the due date of invoices " Oldest to newest "
Posted on 2016-10-14
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.
Customer Name Payment
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