How can we help you today?

Follow

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

  1. Loans main view > Click the +ADD button in the upper right corner.
  2. 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
  3. Click the green ADD button to create a new loan and continue adding more information to the loan.

add_loan_EN.png

add_loan_pop-up_EN.png

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.

loans_editing_EN.png

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

loans_editing_2_EN.png

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 Set the internal identifier of the loan.
Property

Select the status of the loan; Applied, Repayment or Paid. 

Options are set in the Settings > Loans

Unit

Name of the financing institute / bank that has issued the loan.

Plot

Select the company that administers the loan, can also be a group company.

Building

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.

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:

  1. Date: Date of the balance (future amortizations will use this date as a base)
  2. Amortization paid: How much of the loan has been paid from the start of the loan.
  3. 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:

  1. Click Add 
  2. Give the date for the repayment
  3. Give the principal payment amount
  4. 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:

  1. Start or review date (*mandatory field): Set when the interest starts to be applied.
  2. New interest rate % (*mandatory field): Set the interest rate that starts from the date selected. 
  3. New margin %: Set the bank’s margin on top of the interest rate.
  4. TOTAL INTEREST RATE %: Shows the total interest percentage from the loan.
  5. 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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.