Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |