Comparables Database

Build a searchable database of comparable evidence from document extractions, sold properties, and standalone comparable schedules.

Where Comparables Come From

  1. Document extraction — When brochures mention recent transactions, the AI extracts them automatically.
  2. Sold properties — When you mark a property as sold, a comparable record is created with verified transaction details.
  3. Comparable schedules — Upload a standalone spreadsheet and each row is extracted as a separate comparable.

Deduplication

  1. Exact match — Same address and date are merged automatically
  2. Fuzzy match — Similar addresses with close dates are flagged for review
  3. Manual merge — You can merge duplicates from the comparables list view

Data quality

Comparables from sold properties are marked as "Verified". Extracted comparables are marked as "Extracted" — always cross-reference with original sources for formal valuations.

Browsing & Filtering

  • Sector — Office, Industrial, Retail, Mixed Use, etc.
  • Location — City or postcode area
  • Date range — Filter to transactions within a specific period
  • Price range — Minimum and maximum transaction values
  • Yield range — Filter by net initial yield

Uploading Comparable Schedules

  1. Go to Upload in the sidebar
  2. Select your Excel file containing transaction data
  3. Choose Comparable Schedule as the document type
  4. The AI identifies columns and extracts each transaction
  5. Review the extracted comparables and save

Best practice for Excel schedules

Include headers: Address, Date, Price, Yield, Tenant, Sector. Clear headers improve accuracy.

Comparable Fields

Each comparable record can include up to 23 fields:

  • Address, city, postcode, sector
  • Transaction date, price, yield (NIY and EY)
  • Tenant name, lease terms, rent
  • Floor area, price per sq ft
  • Source document and extraction confidence