Rent roll & financial data
How EQUIRE's Rent Roll and Extracted Data tabs turn parsed documents into clean tenancy and T-12 inputs before valuation finalization.
After Document ingestion, most teams spend time in Rent Roll and Extracted Data normalizing what the pipeline extracted. Quality here directly drives Valuation DCF assumptions and IC Memo credibility.
Questions this workflow answers
- Who pays rent, how much, and when do leases roll?
- How concentrated is cash flow by tenant?
- Is headline occupancy masking weak credit or near-term rollover?
- What does in-place T-12 performance imply for stabilized NOI and risk?
Rent Roll tab
- Loads tenant rows from the canonical deal schema.
- Sort by tenant, suite, SF, rent, start date, end date.
- Inline edits for quick cleanup; delete spurious duplicate rows from bad extraction.
- Spreadsheet export for offline review or sharing.
Edits flow: inline edit → schema patch API → schema update → valuation / overview refresh.
Extracted Data tab (financial inputs)
Operating-statement coverage typically includes:
- Revenue lines (base rent, reimbursements, other income, EGI)
- Expense lines (taxes, insurance, utilities, repairs, management, total OpEx)
- NOI and related below-the-line fields when present
Use this surface to align T-12/T-3 periods with the documents you trust most.
Link to valuation
The model consumes tenancy and T-12 signals for, among other things:
- Market rent and growth
- Stabilized occupancy
- Expense ratio and expense growth
- Leasing and downtime assumptions
Re-run valuation (or relevant analyst steps) after material rent-roll or NOI corrections so downstream assumptions and memos stay coherent.
QA checklist before IC
- Top tenants by rent / SF match source docs.
- Major tenant lease expirations are correct.
- Vacant vs occupied labeling is honest (no false occupancy).
- Total SF and occupied SF tie out.
- Operating period and NOI look reasonable for the vintage and quality story.
- After large edits, refresh valuation and re-check scenarios.
Common failure modes
- Duplicate tenants from multi-document merges.
- Missing lease ends from thin abstracts.
- Monthly vs annual rent unit confusion on manual fixes.
- Vacancy or pseudo-tenant rows mis-labeled as named tenants.
Fix in Rent Roll / Extracted Data, then re-run affected valuation work — see Valuation DCF for sensitivity and scenario behavior.
Related
- Document ingestion — extraction, conflicts, and review.
- IC Memo — narrative consumes these numbers.
Last updated on
Document Ingestion
How EQUIRE turns uploaded OMs, rent rolls, and operating statements into a structured deal record — pipeline stages, upload limits, reconciliation, embeddings, and valuation seeding.
Valuation DCF
How EQUIRE builds institutional-grade DCF models — the 10-step analyst pipeline, SOURCE_PRIORITY, scenarios, sensitivity (in-app vs Excel), and API hydration guardrails.