| User roles |  Admin |  staff |  external contributor | ✗Pulse user |
In this article, we will explain step by step how to use the interest calculation model in Silverfin. This process includes setting up the current account, adding entries, and calculating the debit and credit interests. Follow these instructions to ensure your calculations are accurate and correct.
TABLE OF CONTENTS
- Step 1: Explaining individual current accounts
- Step 2: Adding the interest calculation explanation
- Avoiding an infinite loop
- Admin users only!
Step 1: Explaining individual current accounts
- Activate the correct account template
- Go to the individual account you want to explain.
- Click on "Edit" and select the "Current Account" template.
- Set up the automatic explanation
- Use the data from your accounting package to automatically explain the individual account.
- Since the booking date is not always the correct date for the interest calculation, you can adjust the date in Silverfin.
- Navigate to the individual current account and use the automatic explanation to copy the ledger from your accounting package into the explanation.
- Reference to date and description: Make sure to enter the date from your accounting package and provide the correct booking description (such as comments or references).
- Update the history
- After clicking "Save", the history will be imported into the template.
- If you want to modify, add, or remove a date or description, you can manually adjust the lines to build the correct history for the interest calculation.
- When referring to the interest calculation, it is important not to check the items you want to include in the calculation base to ensure the interest is calculated correctly. For the booked interest amount of the period, you should check the box.
- Automatic merging of entries
- If you explain automatically based on the date, all entries with the same date will be merged, and the description will not be displayed.
- If you explain automatically based on the description, all entries with the same description will be merged, and the date will not be displayed.
Step 2: Adding the interest calculation explanation
- Add individual accounts
- Once the individual accounts are explained, add them to the interest calculation by clicking the # icon.
- Once the individual accounts are explained, add them to the interest calculation by clicking the # icon.
- Select the calculation frequency
- You can choose to calculate debit and credit interests based on days, months, quarters, or years. Select the desired frequency from the dropdown menu.
- You can choose to calculate debit and credit interests based on days, months, quarters, or years. Select the desired frequency from the dropdown menu.
- Enter the interest rate
- At the top of the explanation, you can enter the debit and credit interest rate.
- At the top of the explanation, you can enter the debit and credit interest rate.
- Automatic interest calculation
- If the interest calculation changes during the year (for example, from debit to credit), you do not need to manually transfer the amounts between accounts. Silverfin will automatically apply the correct percentage based on the positive or negative amount.
- A summary of the total debit and credit interests will be displayed at the bottom of the template.
- If the interest calculation changes during the year (for example, from debit to credit), you do not need to manually transfer the amounts between accounts. Silverfin will automatically apply the correct percentage based on the positive or negative amount.
- Calculating withholding tax
- Withholding tax is only applied to credit interests. Enter the payment date and the % withholding tax for the correct calculation.
- Withholding tax is only applied to credit interests. Enter the payment date and the % withholding tax for the correct calculation.
- Calculating interest by period
- The interest calculation is based on the booking date. Silverfin adds the lines per month if you calculate on a monthly basis. For yearly calculations, you can simply enter the opening and closing balances.
- The interest calculation is based on the booking date. Silverfin adds the lines per month if you calculate on a monthly basis. For yearly calculations, you can simply enter the opening and closing balances.
Avoiding an infinite loop
Once the interests are booked on the individual current account, you need to complete the account so that a green dot appears. This increases the final value in the overall interest calculation.
- Enter the booked amount under "Interest posted to the account" to avoid an infinite loop. Silverfin will then take this into account to complete the calculation correctly.
Check with the booked amount on account 65 or 75
Finally, through the # icon next to "Total gross interest", you can link the relevant account to check that the booked amount corresponds to the entries on accounts 65 or 75. This ensures the total gross interest is processed correctly.
Admin users only!
If you want to assign a default account, this can easily be done by adding the following code in the configuration box at the office level:
{% assign default_check_dividends = "65" %}.
The account number between the quotation marks can be adjusted based on the account you wish to use.