A rent roll is a report that lists every tenant in a property, one row per lease, with the rent they pay, the space they occupy, and the dates their lease runs. It is the document a buyer, lender, or asset manager reads first, because it answers the only question that matters at a glance: what income does this property actually produce, from whom, and for how long. The rent roll is built from the leases, and it is only as accurate as its last reconciliation against them.
What a rent roll is used for
Different readers pull different answers out of the same report:
- Owners and asset managers use it to track occupancy, income, and upcoming expirations across the portfolio.
- Buyers underwrite an acquisition from it. During due diligence the buyer's team re-abstracts every lease specifically to confirm the seller's rent roll is true.
- Lenders size loans against it. A lender will typically ask for a certified rent roll plus tenant estoppel certificates that confirm the key rows.
- Property managers bill from it: base rent, escalations, and recoveries all flow from what the rent roll says each tenant owes.
The columns a rent roll should include
Formats vary by owner and by asset class, but a commercial rent roll worth relying on carries these columns for every lease:
| Column | What it captures |
|---|---|
| Tenant and suite | Legal tenant name, DBA if different, suite or unit number |
| Square footage | Rentable SF, and the pro-rata share it drives |
| Base rent | Current rent, per SF and annual, from the rent schedule |
| Escalations | Step dates and method: fixed, percentage, or CPI |
| Term dates | Commencement and expiration; months remaining |
| Recoveries | Lease type (NNN, modified gross, full service) and CAM terms |
| Options | Renewal, termination, and expansion rights with notice windows |
| Security | Deposit or letter of credit held; guaranties |
| Other income | Percentage rent, parking, storage, signage |
Residential rent rolls are simpler (unit, tenant, rent, lease end, deposit, balance), but the principle is the same: one row per lease, current facts only, every figure traceable to a document.
Rent roll example
A condensed rent roll for a small mixed office and retail property might look like this:
| Suite / Tenant | RSF | Rent / SF | Expires | Notes |
|---|---|---|---|---|
| 100, Brightline Cafe | 1,800 | $38.00 | 2027 | NNN, 6% percentage rent over breakpoint |
| 220, Meridian Advisors | 3,400 | $34.50 | 2029 | MG, 3% annual steps, one 5-yr option |
| 400, Northway Logistics | 14,250 | $32.50 | 2031 | Tenant break at month 60, 9-mo notice |
| 510, Halcyon Studio | 2,100 | $36.00 | 2026 | Expiring; renewal notice window open |
Even in four rows you can see what the report is for. The 2026 expiration needs a renewal conversation now, the month-60 break right changes the building's real weighted average lease term, and the percentage rent row will not show up in base rent at all. If you want the full column structure to copy, our rent roll template lays it out.
Where rent rolls go wrong
Almost every bad rent roll fails the same way: it drifted from the leases. Someone renewed a tenant and updated the accounting system but not the report. An escalation stepped and nobody caught it. An amendment moved an expiration date. The rent roll says one thing, the lease says another, and the difference surfaces at the worst possible time, in front of a buyer or a lender whose counsel is re-reading every lease.
That is why sophisticated buyers never take a rent roll at face value. They abstract the leases and rebuild it. When the seller's roll and the rebuilt roll disagree, the lease wins, and the purchase price conversation reopens. Sellers who reconcile their rent roll against the actual lease documents before going to market keep control of that conversation. The same discipline applies to collections: when you audit whether billed rent was actually received, the bank records are the other half of the reconciliation, and if those only exist as PDF statements you can convert the bank statement to Excel and match deposits to the roll line by line.
How to build a rent roll from your leases
- Collect the full lease file for every tenancy: original lease, every amendment, and any assignment. An amendment you skip is a wrong row.
- Abstract each lease: pull the tenant, suite, square footage, current rent and escalations, term dates, recoveries, options, and deposit. This is standard lease abstraction, done manually in 3 to 8 hours per lease or in minutes with AI.
- Roll the abstracts up: one row per lease, consistent columns, current-period values.
- Reconcile and date it: check the roll against billing records, stamp it as of a date, and keep the source link on every figure so anyone can verify a row against the lease in seconds.
Leaseabstracts does steps 2 through 4 from the documents themselves: upload the leases and export a source-linked rent roll to Excel. See how it works.
Rent roll FAQ
What is a rent roll in commercial real estate?
A rent roll is the row-per-lease report of a property's tenancies: tenant, suite, square footage, current rent, escalations, term dates, recoveries, options, and deposits. Owners manage from it, buyers underwrite from it, and lenders size loans against it, which is why its accuracy against the leases matters so much.
What is the difference between a rent roll and a lease abstract?
A lease abstract summarizes one lease in depth; a rent roll summarizes every lease in one line each. The rent roll is effectively the portfolio view built on top of the abstracts, so if the abstracts are wrong or stale, the rent roll is too.
Who prepares the rent roll?
Day to day, the property manager maintains it, usually out of the accounting system. For a sale or refinance, the owner certifies it, and the buyer or lender independently verifies it against the leases and against tenant estoppel certificates before relying on it.
What is a rent roll worth as evidence?
On its own, not much: it is a management report, not a source document. Its credibility comes from reconciliation. A rent roll where every figure is traced to a lease clause, and confirmed by signed estoppels, is the version a buyer or lender will actually accept.