Rent Roll

A rent roll is more than a spreadsheet; it is the financial spine of any income-producing property. At its core, the document answers three questions: who is paying, how much they owe each month, and when their obligation ends. A well-maintained rent roll will typically contain the unit number or identifier, the tenant's legal name, the lease commencement date, the lease expiration date, the contracted monthly rent, any concessions or rent-free periods in effect, and the current balance owed. For larger portfolios, it may also flag security deposit amounts, pet fees, parking charges, and utility reimbursements. Gross potential rent (GPR) is derived directly from the rent roll and represents the maximum income the property would generate if every unit were occupied at full contracted rent with no delinquencies.

Investors and lenders use the rent roll to stress-test a property's income before closing. The core income formula a lender runs off the rent roll is: Effective Gross Income (EGI) = Gross Potential Rent minus Vacancy and Credit Loss plus Other Income. In notation: EGI = GPR - (GPR x Vacancy Rate) + Other Income. From EGI, the lender subtracts operating expenses to arrive at Net Operating Income (NOI), which then feeds the capitalization rate and debt-service coverage ratio calculations. A rent roll with many near-term lease expirations signals rollover risk, meaning the buyer or lender must underwrite the possibility that tenants do not renew at the same rate. Conversely, a rent roll with long-term leases locked in at below-market rates signals mark-to-market upside, an opportunity to raise rents at renewal and grow NOI without adding units.

For day-to-day property management, the rent roll doubles as a collections tracker. Running it weekly lets a manager catch delinquencies before they compound, identify which leases are expiring in the next 60 to 90 days, and prepare renewal offers proactively. When preparing for a sale or refinance, the rent roll is typically presented alongside trailing 12-month bank statements to verify that the income shown is actually being collected. Audited rent rolls carry more weight with institutional buyers because a third-party accountant has confirmed that each line matches a signed lease and bank deposit. Discrepancies between the rent roll and bank records are a common source of price renegotiation, so accuracy from day one protects the owner's equity at disposition.