Skip Navigation
Operator OS

What Is a Rent Roll? A Filled Sample for 1–4 Unit Landlords

A rent roll is a one-page snapshot of every unit, tenant, rent, deposit and balance on one date. The columns, a filled 4-unit sample, and four monthly checks.

7 min read
Two neighboring front doors, one mint green and one cobalt blue, on a white terraced building
On this page

A rent roll is a one-page list of every rental unit you own, showing who lives there, what they pay, when their lease ends, what deposit you hold and what they owe, all as of one date. In five minutes you will know exactly which columns it needs, what a filled one looks like for a small portfolio, and the four things to read off it every month.

If you own one to four units, you probably have this information already. It is just scattered across lease PDFs, a banking app and your memory. The rent roll puts it on one page. The Small-Landlord Income & Expense Workbook includes a printable rent roll sheet, plus a Rent Ledger that works out each unit’s balance and days late for you. But you can build one from your leases in about fifteen minutes, so here is the method either way.


What Goes on a Rent Roll

A rent roll has one row per unit, including empty ones, and one column for each fact you need to see at a glance. These eight columns cover a small landlord:

The eight columns of a small-landlord rent roll, what each one records, and why it earns its place.
ColumnWhat it recordsWhy it matters
UnitAddress and unit numberOne row per door, vacant ones included
TenantWho is on the leaseWho you contact, and who owes
Lease startFirst day of the current termHow long the tenancy has run
Lease endLast day, or “month-to-month”Your renewal deadline
Monthly rentWhat the lease says they oweThe income the unit is supposed to produce
Security depositAmount held and where it is heldMoney you owe back, not money you earned
Balance owedUnpaid rent as of todayYour early warning on a paying problem
StatusCurrent, Partial, Late or VacantOne word you can scan down

Two optional columns are worth adding once the basics are there. Market rent is what the unit would rent for today. Notes holds things like a pet fee, a parking space or a promised repair.


A Filled Rent Roll: Four Units, One Date

Here is how the math plays out with illustrative numbers. Picture a landlord with a duplex, a single-family house and a condo, reading their rent roll on November 5, 2026, a few days after rent was due.

Illustrative four-unit rent roll as of November 5, 2026. “n/a” means the column does not apply.
UnitTenantLease endRentDepositBalanceStatus
Duplex, Unit ATenant 1Jul 31, 2027$1,350$1,350$0Current
Duplex, Unit BTenant 2Dec 31, 2026$1,275$1,275$425Partial
HouseTenant 3Month-to-month$1,900$1,900$0Current
CondoVacantn/a$1,100 askingn/an/aVacant
Totaln/an/a$5,625$4,525$4253 of 4 occupied

That one table answers questions a stack of bank statements cannot, and it fits on a phone screen.


How to Read a Rent Roll: The Four Checks

Reading a rent roll means running four checks, in this order, every month. Each one turns a column into a decision.

  1. Vacancy: what is empty, and what is it costing? The condo has produced nothing since its last tenant left. At $1,100 asking, every month it sits empty is $1,100 gone for good. Three of four units occupied sounds fine until you see a fifth of the potential rent ($1,100 of $5,625) missing.
  2. Delinquency: who owes, and how much? Unit B paid $850 of $1,275. A $425 balance in week one is a phone call. The same balance carried into a second month is a much harder conversation. Collected this month is $4,100 of the $4,525 the occupied units owe, about 91%.
  3. Expirations: whose lease ends soon? Unit B’s lease ends December 31, under 60 days away, and that is the same tenant running a balance. That combination is the one to decide on now: renew, renew at a new rent, or prepare for a turnover. The house is month-to-month, so it can end on short notice from either side. If the rent question is the hard part, work through whether to raise the rent on a good tenant before the renewal letter goes out.
  4. Deposits: what do you owe back? The deposit column totals $4,525, and none of it is yours yet. Keeping that number in its own column stops you spending it as if it were income.

The key takeaway: a rent roll is not a record you file. It is a monthly check that takes five minutes.


Rent Roll vs. Rent Ledger

A rent roll and a rent ledger are not the same document, and a small landlord needs both. The rent ledger is the history: every charge and every payment, in date order, often one ledger per tenant. The rent roll is the snapshot: one row per unit, as of one date.

The ledger is where the balance column comes from. If Unit B’s ledger shows a $1,275 charge on November 1 and an $850 payment on November 3, the roll shows $425 owed. Keep the ledger as payments arrive, then read the roll once a month.


Who Asks for a Rent Roll

On a 1–4 unit property, a rent roll is usually something you keep for yourself. But others may ask for one at some point:

  • A buyer, when you sell. Anyone buying an occupied rental usually wants to know what each unit pays, when each lease ends and what deposits transfer with the property. A current rent roll answers all three on one page.
  • A lender, depending on the loan. For a mortgage sold to Fannie Mae, Fannie Mae’s rental income rules (opens in new tab) document rental income from your tax return’s Schedule E and, in some cases, a lease. A rent roll is not on that list. It is the quickest way to make sure your leases and your return tell the same story.
  • You, at tax time. Total rent received goes on line 3 of Schedule E, per the IRS Schedule E instructions (opens in new tab). Your ledger’s payments for the year add up to that number, and twelve monthly rent rolls show any gap between rent due and rent received, a useful cross-check before you file. The expense side is its own job: see what expenses go on Schedule E for a rental property.

The Two Mistakes That Make a Rent Roll Lie

Two errors creep into almost every homemade rent roll, and both inflate how well you are doing.

  1. Leaving vacant units off. A rent roll that lists only occupied units always looks 100% full. Keep every door on it, with its asking rent, so the vacancy cost stays in front of you.
  2. Mixing deposits and advance rent into rent collected. According to IRS Publication 527 (opens in new tab), a security deposit you plan to return is not income when you receive it, while advance rent, including a “deposit” that will be used as the final month’s rent, is income in the year you receive it. Label each one honestly in the deposit column so the roll and your tax return agree.

Common Questions About Rent Rolls

Is a rent roll the same as a rent ledger?

No. A rent ledger is the payment-by-payment history: every charge and every payment, in date order. A rent roll is the summary of every unit on one date. You keep the ledger all month and read the roll off it.

How often should I update a rent roll?

Once a month, a few days after rent is due. That is when the balance column means something, and it puts the lease-end column in front of you while there is still time to act on it.

Is a security deposit income on a rent roll?

No. Keep deposits in their own column and out of the rent totals. The IRS treats a deposit you plan to return as not income when you receive it. The exception is a deposit that will be applied as final rent, which counts as advance rent.


Build Yours Today

Here’s the move. Open your leases, make one row per unit using the eight columns above, and fill in the balance from this month’s payments. That is your first rent roll. Do it again next month, a few days after rent is due.

If you would rather start from something already built, the Small-Landlord Income & Expense Workbook has a printable rent roll sheet. Its Rent Ledger flags every payment Paid, Late, Partial or Unpaid, its Leases & Deposits tab counts down to each lease end, and it is a file you own rather than a subscription you rent.


Put it to work

Set up and ready to fill in — a one-time download, not a subscription.