A rent roll arrives in whatever format the property manager exports: a PDF with merged cells, a spreadsheet with a tab for each building, a scan. The underwriter retypes or pastes it into a model before any analysis starts. Then the real work begins. Does the occupancy match what the borrower said? Does the income tie to the T-12? Is an expired lease still counted, or a unit listed twice? Concessions add to the work: the Census Bureau's Survey of Market Absorption, as summarized by the National Association of Home Builders in August 2026, found that only 41% of new apartments completed in the first quarter of 2026 were absorbed within three months. Most rent roll problems are small, and each one changes the income a loan is sized on.

The volume makes it worse. Every deal brings its own rent roll in its own format, and the setup work repeats on each one. A panelist at the CREFC June 2026 Conference described where the time goes:

“If you think about the amount of work that goes into underwriting a deal, there's a lot of time that's spent in just model setup, loading historical financials, rent rolls, pulling comps.”

A panelist at the CREFC June 2026 Conference

Smart Capital Center reads rent rolls in any format, standardizes the data, reconciles unit counts and occupancy, and flags every variance for the analyst. For the underwriters and credit analysts using it, that means:

●      Any format, one structure. Rent rolls from different property managers land in the same standardized layout, ready for review.

●      Every variance flagged for the analyst. Unit counts and occupancy are reconciled, and mismatches are listed so the analyst knows where to look.

●      Every figure linked to its source. Each number links back to the page of the rent roll it came from, so questions in credit committee get answered with the document.

This article covers what a rent roll is, what it includes, what lenders check, how to reconcile it with a T-12, the red flags that change a credit decision, and how AI speeds up the review.

What Is a Rent Roll in Commercial Real Estate?

A rent roll is a property-level report that lists every unit or suite in a building with its tenant, lease dates, contract rent, and square footage as of a specific date. Lenders and investors use it to confirm occupancy and in-place rental income. It is useful once it ties out to the operating statements and the property's physical records.

Definitions Worth Having on Hand

●      Rent roll: a report listing each unit or suite with its tenant, lease terms, rent, and square footage as of a stated date.

●      T-12: the trailing twelve months of operating statements, showing actual income and expenses.

●      Contract rent: the rent stated in the lease, before concessions, free rent, or other adjustments.

●      Concession: a discount or incentive offered to a tenant, such as free rent or reduced move-in costs.

●      Charge code: a label in the property management system that identifies a type of charge, such as base rent, parking, or utilities.

●      Physical occupancy: the share of units or square footage that is occupied.

●      Economic occupancy: the share of potential rent that is actually collected.

●      Rollover risk: the risk that leases expire and the space is re-leased at lower rent, after a vacancy, or not at all.

●      Reconciliation check: a test that compares figures that should agree, such as rent roll income and T-12 income, and flags any difference.

●      Agentic AI: AI that carries out multi-step work on its own, pulling from documents and external sources and reconciling what it finds, then handing conclusions to a person to decide on.

Multifamily vs. Commercial Rent Rolls

Multifamily and commercial rent rolls answer the same question, which is what income is in place, and they are built differently.

What Information Is Included in a Rent Roll?

The Core Fields

Most rent rolls list the same core fields, with more detail added by property type:

●      Unit or suite number and tenant name

●      Lease start and end dates

●      Contract rent and scheduled rent escalations

●      Square footage

●      Security deposits

●      Concessions and free rent

●      Charge codes for each type of charge

How Rent Roll Formats Vary and Why That Slows Review

Each property management system exports a rent roll its own way. Column names differ, charges are coded differently, and some exports bury totals in the middle of the page. An analyst spends time converting the layout before checking a single number. A principal at a CRE investment firm described the wish:

“It'd be nice to just be able to put the trailing 12 and rent roll quickly in our model.”

A principal at a CRE investment firm

What Do Lenders Look for in a Rent Roll?

Lenders use the rent roll to confirm what the property earns today. Eight checks come up on almost every file.

Occupancy on the Rent Roll vs. the Occupancy the Borrower Claims

Count the occupied units or leased square footage on the rent roll and compare the result with the occupancy stated in the loan request. A gap of even a few units changes the income, and it often traces to units that are down, in a model apartment, or under a lease that has not started.

Rental Income on the Rent Roll vs. the T-12

