1. Click Add/Arrange Comps
All calculations performed on the Expense Grid are driven by the data stored within your various comparable sale records. As such, you need to click Add/Arrange Comps to begin the process for importing relevant records into your grid.
Note: Please refer to the separate help page regarding the Expense data page for N1 Web to learn more about expense data.
2. Import Your Comps
Next, you will need to follow the same procedure used to add comparable sale records into a table.
If you are unable to remember how this process is completed, click here.
3. Click Toggle Display Twice
After the data has been imported, you can exit out of the Add/Arrange Comps window; you may immediately notice that the data is not updating, or does not appear correctly.
Click Toggle Display once, wait for the layout to adjust, and then click it again to lock in any changes. Your records should then appear correctly in the grid.
The Subject column is hidden by default; if you wish to compare the Subject against your other Expense Comparables, after clicking Toggle Display once, locate the Subject column, and at the top of the column click the Hide cell, and select Show. Then click Toggle Display again.
The Subject expense information is pulled from the Income and Expense Summary worksheet. Choose the Year or Pro forma that requires display via a dropdown in the IncExp Subject Data Export table.
4. Toggle Between Assessment Tax Data and Active Instance of Inc/Exp
Users may wish to toggle between Assessment tax data or the active instance of Income/Expense for comps chosen for their expense analysis.
For the active instance of Income/Expense Tax Expense, users should choose “Tax Expense” in the first dropdown expense category within the Expense Grid.
For the Assessment data “Taxes,” users should choose “Taxes.”
Subject data within the Expense Grid will ALWAYS pull from the data entered in the Assessment worksheet.
5. Review Your Data
Once you have successfully imported your Expense Comparables, all that's left to do is simply review the information relevant to you. Each expense (Taxes, Insurance, Management, etc) has a table dedicated to visualizing that data averaged across your comparables.
You can use the Navigate function to quickly access these tables.