A rent roll is the lease-by-lease income register of a property: one row per space, carrying the tenant, the area, the lease dates, and every dollar the lease obligates that tenant to pay. It is the document every other number in a deal is checked against.
Search for rent rolls and you will get eight explanations written for someone who owns a duplex. They are not wrong. They are just answering a different question than the one an acquisitions team asks when a broker sends over a $40M shopping center and the bid is due in nine days. This guide is the second version.
What a rent roll actually is
Formally: a schedule, current as of a stated date, listing every leased and vacant space at a property alongside the economic terms of the lease governing it.
Three properties of that definition matter more than the definition itself.
It is point-in-time. A rent roll is a photograph, not a film. It is true as of its date and progressively less true afterward. A rent roll dated four months ago and a rent roll dated last Tuesday are different documents, and the difference is often where the deal lives.
It is lease-by-lease. The unit of a rent roll is the lease, not the property. This is what separates it from every summary that sits above it. A property-level rent number tells you what the asset produces; a rent roll tells you which specific obligations produce it and when each one ends.
It is a claim, not a fact. The seller’s property manager produces it. In a sale process, that is a party with a position. Every material line should trace to an executed lease or amendment in the data room.
For the column-by-column anatomy (the twenty fields that belong on an institutional commercial rent roll, plus sample rolls for multifamily, office, retail, and industrial), see the rent roll sample and template guide.
Who reads a rent roll, and what each reader is looking for
The same document does four different jobs depending on who has it open.
The broker builds the offering memorandum from it and presents the stabilized version: in-place rent, occupancy, a market-rent assumption for the vacant space.
The buyer’s analyst rebuilds the income statement from it, lease by lease, and looks for the difference between the broker’s story and the leases.
The lender sizes debt against it and cares most about durability: expiration concentration, tenant credit, and how much of the income is month-to-month.
The asset manager, post-close, uses it as the operating baseline that every subsequent leasing decision is measured against.
A rent roll that satisfies the broker frequently fails the other three. That is not deception; it is a document built for one purpose being used for four.
How buy-side underwriters stress-test a rent roll
Five checks, in this order. They are cheap, and each one can kill a deal.
1. Tie the rent roll to the operating statement. Annualize in-place base rent from the rent roll. Compare it to the rental income line on the T-12. These two numbers will not match, and they should not: the delta is loss to lease, vacancy, concessions, and collection loss. What matters is whether you can name the components. An unexplained gap is not a rounding difference; it is a question you have not asked yet. See the T-12 guide for the other side of this reconciliation.
2. Stack the expirations. Sort by lease end date and total the square footage and rent rolling in each of the next five years. Concentration is the risk that does not show up in year-one NOI. A center at 95% occupancy with 40% of its GLA expiring in month 26 is not a 95% occupancy asset.
3. Mark the rents to market. Compare in-place base rent per square foot against submarket comps, lease by lease. Below-market leases are upside with a date attached: the date being expiration. Above-market leases are the opposite, and they are the ones brokers describe as “in place.”
4. Isolate what is not durable. Month-to-month tenants, tenants in a free-rent period, tenants with termination options, and tenants whose obligation is a percentage of sales rather than a fixed number. Each of these is income the rent roll displays with the same confidence as a ten-year corporate lease.
5. Reconcile occupancy against the operating statement. Physical occupancy on the rent roll and economic occupancy implied by the T-12 should be reconcilable. When they are not, the usual cause is that the rent roll counts a space as occupied that stopped paying some months ago.
Where rent rolls break
In offering memoranda and data rooms, the same defects recur.
Escalations that live only in the lease. The rent roll shows current base rent. The lease specifies a 3% annual bump every January. Model from the rent roll alone and every year after year one is wrong.
Reimbursement structures collapsed into one field. NNN, modified gross, base-year stop, and full service are economically different and frequently appear in the same column with the same formatting. Recovery income is the second-largest line in most commercial pro formas, and it is routinely modeled from a field nobody standardized.
Stale occupancy. Tenants who vacated still shown as in place. This is less often deception than lag: the rent roll is generated from the property management system and the move-out was processed late.
Area that does not reconcile. The sum of leased plus vacant square footage does not equal the building’s rentable area. Usually load factors or common area; occasionally a space counted twice.
Vacant space carrying a rent. A market-rent assumption for vacant suites, entered into the in-place rent column. Annualize that column and you have quietly underwritten a lease-up you have not done.
None of these are exotic. All five are found by reading the rent roll against the leases and the T-12, which is exactly the work that takes an analyst real time on every deal and is the reason most teams only do it properly on the deals they are already committed to.
Which version of the rent roll you should be working from
A live deal produces several rent rolls, and they are not interchangeable.
The marketing rent roll, attached to the offering memorandum. Often a summary, sometimes reformatted by the broker, occasionally months old. Fine for screening. Never model a bid off it without asking for the source export.
The diligence rent roll, delivered at LOI. This should be a native export from the property management system, dated within the last thirty days, with vacant space shown explicitly. If what arrives is a hand-built spreadsheet, ask for the system export as well: the gap between the two is informative.
The closing rent roll, dated within a few days of funding and usually certified. This is what the lender funds against, and it is the version where late-breaking move-outs surface.
Ask for all three, and diff them. Movement between the marketing roll and the diligence roll (a tenant who quietly became month-to-month, a suite that emptied) is the cheapest diligence signal available, and almost nobody checks it because it requires normalizing two differently-formatted files to compare.
Multifamily and commercial rent rolls are different documents
They share a name and little else.
A multifamily rent roll is wide and shallow: hundreds of rows, eight to twelve columns, leases that are nearly identical apart from unit type, rent, and dates. The analytical questions are aggregate: average in-place rent by floor plan, loss to lease against market, concession burn-off, expiration smoothing across months, and how much of the roll is month-to-month after a lease-up.
A commercial rent roll (office, retail, industrial) is narrow and deep: perhaps twenty rows, but fifteen to twenty columns per row, and every lease individually negotiated. The questions are lease-specific: what recovery structure governs this tenant, what does the escalation schedule actually say, is there a termination option, is there percentage rent above a breakpoint, who pays for the roof.
The practical consequence is that a process built for one does badly on the other. Multifamily tooling tends to assume uniformity and quietly flattens the terms that make a commercial lease what it is. Commercial tooling applied to a 300-unit property drowns in rows. This is why “rent roll software” is a category with genuinely different products in it rather than one product with a checkbox.
From rent roll to cash flow model
The rent roll is where a DCF starts. Each lease becomes a revenue stream with a start, an end, an escalation schedule, and a recovery method. At expiration, each stream gets an assumption: renewal probability, market rent, downtime, tenant improvements, leasing commissions. Sum the streams, layer in the operating expenses from the T-12, and you have a projection.
Which means every error in the rent roll compounds forward through the entire hold period. A misread escalation is not a year-one variance; it is a decade of variance and a terminal value built on top of it.
This is the argument for treating rent roll normalization as a discipline rather than a data-entry step. The document is the foundation of the model, it arrives in a different format from every seller, and it is produced by the counterparty.
Why rent rolls never look the same twice
There is no standard. Yardi, MRI, RealPage, AppFolio and Entrata each export a different shape, and a meaningful share of rent rolls are spreadsheets a property manager maintains by hand. Dates appear as text. Vacant units appear as blank rows, as zero-rent rows, or not at all. Suites are split across merged cells. Multi-tenant industrial rolls put step rents in a footnote.
For one asset this is an afternoon of cleanup. Across a portfolio, or across the twenty deals a team screens for every one it bids, it is the single largest consumer of analyst time in the acquisition process, and it is work that produces no insight, only a usable file.
That is the specific problem rent roll software exists to solve: extract from whatever format arrives, normalize to one schema, reconcile against the T-12 and the executed leases, and surface the exceptions instead of the whole file. Moraine (morainecre.com) parses the rent roll, normalizes it, and ties it to the T-12 and the leases with page-level citations, so the analyst’s day goes to the five stress tests above instead of to retyping.
Related reading
- Rent roll sample and template: the 20 columns, with samples by asset class
- Rent roll software: extraction, normalization, and validation
- Free rent roll Excel template: download
- What is a T-12?: the other half of the reconciliation
- Commercial real estate underwriting: where the rent roll becomes a model