This guide will teach you how to use the Solutions sheet to recapture Expense and Rent Roll data and import it into Valcre Online as Expense and Lease Comparables, saving you time doing double entries.
Prerequisites
- Subscription Tier: Professional and Enterprise
- Solutions Sheet must be purchased and enabled
- Completed RentRoll sheet.
- Completed IE_IN (Income and Expense) sheet
- This is currently in Beta testing for a select group of customers. If you want to enable it after the testing, please contact your Client Success Manager.
Step 1: After completing all other sheets in the Valuation Workbook, select the Solutions sheet from the bottom or left navigation menu.
The two tables with the Solutions sheet you will use are:
- Subject Expense Data to Expense Comp
- Subject Rent Roll to Lease Comparable
Both tables are pre-filled using the data already entered into previous sheets within the workbook.
Step 2: Fill in additional fields that you wish to include in the import into Valcre Online.
The Subject Expense Data to Expense Comp
Optional Additional fields to fill out are shaded Yellow/Gold.
If you renamed any expense on the IE_IN sheet, you will notice a red comment above the category telling you to check it. You will need to select the expense category name from the blue shaded dropdown (row 7); this will pull data into the table. Next, select the appropriate field name for that expense category (row 9).
- Note: If you have duplicate field names, you must manually combine them.
Subject Rent Roll to Lease Comp
| Pro tip: What you enter on the Rent Roll isn’t necessarily the beginning of the lease; you must enter the actual starting rent on Primary $/SF (YR). The rest of the items are optional. Fill in as much data as you want to capture. |
Step 3: Open a new, blank Excel Workbook (not a new Valcre Valuation Workbook) and copy/paste the first table into it using the paste with special values and number formatting option.
| Pro tip: CTRL shift right arrow, down arrow CTRL C- to highlight and copy the entire table |
For the Subject Expense Data to Expense Comp table, if you used an annualized year, you must make it just a year; otherwise, you will have an error on that one value when you import it into Valcre Online.
Step 4: Save the file as a CSV file
Step 5: Using a fresh workbook, repeat the last two steps with RentRoll table
Step 6: Sign in to Valcre Online and select Create New from the top left menu.
Step 7: Select Import Properties and select the first file, followed by Import.
Step 8: Repeat the last step with the second file.
Step 9 (optional): Double-check your work by going to that property to view the comps that were added.
For additional questions about using the Solutions sheet for Data Recapture in Valcre Office, please contact Valcre Support using the live chat feature in Valcre Online or Valcre Mobile.