Rent Roll Template for Landlords: What to Include
A rent roll is a portfolio-level snapshot of rental units, current tenants, lease dates, contract rent, occupancy status, and other key tenancy facts. Unlike a rent payment ledger, which records every transaction, a rent roll is designed to answer operational questions quickly: Which units are occupied? What rent is currently scheduled? Which leases expire soon? Which units are vacant?
A rent roll is an internal management record. It should not replace leases, payment ledgers, accounting records, or legal notices. If a field conflicts with a signed lease or amendment, the signed document controls.
Quick answer: what columns should a rent roll include?
- Property name or address
- Unit number
- Occupancy status
- Tenant or leaseholder name
- Lease start date
- Lease end date
- Current contract rent
- Security deposit reference
- Move-in date
- Renewal or notice status
- Parking, storage, or other major unit notes when useful
- Last reviewed date
Why a rent roll is different from a rent payment tracker
A Rent Payment Tracker answers “what transactions happened?” A rent roll answers “what does the property look like right now?” That distinction is important because mixing payment history into the rent roll can make the sheet too wide and harder to audit.
Rental Property Lab and other current rent-roll resources describe the rent roll as a master list of units, occupants, rent, and lease timing rather than a transaction ledger.
1. Use one row per rentable unit
For a multi-unit building or portfolio, each unit should have its own row even when vacant. This prevents vacant units from disappearing from the operating picture. If you own single-family rentals, one row per property can work.
Use a stable property and unit identifier so rent-roll rows connect to maintenance, inspection, lease, and financial records.
2. Separate occupancy status from tenant name
A blank tenant field does not always tell the whole story. A unit can be vacant, notice given, turnover in progress, held for renovation, or ready for move-in. Add a simple status field with neutral operational labels.
Avoid subjective tenant ratings or protected-class information. HUD’s federal Fair Housing Act framework applies to most housing activities, and state or local law may add protected categories.
3. Copy lease dates exactly from the current signed documents
Record the current term’s start and end dates and update them only after a renewal or extension is fully executed. Preserve prior lease history elsewhere instead of overwriting every old term in a way that erases the record.
The Lease Expiration Tracker should handle reminders and workflow. The rent roll only stores the current snapshot.
4. Use contract rent—not a guess at collected rent
The monthly-rent column should show the current contractual amount for the unit. Actual cash received belongs in the payment tracker or accounting log. This keeps the rent roll useful for comparing scheduled rent with collected income without blending the two concepts.
If concessions, credits, or temporary adjustments apply, decide on a consistent additional field rather than changing the contract-rent number without explanation.
5. Keep deposits as a reference field
You can include the deposit amount or a link to the deposit record, but the detailed transaction history should live in the Security Deposit Ledger. Deposit rules differ by state and locality, and a rent roll should not try to manage holding, interest, deductions, or refund deadlines.
6. Add renewal status without turning the rent roll into a legal calendar
A concise status such as “review scheduled,” “renewal offered,” “signed,” or “move-out confirmed” can be useful. Do not hard-code generic 30-, 60-, or 90-day legal deadlines into the sheet unless they come from the actual lease and applicable law.
Use the Lease Renewal Checklist for the full renewal workflow.
7. Review the rent roll on a fixed schedule
Monthly review works well for many small landlords. Confirm occupancy, current rent, lease dates, move-in or move-out changes, and renewal status. If several people manage the portfolio, add a “last updated” field so stale rows are easy to identify.
8. Use totals carefully
A spreadsheet can total contract rent across occupied units, but label the number accurately. Scheduled or contract rent is not the same as cash collected, taxable income, or net operating income. Vacancies, partial payments, concessions, expenses, and timing differences can make those numbers diverge.
Use the Rental Property Income & Expense Log for broader financial activity.
9. Keep sensitive information out of the roll
A rent roll usually does not need Social Security numbers, bank details, screening reports, birth dates, medical information, or copies of identification. The FTC recommends keeping only personal information needed for legitimate business purposes and restricting access to sensitive records.
A practical small-landlord rent roll layout
For one to twenty units, a spreadsheet with columns for property, unit, status, leaseholder, start, end, monthly rent, deposit reference, renewal status, and notes is usually enough. Add filters for property and lease-end month. Keep detailed payment, maintenance, and communication history in their dedicated records.
How this fits into the record system
The rent roll is the dashboard. The lease summary contains detailed terms for one tenancy. The payment tracker shows transactions. The expiration tracker manages dates. The tenant directory stores contact details. The income and expense log shows property-level financial activity.
The Property Management Binder can organize the property-side records—maintenance, inspections, inventory, emergency information, and other operational checklists—that complement a rent roll.
Add a vacancy and turnover view
A useful rent roll should make vacant units visible without turning into a turnover project plan. Add a status such as occupied, notice given, vacant, make-ready, ready to rent, or lease signed. Then link the unit to the detailed turnover or vacancy checklist instead of adding repair tasks to the rent roll.
Use a rent-roll review to catch inconsistent records
Compare lease end dates with the expiration tracker, rent amounts with the latest signed lease, occupancy with the tenant directory, and deposit references with the deposit ledger. If two systems disagree, investigate the source document rather than choosing whichever number looks familiar.
This cross-check is especially useful after renewals, rent changes, move-outs, or ownership transitions because those events create the most stale rows.
Keep an archived monthly snapshot when useful
For a larger portfolio or a property being refinanced, sold, or reviewed over time, save periodic snapshots instead of continuously overwriting the same file. Historical rent rolls can help explain changes in occupancy, scheduled rent, and lease timing without reconstructing old data from individual leases.
What should not be in a rent roll?
- Every individual rent payment transaction
- Detailed security-deposit deductions
- Full tenant screening data
- Protected-class information
- Maintenance work-order history
- Passwords, bank details, or payment credentials
FAQ
Is a rent roll the same as a rent ledger?
No. A rent roll is a current portfolio snapshot. A rent ledger is a transaction history for rent charges and payments.
Should vacant units stay on the rent roll?
Yes. Mark them vacant or turnover instead of deleting the row so the full rentable inventory remains visible.
Should the rent roll include security deposits?
A reference amount can be useful, but detailed deposit accounting belongs in a separate ledger.
How often should it be updated?
Update it whenever a lease, tenant, rent amount, or occupancy status changes and review the entire roll on a regular schedule.