How to Read a Rent Roll (Line by Line) and Spot the Red Flags

A rent roll is the single most important spreadsheet in rental real estate. For buyers it's the foundation of every offer. For owners it's the monthly health check. For lenders it's the document that determines whether a deal qualifies for financing. And yet most landlords have never been shown how to read one line-by-line.

Here's what every column actually means — and where sellers hide problems.

What a rent roll is

A rent roll is a unit-by-unit snapshot of every tenancy in a property (or portfolio) at a single point in time. One row per unit. At minimum it shows who lives there, what they pay, when their lease ends, and whether they are current.

The 12 columns every rent roll should have

1. Unit number / address — including vacant units. A rent roll that omits vacants is hiding something.
2. Tenant name — "Vacant" if empty.
3. Bed / bath / sq ft — so rent-per-sq-ft can be compared.
4. Lease start
5. Lease end — flag anything month-to-month or expiring in <90 days.
6. Monthly rent — the contract amount.
7. Market rent — what a new tenant would pay today. The gap is your upside (or loss).
8. Security deposit held — this is a liability, not your money.
9. Move-in date — long tenure is good; less than 6 months in a "stable" portfolio is suspicious.
10. Balance owed — current arrears.
11. Last payment date — the single best predictor of future payment.
12. Notes — Section 8? Pet rent? Pending eviction?

The math you should always run

Physical occupancy can be 100% while economic occupancy is 88% — that 12% is either concessions, delinquencies, or below-market rents that the seller is quietly carrying.

5 red flags that hide in a rent roll

• Identical lease start dates across many units → recent push to "fill" before a sale.
• Cluster of leases ending within 60 days of closing → likely turnover & vacancy you'll inherit.
• Rents 15%+ below market with long tenure → friends, family, or "loyalty" tenants who fight a raise.
• Balance owed > 1 month on multiple units → owner is reporting paper income, not cash.
• "M2M" everywhere → no written leases. Verify with bank deposits.

Rent roll vs T-12

The rent roll is a single point in time. The T-12 (trailing 12 months of income and expenses) is the year. Read them together — a strong rent roll today with a weak T-12 means the seller just "stabilized" the property for the listing photo.

For the full deal workflow see our 7-step rental analysis framework.