How to Read a Rent Roll at a Glance: 4 Numbers That Matter

TL;DR: A rent roll is a one-page snapshot of every unit, its rent, its lease term, and what's owed. Scan four columns first — current rent, market rent, lease end date, and balance due — and you'll know within two minutes whether a property is healthy, underpriced, or hiding a collections problem. A 5% or higher gap between current and market rent across multiple units usually means the owner hasn't kept pace with the market for at least a year or two.

_Last reviewed: July 2026 · 7 min read_

You've got a spreadsheet in front of you with 12, 40, or 200 rows of unit numbers, dollar figures, and dates, and no idea which number matters most. That confusion costs money — either you overpay for a property with hidden vacancy problems, or you miss a portfolio that's quietly underpriced and ready to cash-flow better than the asking price suggests.

Okoniq Property Hub keeps rent, lease dates, and maintenance history in one place, so pulling your own rent roll takes minutes instead of a scavenger hunt through old leases.

What exactly is a rent roll, and why should you care?

A rent roll is a list of every unit in a property, showing who lives there, what they pay, when their lease ends, and whether they owe anything. It's the financial fingerprint of a building — pull one at any moment and you can tell whether the owner is running it well or letting it drift.

Lenders ask for a rent roll before approving a loan. Buyers ask for one before making an offer. Property managers generate one every month just to keep track of their own portfolio. If you're an owner-operator with even four or five units, a rent roll dated within the last 30 days should be something you can produce on demand — not something you reconstruct from memory and a stack of paper leases.

Which four numbers on a rent roll actually matter?

Four columns tell you almost everything: current rent, market rent, lease end date, and balance owed. Everything else on the sheet — unit size, tenant name, deposit amount — is context, not signal.

Current rent versus market rent shows you the gap between what you're collecting and what the unit could actually command. If a two-bedroom is renting for $1,450 and the market rate for comparable units is $1,650, that's a $200-a-month gap, or $2,400 a year, sitting on the table. Lease end date tells you your exposure — a building where 60% of leases expire in the same 90-day window means a lot of turnover risk hitting all at once. Balance owed flags collections problems before they become eviction filings.

| Column | What it tells you | Red flag threshold | |---|---|---| | Current vs. market rent | Pricing gap, lost revenue | Gap over 8-10% | | Lease end date | Turnover timing risk | 40%+ leases expiring in same quarter | | Balance owed | Collections health | Any balance over 30 days past due |

How do you spot red flags in a rent roll fast?

Scan for clusters, not single numbers. One late tenant is normal; five late tenants on the same rent roll is a pattern worth investigating before you sign anything.

Look for units marked "vacant" longer than 30 days — each vacant day past that point usually means either the price is wrong or the unit needs work nobody's addressed. Look for concessions (free months, reduced deposits) buried in notes columns; these lower effective rent even when the sticker price looks fine. And check for month-to-month tenants stacking up, since they signal either a management gap or tenants waiting out a sale.

How does a rent roll connect to maintenance costs and deferred repairs?

A rent roll rarely shows repair history directly, but low rents and long vacancies almost always trace back to physical condition. If three units in a 12-unit building are renting 15% below market, ask why — often the answer is a roof that's aging faster than it should or foundation issues buyers noticed during a walkthrough, like the kind covered in which foundation cracks are actually serious.

Deferred maintenance shows up as suppressed rent long before it shows up as a line-item expense. A unit sitting vacant for 60 days because of water intrusion — the sort of issue described in signs water is undermining your foundation — costs far more in lost rent than the repair itself would have. Before buying based on a rent roll, walk the property and match the numbers to what you actually see.

How often should you update or request a rent roll?

Update your rent roll monthly if you self-manage, and request one dated within the last 30 days from any seller or property manager before you make decisions based on it. A rent roll from six months ago can hide a lease that's since expired, a tenant who's stopped paying, or a rent increase that never happened.

For due diligence on a purchase, ask for trailing 12-month rent rolls, not just a single snapshot. That history shows whether vacancy and turnover are one-off events or a recurring pattern — the difference between a bad month and a bad building.

FAQ

What's a normal vacancy rate on a rent roll?

A healthy rent roll typically shows vacancy under 5-7% at any given time; anything sustained above 10% across multiple months signals a pricing, condition, or management problem.

How do I calculate the rent roll gap myself?

Subtract current rent from market rent for each unit, then divide by market rent — a gap over 8-10% on multiple units means the property has been underpriced for a while, often a year or more.

Does a rent roll show maintenance requests or repair costs?

Not usually. A standard rent roll covers rent, lease dates, and balances; maintenance history is typically a separate log, though low rents and long vacancies often point back to unresolved repair issues.

Can I trust a rent roll a seller gives me during due diligence?

Verify it against actual bank deposits and signed leases before relying on it fully; sellers sometimes present optimistic numbers that don't match collected rent.

How many units before I need software instead of a spreadsheet?

Most owner-operators find a spreadsheet manageable up to 6-8 units; beyond that, tracking lease dates, balances, and market comps by hand starts costing more time than it saves.

This is educational information, not financial or legal advice. Consult a CPA or real estate attorney before making purchase or leasing decisions based on rent roll data.