Analytics Offering Users Guide
Sponsor Metrics Dashboard
Part of the IMS Analytics Offering, the Metrics Dashboard, provides views into the financial data uploaded from your accounting system. This guide will discuss the Views included within the offering, the Filters that can be applied to the portfolio, and how to Navigate between the views.
There are many views available allowing you to drill into your portfolio to understand what is being performed and why with an increasing level of data granularity.
This view provides the default portfolio aggregation. You will see overarching metrics about your portfolio’s financials at the top with bar charts of values by month. Below that you will see NOI Actual vs Budget a Map showing your property locations. At the bottom of the view you see aggregates
Asset One Pager
This view allows you to see details about one specific property. The Attributes, Debt, and Equity sections are populated from IMS and the other items on the report pull from the accounting system data.
To get the Financial Summary section to appear on one sheet (for printing), hover over the “Category” header and press the “-“ button.
P & L Details
The Details view allows you to drill into the specified Actual and Budget values from the filters on the left.
To drill into the Account Descriptions from your accounting systems, hover over the “Description” header and press on the “+” box
Displays Economic and Physical occupancy at the portfolio level, overlaid on EGI, and within a table for each property.
This view provides details on what accounting system financial data has and has not been loaded into our database. The table at the bottom has one row for each property and provides a color-coded view into what budget and actual data has been loaded for each month.
Using dropdowns on the left of each screen, you can slice and dice your portfolio in different ways. Most views contain the same filters, with slight differences. Note, date filters applied on other views will carry over to the Asset One Pager
A multi-select dropdown with the name of each property.
A multi-select dropdown with the property types
Sub Property Type
A multi-select dropdown with the sub-property types. Note, this data must be loaded by IMS into the analytics database
A multi-select dropdown with the project status per IMS
A multi-select dropdown with the city and state together
A multi-select dropdown with MSA values that were looked-up from the associated city and states
The duration which you have owned the properties.
Allows you to select an associated date range fixed against today’s date. Note, depending upon the “Current Month” filter you may need to select additional months to get the expected number to show.
A dropdown with a variety of Trailing options (including T3, T6, and T12). Note, this filter is only available on the P&L Details view.
Segment 1 and Segment 2
These values can be used to indicate groups of properties in your portfolio, such as funds. Note, this data must be loaded by IMS into the analytics database.
Depending upon when financials are finalized, you may or may not want to see the current or prior months. This dropdown allows you the flexibility to see associated dates.
There are a couple of ways to move around the application.
The first is a drop down in the top right corner of IMS that takes you directly to each view.
To get back to the Sponsor dashboard you can click on the Home Button , or a header in any view, such as:
To get to a populated Asset One Pager, you must click on the PROPERTY NAME from a property table on either the Metrics Dashboard or the Portfolio Occupancy views.
Clicking on an Occupancy number from either the Metrics Dashboard or Asset One Pager will direct you to Portfolio Occupancy.
Operating Expense Ratio = Operating Expenses / EGI
Economic Occupancy = SUM(Gross Potential Rent + Vacancy Loss + Concessions + Loss Gain to Lease + Model Unit(s) + Subsidy Income + Commercial Income + Commercial Vacancy + Percentage Rent + Bad Debt) / Gross Potential Rent
How to download the data
Follow these steps to access the raw accounting system data used for the reports:
- Click on the Income Statements link in the left navigation
- Press the Export Button on the top right
- Click on the “Full data” tab
- Check the “Show all columns” box
- Click the “Download all as rows as a text file”
- A csv file will be downloaded into your browser’s download directory
Income Statement Report
- Timeframe (Month, Quarter, Year, Rolling 12)
- Actual, Budget and Variance
- Dates (allows user to view as far back or forward as they like)
- Active/Inactive properties
- Property Type
- Property Name
- Census Region
- Metropolitan Statistical Area