Annualized contract rent should land close to T-12 rental income. A large gap points to something the rent roll counts and the T-12 does not, or the reverse. The next section shows how to bridge the two.

Expired Leases and Duplicate Unit Numbers

A lease with an end date in the past that still counts in total rent overstates income unless a month-to-month arrangement is documented. A unit number listed twice does the same. Both are easy to miss in a long export and easy to find with a check built for them.

Concessions and Free Rent

Contract rent can overstate what tenants pay when free months and other concessions are not reflected. Slow lease-up is when concessions tend to appear, and the 41% absorption rate cited above was the seventh consecutive quarter below 50%. A recently signed lease on a newer property deserves a question about what the tenant is actually paying.

Contract Rent and Rent Escalations

Scheduled escalations and rent growth assumptions should be read against what rents are doing. The U.S. Bureau of Labor Statistics Consumer Price Index for rent of primary residence rose 3.5% in 2025 on an annual average basis, after 5.1% in 2024 and 8.0% in 2023. An escalation schedule, or an underwriting growth rate, that sits well above that trend needs support.

Lease Expiration Schedule and Rollover Risk

The expiration schedule shows how much income comes up for renewal inside the loan term. Cushman & Wakefield's Q2 2026 U.S. Office Marketbeat puts national office vacancy at 20.1%, down 10 basis points year over year. Cushman & Wakefield's research lead put the leasing side plainly:

"Occupiers remain disciplined in their leasing decisions."

David C. Smith, Head of Americas Insights, Cushman & Wakefield, Q2 2026 U.S. Office Marketbeat, July 9, 2026

With roughly one in five square feet still vacant nationally, a tenant that leaves may be hard to replace, so the schedule matters as much as current occupancy.

Tenant Concentration in Commercial Properties

On commercial properties, lenders check how much of the income comes from the largest tenants and how their lease terms line up. One tenant carrying a large share of rent, with a lease ending inside the loan term, is a credit question before it is a data question.

Unit Mix and Total Square Footage vs. the Appraisal, OM, or Building Records

Unit counts, unit mix, and total square footage on the rent roll should match the appraisal, the offering memorandum, and the building records. A mismatch changes rent per square foot and revenue per unit, and it can mean units are missing from the roll.

How Do You Reconcile a Rent Roll With a T-12?

Reconciliation turns two documents into one answer: how much of the rent roll's income is supported by what the property actually collected. Work through the same steps on every file.

Seven Steps, in Order

1.   Pull the rent roll and the T-12 for the same period. Confirm the rent roll date and the T-12 end date.

2.   Annualize the contract rent. Multiply monthly contract rent on the rent roll by 12.

3.   Compare it with T-12 rental income. Record the variance in dollars and percent.

4.   Remove known mismatches. Take out duplicate unit numbers, expired leases, and units counted twice.

5.   Adjust for concessions and free rent. Contract rent often does not show them.

6.   Investigate what remains. Check bad debt, move-in timing, and non-rent charges coded to rent.

7.   Document every adjustment and its source page. Keep the file ready for credit committee.

A Worked Example: 80 Units, a 7.05% Gap

An 80-unit multifamily property shows $108,300 of monthly contract rent on its rent roll, or $1,299,600 annualized. T-12 rental income is $1,214,000, so the rent roll runs $85,600 above the T-12, a 7.05% variance. Three problems explain most of it.

Illustrative example, not client data.

The $69,840 of identified overstatement is small against the whole property, and it still matters. At a 9.00% minimum debt yield, that income would support about $776,000 more loan than the property earns.

What Are Red Flags on a Rent Roll?

Eight Signals That Change the Answer

●      Occupancy on the rent roll above the occupancy the borrower stated.

●      Rent roll income well above T-12 rental income, with no bridge between them.

●      Leases with end dates in the past still counted in total rent.

●      Duplicate unit numbers, or suites listed twice.

●      Contract rent that does not reflect free rent or concessions.

●      A heavy expiration schedule inside the loan term, or one tenant carrying a large share of income.

●      Unit mix or total square footage that differs from the appraisal, OM, or building records.

●      A rent roll dated far from the T-12 period, or one with missing units.

