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

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

Version: 1.8 / 1.9 / 2.0

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:

Image 1

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

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations