What Is a Rent Roll? A Simple Guide for Landlords

News & Blogs

Home/Blogs

Home

Blogs

Real Estate Industry

What Is a Rent Roll? A Simple Guide for Landlords

What Is a Rent Roll? A Simple Guide for Landlords

Real Estate Industry
# February 10, 2026
# 469 Views

You buy a property. You will find tenants. You collect rent. On the surface, being a landlord looks simple. But if you treat it like a casual hobby, you will run into trouble the moment you try to scale up, refinance, or sell.

If you walk into a bank today to ask for a loan on an investment property, the loan officer is going to ask for two things before you even sit down: your tax returns and your Rent Roll.

If you hand them in a shoebox full of receipts or a messy notebook, they won’t take you seriously.

A rent roll is the most critical document for managing the health of your real estate investment. It tells you precisely what is happening with your income stream right now. It is the difference between owning a building and running a business.

Here is a breakdown of what a rent roll actually is, what goes in it, and why you are flying blind without one.

What Exactly Is a Rent Roll?

A rent roll is a snapshot.

Think of your Profit and Loss (P&L) statement as a history book. It tells you what happened last year or last month.

A rent roll is the breaking news. It tells you the status of every single unit in your portfolio at this exact moment. It is a comprehensive list of tenants, lease terms, and income data.

For a single-family home, this might seem overkill. You know the tenants, Bob and Linda. You know they pay $1,500 first. But once you have a duplex, a fourplex, or an apartment building, keeping that info in your head is dangerous.

Real estate investors use this document to calculate the value of the property. Lenders use it to see if the property makes enough money to cover the debt. Property managers use it to chase down late rent.

The Essential Components (What to Include)

You don’t need fancy software to build one. Excel or Google Sheets works fine. The key is accuracy.

If you are building your own, you need more than just names and numbers. A professional rent roll needs specific columns to be useful.

Here is what needs to be there:

1. Unit Identification

This seems obvious, but it gets messy. List the unit number or address. If it includes a garage or a storage unit, list that too.

2. Tenant Information

Name: Who is on the lease?
Contact Info: Phone and email (optional on the main roll, but good to link).
Occupancy Status: Is it occupied, vacant, or “down” (under repair)?

3. Lease Data (The Most Critical Part)

This is where the money is made or lost.

Lease Start Date: When did they move in?
Lease End Date: This is vital. If all your leases end in December, you will have a problem. You need to know when you have to renew your people.
Lease Type: Is it a 12-month lease or month-to-month?

4. Financial Data

Current Rent: What are they actually paying?
Market Rent: What should they be paying? This column helps you see if you are undercharging.
Security Deposit: How much are you holding? (This is a liability—it’s not your money).
Additional Income: Pet fees, parking fees, utility chargebacks.
Arrears: Is anyone behind on rent? If so, how much?

Why You Actually Need One (It’s Not Just Paperwork)

You might think, “I check my bank account. I know I have money.”

But cash in the bank doesn’t tell the whole story. Here is why the rent roll is the backbone of your investment.

1. It’s Required for Financing

Banks do not trust you; they trust numbers.

When you try to refinance to pull cash out or buy another building, the appraiser and the underwriter will demand a current rent roll. They use it to calculate the Debt Service Coverage Ratio (DSCR). Basically, they need to prove the property brings in enough cash to pay the mortgage with a safety margin.

If your rent roll is messy or incomplete, the bank assumes your management is messy. That leads to higher interest rates or a rejected loan.

2. It Determines Property Value

Commercial real estate (anything 5 units or more) is valued based on income, not just what the building looks like.

Buyers look at the “Cap Rate.” To figure that out, they need the Net Operating Income (NOI). You cannot calculate NOI without a solid rental roll.

If you plan to sell, a buyer will look at your rent roll to see:

Are tenants paying on time?
Are the leases about to expire?
Are the rents at market rate or way below?

If you have long-term tenants on low rents, the building is worth less. The rent roll reveals that instantly.

3. Catching Lease Expirations

Let’s say you have a 10-unit building. If you aren’t paying attention, you might have four leases ending in the same month. If those four people move out at once, your cash flow crashes.

A rental roll lets you see the future. You can look at the “Lease End” column and see that Unit 4 is expiring in 60 days. That gives you time to reach out now and ask for a renewal, rather than scrambling to fill a vacancy later.

Rent Roll vs. The P&L Statement

A lot of new landlords confuse these two.

The Profit & Loss (P&L) statement shows income and expenses over a period. It shows you that you collected $10,000 in January and spent $2,000 on repairs.

The Rent Roll does not show expenses (usually). It shows the potential and contractual income.

P&L says: “We collected $900 from Unit 1 this month.”
Rent Roll says: “Unit 1 is supposed to pay $1,000; they owe $100 in late fees, and their lease ends in May.”

You need both. The P&L tracks the cash; the rent roll tracks the agreements.

Red Flags a Rent Roll Reveals

When I look at a rent roll, I’m looking for problems. Whether you are buying a building or just auditing your own, here are the red flags that jump off the page.

The “Month-to-Month” Trap

If every tenant is on a month-to-month lease, that is risky. They could all leave tomorrow. It makes the income stream unstable.

Large Balances in “Arrears”

If the “Amount Due” column is high, you have a collection problem. If a tenant is three months behind, that isn’t income but a potential eviction. A P&L might hide this (because it uses cash accounting), but the rent roll exposes it.

The “Round Number” Problem

This is a pro tip. If you see a rent roll where every rent is exactly $1,000 or $1,500, it’s often fake or lazy. Real rents are usually $1,050, $1,495, etc. If the numbers look too perfect, dig deeper.

Wide Gaps Between Current and Market Rent

If Unit A pays $800 and Unit B pays $1,400 for the same layout, you have a management issue. You are losing money on Unit A. The rent roll highlights this “Loss to Lease”, the money you are leaving on the table.

Tips for Maintaining Your Rent Roll

This document is useless if you don’t update it.

Update it monthly: Do it when you post rents. If someone pays late, update the arrears column.
Keep a digital copy: Don’t just rely on property management software. Export it to Excel or PDF and save it. If you fire your property manager, you don’t want them to hold your data hostage.
Track the “Other” Income: Don’t just list base rent. If you charge $25 for a parking spot, list it. Those little fees add up and increase the value of the building when you sell.

The Bottom Line

Real estate is a numbers game. You might own the bricks and mortar, but the value is in the leases.

The rent roll is the report card for your property. It tells you if you are passing or failing. It helps you catch late payments, prepare vacancies, and prove to the bank that you are a professional.

If you don’t have one, stop what you are doing and build one today. It’s the first step to moving from a landlord who owns a house to an investor who runs a business.

FAQs

What is a rent roll?

It is a document that lists every unit in your property, who lives there, how much rent they pay, and when their lease ends. It gives a snapshot of your current income.

Why do banks ask for a rent roll?

Banks need to see if the property brings in enough money to pay the mortgage. The rent roll proves that the income is real and stable.

What should be included in a rent roll?

You need the unit number, tenant name, current rent amount, lease start and end dates, security deposit held, and any past due balance.

How is a rent roll different from a P&L?

A Profit & Loss (P&L) statement shows what happened in the past (income vs. expenses). A rent roll shows the current status of your leases and what should be coming in.