Every deal in IntellCRE has a Sales Comps tab and a Rent Comps tab. Each tab shows your comps on a map and in a table with the data points for each comp. This article covers how to get comps into the system, how to manage and edit them, and how they show up in your marketing materials.
Getting Comps into IntellCRE
There are several ways to add comps to a deal. Use whichever fits your workflow.
Upload them when you create the deal. This is the easiest method. When you create a new property and upload files to the data room in the first step, include any documents that contain comps. That could be a PDF, a CoStar export, a comps tab in your setup sheet or underwriting model, a separate spreadsheet, a Word document, or any other format. The comps are pulled out automatically while the deal is being created.
Upload them to Documents later. If you didn't include comps at the start, you can upload the file to the property's Documents at any time. When IntellCRE finds information you may want to import, it will let you know. Choose to import it, and any sales or rent comps will be added to the right tab automatically.
Upload them from the comp tabs. On the Sales Comps or Rent Comps tab, click Upload comps. Add Excel, PDF or image files (PNG, JPEG, WebP or GIF), like a screenshot of a comp table. IntellCRE reads each file and each Excel sheet and finds the comps in it. Click Import Sales Comps or Import Rent Comps.
Your files process in the background, so you can close the window and keep working. When they're ready, choose Use all as comps for this property (they're also saved to your comp library) or Add to comp library only.
IntellCRE automatically skips incomplete duplicate rows, so you don't end up with half-filled copies of the same comp.
Copy and paste. The comp table works like an Excel table, so you can copy a table from a spreadsheet and paste it straight in.
Add comps manually. Click + Create to add comps one at a time.
Search on the map. Click Search on Map to search IntellCRE's internal databases. (In the brochure builder this button is called Search Comps on Map.) You can narrow the results with filters, or use the polygon tool to draw an area, like a specific neighborhood, and see only the comps inside it. On the Rent Comps tab, the filters are tailored to rent and lease comps.
AI Suggest. Tell the AI how many comps you want and which characteristics matter most. It then searches your internal comp database, the web, or both. In the brochure builder, this is called AI Comp Search. See Making Changes Mid-Deal for the options.
Managing and Editing Comps
Once your comps are imported, they appear in the table on the comp tab. You can fully customize the table. Default columns include a photo, name, address, sold date or status (for example, "On Market" for an active listing rather than a confirmed sale), sale price, number of units, unit mix, square footage, cap rate, and more. You can add new columns for other data points, change the column order, and hide columns you don't need.
Show $/unit and $/SF. Click + at the end of the column headers and pick $/unit or $/SF under Columns. These are calculated from each comp's sale price, units and rentable area, so fill those in first.
Add a custom column. Click + and choose Create new custom column….
Remove a column. Hover over the column header, click …, and choose Hide column. A custom column you create is a data field for your whole organization. To remove it everywhere, go to Settings > Deals > Data Fields, open the field's … menu, and choose Archive or Delete permanently. You need data fields permission to do this.
Averages and the subject property's data appear at the bottom of the table.
You can edit, add, or remove comps at any time. You can also edit values directly in the table, such as changing the number of units.
Map view. Use the map controls in the bottom-right corner to zoom and position the map. Click Save new map zoom and position to make that view the default for your deck. You can still adjust the map in the deck afterward.
If you need to change your comps later, go back to the deal's Sales Comps or Rent Comps tab and edit them there.
The Comp Library
To see all the sales and rent comps for your whole organization in one place, go to Properties > Comp library. Click Import comps to bulk import full comp reports. You don't need to sort them first. IntellCRE finds the sales and rent comps in each file and labels them, and you can change the Sales and Rent labels before you import. You can also sort the library, and manage and update comps over time. Past deals you've run through IntellCRE can also be used as comps.
How Comps Appear in Your Marketing Materials
When you build a deck for a deal, your comps are added automatically. The Sales Comps section includes a comp map, a sales comp summary table, and detailed sales comp pages. The Rent Comps section includes a rent comp summary table and detailed rent comp pages. Every table is fully editable in the deck, so you can change photos, text, and the table itself as needed.
Need help?
If you have questions about working with comps, email us at [email protected].