What is a rent roll? (And why even a three-unit landlord needs one)
Ask a self-managing landlord how the portfolio's doing and you'll usually get a feeling — "pretty good, everyone's mostly paying." Ask a lender, a buyer, or an insurance agent the same question and they'll ask for a specific document: the rent roll. It's the least glamorous artifact in real estate — one row per unit — and it quietly answers every question that matters: what should this portfolio earn, who's actually in it, and which leases are about to become problems. If you keep exactly one operating document as a landlord, this is the one.
One row per unit — that's the whole idea
A rent roll is a table with a row for every rentable unit you own — including the empty ones, which is half the point. The standard columns:
- Property and unit — so a duplex is two rows, not one.
- Tenant name — or blank, which is how vacancy becomes visible instead of vaguely known.
- Lease start and end dates — the two cells that run the business, as we'll get to.
- Monthly rent — the contract amount, not what arrived (that's the ledger's job, below).
- Security deposit held — which your state regulates more tightly than most landlords realize; the deposit-deadline guide covers how tightly.
- Beds/baths or unit type — so the roll doubles as the portfolio inventory.
Sum the rent column and you get your monthly rent roll — the number the portfolio should produce at full collection. Count the occupied rows against the total and you get occupancy. A sample ten-unit portfolio might read: 8 occupied, 80% occupancy, $12,950 a month at full song. Two numbers, and you already know more than "pretty good."
The lease dates are the part that pays
Here's what separates a rent roll that earns its keep from a list of tenants: watching the lease-end column. A lease that expires unnoticed doesn't end the tenancy — in most arrangements it slides into month-to-month, which means a tenant who can leave on short notice, in whatever month they choose, at last year's rent. Do that across a few units for a few years and you've quietly built a portfolio with no lease terms, mistimed turnovers, and rents that drifted below market by accident rather than decision.
The fix is a renewal window: flag every lease inside 60 days of expiring, and treat the flag as a task — send the renewal, open the rent conversation, or plan the turnover on your schedule instead of the tenant's. Expired leases and vacant units get the loudest flag. This is mechanical work a spreadsheet does better than memory: days-to-lease-end is a subtraction, and red-at-expired / amber-inside-60 is a formatting rule. The judgment — renew, raise, or re-list — stays yours; the not-forgetting gets automated.
Rent roll vs. rent ledger — don't merge them
The classic small-landlord bookkeeping mistake is one mega-sheet where contract rent and received rent share a column. Keep them separate, because they answer different questions:
| Rent roll | Rent ledger | |
|---|---|---|
| One row per… | unit | charge (unit × month) |
| Answers | what should come in | what actually did |
| Key output | monthly roll, occupancy, lease flags | balances, overdue list, collection rate |
| Changes | rarely (move-ins/outs, renewals) | every month, every payment |
The gap between the two is where the truth lives. That sample portfolio with a $12,950 roll might show $1,950 still outstanding and a collection rate in the high eighties — which turns "everyone's mostly paying" into a short, specific list of who to chase and how far behind each one is. A ledger row per charge, with amount-paid beside amount-due, produces the balance and the status (paid, partial, overdue) on its own. Add the third log — maintenance, with cost and open/closed status per unit — and you can finally see the unit that's eating its own rent in repairs, which is a sell-or-raise conversation you can't have from receipts in a shoebox.
Why lenders always ask for it
Beyond running your own shop, the rent roll is the document the outside world grades you on. Refinancing a rental — including the refinance step that makes a BRRRR work — starts with the lender asking for a current rent roll. Selling, the buyer's first diligence request is the rent roll. Insurance, estate planning, a partnership conversation: rent roll. Producing a clean one in five minutes reads as "this person runs a business"; reconstructing one from bank statements over a stressful week reads as the discount the buyer was hoping for. The landlords who keep it current aren't more diligent people — they just keep it somewhere that updates itself as they log ordinary events: a move-in, a payment, a repair. (And every tenant on it should have arrived through a process that holds up — screening done legally is the front door of the same system.)
Rent roll, ledger, and maintenance — one workbook, one dashboard
The Rental Property Tracker is the system in this article, built: a 40-unit rent roll with the lease-expiration engine (vacant and expired turn red, inside-60-days turns amber), a rent ledger where balances and Paid/Partial/Overdue status figure themselves, a maintenance log, and a dashboard that rolls it up — occupancy, monthly rent roll, outstanding rent, collection rate, expiring leases, open repairs. Pure formulas, no macros, Excel.
Start with the units you have
A rent roll for three units takes fifteen minutes to set up, which is exactly why it gets skipped — it feels like paperwork for a bigger operation than yours. But the three-unit landlord loses the same ways the thirty-unit one does: the lease that lapsed into month-to-month two years ago, the tenant who's been $300 behind since spring, the deposit amount nobody wrote down. One row per unit, kept honest, is the difference between owning rentals and running them. This is an operations record, not legal or tax advice — lease terms and deposit rules are state-by-state questions for your own lease and, when it matters, a local professional.