Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bill Payments
Hi all
I have a list of customer account invoices eg: £300.76 £125.87 £34.26. £56.77 £21.67 £159.76 Then a customer makes a lump sum payment of but no information of which acctual bills they are paying. Is there a way of calculating every different computation of invoice amount to try to match them to the ammount paid. I hope this explains what I want to do obviously the list I have is a huge amount longer than the on above. Thanks |
#2
|
|||
|
|||
Yes there is a way to find a solution, which is not necessarily the only
solution, using solver. Assuming your payments are in A1:A6 and that B1:B6 are blank and that you have the formula =SUMPRODUCT((A1:A6)*(B1:B6)) in cell A7 then Tools/Solver Set target cell: A7 Equal to value of: "the payment" By changing cells: B1:B6 Subject to constraints: Use add and enter B1:B6 = binary HTH PC "NevHier" wrote in message ... Hi all I have a list of customer account invoices eg: £300.76 £125.87 £34.26. £56.77 £21.67 £159.76 Then a customer makes a lump sum payment of but no information of which acctual bills they are paying. Is there a way of calculating every different computation of invoice amount to try to match them to the ammount paid. I hope this explains what I want to do obviously the list I have is a huge amount longer than the on above. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching cheque payments to invoices | Excel Discussion (Misc queries) | |||
How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
Reports on the plan of consolidated payments in EXCEL | Excel Discussion (Misc queries) | |||
How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
Loan amortization schedule with bi-monthly payments | Excel Worksheet Functions |