To add a loan, you have two options:

• Go to the “Finances” section, then click on “Loans/Mortgages” and finally on the “Import a Loan” button to import a payment schedule;
• Go to the “Finances” section and create a new recurring expense of type “Loan” from the “Finances” section or import a payment schedule.

Create a loan with a recurring “Loan” expense

If you choose to create a recurring expense of type “Loan”, you have the option of using the automatic payment schedule calculation. To do this, you will need to provide the following information:

1. The start and end date,
2. The total amount,
3. The interest rate,
4. The insurance rate.

A button will allow you to preview the payment schedule before validating this expense.

If the schedule does not meet your expectations, the only solution will be to proceed with the importation of a schedule from the “Loans” section.

Import a loan from the “Loans” section

To import a loan, you can upload a file containing your payment schedule in Excel or Open Office format from the “Loans” page following our models.

• Excel Document Template
• Open Office Document Template

You can use this file to calculate your loan schedule. Once the calculation is done, export the import template (available in the first sheet, named “Import Model”).

• Mortgage Calculator Excel
• Mortgage Calculator Open Office

Modify or stop a loan/mortgage

Loan created as a recurring expense

To modify the instalment of a loan, locate and modify the last payment generated. This change will be applied to all future instalments. Payments already generated must be manually modified, one by one, if necessary.

To end a loan, locate and modify the last payment generated, then click on the actions on the right, and finally on “Stop”. This action is only available for the last instalment generated.

Loan imported via the “Loans” section

To modify an imported loan, you must first delete it, then import an updated payment schedule. You cannot modify individual instalments.

The deletion and stopping of imported loans can be done from the “Loans/Mortgages” section. Filter the loans in question, then use the Actions at the bottom of the page.

Delete a loan/mortgage

You can delete imported loans from the Loans/Mortgages section (filter by the loan in question then use the actions at the bottom) or the Finances section.

Loans created from the Finances section must be deleted from the same section.

Use the filters to only see the loan, select all lines, then delete them with the Delete action at the bottom of the table.

To delete an imported loan from the Loans/Mortgages section, filter to only see that loan, use the Delete button at the bottom of the table.

Renegotiation of the loan

To integrate a loan renegotiation, it is necessary to interrupt the existing ongoing loan and create a new loan.

It is recommended to import payment schedules using the templates provided on the “Loans” page.

For the old loan, you can export it, clean the export file by deleting unnecessary instalments, save the file, then re-import it.

Before re-importing the modified file, ensure to delete the old existing loan in Rentila.

Deduction of insurance and interest in the balance sheet

The amounts of insurance and loan interest are automatically subtracted in the Balance Sheet and the Tax Declaration Assistance.