This article explains the setup of interest calculation in Sapera, including the interest period, interest rate, minimum amount, tolerance period and conditions for adding interest. The settings are used when "Calculate interest" is run on debtors – several of the values are pre-filled in the calculation dialog and can be adjusted there.
1. From the hamburger menu in the top left corner of Sapera, open "Shop Manager".
2. Go to "Setup" → "Settings" → "Accounting" → "Interest calculation".
Specifies whether calculated interest should be aggregated per customer or posted per voucher.
Options:
Yes: The interest for the customer is collected in one interest entry per interest period (across departments in the same accounting entity) with its own voucher number.
No (default): An interest entry is created per original voucher/invoice.
The default interest rate in percent per month, which is applied to overdue payments.
Example: 1.5 = 1.5% per month. With a quarterly interest period, 3 × 1.5% = 4.5% is therefore added per quarter.
Note: The rate is pre-filled in the "Calculate interest" dialog and can be changed there – the change is saved as the new default. If a customer has their own interest rate in the debtor setup, it is used instead of the default rate.
The smallest interest amount Sapera charges per interest entry. If the calculated amount is lower than the limit, no entry is created. The value is pre-filled in the "Calculate interest" dialog and can be changed there.
Defines the length of the interest periods, i.e. how often interest entries are created. The periods are counted from the start of the financial year. Note: The interest rate is per month and is multiplied by the length of the period – the choice of period therefore does not change the effective interest rate per month, only how often it is posted.
Options:
Month (default): Interest entries are created per month (1× the monthly interest).
Quarter: Interest entries are created per quarter (3× the monthly interest).
HalfYear: Interest entries are created per half-year (6× the monthly interest).
Year: Interest entries are created once a year (12× the monthly interest).
The number of days of delay after the due date before interest accrual starts. Interest is calculated from the due date + 1 day + the tolerance days. The default is 0.
Example: 5 = no interest is added for the first 5 days after the due date.
Specifies whether interest should only be calculated on entries that have been included in a reminder run.
Options:
Yes (default): Interest is only calculated on overdue entries that have been included in at least one reminder.
No: Interest is calculated on all overdue entries, regardless of whether a reminder has been sent.
Specifies a date before which entries are excluded from the interest calculation (compared with the entry's financial date). Used to limit which historical entries are included. The date is pre-filled in the "Exclude entries earlier than" field of the "Calculate interest" dialog.
Note: Even though the field name mentions "mm-dd-yyyy", the date must be entered in the format DD-MM-YYYY (day-month-year) – that is how Sapera interprets the value.
Example: 31-12-2022 = entries with a financial date before 31 December 2022 are ignored in the calculation.
Want to know more?
Read more in these related articles:
Calculate interest
This article explains how to add and calculate interest on outstanding entries for customers in Sapera