Satech Jubara
asked on
by excel How can I distribute the payment based on the due date of invoices " Oldest to newest "
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
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
Can it be done in VBA Macro?
ASKER
Dear Als315,
Frankly I don't understand how i can d , i have enclosed my case in excel , could you please help me how i can do it
Thanks
Frankly I don't understand how i can d , i have enclosed my case in excel , could you please help me how i can do it
Thanks
ASKER
Dear Als315,
Frankly I don't understand how i can d , i have enclosed my case in excel , could you please help me how i can do it
Thanks
Frankly I don't understand how i can d , i have enclosed my case in excel , could you please help me how i can do it
Thanks
We can do it in macro, but in this case it will be xlsm file and you should allow macros. Can you upload excel file with some sample data?
ASKER
Dear ,
Please see the attached
Please see the attached
ASKER
could you please send me the code ???
Sorry, nothing is attached. You should select file ("Attach file") and then press "Upload File"
ASKER
Dear Alexey ,
please see my attached file .
Your cooperation is highly appreciated :)
Thanks , once again
Ala'a Khalil
My-case.xlsx
please see my attached file .
Your cooperation is highly appreciated :)
Thanks , once again
Ala'a Khalil
My-case.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear als315
Yes great , Thank you so much my friend, this sheet will help me to solve many cases related with account receivable balances
Thanks , once again
Thanks
Yes great , Thank you so much my friend, this sheet will help me to solve many cases related with account receivable balances
Thanks , once again
Thanks