How can we help?

KPI: Income Statements Dashboards

Part of the IMS Key Property Insights Offering, the Income Statements Dashboard provides a standardized view into the financial data uploaded from your accounting system. This guide will discuss the views included within the offering and how to download the reports.

Income Statement

This view allows you view a couple different standard reports by selecting the Income Statement Type drop down menu with options that include: Actual statement, Budget statement, Variance between the Actual and Budget statement, and a Per Unit or square feet report for all. Default view aggregates all properties together, but by hovering over the headers a negative/plus sign box will appear that will allow the user to drill up and down into the segments and individual properties as well as the account codes if that level of detail is wanted.

income_statement.png

income_statement_2.png

Property Comparison

This view allows you compare properties by listing them at the top of the sheet and having the different line items on the side. You can compare your properties in a couple different ways by selecting the Income Statement Type drop down menu with options that include: Actual statement, Budget statement, Variance between the Actual and Budget statement, and a Per Unit or square feet report for all. This will be aggregated for the date range selected.

property_comparison.png

 

To compare Segments, the user has the ability to drill up and down by hovering over the header to which a minus/plus sign box will appear. This will aggregate the data for those properties that are in that Segment.

property_comparison_2.png

 

Budget Comparison

This view provides Actual versus Budget metrics for Month to Date, Quarter to Date, and Year to Date. This will be aggregated across all properties selected by the filters on the left-hand side.

budget_comparison.png

Portfolio Financial Report

This is a comparison view that allows the user to compare the properties on the left-hand side along with the Metric totals for Actual, Budget, Variance, and Variance Percentage. The Metric totals options include: EGI, OpEx, NOI, Non OpEx, and Per Unit or square feet for all.

portfolio_financial.png

Rent Roll

This view shows each property and its Physical Occupancy that is received from the Rent Rolls each month.

CoA Mapping

This view is the Chart of Account mapping that we perform internally. This allows the user to see how we are categorizing the various account codes and descriptions that are sent from the accounting systems.

 

How to Download the Data as an Excel file

Follow these steps to access the Excel view for the reports:

  1. Click the Export button on the top right
  2. Click the Download button
  3. A CSV file will be downloaded into your browser’s download directory

download_excel.png

Screen_Shot_2019-03-07_at_11.14.54_AM.png

How to Download the Data as a PDF

Follow these steps to access the PDF view for the reports:

  1. Click the Print button on the top right
  2. Choose your layout size (Landscape recommended)
  3. Click Generate
  4. Click Download
  5. A PDF will be downloaded into your browser’s download directory

print_2.png

2.png

3.png

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