Hello Sir,
Can you please help to solve my doubt. My doubt is nothing but regarding to invoice and payment settlement using excel. If we have issued two invoices of amount 20000/- and 30000/- and we are getting a payment of 40000/-. Then the balance amount 10000/- must show as the outstanding in the second invoice row. Payment must be cleared on each invoices and also excel should work out if a payment is getting after the credit period with an interest rate of whatever we want. Actually I've done that but failed in interest calculation. Waiting for your valuable reply
Can you please help to solve my doubt. My doubt is nothing but regarding to invoice and payment settlement using excel. If we have issued two invoices of amount 20000/- and 30000/- and we are getting a payment of 40000/-. Then the balance amount 10000/- must show as the outstanding in the second invoice row. Payment must be cleared on each invoices and also excel should work out if a payment is getting after the credit period with an interest rate of whatever we want. Actually I've done that but failed in interest calculation. Waiting for your valuable reply