Owner Resources

How to read a rent roll

A rent roll is the unit-by-unit ledger of an apartment building’s rental income. Each row is a single unit, and the columns describe who lives there, what their lease says, what they pay, and whether the unit is occupied. Read together, the rows tell you what the building actually collects today — which is the foundation every income figure in a deal is built on. Reading a rent roll well is mostly about knowing what each column means and refusing to trust any of them until you have checked them against the leases and the deposits.

The anatomy of a rent roll A table skeleton representing a rent roll. A navy header row spans the top with five labeled columns: unit, tenant, lease start and end, monthly rent, and status. Below the header are several blank rows, each standing for one apartment unit, with the cells intentionally empty. Brass callouts point to the monthly-rent column as the income line and to the status column as the occupancy signal. The diagram shows only the structure of a rent roll — which columns exist and what each one carries. No dollar amounts or figures are shown. The anatomy of a rent roll Unit Tenant Lease start & end Monthly rent Status The income line The occupancy signal Each row — one unit
A rent roll, column by column: each row is one unit, the rent column carries the income, and the status column shows occupancy. This shows the structure of a rent roll, not any building’s actual figures.

This is general education for prospective and current owners, not investment, financial, tax, or legal advice — run your specific numbers past your own accountant and lender. What follows walks each column of a rent roll, explains what it tells you, and shows how to check it so the income story you build a deal on is real rather than reported.

The unit column: the building, one row at a time

The leftmost column identifies each unit, and it is the spine of the whole document. Every other figure on the row hangs off this identifier. The first thing to do with it is simple counting: make sure the number of rows matches the number of units the building is supposed to have. A rent roll that is missing units, or that quietly folds a non-revenue space into the count, distorts everything downstream.

The unit column also lets you map the building’s mix. Reading down it, you can see how many of each floor plan exist, which matters because a building’s income is the sum of its unit types, not an average. Two buildings with the same unit count can produce very different income if one is weighted toward larger units. Confirm the unit list against the actual building before you trust any total.

The tenant column: who is actually in place

The tenant column names the resident on each lease, and its job is to confirm that occupied units are genuinely occupied by a real, leased tenant. A blank where the status says occupied is a flag. So is a single name appearing across an implausible number of units, which can signal a related party or a placeholder propping up the apparent occupancy.

You are not reading this column for the names themselves; you are reading it to confirm the income on each row belongs to a real tenancy you can verify against a signed lease. In due diligence, the tenant name on the rent roll should match the tenant name on the lease and on the payment ledger. Where it does not, that row needs explaining before you count its rent.

The lease start and end columns: how locked-in the income is

The lease dates tell you when each tenancy began and when it expires, and together they reveal how stable the income is. A building where most leases expire in the same narrow window carries concentrated turnover risk — a lot of units coming open at once. A building with staggered expirations spreads that risk out. Neither is good or bad on its own, but you want to see the pattern before you buy it.

The end dates also flag near-term exposure. Leases expiring soon are income that is not yet committed, and any unit already on a month-to-month arrangement past its original term is income that can leave on short notice. Read the expiration column alongside the status column, and you get a clear picture of how much of the building’s rent is contractually locked in versus floating.

The monthly rent column: the income, verified not assumed

This is the column the whole document exists to report: what each unit pays per month. Annualized and summed across the occupied units, it is the building’s in-place rental income — the real starting point for an income analysis, distinct from the theoretical maximum if every unit were full at market rent.

The discipline here is verification. The rent on each row should match the rent in that unit’s signed lease, and the collected rent should trace to bank deposits or a payment ledger. A rent roll is a seller’s representation until you have tied it to those sources; once you have, it becomes income you can underwrite. Watch, too, for concessions — a unit showing full rent on the roll while a side agreement grants free weeks is reporting income the building does not really collect.

Real-World Scenario: A buyer receives a clean-looking rent roll showing the building fully occupied at strong rents, and the income total makes the deal pencil. In due diligence, the buyer matches each row to the leases and the bank deposits and finds two units where the collected rent is well below the rent roll figure because of move-in concessions, plus one occupied unit whose tenant has not paid in two months. The verified income is lower than the reported income. Same building, same rent roll — checking the columns against the sources changed what the income was actually worth, and the buyer adjusted the offer instead of inheriting a surprise.

The status column: occupancy at a glance

The status column tells you, unit by unit, whether each one is occupied, vacant, or on notice. Counted against the total, it gives you the building’s current physical occupancy — and physical occupancy is not the same as economic occupancy, because an occupied unit whose tenant is delinquent is occupied but not paying. Read the status column together with the rent and the payment history to separate the two.