For the wider set of checks around these, see CRE Lenders' Due Diligence: What Underwriters Verify and Commercial Real Estate Due Diligence: 2026 Guide.

How Is AI Used to Analyze Rent Rolls?

Rent roll analysis is data work. The analyst's time should go to the credit judgment, so the data work is the part to speed up.

Standardizing Any Format

Smart Capital Center's agentic AI reads a rent roll from any property manager, in any layout, maps it to one standard structure, and checks in-place rents against market data from 120M+ properties, 1B+ signals, $500B+ analyzed. A CRE capital markets professional described the manual version:

“It takes rent rolls and spreads them out, breaking it out by floor plan, by recently signed leases, 30, 60, 90, 120 days. But at the end of the day, that's data entry.”

A CRE capital markets professional

Removing that data entry is where the time comes back. KeyBank Real Estate Capital cut financial model prep time by 40%.

A Reconciliation Summary That Flags Mismatches

Smart Capital Center builds a reconciliation summary of occupancy, vacancy, and rent per unit, compares unit counts against the other documents in the file, and flags every variance for the analyst. Each figure links back to the page it came from. Rose Community Capital "reviews significantly more applications with greater depth and consistency" with Smart Capital Center.

Comparing Two Rent Rolls Over Time

Setting two rent rolls side by side shows which leases rolled, which units turned over, and how rents moved between dates. The underwriter reads the changes and makes the credit call. For more on how the tools in this category compare, see how underwriting software platforms compare, and for the basics of the loans being underwritten, CRE Loans Explained.

A Rent Roll Is Only as Good as Its Tie-Out

Most rent roll problems are small: an expired lease, a duplicated unit, an unrecorded concession. They still change the income a loan is sized on, and a rent roll is only useful once it ties out to the operating statements and the property's physical records. Smart Capital Center's agentic AI standardizes the data, reconciles the figures, and flags every variance for the analyst, and the credit judgment stays with the underwriter.

See your next rent roll reconciled to the T-12, with every variance linked to its source page.

Book a demo with Smart Capital Center →

Frequently Asked Questions

Q: What is a rent roll in commercial real estate?

A: A rent roll is a property-level report that lists every unit or suite with its tenant, lease dates, contract rent, and square footage as of a specific date. Lenders and investors use it to confirm occupancy and in-place rental income. It is useful once it ties out to the operating statements and the property's physical records.

Q: What information is included in a rent roll?

A: A rent roll typically lists the unit or suite, tenant name, lease start and end dates, contract rent, square footage, security deposits, concessions, charge codes, and scheduled rent escalations. The exact fields depend on the property type and the property manager's system. Commercial rent rolls often add recoveries and renewal options.

Q: What do lenders look for in a rent roll?

A: Lenders compare the rent roll's occupancy with the occupancy the borrower claims and compare its rental income with the trailing 12-month operating statement. They also look for expired leases still counted, duplicate unit numbers, concessions, the lease expiration schedule, tenant concentration, and unit mix and square footage that match the appraisal and building records.

Q: How do you reconcile a rent roll with a T-12?

A: Annualize the rent roll's contract rent, compare it with T-12 rental income, and record the variance. Then remove known mismatches such as duplicate units and expired leases, adjust for concessions, and investigate what remains. Document each adjustment and its source page.

Q: What are red flags on a rent roll?

A: Common red flags include occupancy above what the borrower stated, rent roll income well above T-12 income, expired leases still counted, duplicate unit numbers, and contract rent that ignores free rent. For commercial properties, a heavy expiration schedule or one tenant carrying a large share of income also calls for a closer look.

Q: How is AI used to analyze rent rolls?

A: AI reads a rent roll in any format, standardizes the data, builds a reconciliation summary of occupancy, vacancy, and rent per unit, and flags mismatches for the analyst. It can also compare two rent rolls over time. Smart Capital Center's agentic AI links each figure back to the source document, and the underwriter makes the credit call.

Q: How is a multifamily rent roll different from a commercial rent roll?

A: A multifamily rent roll lists apartments by unit number with monthly rent, shorter leases, and concessions. A commercial rent roll lists suites and tenants, usually with rent per square foot, multi-year leases, escalations, and expense recoveries. Lenders emphasize turnover and concessions on multifamily, and rollover, tenant credit, and concentration on commercial.