Property Finance

Created by Teuvo Suoraniemi, Modified on Thu, 28 Nov at 12:48 PM by Teuvo Suoraniemi

This function is for entering Real Estates and Mortgages linked to Real Estates.

The Mortgages can then be linked to Loans. See article Linking Mortgages to Loans

It is possible to import both types via an csv file. Please see example files further down in this article.


Real Estate

Required fields are Owner, property identifier and Name


Example of an Real Estate


Mortgages


NOTE! You must first enter the real estate you want to register mortgages for. But the system can also automatically create the real estate (if it does not exist) when importing the mortgages. You then need to add fields Property Identifier and Owner in the file.


Required fields are Mortgages identifier, Real estate, amount.


If the mortgage is pledged, used as security for a Loan, the lender is selected in the Pledged list.


If it is not pledged the text 'Owner Registered' is shown.


Column names in reports vs Mortgages register field names


Name = Real estate

Mortgages identifier

Description (same)

Base amount = Amount

Base currency = Currency

Within (same) 

Deal begin date = Issue date

Deal end date = Annulment date 

Order number (same) 

Counterparty = Pledged. Blank if Owner registered (not pledged)


Column names in reports vs Real Estate register field names


Legal Entity = Owner

Owner Percentage

Name = Real estate

Real Estate Address

Property Number

Property Identifier

Description

Closing Balance/Market Value Clean = Market Value

Balance Start Date = Market Value Date

Deal begin date = Acquisition date

Base amount/Nominal Amount = Acquisition  Amount

Fee Amount = Acquisition Cost

Base currency =Acquisition   Currency

Deal end date = Sell date

Pledges Loans




Import - file examples.


Please note that the file "Real Estate.csv" should be imported in tab Real Estates. The other two files "Mortgages.csv" &  "Mortgages_and_realestates.csv" needs to be imported in tab Mortgage. The file "Mortgages_and_realestates.csv" will update also Real Estates with data.  



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article