Due Diligence
Rent Roll Data Quality Checklist
A 10-point scoring framework for analyzing rent roll data quality and consistency before you underwrite a CRE acquisition.
Why Rent Roll Data Quality Matters
Every CRE acquisition model starts with the rent roll. It feeds your NOI calculation, your cap rate, your debt sizing, and your hold-period returns. If the rent roll data is wrong, everything downstream is wrong — and you won't discover it until after you've closed.
The problem is that rent rolls arrive in every format imaginable — Excel exports from Yardi, PDFs from MRI, or hand-typed spreadsheets from on-site managers. There is no universal standard. This means data quality problems are the norm, not the exception, and the buyer is responsible for catching them.
The 10-Point Rent Roll Quality Checklist
Use the interactive scorer below to evaluate your rent roll. Each check is weighted by its impact on underwriting accuracy — a rent-to-T-12 mismatch is more dangerous than a missing security deposit:
Interactive Tool
Rent Roll Health Score
Check each item your rent roll satisfies to calculate a data quality score.
0 of 10 checks passed — Significant data quality issues. Do not underwrite without remediation.
Check 1: Freshness — Is the Rent Roll Current?
A rent roll should be dated within 30 days of your analysis. Anything older than 60 days is unreliable — tenants may have moved out, new leases may have commenced, or amendments may have changed rent schedules. During active due diligence, request a refreshed rent roll at least twice: once at LOI and once within 5 days of closing.
Red flag: A seller who is slow to produce an updated rent roll may be buying time to paper over vacancy or delinquency issues.
Check 2: Completeness — Every Unit Accounted For
The number of line items on the rent roll should match the physical unit or suite count. Walk the property or check against building records to confirm. Missing units could mean unreported vacancy. Duplicate entries inflate reported income. For multifamily, check unit numbers against the property's tax records or BOMA measurement records for commercial properties.
Check 3: Income Consistency — Rent Roll vs. T-12
This is the highest-impact check. Annualize the rent roll total (sum of monthly rents times 12) and compare it against the trailing-12-month operating statement (T-12). They should be within 3% of each other.
Common causes of divergence:
- Concessions not on the rent roll — Free rent periods reduce collected income but may not appear as line items.
- Recent tenant turnover — A move-out mid-year creates a gap between annualized current rent and actual collected income.
- Non-recurring T-12 income — One-time fees, lease termination payments, or insurance recoveries inflate the T-12 above sustainable income.
- Delinquent tenants — The rent roll shows contractual rent; the T-12 shows what was actually collected. The gap is bad debt.
Check 4: Lease Dates — No Blanks, No Holdovers
Every tenant row should have commencement and expiration dates. A blank expiration date may mean the lease has expired and the tenant is on a month-to-month holdover — which is at-will occupancy, not secured income. Holdover tenants can leave with minimal notice and should be underwritten as vacancy risk, not stabilized income.
Also verify escalation dates are populated. If base rent increased on January 1 but the rent roll still shows the prior year's rate, you're underwriting with stale economics.
Check 5: Concession Transparency
A rent roll that shows $50,000/month in face rent may produce only $35,000 in actual cash flow once free rent periods, TI amortization, and move-in concessions are accounted for. If the rent roll does not break out concessions as separate line items, request a concession schedule. Then calculate net effective rent — the number that actually matters for underwriting.
For multifamily, check whether the rent roll shows face rent or concession-adjusted rent. In markets with heavy concession activity, the gap between the two can exceed 10%.
Check 6: Security Deposit Verification
Security deposits transfer to the buyer at closing. Verify that the deposit amounts on the rent roll match the lease terms and that the aggregate is reflected on the seller's balance sheet. Missing or short deposits may indicate prior applications against unpaid rent — a signal of historical delinquency the seller may not have disclosed.
Check 7: Square Footage Consistency
Every per-square-foot calculation in your model — rent PSF, expense PSF, TI PSF — depends on accurate area figures. Cross-reference the rent roll's square footage against lease documents and building measurement records. For office properties, confirm which BOMA measurement standard was used. A building measured under BOMA 2017 will show different rentable areas than one using legacy standards.
Check 8: Lease Expiration Distribution
Build an expiration schedule from the rent roll and look for clustering. If more than 25% of revenue expires in a single quarter, you face simultaneous re-leasing risk, capital expenditure spikes for tenant improvements, and potential downtime. Healthy portfolios distribute expirations across the calendar year with no single quarter exceeding 15–20% of revenue.
Check 9: Tenant Concentration
If a single tenant represents more than 25% of gross rental revenue, the property's value is disproportionately dependent on that tenant's credit quality and renewal intent. This isn't automatically a problem — a credit-rated anchor tenant on a long-term lease can be a strength — but it changes how you model downside scenarios. Quantify the revenue concentration on the rent roll and stress-test your model with a vacancy scenario for the largest tenant.
Check 10: Estoppel Cross-Reference
The final quality check is external validation. Estoppel certificates are signed tenant confirmations of their lease terms. Cross-reference the rent, dates, deposit, and option fields on each estoppel against the corresponding rent roll entry. Any discrepancy means either the rent roll is wrong, the tenant's understanding of the lease is wrong, or an undisclosed amendment exists. All three require investigation.
Benchmarks: What Good Looks Like
Use these thresholds as reference points when evaluating rent roll health:
| Metric | Healthy Range | Red Flag |
|---|---|---|
| Physical occupancy | 93–96% | Below 88% or above 99% |
| Economic vs. physical occupancy gap | 2–4 percentage points | Gap wider than 6 points |
| Rent roll vs. T-12 variance | Within 3% | Greater than 5% |
| Month-to-month tenants | Under 15% of revenue | Over 20% of revenue |
| Single-quarter expiration concentration | Under 20% of revenue | Over 25% of revenue |
| Largest tenant concentration | Under 20% of revenue | Over 30% of revenue |
| Rent roll age | Under 30 days | Over 60 days |
How LeaseParse Helps
Rent roll verification depends on having accurate lease abstracts to cross-reference against. LeaseParse extracts 50+ fields from commercial leases — rent schedules, escalations, concessions, option rights, and square footage — giving you the structured data needed to validate every line on the rent roll. Abstract a lease or compare pricing.
FAQ
How often should a rent roll be updated during due diligence?
Request a rent roll dated within 30 days of your letter of intent, and again within 5 days of closing. Any rent roll older than 60 days should be treated as unreliable — move-outs, amendments, and new leases may have changed the income picture since it was generated.
What is the difference between physical and economic occupancy on a rent roll?
Physical occupancy counts occupied units regardless of payment status. Economic occupancy measures actual collected revenue as a percentage of gross potential rent. A property can show 95% physical occupancy but only 88% economic occupancy if tenants are delinquent or receiving concessions. The gap between the two is one of the most important data quality signals in a rent roll.
How do you reconcile a rent roll against a T-12?
Annualize the rent roll (monthly rents times 12) and compare the total against the trailing-12-month income statement. They should be within 3% of each other. Larger gaps indicate concessions not reflected in the rent roll, recent tenant turnover, or one-time income items inflating the T-12. Investigate every material variance line by line.
What rent roll red flags should kill a deal?
No single red flag is automatically fatal, but combinations are. A rent roll that is more than 60 days stale, shows more than 30% of revenue from a single tenant, has annualized income diverging more than 10% from the T-12, and lacks concession disclosure should trigger serious reconsideration. The cost of remediation and re-underwriting may exceed the deal margin.