Adding and editing loans in the user interface

Data import is done via the user interface or Assetti API integration. New loans are added to the grid of main Loans view and further editing is done on the Terms tab of the loan fact sheet.

Loans in the grid are displayed from oldest to newest. Use the grid view for filtering, quick fixes, exporting and deleting the loans created by mistake.

Adding a loan in the UI

Loans main view > Click the +ADD button in the upper right corner.
In the pop-up, fill in the following fields:
- Loan number (mandatory)
- Financing institute / bank
  - If it’s already in Assetti as a contact, you find it in the drop down menu.
  - If not, you can add it directly in the pop-up > click on the row and write the name of a company. Assetti creates a organisational contact and it is found in the Contacts main view for further editing.
- Loan sum
Click the green ADD button to create a new loan and continue adding more information to the loan.

Editing the loan in the UI

Once you have created a new loan, you will be directed to the page with Terms and Amortizations tabs. Editable sections in the Terms tab have a pencil icon in the upper right corner or a link in the section. Data in the Amortizations tab is based on the information given in the Terms so it cannot be edited.

You can edit an existing loan by clicking on the loan number from the grid in the Loans main view.

Terms tab

See below the content of each sections.

*) Organisations and contact persons must first be added to Contacts in order to select them from the drop down menu.

KEY FACTS

TITLE	DESCRIPTION
Repayment	Shows the monthly amount to be paid for the loan
Interest rate	Shows the current interest rate for the loan
Total loan	Shows the full value of the loan
Loan maturity	Shows the duration of the loan
*Borrower )**	Company that has taken the loan; it can be a parent company or a housing/property company. Select from the drop down menu.
*Contact Person )**	Contact person of the borrower (company). Select from the drop down menu.
Summary	Information about the loan, free text field.

GENERAL INFORMATION

TITLE	DESCRIPTION
Loan identifier	Set the internal identifier of the loan.
Loan status	Select the status of the loan; Applied, Repayment or Paid. Options are set in the Settings > Loans
Financing institute / bank	Name of the financing institute / bank that has issued the loan.
*Company )**	Select the company that administers the loan, can also be a group company.
Subject(s) of the loan	Select on which subject the loan has been taken for, e.g. a portfolio, a property and/or a unit. You can also select if an asset from the portfolio is used as collateral.
Additional information	Free text to describe the loan in general.

COLLATERAL

TITLE	DESCRIPTION
Portfolio	Shows the amount of portfolios that are collaterals of the loan
Property	Shows the amount of properties that are collaterals of the loan
Unit	Shows the amount of units that are collaterals of the loan
Plot	Shows the amount of plots that are collaterals of the loan
Building	Shows the amount of buildings that are collaterals of the loan
Money guarantee	Set the amount of money to be used as collateral for the loan
Additional securities	Free text to describe other securities, e.g. rental income
Collateral type	Select what type of collateral is used for the loan. Options are in the Settings > Loans
Deposit	Add the initial investment to be paid by the investor

LOAN DETAILS

TITLE	DESCRIPTION
Loan sum	Edit the initial sum of the loan.
Balance	If the loan is not new, add the current balance of the loan in this field: Date: Date of the balance (future amortizations will use this date as a base) Amortization paid: How much of the loan has been paid from the start of the loan. Interest paid: How much interest has been paid from the start of the loan.
Loan type	Select the type of loan used: fixed installment, flat-rate, bullet or annuity. Options are set in the Settings > Loans
Repayment	Set the amount for repayment agreed in the loan agreement
(Bullet) Interest schedule	Add the period in months for scheduled interest
Repayment schedule	Set the loan repayment interval in months
(Bullet) Repayment schedule	To add the interest schedule for bullet loans: Click Add Give the date for the repayment Give the principal payment amount Click SAVE
Final payment (residual value)	Set the amount of final payment
Loan start date	Set the date the loan was created
Loan end date	Visualize the loan end date for fixed installments loan types, or set the end date if you use other loan types.
Interest %	Add the interest rate: Start or review date (mandatory field): Set when the interest starts to be applied. New interest rate % (mandatory field): Set the interest rate that starts from the date selected. New margin %: Set the bank’s margin on top of the interest rate. TOTAL INTEREST RATE %: Shows the total interest percentage from the loan. Comment: Add comments about the new interest percentage, free text field.
Interest type	Select what type of interest is being used, e.g. Euribor 12. Options are set in the Settings > Loans
Number of interest days	The number of days used for the interest, depending on a company it can be 360, 365 or also 145 in some cases.
Fixed interest end date	Set the date until which the fixed interest rate is agreed.
Initial administration fee	Give the amount of bank's initial fee paid for the administration of the loan.
Monthly servicing cost	Give the bank's monthly fee for managing the loan.

Amortizations tab

This tab displays how the loan will be repaid and calculated based on the data added to the Terms tab or the grid in the Loans main view.

How can we help you today?