If you’re managing more than one rental, you already know the problem: rent due dates, lease terms, and tenant details start living in your head, a notebook, a text thread, and three different spreadsheets. That’s how payments get missed and lease renewals sneak up on you.
A rent roll template fixes this by giving you one page that shows every unit, every tenant, and every rent status at a glance. You don’t need property management software to get organized — you need a simple, consistent format you’ll actually update.
This guide walks through what a rent roll template should include, how it’s different from a rent ledger or a rental income spreadsheet, and how to keep it current without it becoming another chore you abandon after a month.
This article is for informational purposes only and does not constitute legal or tax advice. Laws vary by state. Consult a qualified attorney or tax professional for advice specific to your situation.
What Is a Rent Roll (and Why Small Landlords Need One)
A rent roll is a single document that summarizes every unit you own or manage: who’s living there, what they’re paying, when their lease ends, and whether rent is current. Property managers with large portfolios use rent rolls to report to owners and lenders. But a rent roll template is just as useful for a landlord with two duplexes or a triplex and a single-family rental — anywhere you have more than one tenant to keep straight.
The key difference between a rent roll and other landlord paperwork is scope. A rent receipt documents a single payment. A rent ledger tracks one tenant’s payment history over time. A rent roll template pulls back further and shows your entire portfolio in one view — every unit, every tenant, side by side. Landlords who’ve outgrown a mental checklist but don’t need full property management software land squarely in rent roll territory.
Without this bird’s-eye view, it’s easy to lose track of which lease is expiring next month, which unit is behind on rent, or which tenant’s deposit hasn’t been reconciled. A rent roll template solves that by putting everything on one page you can scan in thirty seconds.
What to Include in a Rent Roll Template
A good rent roll template doesn’t need to be complicated. At minimum, build a row for each unit and include these columns.
Unit and Property Identifiers
Start with a clear label for each property and unit — address, unit number, or both if you manage multiple buildings. If you own a mix of single-family homes and multi-unit buildings, keep the labeling consistent so you can sort and scan quickly. This matters more than it sounds like it would once you’re past three or four units.
Tenant Names and Lease Dates
Each row needs the current tenant’s name, lease start date, lease end date, and whether the lease is fixed-term or month-to-month. This is the column that saves you from a surprise renewal deadline or an accidental month-to-month rollover you didn’t intend.
Rent Amount and Due Date
List the monthly rent amount and the due date for each unit. If you’ve raised rent on some units but not others, this column makes the discrepancy obvious — useful for catching a unit that’s been under market for two years without you noticing.
Payment Status Column
This is the column that turns a static spreadsheet into a working tool. Mark each unit paid, late, or partial for the current month, and update it as payments come in. Some landlords use a simple color code (green, yellow, red); others just type “Paid 6/1” or “Late.” Either works, as long as it’s consistent.
When a payment comes in, document it right away and log the date on your rent roll. The receipt is your proof of payment; the rent roll is your at-a-glance summary. Used together, you get both the documentation and the overview.
Free Rent Roll Template (Download)
A basic rent roll template can be built in any spreadsheet tool — Google Sheets, Excel, or even a shared document if you’re not ready to touch formulas. If Excel is your preference, FreeRentReceipt’s rent receipt Excel template uses a similar row-per-entry layout you can adapt for a rent roll. Set up one row per unit with columns for property/unit, tenant name, lease dates, rent amount, due date, and payment status. Add a notes column for anything unit-specific: a pending repair, a security deposit deduction, or a tenant who’s asked about renewing early.
Keep the template on a shared drive you can access from your phone, since rent roll updates usually happen in the moment — right after a tenant pays, or right after you notice a lease is expiring. If you’re also tracking broader income and expenses across your properties, a rental property profit and loss template pairs naturally with a rent roll: the rent roll shows current status, the P&L shows the financial picture over time.
For each payment you log, create a rent receipt online — free so you have a dated, itemized record that matches what’s marked on your rent roll. That pairing — rent roll for status, receipt for proof — is the simplest system most small landlords need.
Rent Roll vs. Rental Income Spreadsheet
These two terms get used interchangeably, but they’re not quite the same thing. A rent roll is structured around units and tenants — it answers “who owes what, and is it paid?” A rental income spreadsheet is structured around money over time — it answers “how much did I collect this year, and what did it cost me?”
If you’re preparing for tax season or trying to understand your actual return on a property, a rental income spreadsheet that tracks monthly income and expenses per property is the better tool. Our free rent tracking spreadsheet for landlords is built for exactly that use case. If you’re managing day-to-day operations — who’s current, whose lease is expiring, what unit needs attention — the rent roll template is what you want open on your desktop.
Many landlords eventually keep both: a rent roll for operational status and a rental income spreadsheet for the financial summary. They serve different questions, and trying to force one document to do both jobs usually means it does neither well. For a deeper look at the recordkeeping habits that support both documents, FreeRentReceipt’s guide on landlord record keeping covers the basics worth having in place before tax time.
At tax time, your rental income spreadsheet — not your rent roll — is what feeds into Schedule E. The rent roll is an operational tool; the income spreadsheet (or your accounting software) is what your tax preparer actually needs. The IRS’s guidance on rental income and expenses outlines what counts as reportable income and what records support your deductions.
How to Keep Your Rent Roll Updated
A rent roll template only works if you actually update it. The landlords who stick with this system build it into a monthly habit rather than an occasional catch-up project.
The simplest approach: update the payment status column every time rent comes in, whether that’s the 1st of the month or spread across a few days for different units. If you log each payment with a free rent receipt as it arrives, updating the rent roll takes thirty seconds — you’re just marking what you already documented.
Set a recurring reminder for the first week of each month to review lease end dates on your rent roll and flag anything expiring in the next 60–90 days. This is the single biggest reason landlords keep a rent roll in the first place: it turns lease renewals from a surprise into a planned task. If a tenant’s payment history matters for that renewal decision, a rent ledger tracks the full record for that specific unit — a useful companion to the portfolio-wide view your rent roll gives you.
Nolo’s overview of recordkeeping for landlords is a useful reference if you’re deciding between paper records, a spreadsheet, or dedicated software — the right system depends on how many units you manage and how much time you want to spend on admin. For most landlords with 1–4 units, a rent roll template plus a simple receipt system covers the essentials without the cost or learning curve of full property management software.
For more rental management advice, browse our Landlord Tips (https://rentreceiptblog.com/category/landlord-tips/) category. For receipt templates, documentation help, and proof-of-payment guidance, explore our Rent Receipts (https://rentreceiptblog.com/category/rent-receipts/) category.
Keep Your Rent Roll and Your Receipts in Sync
A rent roll template gives you the big picture — every unit, every tenant, every rent status in one place. But it’s only as accurate as the payment records behind it. The easiest way to keep both in sync is to document each payment the moment it happens.
Generate your free rent receipt at FreeRentReceipt.com every time rent comes in, then update your rent roll to match. It takes a minute, and it means you’re never scrambling to reconstruct payment history when a tenant disputes a charge or a lender asks for documentation.
FAQ
What’s the difference between a rent roll and a rent ledger? A rent roll summarizes every unit and tenant across your portfolio at a single point in time. A rent ledger tracks one tenant’s full payment history over time — every payment, date, and amount for that specific unit.
Do I need a rent roll for one rental property? It’s less critical with a single unit, since you don’t need to compare across properties. But even one-unit landlords use a simplified rent roll to track lease dates and payment status alongside their other rental income spreadsheet.
Is a rent roll the same as a rental income spreadsheet? No. A rent roll tracks operational status — who’s paying, whose lease is expiring. A rental income spreadsheet tracks financial totals — income and expenses over time, usually for tax purposes.
How often should I update my rent roll template? Update the payment status column monthly as rent comes in, and review lease end dates at least once a month so renewals don’t catch you off guard.
Can I use a rent roll template if I self-manage without software? Yes. A rent roll works fine as a basic spreadsheet — you don’t need property management software until you’re managing enough units that manual updates become unmanageable.
What should I do if a tenant disputes a payment shown on my rent roll? Pull the dated rent receipt for that payment. If you’ve been generating a receipt for every payment, you’ll have the exact date and amount on record to resolve the dispute quickly.
Does a rent roll template help at tax time? Indirectly. Your rent roll confirms which units were occupied and paying, but your rental income spreadsheet or accounting records are what actually feed into Schedule E for tax filing.
