Interest calculator on a past due invoice

Copper Contributor

I have a customer who has not been making regular payments for more than a year. I need a calculator that will take in the invoices written, subtract the payments received and calculate the monthly interest that we could charge to the customer and present them with a cumulative total amount due. 


4 Replies



In the inserted file you will find an example that you can develop further or just use :).


I would be happy to know if I could help.




I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.


Thank you but this is NOT at all what I need. It's not a loan with a definite payoff date and I need to include compound interest. 



What I have sent you is food for thought for your plan.

The forum is there to get help with a project or plan.

If you would like to have a worksheet tailored to your needs,

this is more a commissioned work and not the help for self-help that you can get here.

However, I wish you every success in your project.

Thank you. I have several methods to come up with amounts that are "close enough". I just wonder if there is a worksheet that someone has already figured out and could share it with me.