What Is a Rent Roll? A Practical Guide for Small Landlords

A rent roll is a structured document that summarizes the lease terms, tenant information, and rental income for every unit across your properties. It provides an immediate, unit-by-unit snapshot of scheduled rent, collected payments, lease expiration dates, and outstanding balances.

While an income statement shows historical financial performance over a given period, a rent roll shows the operational health of your portfolio right now. Whether you manage two single-family homes or a dozen multifamily units, maintaining an accurate rent roll is essential for managing cash flow, planning turnovers, and presenting your portfolio to lenders.

Why monthly bank deposits fail to tell the whole tenant story

Many small landlords track their business by reviewing bank deposits at the start of the month. If the mortgage is paid and the balance goes up, the portfolio appears healthy. However, relying solely on bank statements hides critical operational risks until they become expensive problems.

A bank statement only confirms that money moved. It does not show:

• Which specific tenants are under market rent
• Whether incoming funds represent current rent, late fees, or deferred security deposits
• Upcoming lease expirations that might cluster in the same month
• Subtle accumulation of unpaid balances or partial payments
• Vacant units that are quietly bleeding holding costs

A rent roll bridges the gap between raw cash movement and lease-level operations. By standardizing tenant data into a single reference document, you create a baseline for auditing your revenue stream against your lease contracts.

Essential data fields every rent roll must include

An effective rent roll needs enough detail to evaluate unit performance without becoming an unmanageable administrative burden. For landlords managing 1 to 20 doors, the following data fields provide the complete operational picture:

1. Property and unit identifiers

Record the property street address, unit number or identifier (e.g., Unit A, Main House, Upstairs), and unit specifications such as bedroom and bathroom counts or square footage.

2. Tenant details

Include the primary leaseholder's full legal name, contact phone number, and email address. If co-signers or multiple tenants are on the lease, note them clearly.

3. Lease timing

Document the exact lease start date, lease end date, and renewal status (e.g., fixed-term or month-to-month). Tracking these dates prevents unplanned vacancy windows and gives you adequate lead time to send non-renewal or rent increase notices.

4. Scheduled rent vs. collected rent

State the contracted monthly base rent alongside any ancillary charges, such as dedicated parking fees, storage lockers, or pet fees. Record the actual rent collected for the current billing cycle to identify shortfalls immediately.

5. Payment status and arrears

Track whether rent is paid on time, currently past due, or carrying a rolling unpaid balance from previous months. Regular arrears tracking is critical before tenant debt becomes unrecoverable.

6. Security deposit records

List the total security deposit and any pet deposits held for each unit. As covered in our guide to security deposit accounting for rental property, deposits are liabilities owed back to the tenant, not earned revenue, and must be tracked separately from monthly income.

A practical rent roll example

Below is a realistic snapshot of a 4-unit portfolio managed across two properties (a duplex and two single-family homes):

Portfolio totals from this snapshot

• Gross scheduled potential rent: $7,450 / month
• Actual collected rent & fees: $5,500 / month
• Current economic shortfall: $1,950 / month ($2,100 vacant unit offset by $150 in ancillary fees)
• Total tenant liabilities held: $5,350

Examining this table immediately highlights two critical management actions: Unit 104B is on a month-to-month agreement at $1,300 (likely below the market rate established by Unit A's $1,450 base), and 510 Oak St requires an immediate lease renewal conversation to avoid a mid-January vacancy.

4 practical ways small landlords use a rent roll

Maintaining this document goes beyond basic record-keeping. A well-kept rent roll functions as an analytical tool across multiple areas of property management.

1. Staggering lease expirations to control turnover costs

Turnover is one of the single largest drivers of reduced rental yields. If you own three properties and all three leases expire in July, you face potential simultaneous vacancies, concentrated repair bills, and hours spent marketing units at the same time.

A rent roll gives you a bird's-eye view of your lease expiration calendar. When signing new leases or offering renewals, you can adjust lease lengths (such as offering a 14-month or 10-month term) to ensure turnovers are spaced evenly throughout the year.

2. Identifying under-market rents and revenue leakages

Over time, sitting tenants often fall behind prevailing market rates. When managing multiple properties, it is easy to forget whether a specific lease was signed two years ago or four years ago.

Reviewing your rent roll alongside market data shows exactly which units are underpriced. For practical strategies on setting rates based on costs and market capacity, read our breakdown on how much rent you should charge using a numbers-first method.

3. Measuring true economic occupancy

Physical occupancy simply tracks whether a body is living in the unit. Economic occupancy measures how much of your potential gross income was actually collected.

If a tenant is two months behind on rent, your physical occupancy is 100%, but your economic occupancy is substantially lower. A rent roll helps you calculate these losses cleanly. To dive deeper into this distinction, see our guide on economic vacancy vs physical vacancy.

`` Economic occupancy rate = (actual rent collected / gross potential rent) x 100 ``

Using our earlier portfolio example:

`` Economic occupancy rate = ($5,500 / $7,450) x 100 = 73.83% ``

4. Qualifying for financing and DSCR loans

When you apply for a mortgage refinance, portfolio line of credit, or a Debt Service Coverage Ratio (DSCR) loan, lenders will invariably ask for a copy of your current rent roll. Lenders use this document to verify actual in-place income rather than relying purely on projections.

An organized, up-to-date rent roll demonstrates professional asset management and accelerates the underwriting process. To learn how lenders evaluate these figures against your debt obligations, review our guide to DSCR for rental property.

Common rent roll mistakes to avoid

Small landlords often introduce errors into their rent rolls that distort financial reporting. Watch out for these frequent mistakes:

• Mixing security deposits with rental revenue: A security deposit is not income; it belongs to the tenant until lawfully claimed for damages or unpaid rent. Treating it as current revenue will artificially inflate your monthly cash-flow picture.
• Failing to log concessions: If you offered one month of free rent spread across a 12-month lease, record both the base contract rent and the net effective rent collected each month.
• Letting the document go stale: A rent roll that is updated only once a year during tax season is useless for day-to-day decisions. Update your rent roll every time a lease is signed, rent is collected, or a tenant vacates.
• Omitting ancillary income streams: Pet rent, storage shed fees, garage rentals, and utility reimbursements should be itemized. Omitting them understates the true revenue generation of the unit.

How to structure and maintain your rent roll

To build a functional rent roll from scratch, choose a format that fits the size of your portfolio and your administrative habits:

1. Spreadsheets: For landlords with 1 to 5 units, a simple spreadsheet in Google Sheets or Microsoft Excel is often sufficient. Use separate columns for each of the core fields outlined above and create a summary row with basic formulas to sum your total potential and collected rent.
2. Property tracking platforms: As your portfolio grows past a few doors, managing individual spreadsheets alongside your monthly receipts, mortgage payments, and maintenance costs can become fragmented. If you are comparing systems, see the landlord's guide to tracking multiple rental properties.

Set a calendar reminder on the 5th of each month—after your rent grace period closes—to review every unit, log any overdue amounts, and verify lease expiration dates for the next 90 days.

A rent roll keeps your lease terms, unit revenues, and tenant statuses organized in one place. Pair your rent roll with dedicated cash-flow tracking to ensure your collected rental income covers your operating expenses, debt service, and capital reserve targets.

Propertira tracks your rental income, recurring bills, and one-off maintenance expenses to show you exactly how much cash flow your portfolio generates every month. See what your rentals actually make.