Learning how to read a rent roll is two skills, not one. The first is knowing what each column represents and how the columns cross-check each other. The second is reconciling every figure back to the executed lease it came from, because a rent roll is a hand-entered or software-exported summary, and any error in it propagates into valuation, debt sizing, and expense recovery. Most people learn the first skill and skip the second. That is why rent rolls are the most trusted and least verified document in commercial real estate.
Key Takeaways
A rent roll is a summary, not a source document. The executed lease and its amendments are the source of truth for every field on it.
The single most common rent roll error is a base rent that reflects the commencement rate rather than the current escalated step, which understates income on every long-dated lease.
Rentable square feet, not usable square feet, is the correct area basis. A mixed basis misstates both rent per foot and pro rata share on the same line.
A rent roll omits what it was never designed to carry: co-tenancy triggers, exclusive use clauses, go-dark rights, cure periods, and most termination options.
The rent roll must tie to the T-12. If annualized rent roll income does not reconcile to trailing rental revenue, one of the two is wrong and the gap is the finding.
What Is a Rent Roll and Who Relies on It?
A rent roll is a property-level summary listing every tenant and the lease terms that drive income: suite, area, rent, escalations, term dates, recovery method, and options. Owners use it to track income, lenders to size debt, buyers to price an acquisition, and managers to run billing. Every one of those decisions inherits its errors.
That is the reason the document deserves more scrutiny than it gets. A rent roll circulates as though it were audited output. It is closer to a working spreadsheet that has been copied forward through several owners, several property managers, and several software migrations, absorbing a transcription error at each step. Nothing in the format flags a stale field.
How to Read a Rent Roll: What Does Each Column Mean?
Reading a rent roll means knowing what each field should contain and which fields validate each other. Rent per foot validates base rent against area. Pro rata share validates area against the building total. Expiration validates against the escalation schedule. A rent roll where these do not agree has an error in at least one of them.
Column | What it represents | The read |
|---|---|---|
Suite or unit | Physical space identifier | Must match the lease premises definition |
Tenant name | Legal tenant entity | The entity on the latest assignment, not the trade name |
Rentable square feet | Billable area including load factor | Confirm the basis is rentable, not usable, on every line |
Lease start and end | Commencement and expiration | Expiration must reflect exercised renewals |
Base rent | Rent in effect today | Note whether quoted monthly or annually |
Rent steps | Scheduled future escalations | Fixed dollar, fixed percent, or index-based |
Recovery method | Base year, expense stop, or net | Blank here means recovery income is unverifiable |
Pro rata share | Tenant percent of the building | Should sum toward 100 percent across occupied area |
Options | Renewal, expansion, termination | Usually the emptiest and most valuable column |
Security deposit | Cash or letter of credit | Form matters as much as amount |
Two reads catch most problems. Divide annual base rent by rentable square feet and scan the resulting rent per foot down the column. An outlier signals a data entry error, an area error, or a deal unusual enough to read in full. Then check that the area basis is consistent: rentable area includes a share of common area through a load factor, and BOMA publishes the measurement standards that define it. A suite entered at usable area understates the space and misprices the tenant on two lines at once.
What Does a Rent Roll Leave Out?
A rent roll omits every lease provision that is not a number in a column. Co-tenancy triggers, exclusive use clauses, go-dark rights, relocation rights, audit rights, cure periods, self-help remedies, and the notice windows attached to options are all absent. So is the reason behind any number, which is where most disputes originate.
The omissions are not oversights. A rent roll is a billing and reporting artifact, and those provisions do not bill. But they price. A termination option exercisable in twenty-four months changes how a buyer values the entire building, and it will not appear on a standard rent roll unless someone abstracted the lease and carried it over. Free rent and tenant improvement allowance balances are similarly absent from most formats, which means face rent on the rent roll can sit well above effective rent.
Omitted item | Where it lives | What it changes |
|---|---|---|
Termination options | Options article | Weighted average lease term, exit value |
Co-tenancy triggers | Retail lease conditions | Rent abatement risk on anchor loss |
Free rent remaining | Rent schedule or amendment | Near-term cash flow |
TI allowance unfunded | Work letter | Capital obligation at closing |
Notice windows | Options article | Whether a renewal is still live |
How Do You Reconcile a Rent Roll to the Leases?
Reconciliation is a field-by-field comparison of each rent roll line to its governing document. The governing document is rarely the original lease. It is the original lease as modified by every amendment, side letter, assignment, and renewal, with the most recent instrument controlling any term it changes. Assemble the full stack before comparing anything.
Field | Source of truth | Common error |
|---|---|---|
Tenant name | Latest assignment | Assignment not reflected |
Term dates | Latest renewal or amendment | Stale expiration |
Base rent | Current step on the rent schedule | Commencement rent left in place |
Escalations | Rent schedule | Wrong step or wrong effective date |
Square footage | Lease and amendments | Usable and rentable mixed |
Recovery method | Expense article | Blank or wrong method |
Pro rata share | Lease, remeasurement | Outdated after a re-stack |
Options | Options article | Missing or already expired |
Where the rent roll and the lease disagree, the lease wins, with one qualification: an estoppel certificate signed by the tenant is stronger evidence of the operative terms than either, because it is the tenant confirming what they believe they owe. That is why estoppels, rent rolls, and leases have to be driven to one truth rather than reconciled pairwise. The distinction between summary-level and document-level checking is covered in rent roll versus lease reconciliation.
How Do You Tie the Rent Roll to the T-12?
The rent roll is a point-in-time snapshot and the T-12 is a twelve-month history, so they will never match exactly. They should reconcile. Annualize the rent roll, adjust for mid-year move-ins, move-outs, escalations, and free rent, and compare the result to trailing rental revenue. An unexplained gap is a finding.
Work the example. A twelve-suite office building shows 96,000 rentable square feet at 92 percent occupancy, with the rent roll listing 2,024,000 dollars of annualized base rent. The T-12 shows 1,881,000 dollars of rental revenue. The 143,000 dollar gap resolves into three items: one 6,400 square foot tenant commenced in month seven at 28 dollars per foot, contributing only 89,600 dollars of the 179,200 dollars annualized, a 89,600 dollar difference; a second tenant received three months of free rent inside the trailing period worth 34,500 dollars; and a third tenant's 4 percent escalation took effect in month eleven, so the trailing period captured 3,200 dollars of the 19,200 dollar annual increase, a 16,000 dollar difference. Those three items total 140,100 dollars, leaving 2,900 dollars unexplained, which is inside a reasonable tolerance for billing timing.
The point is not the arithmetic. It is that every dollar of the gap has to name a cause. A gap you cannot decompose means either the rent roll overstates in-place income or the T-12 understates collections, and both are material to the price. This is the same discipline applied to the expense side in T-12 analysis.
Frequently Asked Questions
How do you read a rent roll for the first time?
Start with the column headers and confirm the units: monthly or annual rent, rentable or usable area. Then compute rent per square foot for every line and scan for outliers. Then check that expirations reflect exercised renewals. Those three passes surface most errors before you open a single lease.
What is the difference between a rent roll and a lease abstract?
A rent roll is a property-level summary with one line per tenant, built for income tracking. A lease abstract is a document-level summary of one lease's operative terms, built for accuracy. The abstract is the record you reconcile the rent roll against.
How often should a rent roll be reconciled to the leases?
At minimum during acquisition due diligence and annually at expense reconciliation. It should also be reconciled whenever a lease is signed, amended, renewed, or assigned, because those events change the exact fields a rent roll most often gets wrong.
Why does base rent on the rent roll differ from the lease?
Usually because the rent roll shows the commencement rent while the lease has escalated since. It can also reflect an amendment that reset rent, a blend-and-extend, or an abatement period the rent roll never recorded. The current step on the lease rent schedule governs.
Conclusion
A rent roll is the most consequential document in commercial real estate that nobody verifies. It drives valuation, debt sizing, and expense recovery, and it is assembled by hand from documents almost nobody reads end to end. Reading it well means treating every populated field as a claim with a source, and treating every empty field as a question.
The reconciliation converts the spreadsheet into evidence. Trace each line to its governing amendment, tie the annualized total to the trailing financials, and account for every dollar of the difference. What is left is a rent roll you can underwrite from, a different object from the one that arrived attached to an email.