What Is a Rent Roll?

Think of a rent roll as a photograph, not a movie. It captures the property's income position at one moment: July 1, 2026, say. It does not tell you what happened in March, and it does not promise anything about October. That is why every legitimate rent roll carries an as-of date. A rent roll without a date is the first red flag on the list, because scheduled rent changes every time a lease renews, a tenant leaves, or a unit turns.

The second thing a rent roll is not: a record of money received. The rent column shows what each tenant is supposed to pay under the lease. Whether they actually paid lives in the delinquency column if the report is honest, and in the bank statements either way. Keeping "scheduled" and "collected" separate in your head is most of what it takes to read a rent roll like a professional.

If you own even one rental, you have a rent roll whether you have written it down or not. Writing it down is what turns it into a lending document, a diligence document, and a tax workpaper. For the bookkeeping system that keeps it accurate all year, see our guide to real estate accounting.

Most rent roll examples online are suspiciously clean: every unit full, every tenant current, every lease freshly signed. Real ones have problems, and the problems are the point. The sample below has a vacancy, a month-to-month holdover paying below market, a delinquency, and a lease expiring in 30 days, because that is what an ordinary small building looks like on any given day.

Notice what the totals row does. Scheduled rent on occupied units is $11,595 per month, but gross potential rent, the number with the vacant unit filled at market, is $13,145. The gap between those two numbers, plus whatever the delinquent tenant never pays, is the difference between the property on paper and the property in your bank account.

• Unit: the identifier. Cross-check the unit count against the appraisal and the listing. Sellers occasionally count a non-conforming basement unit that a lender will not.
• Tenant name: a real name, not "occupied." Blanks or initials-only across the board make estoppel verification impossible and can hide related-party tenants paying invented rents.
• Square feet / unit type: lets you compute rent per square foot and spot the unit priced wildly out of line with its siblings.
• Lease start and end: the risk calendar. Two red flags live here: leases that all expire in the same quarter (a turnover cliff), and very old start dates with no renewals, which usually mean long-term tenants sitting far below market.
• Monthly rent: compare each unit to current market. Below-market rents are upside to a buyer and a discount to a lender, but they are also a question: why has this rent never been raised?
• Security deposit: the amount held per unit. Zeros and round-number inconsistencies suggest sloppy records, and the deposits must transfer to a buyer at closing.
• Status and balance owed: current, month-to-month, vacant, or delinquent. A month-to-month concentration means the income can walk out with 30 days' notice. A delinquency column that is suspiciously all zeros on a working-class property deserves a bank-statement check.

These three reports get conflated constantly, and the confusion is expensive because each one can look healthy while another looks terrible. The rent roll is the snapshot, the P&L is the scoreboard for a period, and the T12 is the twelve-month trend line. Serious diligence reads all three together.

The practical rule: the rent roll tells you what the income should be, the T12 tells you what it actually was, and the difference between them is a list of questions with names and unit numbers attached.

For one to roughly a dozen units, a spreadsheet is genuinely the right tool. One row per unit, an as-of date at the top, a totals row at the bottom, updated monthly when you post rent. Here are the columns, in order, ready to copy into row one:

Two habits separate a useful rent roll from a decorative one. First, date every version and keep the old ones; the history is what shows a lender or buyer how the property actually behaves. Second, never let the rent roll drift from the leases. If you give a tenant a $50 concession on a handshake, it goes in the notes column, because undocumented side deals are exactly what estoppel certificates exist to surface.

Past a dozen units, or the first time you manage a turn, a delinquency, and a lease renewal in the same month, property management software earns its subscription: it generates the rent roll automatically from the lease and payment data you are already entering. We compare the options landlords actually use in our real estate accounting software guide.

Your rent roll and your tax return describe the same income stream, so they need to reconcile, but they will almost never match to the dollar. The rent roll shows scheduled rent as of a date; Schedule E reports the gross rents you actually received during the year on line 3. The legitimate differences between "rent roll times twelve" and the Schedule E number are vacancy, delinquency, mid-year rent changes, and concessions. Everything left over after those four is a question someone will eventually ask.

Two timing rules do most of the work in this reconciliation:

• Security deposits are not income when you receive them, as long as you intend to return the deposit at the end of the lease. They sit on your rent roll as a liability, not revenue. The year you keep part or all of a deposit, to cover damage or unpaid rent, that amount becomes income. And if a "deposit" is really the last month's rent by agreement, it is advance rent, which is income immediately.
• Prepaid rent is income when received. Most landlords are cash-basis taxpayers, so rent counts the year the money arrives. And advance rent, any amount received before the period it covers, is income in the year received regardless of your accounting method. A tenant who prepays January in December moves that income into the earlier tax year.

If Schedule E itself is unfamiliar territory, our line-by-line Schedule E guide covers where every one of these numbers lands.

The lesson generalizes. A rent roll is a claim. The bank statements, the leases, the estoppels, and the tax return are the evidence. When all of them agree, you can trust the number. When they do not, the gap itself is the most informative number on the page.