How can we help you today?

Follow

Fund Reports

Please note: This feature is only available for professional and enterprise plans. If you are interested or have questions regarding this, please contact our sales here.

Assetti’s fund reporting aims to ease up the quarterly reporting, get rid of redundant excel reporting, and improve data sharing. You can create, export and publish quarterly fund reports for portfolios which are classified as ‘fund’. After these reports are ‘published’ they are unable to be edited. These reports are then able to be viewed from the fund report tab on the left side of the screen or can be exported to excel. The graphs and charts used in this report can also be exported separately.

You will need to create a template before you can create your report. There is no limit on how many templates you can make.

To create a template click the add button in the top right corner of the screen and name your new template. You will then be taken to the template creation page.

Screenshot_2019-02-05_at_15.07.58.png

Here you can add various charts, graphs, and text boxes by clicking on the blue add symbols. If you click the blue add button, you will have a popup window where you define:

  • the type of widget (trend, pie chart, table, free text, gauge, or fund information)

  • the data set (where the chart gets its information from)

  • size (1x2, 1x1, 2x3 etc.)

  • widget title (what you want to name this section of the template)

These options may change depending on the widget that you choose.


To create a new report, click the add button in the top right corner. You can then either choose to add a new template or a new report. Remember you must create a template first. If you choose a new report, you will get a pop up where you will select:

  • a report’s period

  • which portfolio the data is pulled from

  • the report’s language

  • which template you want to use

The author of the report (you) is automatically added to the report. Once you click create, the report is generated based on your already designed templates.

 

Available widgets

Trends: Yield

This option allows you to create a trend graph based on your yield for the portfolio. It will show the percentage per quarter for the entire portfolio, NOI € / (most recent) Property value € '100.

Pie Charts: Investment

Breakdown based on market value. Slices of the pie that show property's names have more than 5%. The properties with a  5% share or lower are combined as “Others”.

Pie Charts: Biggest Tenants

Braekdown by annualized rents. Values bigger than 5% are shown separately per tenant, with the tenant’s name. Those smaller than 5% are shown as a one pie slice called “Others”.

Pie Charts: Investment Strategy

The breakdown by strategy is also a pie chart. The acquisition value is based on the combination of the entire fund’s acquisition values and is broken down by strategy. The pie chart shows the strategy share in percentages. Strategies can be edited via the tab in the property view.

Table: Rent Roll

This table chart shows:

  • Property name

  • Number of tenants: the amount of tenants for that property

  • sum of leased area: the total amount of your leased area

  • sum of vacant area: the total amount of the vacant area  

  • your total rent income: the total rent amount you make from your leases

  • Vacancy: the percentage of empty leases you have for the property

  • the vacancy amount: the amount of money lost due to the empty leases

  • Maturity: the maturity of your property

  • main tenant: the most profitable tenant of your property

  • leased area of the main tenant: the area leased to your main tenant

  • total rental income (main tenant): how much your main tenant brings in

  • the main tenant’s rent in %: the percentage compared to your total rent roll  

You can hide some data points by clicking the three lines in the upper right corner.  This chart shows up 12 lines at the time and you can view the rest of the lines if you scroll down.

Fund Information:

Fund Information data is partially automated but all of the data can be edited by clicking the pen icon. You can also delete a section if you don’t want it to be included by clicking the X next to the desired field.

Included data fields:

  • Currency: this is a drop down menu that offers all 19 currencies that Assetti supports

  • Market value: this comes from the main factsheet

  • Risk Rating: this come from the ‘info’ section of your portfolio factsheet

  • Equity in the company: this fund’s stake in the company as a whole

  • Bank Loans

  • Loan to value: amount necessary to receive a down-payment

  • Interest rate protection (%): protection against a rise in the standard interest rate

  • Committed Capital: an agreement for an investor to contribute money to the fund

  • Allocated Equity: capital assigned to specific accounts or purposes

  • Non-Allocated Equity: capital not assigned to specific accounts

  • Investors: how many investors you have for this fund

  • Number of properties: the properties included in this fund

  • Gross lettable area (m2):  the amount of space available to be rented

  • Occupancy rate (%): how much of your property is currently leased

  • Number of tenants: the tenants included in this fund

  • Maturity: The period when a debt must paid for the fund

Free text:

This is an open text box for free text. By clicking the editing pen icon, you can use the basic formatting tools: bold, cursive, underline, under and upper “index” number, numbered lists and bulleted lists, and hyperlinks.

After you have entered text, click save to save written text to the report. You can continue to edit the text afterwards by clicking the pen icon again.

Gauge: Maturity

This gauge shows the average maturity for the entire fund portfolio.

Screenshot_2019-02-05_at_13.54.00.png

When creating a fund report, remember:  

  • The portfolio type needs to be “fund.” It can be changed by going to ‘portfolio,’ then ‘General information,’ and then change the type to “Fund.”

  • You must have the fund report setting enabled from our side. This tool comes with the ‘professional’ and ‘enterprise’ plans. Click here to contact us for more information.

  • The charts and graphs require a wide data set in Assetti to be shown correctly

  • If you are unable to add a widget’s size, this may be due to other widgets you have already selected. Consider either moving the widget somewhere else or deleting others to make enough room.

  • To edit or delete a widget after adding it in the template, click the three dots in the top right hand corner of the desired widget.

Screenshot_2019-02-05_at_15.04.39.png



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.