Template

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.

Updated November 17, 2026
UnitTenantLease startLease endMonthly rentDeposit heldBalanceStatus
Maple Court 1AMaria R.2026-03-012027-02-28$1,850.00$1,850.00$0.00Current
Maple Court 1BJ. Rivera2025-09-012026-08-31$1,725.00$1,725.00$0.00Month-to-month
Maple Court 2AD. Kim2026-06-152027-06-14$1,950.00$1,950.00$412.50Past due
Maple Court 2BA. Patel2025-12-012026-11-30$1,800.00$1,800.00$0.00Notice to vacate
Maple Court 3A$1,875.00$0.00$0.00Vacant

How to use it

  1. List every unit in the property, one row each, including vacant and down units.
  2. Enter the current tenant and the lease start and end dates. Leave them blank for a vacant unit.
  3. Enter the monthly rent. For a vacant unit, enter the asking or market rent and say so in your notes.
  4. Enter the deposit held for that lease, from your deposit records.
  5. Enter the balance: what the tenant owes today, from the ledger. Use a negative number for a prepaid credit.
  6. Set the status: Current, Past due, Month-to-month, Notice to vacate or Vacant.
  7. Total the monthly rent, deposit and balance columns, and date the rent roll. A rent roll is a snapshot of one day.
FAQ

Questions, answered.

Still have a question? Ask our team

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.