If there's one document that gets passed around more than any other in a commercial real estate transaction, it's the rent roll. Buyers read it to underwrite cash flow. Lenders read it to size the loan. Brokers read it to set the asking price. Tenants don't usually see it, but everything they signed shows up on it. A rent roll is the most concentrated snapshot of a property's economics, and learning to read one fluently is one of the highest-leverage skills in CRE.
Rent rolls look simple at first glance: a table of tenants, lease terms, and rent figures. But buried inside the columns are signals about tenant quality, concentration risk, mark-to-market opportunity, capital obligations, and the soundness of the underlying business plan. A trained eye reads a rent roll the way a doctor reads a chart, picking out the issues that matter and ignoring the noise.
This guide walks through what a rent roll is, the standard columns and how to interpret each one, the differences across property types, the red flags buyers and lenders look for, and how to build one from scratch. If you'd rather skip the spreadsheet work and have lenders evaluate your deal directly from your rent roll, Lev does that automatically.
What is a rent roll?
A rent roll is a structured report that summarizes every active lease at a property, plus key economic and operational information about each tenant. Think of it as the operational accounting of the property: who's there, what they pay, when their lease ends, and what's coming up next.
At a minimum, a rent roll shows: tenant name, unit or suite number, square footage, monthly or annual rent, lease start and end dates, and lease type. More complete rent rolls add escalations, recoveries, security deposits, free rent, tenant improvements, options to renew or terminate, and notes on tenant credit or special circumstances.
Two flavors:
Static rent roll: a snapshot at a specific date. The version that gets shared in a sale or financing process.
Dynamic rent roll: a working document the property manager updates as leases change. Most institutional owners keep dynamic rent rolls in property management software (Yardi, MRI, AppFolio, Buildium) that generates static reports on demand.
The line between rent roll and trailing financials is fuzzy. Rent rolls describe the current state of leases. Trailing 12 statements (T-12) describe historical operating performance. Together they tell a buyer or lender what the property is producing today and how it got there.
For a deeper look at how trailing financials and operating statements fit together with the rent roll, see Lev's CRE due diligence guide.
What's in a standard rent roll
The columns vary by property type and software, but a standard institutional rent roll typically includes the following:
Tenant identification
Unit or suite number: the physical identifier for each leased space. In multifamily, this is the apartment number. In office, the suite number. In industrial, the building and bay.
Tenant name: the legal name on the lease, not necessarily the brand. A retail center might have a "Subway" sign, but the lease is with a specific franchisee entity. The legal name matters for credit underwriting.
Tenant trade name (DBA): the operating name the tenant uses, when different from the legal entity. Useful for understanding what's actually in the space.
Space attributes
Square footage: the leased area. In office and industrial, this is usually rentable square footage (RSF), which includes a load factor for common areas. In retail and multifamily, it's usually usable square footage (USF).
Unit type or floor: in multifamily, the unit type (1-bedroom, 2-bedroom, 3-bedroom). In office, the floor. In industrial, the building or bay.
Economic terms
Monthly or annual rent: the contract rent. Often broken into base rent (the fixed component) and additional rent (operating expense reimbursements, sometimes called recoveries or CAM).
Rent per square foot: rent divided by square footage. The most useful metric for comparing across tenants and benchmarking to market.
Lease type: gross, modified gross, net, double net, triple net (NNN), or absolute NNN. The lease type determines what the rent figure actually buys.
Recoveries or CAM (Common Area Maintenance): amounts the tenant pays toward operating expenses on top of base rent. In a NNN lease, this can be a significant additional component.
Dates
Lease start date: when the tenant's obligation began.
Lease end date (expiration): when the lease terminates, absent renewal.
Move-in date: when the tenant actually occupied (sometimes different from lease start in build-to-suit deals).
Future economics
Rent escalations: scheduled rent increases over the lease term. Sometimes shown in a separate "rent schedule" tab or as future-dated rows.
Options: rights the tenant has to renew, terminate, expand, or purchase. Critical for re-leasing risk and long-term cash flow planning.
Free rent or abatements: months of rent the tenant doesn't pay (typically given at the start of a lease as a concession). Reduces effective rent vs the headline figure.
Tenant improvement allowance (TI): a dollar amount the landlord agreed to spend on customizing the space. Can be a future cash outlay even if the rent says $25 per square foot.
Operational items
Security deposit: cash or letter of credit the tenant has posted.
Guarantor: a parent company, principal, or third party who has guaranteed the tenant's obligations. Critical for credit underwriting in smaller tenant deals.
Notes: any non-standard provisions, side letters, modifications, or operational issues.
A complete rent roll runs 20 to 30 columns wide for office, retail, or industrial. Multifamily rent rolls are usually narrower (10 to 15 columns) but have more rows (one per unit).
How rent rolls differ by property type
The format of a rent roll varies meaningfully across asset classes.
Multifamily rent roll
A multifamily rent roll has one row per apartment unit. The columns are simpler than commercial: unit number, unit type (1BR/2BR/etc.), square footage, tenant name, lease start and end, monthly rent, market rent (the rent the landlord would charge a new tenant), and any concessions.
The most important columns in multifamily are usually: in-place rent, market rent, lease end date, and concessions. Multifamily rent rolls are often used to identify "loss to lease" (the gap between market rent and in-place rent) and to forecast when units will roll to market.
Vacant units are shown as separate rows with no tenant name and either market rent or zero in the rent column. Pay attention to vacancy: a property with 92% occupancy from the OM but a rent roll showing only 88% has a story you need to understand.
Office rent roll
Office rent rolls are more complex because lease terms vary widely tenant-to-tenant. Key columns include base rent (often shown as both per-month and per-square-foot annualized), CAM reimbursements, operating expense base year (the "stop" above which the tenant pays a share of operating expenses), escalations (fixed bumps or CPI-based), options (renewal, expansion, termination), and TI allowance.
Office rent rolls also commonly include a "load factor" or "rentable/usable ratio," because tenants pay rent on rentable square footage but only occupy usable square footage. A 10,000 USF tenant might be paying rent on 11,500 RSF in a building with a 15% load factor.
Retail rent roll
Retail rent rolls include all the office complexities plus a few additional layers. Common columns: percentage rent (rent calculated as a percentage of tenant sales above a breakpoint), kick-out clauses (rights to terminate if sales fall below a threshold), co-tenancy clauses (rights tied to other tenants in the center, especially anchors), exclusive use clauses (rights restricting the landlord from leasing to competing uses), and "pad" vs in-line designation.
Retail rent rolls also commonly show recent tenant sales (often shown as sales per square foot trailing 12 months) and occupancy cost (rent plus CAM divided by sales). Both are critical for understanding tenant health.
Industrial rent roll
Industrial rent rolls look more like office rent rolls (one row per tenant), but with industrial-specific columns: clear height of the leased space, dock door count, drive-in door count, office finish percentage, and trailer storage allocation.
Industrial leases are typically longer and simpler than office or retail leases (often NNN, often with 2.5 to 3.5% annual escalations), so industrial rent rolls are usually less dense per row.
Self-storage and hotel rent rolls
Self-storage rent rolls have one row per unit (just like multifamily), with unit type, size, rent, and tenant. Hotels don't really have rent rolls in the traditional sense (rooms turn over nightly), but they have analogous documents: STAR reports, occupancy and ADR (Average Daily Rate) trailing reports, and segmented revenue breakdowns.
How to read a rent roll: what buyers and lenders look for
Reading a rent roll well is about pattern recognition. A few of the standard analyses:
Weighted average lease term (WALT)
Calculate the weighted average of remaining lease term, weighted by rent or square footage. A long WALT (8+ years) signals stable cash flow. A short WALT (under 3 years) signals significant re-leasing risk in the near term.
For lenders, WALT is one of the most-watched metrics. A property with a strong WALT and credit tenants often supports more favorable loan terms than one with the same NOI but a short WALT.
Tenant concentration
What percentage of rent comes from the largest tenant? The top 3 tenants? In single-tenant net-leased properties, 100% concentration is by design (and the underwriting question becomes the tenant's credit). In multi-tenant properties, more than 25 to 30% of rent from a single tenant raises concentration risk.
Rollover schedule
When are the leases rolling? A rent roll with 40% of rent expiring in the next 24 months is a much riskier asset than one with the same NOI but smoothly distributed expirations over 8 to 10 years.
Build a rollover schedule: percentage of rent (and square footage) expiring in each of the next 5 to 7 years. Steep cliffs warrant much more careful underwriting and capital reserves for re-tenancy.
Mark-to-market
Compare in-place rents to current market rents. A property with significant below-market rent has upside as leases roll. A property with above-market rents has downside as leases roll. The mark-to-market analysis is one of the central value-add levers in CRE.
For multifamily, market rent is usually shown in the rent roll directly. For office, retail, and industrial, market rent has to be estimated using recent comparable leases.
Tenant credit
For commercial properties, the credit profile of each tenant matters as much as their rent. Investment-grade tenants on long leases support premium pricing and tighter cap rates. Sub-investment-grade tenants or sole-proprietor businesses get priced for risk.
A standard credit review: pull recent financial statements (if private) or rating reports (if public). Look at revenue, profitability, leverage, and any recent news. For franchise tenants, the credit of the operating franchisee (not the brand) is what matters.
Concessions and free rent
Effective rent (the rent after subtracting free rent and amortizing TI) is often different from headline rent. A new lease at $30 PSF with 6 months free rent and $40 PSF TI has an effective rent well below $30. Buyers and lenders calculate effective rent to understand what the property is really earning.
Hidden capital obligations
Read the option, expansion, and renewal columns. A tenant with a fixed renewal at below-market rent is exercising a valuable option against the landlord (and against any future buyer). A tenant with a contingent expansion right may force the landlord into difficult build-out decisions. These items don't appear in the rent column but materially affect future cash flow.
Red flags in a rent roll
Some patterns that should slow down a buyer or lender:
Step-down rent: in-place rent is meaningfully higher than scheduled rent in the next 12 to 24 months. The current rent isn't sustainable; underwriting should use the lower future number.
One-page summary doesn't match the underlying leases: always cross-check rent roll figures against actual lease documents during due diligence. Property managers occasionally miscode entries, and discrepancies can be material.
High concentration of recent leases at unusually favorable terms: a landlord facing an upcoming sale may have signed sweetheart leases (long terms, low rents, large TI packages) to inflate the WALT and headline NOI. Look for clustered lease signings in the months before listing.
Below-market rent on a long lease: the tenant has a 12-year remaining term at $15 PSF in a $30 PSF market. The mark-to-market opportunity is real but won't materialize for over a decade.
Concentrated rollover within the loan term: if 40% of leases roll inside a 5-year loan term, the lender will worry about refinanceability at maturity.
Vacant units coded as "month-to-month": actually vacant but presented as if tenanted. Verify occupancy with physical site inspection and bank statement deposits.
Tenant in arrears: rent payments shown as paid in the rent roll but actually in arrears. Verify by reconciling bank deposits to rent roll postings.
Side letters not reflected: a tenant may have a side letter modifying the lease (extending free rent, granting an exclusive, capping CAM) that isn't on the rent roll. Pull every side letter during diligence.
Unrecorded options: tenant has informal renewal arrangements not memorialized in the lease. These create future liability that isn't visible.
For a full diligence framework, see Lev's tenant estoppel guide. Estoppels are the standard tool for confirming the rent roll matches reality.
How to build a rent roll from scratch
If you're an owner who doesn't yet have a clean rent roll (common with smaller properties bought from owner-operators), the build process:
1. Pull every lease: original leases plus all amendments, side letters, and consents. Track lease versions chronologically.
2. Extract key terms: tenant name, square footage, base rent, additional rent, lease type, start and end dates, options, escalations, free rent, TI obligations.
3. Build a master spreadsheet: one row per lease, columns for each data point above. Include unit number, square footage, and any property-specific identifiers.
4. Reconcile to financials: total in-place rent on the rent roll should match the rent income line on the trailing 12 statements (with any minor adjustments for AR/AP timing).
5. Reconcile to lease abstracts: a separate document summarizing each lease in narrative form. Useful for verifying the structured data in the rent roll.
6. Verify with tenants: send each tenant an estoppel certificate confirming the key economic terms. Estoppels are the gold standard for rent roll accuracy.
Property management software (Yardi, MRI, AppFolio, Buildium, RentRedi) automates most of this once it's set up, but the initial data entry is meaningful work for properties that have been hand-managed.
Frequently asked questions
What's the difference between a rent roll and a lease abstract?
A rent roll is a structured table of key economic terms across all tenants, designed for quick analysis. A lease abstract is a narrative summary of a single lease, often longer (3 to 8 pages) and more detailed. Most institutional owners maintain both: a rent roll for portfolio-level analysis, and lease abstracts for tenant-level reference.
Do I need a rent roll for a single-tenant property?
Yes. Even a single-tenant property has a "rent roll" (one row), and lenders and buyers will still want to see it. For single-tenant net-leased properties, the rent roll is short but the lease and credit analysis are deep.
How often should a rent roll be updated?
For active management, monthly. The dynamic rent roll in a property management system should reflect any lease signings, renewals, terminations, and rent adjustments in real time. For deal purposes (a sale or financing), a rent roll dated within the last 30 to 60 days is typical.
What's "effective rent" and why does it matter?
Effective rent is the contract rent adjusted for concessions (free rent, TI, brokerage commissions) amortized over the lease term. A new lease at $30 PSF with 6 months free rent in a 60-month lease has an effective rent closer to $27 PSF. Effective rent is what the landlord actually earns, and it's what should drive underwriting analysis.
Can a buyer rely on the seller's rent roll?
Trust but verify. Buyers should obtain tenant estoppels confirming the rent roll figures, cross-reference rent roll income to the trailing 12 financial statements, and review actual lease documents during diligence. The rent roll is a starting point, not the final answer.
What's a "loss to lease" calculation?
The difference between market rent and in-place rent across the portfolio, expressed in dollars per year or as a percentage. Common in multifamily underwriting. A property with $1 million of in-place rent and $1.1 million of market rent has a $100,000 loss to lease, which represents the upside as leases roll.
How do tenant improvements (TI) show up on a rent roll?
TI is sometimes shown as a separate column (dollar amount per lease) or as a footnote. Buyers should track unfunded TI obligations as a future cash outlay. A new lease that promises $500,000 of TI but only $100,000 has been spent so far is a $400,000 unfunded obligation that comes out of future cash flow.
What's a "blend and extend" in rent roll terms?
A negotiated lease modification where the existing rent is "blended" (averaged) with new rent across a longer extended term. Common during downturns when tenants want lower current rent and landlords want longer commitment. Shows up on the rent roll as a new lease replacing the old one with different economics.
Are vacant units shown on a rent roll?
Yes, typically as rows with no tenant name and either market rent or zero in the rent column. The rent roll should always reconcile to the property's actual occupancy. A property with 22 leased units in a 25-unit building should show 3 vacant rows.
How does the rent roll relate to NOI?
The rent roll drives the revenue side of NOI: total rent (in-place rent from the rent roll), plus other income (laundry, parking, etc.), minus vacancy and credit loss. Operating expenses come from the trailing 12 statements. Together, revenue minus expenses equals NOI. For a deeper walkthrough of NOI, see Lev's DSCR guide which steps through the calculation.
The takeaway
The rent roll is the single most important document in any CRE transaction. It's where every lease, every concession, and every future capital obligation gets summarized. A buyer or lender who reads a rent roll well can spot underwriting issues that pages of marketing material miss; one who reads it poorly can overlook material risks hiding in plain sight.
For owners and sponsors, maintaining a clean, current rent roll is one of the highest-ROI operational disciplines. For buyers and brokers, the rent roll is where the deal really gets underwritten, after the OM hype has been stripped away.
If you're preparing a property for sale or financing, start with Lev to get your rent roll in front of lenders who match your deal profile. Clean inputs translate to faster, better-priced quotes.
