Owners and asset managers: see where your portfolio's NOI is leaking. Schedule a free working session
Reporting

Rent roll: what it is, what to include, and how to audit one.

A rent roll is a snapshot of a property's units or suites on a set date, showing the tenant, lease dates, rent, deposits and balances. Owners, lenders and buyers use it to confirm current income and upcoming expirations. Always date it and tie it to the leases and the T12 before relying on it.

Updated November 6, 2026 · Opennova

Modern apartment facade with dark panels and glass balconies

What to include

Download our free rent roll template (CSV). It opens in Excel or Google Sheets, with one multifamily row and one commercial row as samples.

FieldMultifamilyCommercial
Unit or suite, and sizeUnit type, SFSuite, rentable SF, pro rata share
TenantResidentLegal entity, guarantor if any
StatusOccupied, vacant, notice, model, downOccupied, vacant, subleased
Lease datesStart and endCommencement, expiration, options
RentMarket and in-placeBase rent and escalations
Other chargesParking, pets, utilitiesCAM, tax and insurance estimates
ConcessionsFree rent, discountsAbatement periods
Deposit and balanceDeposit, amount owedDeposit or letter of credit, arrears

Example

Sample data
UnitTypeStatusLease endMarketIn-placeBalance
1012BR/2BAOccupied01/31/27$1,800$1,728$0
1022BR/2BANotice12/31/26$1,800$1,690$0
1031BR/1BAVacantn/a$1,500n/an/a
1041BR/1BAOccupied04/30/27$1,500$1,525$610

How to audit one

  1. Check the date. An old rent roll doesn't show recent move-outs.
  2. Tie to leases. Sample rents, dates and concessions against signed documents. Include all of the largest commercial tenants.
  3. Tie to the T12. Monthly rent should reconcile to the latest month.
  4. Tie to the bank. Confirm that listed tenants are actually paying.
  5. Tie deposits to the deposit account, which is especially important in a change of manager.
  6. Walk the property. Confirm that vacant, occupied and down units match reality.

What it can tell you

  • Loss to lease: market vs in-place rent.
  • Lease expiration clustering: too many leases ending in a weak month.
  • Delinquency: who owes what, and for how long.
  • Concentration and rollover: for commercial, see WALT.
  • Non-revenue units: models and offices that have quietly built up.

Red flags

  • Many leases signed just before a sale, or with unusual concessions
  • Rents far above comparable new leases
  • Round-number rents, or rents that repeat where you'd expect variation
  • Tenants shown as current who aren't paying
  • Family, employee or related-party tenants paying off-market rent
  • Numbers that don't reconcile, with no explanation

How often to pull one

Asset managers usually want one at each month-end, alongside the financial package. Pull one on demand before a refinance, a sale or a change of manager. Keep every dated version, because comparing two rent rolls side by side shows move-outs, new leases and rent changes that a single snapshot can't. A sudden run of renewals at unusual terms is easier to spot that way.

Rent roll vs lease abstract

A rent roll summarizes everyone in one view, while a lease abstract summarizes one lease in depth. Commercial owners need both. A rent roll can't warn you about an option notice date unless someone has captured it from the lease.

Questions owners ask.

What is a rent roll in real estate?

It's a dated schedule listing each unit or suite with its tenant, lease terms, rent and balances. It shows the income in place at that moment.

What's the difference between a rent roll and a T12?

A rent roll is a snapshot of current leases. A T12 shows actual income and expenses over the past 12 months. Use them together.

Is a certified rent roll different?

A certified rent roll is signed by the owner or manager as accurate, and it's often requested by lenders and buyers. Check the required wording with your counsel, since a false certification creates liability.

Keep reading.

See what your rent roll is telling you.

Tell us about the portfolio. We'll identify your highest-impact opportunities within 48 hours, then work through them with you.

Free · No obligation · Confidential
Schedule a working session