When mapping the historical data on the Source Data page, the Calculated NOI and Original NOI appear at the bottom of the screen. After the entire statement has been mapped, these two numbers should match for every month. If they don't match, the first thing that should be checked is if all data was mapped correctly. The most common mistake is that a line item was accidentally left blank or a subtotal row was mapped so the data is being double counted. If the data has been mapped correctly and the NOI numbers still don't match, there are a few potential issues.


One possible issue is that the incorrect row was selected as the first expense row. When historicals are added, the first expense row must be identified. The platform will recognize all lines above that row as revenues and all lines below it as expenses. It will automatically determine if the sign (+/-) of the expenses needs to be "flipped" from positive to negative, but it will treat all revenues as they are entered. All revenue rows are highlighted white in the Source Data and all expenses are beige. If the first expense row needs to be changed, right click on the row in the Source Data and choose to Mark Selected Row as First Expense.



Positive rental loss factors in the Revenue section of the operating statement could be another issue. As mentioned above, all positive revenue numbers will be added and negative revenue numbers will be subtracted. The rental loss factors such as vacancy and loss to lease are almost always entered as negative numbers. However if they are entered as positive numbers that should be subtracted, redIQ will add these as positive numbers instead of subtract them. To fix this, change the numbers in the Excel file from positive to negative before loading the data to redIQ. If a statement has already been loaded and mapped in redIQ, there is no need to delete it. Once changes have been made in Excel, the new data can be copied and pasted in again, then a notification will appear asking if you’d like to overwrite the existing data. Say yes and then an option to apply mappings from the deleted statement will appear. This will ensure you don’t need to redo the work of mapping the line items to your chart of accounts.


Another potential issue is that the NOI provided in the original statement is incorrect. Check the math in the original statement to ensure the listed NOI is correct.