A ready-to-use rent roll spreadsheet for landlords and real estate investors. Track every unit’s rent, lease dates, and status in one place — the same document lenders ask for when you finance or refinance a rental.
A rent roll is a single-page snapshot of all the rental income a property or portfolio produces. Each row is a unit; the columns capture the tenant, lease term, monthly rent, deposit, and status. Add up the rent column and you have the property’s potential gross monthly income — the starting point for cash-flow and cap-rate analysis.
| Column | What it tracks |
|---|---|
| Property / Unit | Identifies each rentable unit in your portfolio. |
| Tenant Name | Who currently occupies the unit (blank if vacant). |
| Lease Start / End | Term dates — flags upcoming renewals and expirations. |
| Monthly Rent | Contract rent per unit; the column totals to your gross monthly rent. |
| Security Deposit | Deposit held, for reconciliation and move-out accounting. |
| Status | Occupied, vacant, on notice, or delinquent. |
| Balance Due | Outstanding balance to track delinquencies. |
| Notes | Renewal terms, month-to-month status, or anything lender-relevant. |
When you apply for an investment-property loan — especially a DSCR loan — the lender uses your rent roll to verify income and size the loan. Buyers use it to underwrite a purchase, and you use it to spot upcoming vacancies, delinquencies, and rent-growth opportunities across your portfolio.
Join our newsletter for new calculators, templates, and lending guidance for real estate investors.
By subscribing, you agree to receive email communications from REinvestorguide. You may unsubscribe at any time.
A rent roll is a snapshot of all the rental income a property or portfolio generates. It lists each unit, the tenant, lease dates, monthly rent, deposit, and status, and totals the potential gross rent. Investors and lenders use it to understand a property’s income at a glance.
At minimum: unit identifier, tenant name, lease start and end dates, monthly rent, security deposit, occupancy status, and any outstanding balance. Many investors add notes for renewals, month-to-month arrangements, or planned rent increases.
A rent roll shows income by unit at a point in time — who pays what and when leases end. A profit & loss statement covers all income and expenses over a period. The rent roll feeds the income side of your P&L and your cash-flow and cap-rate analysis.
Lenders use the rent roll to verify a property’s rental income when underwriting investment-property loans, including DSCR loans. The total monthly rent supports the debt-service-coverage calculation and the income assumptions in an appraisal.
Update it monthly, and any time a lease changes — a new tenant, a renewal, a rent increase, or a vacancy. A current rent roll is what lenders, buyers, and your own cash-flow analysis rely on.
Get matched with investor-friendly lenders — DSCR, hard money, and more. No obligation.
Get Matched