Valcre Office: Data Recapture

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 

1. Subscription Tier: Professional and Enterprise
2. Data Recapture must be purchased and enabled
   • 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.
3. Completed RentRoll sheet.
4. Completed IE_IN (Income and Expense) sheet

Step 1: After completing all other sheets in the Valuation Workbook, select DataRecapture from Load Modules in the Valcre Ribbon.  

The two tables 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. 

Additional Questions?  Valcre Support is ready to help with all your Valcre product questions! You can connect to us via phone, email, or chat!