How to Read a Rent Roll: The Seven Columns That Decide a Deal

An offering package will tell you what a property earns. The rent roll tells you who is paying it, on what terms, and for how much longer. It is a single-date snapshot — one line per unit — and it is the closest thing in real estate to reading the source code rather than the documentation.

Where the T-12 operating statement records what the building did over the last year, the rent roll describes the position it is in today. The two answer different questions, and a deal needs both.

The seven columns worth your attention

• Unit and floor plan. Number, bedroom/bath count, square footage. This is the denominator for everything else — rent per square foot is the only fair way to compare a 1-bed against a 2-bed.
• Occupancy status. Occupied, vacant, notice-to-vacate, model, employee-occupied, or down. These are not the same thing, and lumping them together is the single most common way an occupancy figure gets flattered.
• Market rent. The owner’s stated asking rent for that unit. It is an opinion, not a fact.
• Actual rent. What the lease says the resident pays. This is the fact.
• Lease start and expiration. The term, and therefore the date the unit reprices.
• Security deposit. Small numbers, but a column of zeros usually means deposits were waived to fill units.
• Balance / delinquency. What residents currently owe.

Loss to lease: the first number to compute

Add every market rent, add every actual rent, and take the difference. That gap is loss to lease, and it is the most-quoted opportunity in apartment investing. A property with $10,000 of monthly loss to lease is one where the owner believes rents could be $120,000 higher a year.

The question is whether the market rent column is real. It is written by the seller, on a spreadsheet, in support of a sale. The way to test it is to ignore it entirely and look instead at the actual rents on the newest leases — the units leased in the last sixty to ninety days. Those are transactions, not opinions. If recent leases are signing at $1,150 while the market-rent column says $1,300, the achievable rent today is closer to $1,150, and the remaining $150 is a thesis someone still has to prove. Our own rule is to underwrite below the weakest credible evidence, in the same spirit as checking public records against a pro forma rather than accepting the summary page.

The lease-expiration calendar

Sort the rent roll by expiration date and count how many leases end in each month. What you want is a reasonably even spread. What you sometimes find is a cluster — thirty of eighty leases expiring in the same sixty days, often because the previous owner ran short-term or aligned leases to make the property look full at sale.

A cluster is an operational risk with a date attached. If those residents leave together, the property absorbs thirty turns, thirty vacancy periods, and thirty rounds of leasing cost in one quarter. It also concentrates renewal negotiation into a single seasonal window that may be a poor one. Watch too for very short terms — month-to-month tenancies at scale mean income that can reprice quickly in either direction, and a lender will notice before you do.

Concessions, delinquency, and non-revenue units

Three items regularly sit outside the columns and change the answer.

Concessions. A lease at $1,200 with one month free is economically $1,100. Some rent rolls disclose concessions in a footnote; many do not disclose them at all. Ask for a concession report alongside the rent roll, because a building can post full asking rents and full occupancy while giving away a twelfth of its income.

Delinquency. Scan the balance column and total it. Then ask for an aged-receivables report, because a scattering of small balances is normal operations while a handful of residents ninety days past due is a collections problem — and those units are functionally vacant no matter what the status column says.

Non-revenue units. Models, employee units, and offline units pay nothing. Report them honestly and economic occupancy drops below physical occupancy. That distinction is why break-even occupancy is measured on collected rent rather than on doors filled.

What to reconcile before you trust it

A rent roll should not be read alone. Total the actual rents, multiply by twelve, and compare that to the rental-income line on the T-12. A meaningful gap needs an explanation — recent lease-up, or a number that was prepared for marketing rather than accounting. In diligence, the rent roll is then checked against the actual leases and a tenant-estoppel process, because until a resident confirms their own terms, every line remains the seller’s assertion.

Read this way, a rent roll stops being a table and becomes a schedule: of income that exists, income that has to be earned, and dates on which the building will ask you to prove it.