Debtors Interest Transaction Menu
Debtors Interest Search
Search all interest batches
Interest will only run on debtors that have been flagged with an interest active
| Search | Search interest batches |
| Add | Add a new interest batch |
| Edit | Edit an existing batch |
| Cancel | Cancel an open batch |
| Print interest batch |
Add Debtors Interest Journals
This utility will calculate and create a Debtor Journal for each debtor that is Checked to have interest charges against them for outstanding balances.
The interest is calculated per age period per debtor for the outstanding amount per age period.
The interest percentage is setup on the Debtor Master Detail window.
Debtors> Activity> Interest Transactions> Add
|
Debtor From |
Select the from debtor. (The From and to can be left blank to include all debtors) |
|
Debtor To |
Select the To debtor. |
|
Billing Group |
A selectable value from a dropdown to create journals for a specific debtor billing group. |
|
Aging Date |
This is the date that the aging for the debtors will be based on. |
|
Description |
Enter a description for you interest batch. e.g. Interest on overdue account |
|
Currency |
Select the currency from the drop down. |
|
Reference |
Enter a reference of your choice.eg, Interest on Overdue Account. This is the reference that will appear on your interest transaction line on the debtors statement |
|
Transaction Date |
This is the actual transaction date for the debtor journal. |
|
Long Description |
Enter a description regarding the interest journal. |
|
Standard Tab has four buttons |
|
|
Pre-Process Report |
Pre-process runs the journal calculations but does not process the actual transaction, this allows for assessment and scrutiny before actually processing the interest journals. |
|
Process |
Actually run debtors interest utility. |
|
Close button |
Closes the window. |
|
Print button |
Print debtor’s interest run report |
Preview interest run
.png)
If the amounts are not correct, you can close and amend the relevant parameters such date, Interest Rate, etc. and rerun the interest calculations.
Note: If you click “Process” This will post the interest transaction to the respective debtor's accounts. Typically, you will only Process these transactions on month end, prior to running the debtor's statements and if you are satisfied that the interest amounts are correct.
If you process and there is an error in a particular calculation, you will need to do a journal to correct the mistakes.
Interest Calculation Example
Assume you wish to charge ABC Stores interest of 10% on their outstanding account.
Using the interest setup of 10%, Zero Minimum amount, Period From 30 Days.
| Debtor From | ABC Stores |
| Debtor To | ABC Stores |
| Billing Group | |
| All Description | Interest on overdue account |
| Ageing Date | 30/04/2012 |
| Reference | Interest on overdue account |
| Currency | Rands |
| Transaction Date | 30/04/2012 |
| 180days | 150days | 120days | 90days | 60days | 30days | Current | Balance |
| 0 | 0 | 0 | 1200 | 1000 | 500 | 0 | 2700 |
30/04/2012 Interest calculations:
Current: 31/01/2012 to 29/02/2012 Interest not applicable – zero balance
30 Days:01/03/2012 to 31/03/2012 Interest = R 0.00 (Due to From Period set at 30days)
60 Days: 01/04/2012 to 30/04/2012 Interest = R 8.33(1000 * 10%) / 12
90 Days:
Therefore on 30/04/2012 the ABC stores account will reflect a journal of R 8.32 for the interest calculate from 30-60days.
| Debtors Account | Dr | Cr | Balance |
| 01/04/2012 Opening Balance | 1000.00 | 1000.00 | |
| 30/04/2012 Interest on overdue account | 8.33 | 1008.33 |
Interest Activation Setup
Setup interest to be run in Debtors setup
Debtors Module> Configuration> Debtors Setup
Select the debtor> Amend> Account Details> Interest Setup
.png)
.png)
| Tick the Activate Option | This will activate interest calculations on that particular debtor |
| Minimum Amount | This amount is the minimum amount that interest will be calculated from. That is, if the amount outstanding is less than this amount, no interest will be calculated |
| Period From | This field indicates from how many days outstanding to start calculating interest. ie, if you choose 30 Days as an example, the system will start calculating interest if the amount outstanding is more than 30 days old |
| Interest Rate | Enter the interest rate, number only |
No need to enter a %, only a number
Interest Rate: This is an annual percentage.
If you wish to have interest calculated on all debtors, you will have to follow this process for every debtor.