Why the rent roll is the most important document in the data room
Walk into any institutional acquisitions war room at 11pm and you will find the rent roll open on three screens. The T-12 sits next to it. The offering memorandum is closed. The appraisal is closed. The environmental report is closed. The rent roll is the document every model, every scenario, every risk memo traces back to.
There is a reason for this. Every other document in CRE diligence is either derivative of the rent roll (T-12, budget, appraisal) or ancillary to it (environmental, title, physical condition). The rent roll is the primary source. Get it wrong (miss an escalation, mis-code a reimbursement, carry a vacated tenant as occupied) and every downstream number is wrong.
What a rent roll actually is
A rent roll is a point-in-time schedule of every leased and vacant unit at a property, with the economic terms of each lease laid out side by side. It is a snapshot, run on a specific date, typically the last day of the most recent month, that answers three questions:
- Who is paying rent, and how much?
- When does each lease expire?
- What is vacant?
For institutional buyers, it also answers the follow-ups that determine whether a deal pencils:
- What are the escalations?
- Who pays which operating expenses?
- Which tenants have renewal or termination options?
- What concessions are in place?
- What is the weighted average lease term (WALT)?
A rent roll is not an operating statement. It does not tell you what was collected. It tells you what should be collected under the leases as they stand today.
Example of a rent roll: multifamily sample
Multifamily rent rolls are the simplest. One tenant per unit, short leases, no reimbursements, no options. A clean multifamily rent roll looks like this:
| Unit | Type | Sqft | Tenant | Lease Start | Lease End | Base Rent | Concession | Other Charges | Security Deposit | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 1BR/1BA | 720 | Chen, M. | 2025-08-01 | 2026-07-31 | $1,850 | N/A | $45 pet | $1,850 | Occupied |
| 102 | 1BR/1BA | 720 | Rivera, A. | 2025-11-15 | 2026-11-14 | $1,895 | $500 (mo 1) | N/A | $1,895 | Occupied |
| 103 | 2BR/2BA | 1,040 | Patel, S. | 2024-06-01 | 2026-05-31 | $2,450 | N/A | $75 parking | $2,450 | Occupied |
| 104 | 2BR/2BA | 1,040 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Vacant |
| 105 | Studio | 540 | Johnson, K. | 2025-04-01 | 2026-03-31 | $1,495 | N/A | N/A | $1,495 | Occupied (MTM) |
| 201 | 1BR/1BA | 720 | Nguyen, T. | 2024-09-01 | 2026-08-31 | $1,825 | N/A | $45 pet | $1,825 | Occupied |
| 202 | 1BR/1BA | 720 | Ortiz, L. | 2025-02-15 | 2026-02-14 | $1,800 | $1,000 (mo 1) | N/A | $1,800 | Occupied |
| 203 | 2BR/2BA | 1,040 | Williams, D. | 2024-12-01 | 2026-11-30 | $2,495 | N/A | $75 parking | $2,495 | Occupied |
| 204 | 2BR/2BA | 1,040 | Kim, H. | 2025-03-01 | 2026-02-28 | $2,475 | N/A | N/A | $2,475 | Occupied |
The columns that matter: unit identifier, unit type, square footage, tenant, lease dates, base rent, concessions, other charges, security deposit, and status. That is roughly ten columns. For market-rate multifamily, that is enough.
For affordable housing, LIHTC deals, or military housing, add income restrictions, AMI percentages, subsidy sources, and income-certification dates. The complexity lives in the program compliance, not in the lease structure.
Office, retail, and industrial: rent rolls get complicated
Commercial rent rolls are not harder because there are more tenants. They are harder because each tenant has a genuinely different economic structure. A single-tenant industrial NNN lease is nothing like an office lease with a modified gross structure and a TI allowance, which is nothing like an anchor retail lease with percentage rent and a co-tenancy clause.
Three structural differences from multifamily:
1. Reimbursements. Commercial tenants pay some share of operating expenses, taxes, and insurance on top of base rent. The structure (NNN, modified gross, full service, base year stop) determines who bears which cost. An office tenant on a modified gross lease with a 2025 base year is economically very different from an identical tenant on a straight NNN lease, even at the same face rent.
2. Escalations and options. Commercial leases run 5 to 20 years with annual or periodic bumps: fixed dollar, fixed percentage, CPI-indexed, or fair-market reset. They also carry renewal options, termination options, expansion rights, rights of first refusal, and co-tenancy provisions. Every one of these affects value.
3. Capital commitments. Office and retail leases often include tenant improvement (TI) allowances, moving allowances, and free rent periods. These are negative cash flows on day one that shape actual yield, and you do not see them on a base-rent-only rent roll.
The 20 columns that belong in an institutional commercial rent roll
A rent roll that only shows tenant, square feet, base rent, and expiration is a summary. For an institutional-quality commercial rent roll, expect 15 to 20 columns:
- Suite / Unit ID: unique identifier
- Tenant name: legal entity, not DBA
- Tenant parent / guarantor: credit depends on this
- Square footage: rentable, not usable
- % of building: for pro-rata reimbursement math
- Lease commencement date: rent-commencement, not execution
- Lease expiration date: the base term end
- Months remaining: calculated field, point-in-time
- Base rent (current): monthly and annual, $/SF
- Rent step schedule: future bumps with effective dates
- Escalation structure: fixed, CPI, FMV, or none
- Reimbursement type: NNN, MG, FSG, base year stop
- Base year: if applicable (gross or MG leases)
- Expense stop: $/SF threshold above which tenant pays
- Percentage rent breakpoint: retail only
- Free rent / concessions: current and future abatements
- TI allowance: unfunded balance and deadline
- Security deposit / LOC: amount and form
- Renewal options: count, length, rent structure
- Termination / kickout options: trigger dates and conditions
- Use clause / exclusivity: retail and anchor-dependent
- Occupancy status: occupied, vacant, dark, subleased
A clean rent roll makes each of these a dedicated field, not a comment buried in a notes column. “NNN with base year stop at 2024 expenses plus 3% fixed bumps through 2029” is not a rent roll entry: it is four columns collapsed into one and guaranteed to be mis-modeled downstream.
The common rent roll issues we see every deal
After processing rent rolls on hundreds of institutional deals, the same issues appear again and again. The four most common:
1. Missing or inconsistent escalation dates. The lease says rent bumps on each anniversary. The rent roll shows the current rent but not the step schedule. A modeler who does not open the lease assumes flat rent and underwrites 10% low on forward cash flow. This is a common rent roll error, and it is almost always benign on the seller’s side: the property manager runs the rent roll off current billing, not projected.
2. Ambiguous NNN vs modified gross. The rent roll carries a single “lease type” column with values like “NNN,” “MG,” “Gross,” and sometimes just “Net.” Without a base year, expense stop, or list of recovered expenses, you cannot tell whether the tenant pays operating expenses directly, reimburses CAM only, or reimburses a pro-rata share above a base. Three leases described as “MG” can produce three different underwriting outcomes.
3. Inconsistent unit counts. The rent roll shows 142 units. The T-12 implies 140 units billed. The appraisal says 144 units. The offering memo says 142. Somewhere between subdivided units, model units, down units, and staff-occupied units, the truth lives. Institutional buyers reconcile this before they touch the model.
4. Stale tenant data. A tenant vacated in Q2, the next lease signed in Q4, and the rent roll still shows the Q2 tenant as occupied because the property manager has not updated the master record. You see this most often on rent rolls pulled from Yardi or MRI without a property-level reconciliation. Cross-check against current delinquency reports and the T-12.
Less common but equally damaging: misclassified subleases, undisclosed side-letter modifications, and early renewals that were signed but never memorialized on the rent roll.
How sophisticated buyers stress-test a rent roll
Five checks separate an institutional underwrite from a back-of-envelope. Run them in this order:
1. Tie the rent roll to the T-12. Annualize base rent from the rent roll. Compare to the rental income line on the trailing-twelve-month operating statement. For stabilized properties, expect the rent roll to be 2–6% higher than the T-12 (loss-to-lease, concessions, vacancy). If the delta is larger, something is wrong: either the rent roll is aspirational, the T-12 is dirty, or there is significant collection or vacancy loss the offering memo is not flagging.
2. Stack lease expirations by year. Plot rollover as a percentage of total base rent and total square footage. More than 25% rolling in a single year is a concentration risk. More than 40% rolling within the hold period changes the capital plan materially. Flag anchor tenants and any tenant over 10% of NOI.
3. Compare in-place rents to market comps. Pull brokerage comps for similar product in the submarket. Quantify loss-to-lease or rent premium. A portfolio 15% below market is an opportunity. A portfolio 20% above market is a problem: those tenants will reprice at renewal, and your exit assumptions need to reflect that.
4. Flag credit risk and month-to-month tenants. Pull D&B and PACER on top tenants. Flag anything on month-to-month, any retail tenant below a franchise-grade threshold, and any office tenant whose parent filed within the last 24 months. Month-to-month is not automatically bad, but if your top-five tenants are all MTM, you have a different deal than the one the OM describes.
5. Reconcile occupancy. Physical occupancy (bodies), economic occupancy (paying rent), and leased occupancy (signed leases, including pre-leases not yet commenced) are three different numbers. Make sure the rent roll shows you all three.
For the full underwriting walkthrough, see our guide to commercial real estate underwriting.
Rent roll vs operating statement: different documents, different purposes
Analysts new to CRE sometimes treat the rent roll and the operating statement as two versions of the same document. They are not.
| Rent Roll | Operating Statement (T-12) | |
|---|---|---|
| Time horizon | Point-in-time snapshot | Trailing 12 months of history |
| Unit of analysis | Lease / unit | Month / line item |
| What it shows | Contractual terms as of today | Actual revenue and expenses collected |
| Primary use | Underwriting future cash flows | Validating recent performance |
| What it does not show | What was actually collected | Lease-level economics, escalations, options |
The rent roll tells you what the leases promise. The operating statement tells you what the property delivered. A good underwrite requires both, and the interesting signal lives in the delta between them.
If your rent roll says $3.6M annual base rent and your T-12 says $3.2M collected rental income, the $400K gap is your diligence scope. Is it loss-to-lease from concessions? Unbilled escalations? Collection loss? Bad debt write-offs? Subleases at below-market rents that the owner absorbed? The answer shapes the hold period underwriting.
For a structured approach to reading the T-12 alongside the rent roll, see our real estate pro forma guide.
Where Atlas fits: extracting and normalizing rent rolls in minutes
Most institutional deals begin with a rent roll PDF delivered by the seller’s broker. It is almost never in the format your underwriting template expects. Units are in a different order. Columns are labeled differently. Reimbursements are coded with the seller’s property manager shorthand. Half the escalation schedules live in the notes column.
The old workflow is a junior analyst spending six to ten hours rekeying it into a canonical template, then another analyst reconciling against the T-12, then a third pass flagging anomalies. By the time the model is clean, you have burned two days and are already behind on the bid deadline.
Moraine replaces that workflow. It reads the rent roll PDF (and the underlying lease PDFs when available), extracts to a canonical 20-column schema, normalizes reimbursement codes, reconciles against the T-12 automatically, and flags anomalies (missing escalations, stale tenant data, unit-count mismatches, rollover concentration) before an analyst sees the file. What used to take two days runs in under an hour, before the kickoff call.
That changes how a deal starts: a clean, reconciled rent roll on day one instead of day four.
See how Atlas handles the broader diligence pipeline in our commercial real estate due diligence guide, or explore our deeper write-up on rent roll software and lease abstraction templates.
The bottom line
The rent roll is the document every institutional model builds on, and the quality of the rent roll determines the quality of the underwriting. For multifamily, ten clean columns are enough. For commercial, 15 to 20 columns are the institutional standard: anything less is a summary, not a rent roll.
Before you trust a rent roll, stress-test it: tie it to the T-12, stack the expirations, benchmark to market, flag credit risk, and reconcile occupancy. The anomalies are where the real deal lives.
Before a human analyst spends a day keying it into Excel, run it through an AI extraction pipeline.
See how Moraine extracts and normalizes rent rolls in minutes →