Rent roll template
A rent roll is a list of every unit in a property with its tenant, lease dates, rent, deposit held, current balance and status. This free rent roll template has those columns, five sample rows and a CSV download.
Keep one row per unit, including vacant units, so the rent roll always adds up to the whole property.
| Unit | Tenant | Lease start | Lease end | Monthly rent | Deposit held | Balance | Status |
|---|---|---|---|---|---|---|---|
| Maple Court 1A | Maria R. | 2026-03-01 | 2027-02-28 | $1,850.00 | $1,850.00 | $0.00 | Current |
| Maple Court 1B | J. Rivera | 2025-09-01 | 2026-08-31 | $1,725.00 | $1,725.00 | $0.00 | Month-to-month |
| Maple Court 2A | D. Kim | 2026-06-15 | 2027-06-14 | $1,950.00 | $1,950.00 | $412.50 | Past due |
| Maple Court 2B | A. Patel | 2025-12-01 | 2026-11-30 | $1,800.00 | $1,800.00 | $0.00 | Notice to vacate |
| Maple Court 3A | $1,875.00 | $0.00 | $0.00 | Vacant |
How to use it
- List every unit in the property, one row each, including vacant and down units.
- Enter the current tenant and the lease start and end dates. Leave them blank for a vacant unit.
- Enter the monthly rent. For a vacant unit, enter the asking or market rent and say so in your notes.
- Enter the deposit held for that lease, from your deposit records.
- Enter the balance: what the tenant owes today, from the ledger. Use a negative number for a prepaid credit.
- Set the status: Current, Past due, Month-to-month, Notice to vacate or Vacant.
- Total the monthly rent, deposit and balance columns, and date the rent roll. A rent roll is a snapshot of one day.
What is a rent roll?
A rent roll is a list of every unit in a property with its tenant, lease dates, rent, deposit, balance and status. Owners, lenders and buyers use it to see a property's income at a glance.
What columns should a rent roll have?
At minimum: unit, tenant, lease start, lease end, monthly rent, deposit held, balance and status. Many add unit type, square feet, market rent and move-in date.
How often should I update a rent roll?
Each time a lease, rent or balance changes, and at least once a month at month-end close. Always date it, because it reflects a single day.
Should vacant units be on the rent roll?
Yes. Listing vacant units shows the full property, and occupancy can be read straight from the rows.
Can I download this rent roll template?
Yes. Download the CSV and open it in any spreadsheet program. It is free, with no sign-up.
See Zrico run your portfolio.
Bring a property. We will show you, on your own data, what Zrico would have handled last month.