To calculate finance charges the customer’s statement option must be set up as type ‘2’- PRINT STATEMENT WITH FINANCE CHARGE. This is set up in the Accounts Receivable Menu; Add, Update Delete Customers option. Otherwise, there will be either no statement printed, or the statement will not include any finance charge calculations.

Step 1 is to find out how long the invoice has been overdue:

The days overdue for each invoice is computed by counting the numbers of days between the invoice date and the statement date.

e.g. Invoice date is September 24; statement end date is December 31

September 25, 26, 27, 28, 29, 30 6 days

October 1-31 31 days

November 1-30 30 days

December 1-31 31 days

Total 98 days

Next, the net invoice date is subtracted from the 98 days

E.g. The customer terms are 2% 10 Net 30

Therefore 98 days – 30 days is 68 days.

The DAYS OVERDUE is 68 days for that invoice

Step 2 is to calculate the compound interest factor:

The equation to do this is (days overdue – number of days overdue for financial charge)/365*12

E.g. the invoice is 68 days overdue, and you have specified to charge it as soon as it is one day overdue.

The compound factor is therefore ((68-1)/(365))*12)=2.2

Step 3 is to calculate the finance charge for that invoice:

The equation to do this is (balance of the invoice*monthly finance rate to the power of compound factor)

e.g. The monthly finance charge you specified is 2%, the invoice has a balance of $1286.19

The finance charge is therefore 1286.19((1.02 2.2)-1)=57.27

DOWNLOAD PDF