Rent Roll Template: What to Include and How to Use It

The purpose of a rent roll

A rent roll answers three questions at a glance: who is in the building, what income it produces, and when leases turn. Used well, it drives rent collection, flags upcoming renewals and vacancies, reconciles deposits held, and feeds the income side of a property analysis or a loan application.

For a single unit the rent roll is trivial. For a small multifamily or a portfolio it becomes the document that keeps occupancy, deposits, and lease timing from slipping through the cracks. Keeping it current is a monthly discipline, not a once-a-year exercise.

Property and unit identification

Each row represents one unit. Identify the property address and the unit number so a multi-building portfolio can be sorted and filtered. Include bedroom and bathroom count and the square footage if you track it, because those attributes anchor the rent to comparable units when you review pricing.

Tenant and lease dates

Record the tenant name on the lease, the lease start date, and the lease end date. The end date is the field that drives your renewal calendar; sort by it monthly so no expiration arrives without notice. If you operate on month-to-month tenancies after a fixed term, note that explicitly rather than leaving the end date blank.

Rent and recurring charges

Capture both market rent and contract rent. Market rent is what the unit would lease for today; contract rent is what the current tenant actually pays. The gap between the two tells you whether you have upside at renewal or exposure to a rent reduction at turnover. Add any recurring charges the tenant pays, such as pet rent, parking, or a monthly utility surcharge, so the income figure is complete.

Security deposit tracking

Record the deposit amount held, the account or location where it is held, and the date it was received. Deposits are a liability you owe back to the tenant, subject to jurisdiction-specific deadlines and itemization rules, so the rent roll is where you confirm every deposit is actually held and reconciled. If deposits are commingled or missing, that becomes your liability the day you take over a building.

Payment status and balance

Track the rent due day, the current balance owed, and a status flag such as current, late, or in notice. A rent roll with a live balance column is the simplest collection tool you can keep: sort by balance descending and work the list. Update it at every monthly close so delinquency is visible early, when it is still inexpensive to resolve.

Lease expiration and occupancy

The lease expiration column and an occupancy flag together show the timing of your vacancy exposure. If several leases expire in the same month, you are carrying a clustered vacancy risk; stagger renewals so no single month exposes you to multiple simultaneous turns. Mark vacant units distinctly so occupancy is readable at a glance.

Notes

A free-text notes column captures what the structured fields cannot: a pending reasonable accommodation, a planned renovation, a tenant on a payment plan, or a renewal conversation already underway. Keep notes factual and dated, and avoid recording information that belongs in a separate confidential file.

Reviewing a rent roll

A rent roll is only as useful as it is accurate, and inaccuracies hide problems. Review it monthly for the patterns that signal trouble.

• Contract rent well below market with no documented reason, which understates income and hides upside.
• Lease expiration dates clustered in one or two months, which concentrates vacancy risk.
• Deposits recorded but not matched to a holding account, which signals commingling risk.
• Balances owed growing month over month without a collection action noted.
• Units marked occupied with no current lease on file, which gaps your documentation.

Common inconsistencies to watch

When you receive a rent roll from a seller, treat it as a starting point, not a finished document. Reconcile every line against the lease and the bank statements. Common issues include contract rents that do not match the lease, deposits listed but not actually held, and tenants shown as current who are in fact behind. Each discrepancy is a negotiating point and a future liability if you do not catch it before closing.

How a rent roll feeds property analysis

The rent roll is the income input to nearly every property analysis. Gross scheduled rent comes from summing contract rent across occupied units plus market rent on vacant ones. Vacancy and credit loss are estimated against the rent roll’s history. Effective gross income, net operating income, cap rate, and cash-on-cash return all flow from numbers that start on the rent roll, so an inaccurate rent roll quietly corrupts every metric downstream.

Privacy and recordkeeping

A rent roll contains tenant personal and financial information, so handle it accordingly. Limit access to people who need it for operations, financing, or a sale under appropriate confidentiality. Retain rent rolls as part of the property file for the period your jurisdiction and tax advisor recommend, and dispose of them securely when that period ends. This is educational guidance, not legal advice; confirm retention and privacy obligations with a qualified professional.

Frequently Asked Questions