Property Finance

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

Real Estate = Name

Mortgages identifier

Description (same)

Amount = Base amount

Currency = Base currency 

Within (same) 

Issue date = Deal begin date 

Annulment date = Deal end date

Order number (same) 

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

Column names in reports vs Real Estate register field names

Owner = Legal Entity 

Owner Percentage

Real Estate = Name

Real Estate Address

Property Number

Property Identifier

Description

Market Value = Closing Balance/Market Value Clean

Market Value Date = Balance Start Date 

Acquisition date = Deal begin date 

Acquisition  Amount = Base amount/Nominal Amount

Acquisition Cost = Fee Amount 

Acquisition Currency = Base currency

Sell date = Deal end date

Sell Amount = Sell Amount

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.