You can add interest or finance charges to overdue invoices. The finance charge rates are set up in Sales Ledger settings Processing tab and applied on the customer account Credit tab. You run the calculation of interest at any point during the month, using the Finance Charges option. However, only one interest calculation can be made per account, per calendar month.
Charges are calculated in the following way. The outstanding gross value of any transaction is multiplied by the finance charge rate and divided by 100 (as it's a percentage). For example, if you have an invoice with an outstanding value of £117.50 and the finance charge rate for the customer is 2%, the charge for the invoice is 117.50 x (2/100) = £2.35.
Once generated, finance charges are added to the customer's account. The finance charge is posted to the debtors control nominal account and the default finance charge nominal account that is specified in the Nominal Ledger.
You can reverse finance charges, if required.
The Sales Ledger Finance Charges report is printed.
This shows the customer account reference, name, finance charge band, percentage rate, entry reference, date, due date, days overdue, outstanding value, finance charge value per invoice and total finance charge for each customer.
The finance charge is posted to the Nominal Ledger. This debits the Debtors Control nominal account and credits the Finance Charge nominal account.
The Sales Ledger Finance Charges Reverse report is printed.
This shows the customer account reference, name, finance charge band, percentage rate, entry reference, transaction date, finance charge value per credit note and total reversed finance charge for each customer.
The reverse finance charge transaction is posted. This debits the Finance Charge nominal account and credits the Debtors Control nominal account.
If you have specified a cost centre and department for the default sales nominal account on your customer's account, you must create a nominal account for finance charges with the same cost centre and department.
For example, a customer has a default sales account of 31100 SAL COM. The finance charge is posted to the nominal account 37110 (Finance Charges) SAL COM. If there is no finance charge nominal account with the relevant cost centre and department, the finance charge is posted to the suspense account.
Open: Nominal Ledger > Utilities > Ledger Set Up > Default Nominal Accounts.
Open: Sales Ledger > Utilities > Ledger Set Up > Ledger Settings | Processing.
If you want to add interest or finance charges to overdue unpaid invoices, you can specify the interest charge rates that you want to use here.
When you want to charge a customer interest on their overdue invoices, you assign a Charge index code to the relevant customer accounts on the account Credit tab.
There are 20 Charge Index codes.
Once you have specified the interest rates that you want to use and added the required interest rates to your customer accounts, you can generate your finance charges. This allows you to add interest to any overdue invoices.
Where interest is added, invoice transactions are added to the customer's account with the query flag set to F, and the reference as FIN CHARGE.
Open: Sales Ledger > Sales Accounts > Amend Account | Credit.
Open: Sales Ledger > Period End Routines > Finance Charges.
Enter the Charge date to appear on invoice.
This date is used to post the finance charge transaction. The date entered should not be after the end of the current period.
A list of outstanding transactions potentially requiring finance charges is displayed.
To apply and post finance charges to the customer's account, click Generate.
This also prints a list of all finance charges.
Open: Period End Routines > Finance Charges.
Enter the Charge date to appear on invoice.
This date is used to post the finance charge transaction.
Filter the list of entries displayed using the Selection criteria to show All Transactions, or transactions By date range, By customer range, or By finance charge rate.
A list of finance charges is displayed.
To reverse and post the finance charges to the customer's account, click Generate.
This also prints a list of the reversed finance charges.
Reference