What Is a Rent Roll? What It Includes and How to Build One

A rent roll is a single report that lists every tenant in a property or portfolio along with the rent they pay, their leased space, and the key dates of their lease. It is the at-a-glance picture of a property's income: who is paying, how much, for how long, and when each lease expires. Owners, brokers, lenders, and buyers all read the rent roll first, because it summarizes the contracted income a property produces before anyone digs into the leases themselves.

The rent roll is the working document of commercial real estate. A landlord uses it to track income and renewals, a broker attaches it to an offering memorandum, a lender underwrites a loan against it, and a buyer checks it against the leases during due diligence. Because so many decisions ride on it, the rent roll has to be accurate, current, and built from the actual lease terms rather than from memory or a stale spreadsheet.

What is included in a rent roll?

A rent roll includes one row per lease with the fields that describe that tenancy. At a minimum it lists the tenant name, the unit or suite, the leased square footage, the current base rent, the lease commencement and expiration dates, and the security deposit. A commercial rent roll usually adds more: the rent escalation schedule, renewal and termination options, the recovery or CAM structure, percentage rent for retail, and any free-rent or concession periods still in effect.

The richer the rent roll, the more useful it is. A bare list of tenants and rents tells you today's income. A full commercial rent roll that carries escalations, expirations, and options tells you what the income will do over the next several years, which is what an investor or lender actually needs to price risk.

What is a rent roll used for?

A rent roll is used to understand and verify a property's income. A landlord or property manager uses it to track who owes what, when leases roll, and which renewal windows are open. A broker uses it to market a listing and build the income section of an offering memorandum. A lender uses it to underwrite a loan, sizing the debt against the in-place rent and the rollover schedule. A buyer uses it as the starting point for due diligence, then checks it against the underlying leases.

Because the rent roll drives pricing and lending decisions, the version that gets relied on must reconcile to the leases. A marketed rent roll is prepared to present a property in its best light, so a careful buyer verifies it line by line, which is exactly the work covered in lease abstraction for CRE brokers and in our guide to lease abstraction for acquisition due diligence.

How do you create a rent roll?

You create a rent roll by pulling the key terms out of every lease and laying them out in one row per tenant. Traditionally an analyst opens each lease, finds the rent, dates, square footage, escalations, and options, and types them into a spreadsheet, which takes hours per lease and invites typos. The faster path is to abstract the leases first, then assemble the abstracts into the rent roll. Our step-by-step walkthrough, how to build a rent roll from leases, shows the full workflow.

AI lease abstraction shortcuts the slow part. You upload each lease, the software reads the document and extracts rent, escalations, dates, options, and recoveries into structured fields, and you export those fields straight into a rent roll. Every value links back to the clause it came from, so the numbers are both fast to produce and easy to defend. See lease abstraction software for how that extraction works, and the commercial lease abstract template for the exact fields a complete abstract carries into the rent roll.

What is the difference between a rent roll and a lease abstract?

A rent roll is a summary of current rent across all tenants, while a lease abstract is the full set of key terms for a single lease. The rent roll answers what is being paid right now; the abstract answers what the lease actually says, including the dates, options, escalations, and recovery provisions behind that rent. You build the rent roll from the abstracts. The abstract carries the detail a buyer probes in diligence, and the rent roll rolls those abstracts up into one income picture.

What is a rent roll in commercial real estate?

In commercial real estate, a rent roll is the tenant-by-tenant schedule of leased space and rent for an office, retail, industrial, or mixed-use property. It differs from a residential rent roll mostly in complexity: commercial leases carry escalations, recovery structures, percentage rent, and a web of options that all belong on the rent roll. For an investor running a portfolio, those forward-looking fields are what drive value, which is why lease abstraction for asset managers treats the rent roll as a living dataset rather than a static list.

How often should a rent roll be updated?

A rent roll should be updated whenever a lease changes and reviewed at least monthly. New leases, renewals, amendments, expirations, and rent escalations all change the numbers, so a rent roll that is not kept current quickly drifts from reality. For a sale or a financing, buyers and lenders typically want a rent roll dated within the last 30 days, because a stale rent roll is treated with suspicion no matter how clean it looks.

Who prepares a rent roll?

A rent roll is usually prepared by the property manager or the owner's lease administration team, who maintain it from the leases and the accounting system. On a sale, the listing broker assembles or refreshes it for the offering memorandum. On a financing or acquisition, the lender and the buyer rebuild or verify it from the actual leases rather than relying on the version they were handed. In every case the source of truth is the leases, which is why teams abstract the leases first and let the rent roll fall out of the abstracts.

From leases to a rent roll, the practical workflow

The dependable workflow is simple: gather every lease and amendment, abstract each one to the same set of fields, review the flagged values, then export the abstracts into your rent roll format. Doing it this way means the rent roll reconciles to the leases by construction, so a buyer's verification or a lender's underwriting confirms your numbers instead of contradicting them. A landlord keeping the property books in QuickBooks can then reconcile the rent deposits against that roll by converting statements with a bank statement to QuickBooks converter, track each tenant's required coverage with certificate of insurance tracking software, and sign new leases and renewals that update the roll using a simple online document e-signing tool.

However you maintain it, the rent roll is only as good as the lease data behind it. Abstract the leases well, keep the roll current, and the single most-read document in any commercial real estate deal will hold up to scrutiny.