Property Management Rent Roll preview
Rent Roll sheet tracking tenants, unit numbers, beds, lease dates, monthly rent, market rent, deposits, balances, and occupancy status across multiple properties. 1/5

About this property management rent roll spreadsheet template

This property management rent roll template gives landlords, property managers, and real estate professionals a structured five-sheet workbook to oversee residential rental portfolios. The Rent Roll sheet captures tenant details, lease dates, monthly and market rents, deposits, payments, and balances for each unit across properties like Maple Court, Harbor View, and Oak Terrace. The Lease Alerts sheet flags overdue rent balances, upcoming renewals, and recommended actions so managers can respond proactively.

The Property Dashboard consolidates portfolio-wide KPIs — total units, occupied count, occupancy rate, and monthly rent totals — into a single at-a-glance view. Unit Cards offer quick individual snapshots, and the International Setup sheet provides currency formatting and date convention guidance for teams operating across different markets. Every cell, label, and layout element is fully editable in WPS Office, Microsoft Excel, or Google Sheets.

5 structured sheets

Rent Roll, Lease Alerts, Property Dashboard, Unit Cards, and International Setup in one workbook.

Portfolio-wide tracking

Monitor multiple properties, tenants, lease statuses, and rent collections in a single file.

Clean dashboard style

At-a-glance KPIs with occupancy rates, rent totals, and property-level breakdowns.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, Apple Numbers, and Notion.

Frequently asked questions
The Property Management Rent Roll template is designed for landlords, property managers, and real estate professionals to track tenants, lease dates, rent payments, balances, and occupancy across multiple residential properties. Customize the sample data, labels, and other editable elements in WPS Office for your own portfolio.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data and structure in a Notion database; for branded visual reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder property names, tenant data, rent amounts, dates, and other editable cells with your own portfolio information.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for property portfolio reporting, investor presentations, rent collection tracking, and lease management workflows. It is available for personal and commercial projects, subject to the applicable template license.