What to include
Download our free rent roll template (CSV). It opens in Excel or Google Sheets, with one multifamily row and one commercial row as samples.
| Field | Multifamily | Commercial |
|---|---|---|
| Unit or suite, and size | Unit type, SF | Suite, rentable SF, pro rata share |
| Tenant | Resident | Legal entity, guarantor if any |
| Status | Occupied, vacant, notice, model, down | Occupied, vacant, subleased |
| Lease dates | Start and end | Commencement, expiration, options |
| Rent | Market and in-place | Base rent and escalations |
| Other charges | Parking, pets, utilities | CAM, tax and insurance estimates |
| Concessions | Free rent, discounts | Abatement periods |
| Deposit and balance | Deposit, amount owed | Deposit or letter of credit, arrears |
Example
| Unit | Type | Status | Lease end | Market | In-place | Balance |
|---|---|---|---|---|---|---|
| 101 | 2BR/2BA | Occupied | 01/31/27 | $1,800 | $1,728 | $0 |
| 102 | 2BR/2BA | Notice | 12/31/26 | $1,800 | $1,690 | $0 |
| 103 | 1BR/1BA | Vacant | n/a | $1,500 | n/a | n/a |
| 104 | 1BR/1BA | Occupied | 04/30/27 | $1,500 | $1,525 | $610 |
How to audit one
- Check the date. An old rent roll doesn't show recent move-outs.
- Tie to leases. Sample rents, dates and concessions against signed documents. Include all of the largest commercial tenants.
- Tie to the T12. Monthly rent should reconcile to the latest month.
- Tie to the bank. Confirm that listed tenants are actually paying.
- Tie deposits to the deposit account, which is especially important in a change of manager.
- Walk the property. Confirm that vacant, occupied and down units match reality.
What it can tell you
- Loss to lease: market vs in-place rent.
- Lease expiration clustering: too many leases ending in a weak month.
- Delinquency: who owes what, and for how long.
- Concentration and rollover: for commercial, see WALT.
- Non-revenue units: models and offices that have quietly built up.
Red flags
- Many leases signed just before a sale, or with unusual concessions
- Rents far above comparable new leases
- Round-number rents, or rents that repeat where you'd expect variation
- Tenants shown as current who aren't paying
- Family, employee or related-party tenants paying off-market rent
- Numbers that don't reconcile, with no explanation
How often to pull one
Asset managers usually want one at each month-end, alongside the financial package. Pull one on demand before a refinance, a sale or a change of manager. Keep every dated version, because comparing two rent rolls side by side shows move-outs, new leases and rent changes that a single snapshot can't. A sudden run of renewals at unusual terms is easier to spot that way.
Rent roll vs lease abstract
A rent roll summarizes everyone in one view, while a lease abstract summarizes one lease in depth. Commercial owners need both. A rent roll can't warn you about an option notice date unless someone has captured it from the lease.