Vacant and notice units are the building’s near-term income exposure made visible. A handful of vacancies might mean ordinary turnover or might mean a leasing problem; the rent roll alone will not tell you which, but it tells you where to look. For broader context on how vacancy behaves across markets, the U.S. Census Bureau’s Housing Vacancies and Homeownership data is a useful primary reference, while the specific building’s own history is what should drive your underwriting.

Where the rent roll meets insurance

The rent roll is an income document, but it carries two pieces of information that feed directly into how a building is insured. The first is the income itself. The rental income a rent roll reports is exactly the figure business-income coverage is built to protect — if a covered loss makes units unrentable while the building is repaired, that coverage stands in for the rent the rent roll shows the building would have collected. A rent roll that understates income understates what you would need that coverage to replace.

The second is occupancy and unit count, which feed how the property and liability lines are rated. A building’s exposure is built from real, specific facts — its construction, its systems, its location, and how fully it is occupied — not from a per-unit rule of thumb. That is why a current quote on the actual building beats a guessed number; it replaces a placeholder with a figure tied to the building the rent roll describes. The structure of those lines is laid out in the property insurance and general liability overviews, and the Insurance Information Institute is a useful primary reference on how property-casualty coverage is built.

Read it, then verify it, then act

A rent roll read carefully is one of the most honest documents in a deal, because every column can be checked against a source. Count the units, confirm the tenants, read the lease dates for turnover risk, tie the rent to leases and deposits, and use the status column to separate physical from economic occupancy. Do that, and the income figure you carry into the rest of your analysis means something.

From there, the rent roll feeds the rest of the underwriting. It sets the income that flows into how to calculate cash flow on an apartment deal, it informs the deal-quality lenses in how to tell if an apartment building is a good deal, and it belongs on the due diligence checklist before closing. When you reach the insurance line, start with the apartment building insurance overview — and note the cost varies by location, which is why the conversation differs across Indiana, Texas, and Florida. When you have a building under contract, start a quote or reach the agency so your operating picture carries a real coverage number alongside a verified rent roll.

The bottom line

A rent roll is the unit-by-unit ledger of who is renting, on what terms, and at what rent — and reading it well means checking each column against leases and bank deposits, because the rent roll is the foundation every income figure in a deal is built on.

Frequently asked questions

What is a rent roll?

A rent roll is a unit-by-unit ledger of an apartment building’s rental income. Each row is one unit, and the columns describe the tenant, the lease start and end dates, the monthly rent, and the unit’s status — occupied, vacant, or notice. Together the rows show what the building actually collects today, which is the starting point for any income analysis of the property.

What columns should a rent roll have?

A useful rent roll lists, at minimum, the unit identifier, the tenant name, the lease start and end dates, the monthly contract rent, and the unit status. Many add deposit held, square footage, floor plan, and any concessions. The exact format varies by owner, but those core columns are what let you reconstruct the income story and check it against the leases and deposits.

How do you verify a rent roll?

Tie it back to source documents. Match each row’s rent and dates to the actual signed lease, then trace the rent to bank deposits or a payment ledger to confirm the money is really collected. Flag any unit where the rent roll, the lease, and the deposits disagree. Verification turns a spreadsheet a seller handed you into income you can actually underwrite.

What is the difference between contract rent and market rent on a rent roll?

Contract rent is what the current lease actually charges that tenant — the number on the rent roll today. Market rent is what the unit would command if it were leased fresh at current rates. They often differ, especially in a building with long-tenured residents or recent rate movement. A rent roll reports contract rent; market rent is a separate estimate you build for your own projections.

Does a rent roll show vacancy?

Yes, through the status column. Units marked vacant are not generating rent, and units on notice will turn over soon. Counting vacant and notice units against the total tells you the building’s current physical occupancy. That snapshot, read alongside the lease expiration dates, shows how much of the income is locked in versus exposed to turnover in the near term.

Why does a rent roll matter for insurance?

The rent roll establishes the income a building produces, which is the figure business-income coverage is built to protect if a covered loss makes units unrentable. It also confirms the building’s occupancy and unit count, which feed how the property and liability lines are rated. A verified rent roll and a current insurance quote are two halves of an honest operating picture.

About the author

Nate Jones, CPCU

Nate Jones, CPCU, is the founder of Wexford Insurance and Apartment Guard Insurance, a specialty insurance agency placing apartment building coverage in 48 states across a 17-carrier specialty panel. He prices the insurance line that rides alongside the income a rent roll reports, so owners can pair a verified rent picture with a real coverage number, through Wexford Insurance. Connect via the Apartment Guard Insurance quote form or call 317-942-0549.

Insure your apartment building with a CPCU-led agency

Tell us about your building and we will market it to carriers that write the class.