How to Read a Rent Roll and Reconcile It to the Leases

A rent roll is a single document that lists every tenant in a commercial property along with the terms that drive income: suite, square footage, rent, escalations, term dates, and recovery method. Reading it means understanding what each column represents and how the columns relate. Reconciling it means checking every figure on the rent roll against the executed lease it came from, because the rent roll is a summary entered by hand or exported from software and any error in it propagates into valuation, budgeting, and reconciliation. The two tasks together turn a spreadsheet into a document you can trust.

What a Rent Roll Contains

A rent roll is the operating summary of a property's leases. It is used by owners to track income, by lenders to underwrite debt, by buyers to price an acquisition, and by property managers to run billing. Because so many decisions rest on it, the rent roll is only as good as its agreement with the leases beneath it.

A standard commercial rent roll includes these columns:

Some rent rolls add net effective rent, free rent periods, and tenant improvement allowance balances. The more complete the rent roll, the fewer trips back to the lease documents a reconciliation requires.

How to Read the Core Columns

Reading a rent roll is a matter of knowing what each field should contain and how fields cross-check each other.

Square Footage

The area column should reflect rentable square feet, not usable square feet. Rentable area includes the tenant's share of common areas, applied through a load factor. A rent roll that mixes usable and rentable figures across suites will misstate both rent per foot and pro rata shares. Confirm which measure the rent roll uses, and confirm it is consistent across every line.

Base Rent and Rent Per Foot

Base rent may be quoted monthly or annually, and the same rent roll sometimes mixes both. Divide annual base rent by rentable square feet to get rent per foot, then sanity-check it against market and against neighboring suites. An outlier rent per foot usually signals a data entry error, a square footage error, or a genuinely unusual deal worth reading in full.

Escalations

The rent steps column should show scheduled increases, whether fixed dollar bumps, fixed percentages, or index-based adjustments tied to a rent escalation clause. A rent roll that shows only current rent, with no forward schedule, hides future income and future obligations. Escalations are among the most commonly mis-keyed fields because they change on dates that rarely line up with the reporting period.

Recovery Method

This column tells you how operating expenses flow. A base year tenant pays growth above a benchmark year, an expense stop tenant pays above a fixed rate, and a net tenant pays a share of all recoverable expenses. If the recovery method on the rent roll is blank or generic, the reconciliation cannot verify recovery income, and the rent roll is incomplete for underwriting.

How to Reconcile the Rent Roll to the Leases

Reconciliation is the systematic comparison of each rent roll line to its source lease. The distinction between a rent roll and a lease-level reconciliation is worth understanding on its own, and is covered in rent roll vs lease reconciliation. The workflow below assumes you have both the rent roll and the executed leases, including amendments.

1. Assemble the source documents. For each suite, gather the original lease and every amendment, side letter, and renewal. The most recent amendment governs any term it changes.

2. Verify the parties and dates. Confirm the tenant legal name, commencement date, and expiration date match. Amendments frequently extend the term, and a rent roll that still shows the original expiration is stale.

3. Trace the base rent. Find the current period on the lease rent schedule and confirm the base rent on the rent roll matches the amount in effect today, not the original commencement rent.

4. Rebuild the escalation schedule. Confirm every future step on the rent roll matches the lease schedule, including the effective date of each bump.

5. Confirm square footage. Match rentable area to the lease, checking whether any amendment expanded or contracted the premises or remeasured the load factor.

6. Check the recovery terms. Confirm the recovery method, base year, or stop, and pro rata share against the lease. Remeasurement or re-stacking can change a share the rent roll never updated.

7. Capture options and deposits. Confirm renewal, termination, and expansion rights, and the security deposit form and amount.

The goal is a rent roll where every populated field has been traced to a governing document. A lease abstract built during this process becomes the reusable record that makes the next reconciliation faster.

A Reconciliation Checklist

Working through the checklist line by line is what separates a rent roll that merely looks complete from one that has been verified.

Where Rent Rolls Go Wrong

Rent roll errors cluster in predictable places. The single most common is a base rent that reflects the commencement rate rather than the current escalated rate, which understates income on every long-dated lease. Close behind is a stale expiration date on a renewed lease, which distorts weighted average lease term and rollover exposure.

Square footage mismatches are subtle and expensive because they flow into both rent per foot and pro rata share. A suite entered at usable area rather than rentable area understates the space and misprices the tenant on two lines at once. Recovery method errors are less frequent but higher impact, because a wrong method can misstate an entire year of recovery income.

Options are the most frequently omitted field. Renewal, termination, and expansion rights rarely appear on a basic rent roll, yet a termination right two years out can change how a buyer values the entire building. Reading these from the lease and carrying them onto the rent roll is part of a complete reconciliation.

Automating the Cross-Check

Manual reconciliation is slow because it requires reading each lease, locating the governing terms across a stack of amendments, and typing them into a comparison. Lease abstraction software addresses the reading half by extracting tenant, term, rent schedule, escalations, square footage, and recovery terms directly from the executed documents into structured fields. The mechanics of that extraction are covered in what is lease abstraction.

Once the leases are abstracted, the comparison to the rent roll becomes a field-by-field match rather than a manual read. Automation is strongest at flagging disagreements: a base rent that does not match the current step, an expiration that predates an amendment, a share that no longer ties to the measured area. A human still adjudicates the exceptions, but the volume of lines needing human eyes drops sharply. This is the same reasoning behind broader lease reconciliation, where the value is in surfacing the exceptions, not re-reading every clean line.

Frequently Asked Questions

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 a single lease's key terms, built for accuracy. The abstract is the source 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 reconciliation time. It should also be reconciled whenever a lease is signed, amended, renewed, or assigned, since 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 since escalated to a higher step. The rent roll should always reflect the rent in effect for the current period, not the original number.

Should security deposits and options appear on a rent roll? Yes for a complete rent roll used in underwriting. Deposits affect credit exposure and options affect valuation and rollover risk. Basic operating rent rolls often omit them, which is a gap to close during reconciliation.

What makes a rent roll unreliable? Manual data entry, stale updates after amendments, mixed square footage measures, and blank recovery methods. Each introduces errors that compound into valuation and budgeting, which is why line-by-line reconciliation to the leases is necessary.

Conclusion

A rent roll is the summary a property runs on, but it is only a summary, and summaries drift from their sources. Reading one well means knowing what each column should contain and how the columns cross-check. Reconciling one means tracing every populated field back to the executed lease and its amendments, with particular care for current base rent, escalation schedules, square footage measures, recovery methods, and options. Done by hand it is slow; done with lease abstraction it becomes a field-by-field match that surfaces the exceptions worth a human's attention. Either way, the discipline is the same: never trust a rent roll figure you have not tied to the lease behind it.

Related Reading

• Estoppels, Rent Rolls, and Leases: Three Sources, One Truth

• Rent Roll vs. Lease Reconciliation: Catching the Discrepancies

• Gross-Up Provisions in Commercial Leases, Explained

• Reconciling Leases Across Systems: The Entity Resolution Problem

• Automating Lease Reconciliation Without Losing the Audit Trail