AR: What is the calculation formula used in overdue interest letter?

From AutoCount Resource Center
Jump to navigation Jump to search

Question: What is the calculation formula used in overdue interest letter?


Answer:

The formula used in overdue interest letter report is:

Amount Due * Interest Rate / 100 * Age / 365


Example:


Image 1 shows that debtor with some overdue invoice as at 31st Dec 2017 (Report Filter Date). When click on preview and choose Overdue Interest Letter Report, system will prompt a message for you to key in your interest rate. For this case, key in 10 (10%) and you will get a sample as below:


Interest cal1.png

Image 1


Interest cal2.png

Image 2


Referring to Image 2, there are 2 invoices that is overdue and their respective overdue interest is 39.73 and 6.30. To calculate this amount, use the formula provided at the “answer” section above and plot in the figure:


I-000001: 1000 * 10 / 100 * 145 / 365
= 39.73

I-000002: 200 * 10 / 100 * 115 / 365
= 6.30


By:JS 170808 P170928


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations