Setup a term for a Customer. Terms here is 5% 5 Net 30 which means that Customer C10001 (Sarah Lopez) will get 5% discount if she pays it within 5 days. If she pays it beyond 5 days but within 30 days, she gets the regular price. After 30 days, she will incur interest of 21%.
Take note of the date of this invoice. This will be your basis of computing Finance Charge. In this example, the invoice date is 10/18/2007. The invoice due date is 11/17/2007 and this is 30 days after your invoice date. After this date, C10001 will start incurring finance charges.
Assume that it is 11/21/2007. When you open the Finance Charge form, it will then display this invoice. Here are the examples (see screen shots below) to distinguish the result when using and not using Actual days.
Formula:
Finance Charge = Invoice Total x [(No. of Days/Actual Days) x Rate]
Below is the computation for this example
Finance Charge = Invoice Total x [(4/365) x 21%]
= 233.85 x 0.0023
= 0.54
Formula:
Finance Charge = Invoice Total x [(No. of Months/12 Months) x Rate]
Finance Charge = Invoice Total x [(1/12) x 21%]
= 233.85 x 0.0175
= 4.09