What does reconciling the rent roll against the leases actually catch?

Four categories, and they need separating: unapplied escalations, active concessions, billing errors, and arrears. They look identical in a variance column and mean very different things — an unapplied escalation is recoverable revenue, arrears is a collection problem.

How does this handle a rent roll with no stated as-of date?

It is flagged rather than assumed. Every lease analytic — WALT, expirations, month-to-month exposure — is measured from the roll's as-of date, so a missing one changes what the numbers mean. See WALT.

Is the output usable directly in an underwriting model?

That is the intent: validated in-place rent with escalations projected, so the rent line is a fact from the rent roll rather than a figure retyped from a PDF. See gross potential rent for why the rent roll rather than the T-12 owns that line.

How to Automate Rent Roll Analysis with AI

Workflow Guide

Last updated 2026-03-122 min readWorkflow Guides

The Problem

Rent roll analysis during acquisition due diligence requires comparing every tenant's contracted rent (from the lease) against actual collections (from the operating statement), identifying variances, and understanding whether discrepancies represent billing errors, concessions, arrears, or other factors. For a 50-tenant property, this manual cross-reference is a long, tenant-by-tenant exercise.

Step-by-Step Automation Workflow

Extract the rent roll

Extract rent roll data from the property's management system export or PDF rent roll.

Abstract rent, escalations and concessions from the leases

Abstract base rent, escalation history, and concession terms from each tenant's lease.

Reconcile contracted rent against the rent roll

Automatically reconcile lease-contracted rent against rent roll figures.

Categorise every discrepancy

Flag discrepancies by category: unapplied escalations, active concessions, billing errors, or tenant arrears.

Produce the variance report with lease citations

Generate a variance report with lease-source citations for every discrepancy.

Output an underwriting-ready rent roll

Produce an underwriting-ready rent roll with validated in-place rent and projected escalations.

Time Saved

The rent roll and the operating statement are read from the documents rather than re-keyed, and each figure keeps the document it came from, so review goes to the variances rather than to assembling the comparison

Cost Impact

Identification of revenue uplift from unapplied escalations and billing corrections

Frequently Asked Questions

Automate This Workflow

See this workflow in action with your documents

Crevanta provides the extraction and structuring foundation that makes CRE workflow automation possible.