What is a rent roll?
A rent roll is a snapshot of every unit in a property on one date, showing the tenant, lease dates, monthly rent, security deposit and any balance for each unit. It’s the starting point for valuing an apartment building and one of the first documents a buyer or lender asks to see.
A rent roll is different from a T-12. The rent roll shows what tenants are supposed to pay today under their leases. The T-12, or trailing 12-month operating statement, shows what the building actually collected and spent over the last year. Buyers review both and compare them.
Free rent roll template
Copy these columns into a spreadsheet, with one row per unit, including vacant and down units. Date the rent roll at the top and keep the same unit order you use in your leases and T-12.
| Column | What to enter |
|---|---|
| Unit | Unit number exactly as it appears on the lease |
| Unit type | Studio, 1 bed/1 bath, 2 bed/1 bath and so on |
| Square feet | Interior square footage of the unit |
| Status | Occupied, vacant, notice to vacate, down for repairs, model or employee unit |
| Tenant | Tenant name or an ID if names are withheld until later in diligence |
| Move-in date | Date the current tenant moved in |
| Lease start | Start date of the current lease |
| Lease end | End date of the current lease, or month-to-month |
| Contract rent | Monthly rent under the current lease |
| Market rent | What the unit would rent for today if vacant |
| Other charges | Monthly parking, pet, storage, utility bill-back or other fees |
| Concessions | Free rent or discounts still in effect |
| Subsidy | Housing voucher or other subsidy amount, if any |
| Security deposit | Deposit held for the unit |
| Balance owed | Unpaid rent and charges as of the rent roll date |
| Notes | Pending renewals, legal actions, payment plans or anything a buyer should know |
Rent roll example for an 8-unit building
Here is a short filled-in example using the main columns. A real rent roll would include every column above.
| Unit | Type | Status | Lease end | Contract rent | Market rent | Deposit | Balance |
|---|---|---|---|---|---|---|---|
| 101 | 1 bed | Occupied | 03/31/2027 | $1,250 | $1,350 | $1,250 | $0 |
| 102 | 1 bed | Occupied | Month-to-month | $1,150 | $1,350 | $1,000 | $0 |
| 103 | 2 bed | Occupied | 08/31/2027 | $1,600 | $1,650 | $1,600 | $0 |
| 104 | 2 bed | Vacant | — | — | $1,650 | — | — |
| 201 | 1 bed | Occupied | 12/31/2026 | $1,300 | $1,350 | $1,300 | $650 |
| 202 | 1 bed | Occupied | 06/30/2027 | $1,350 | $1,350 | $1,350 | $0 |
| 203 | 2 bed | Occupied | 01/31/2027 | $1,550 | $1,650 | $1,500 | $0 |
| 204 | 2 bed | Notice to vacate | 11/30/2026 | $1,500 | $1,650 | $1,500 | $0 |
How to calculate occupancy, rent and loss-to-lease
Buyers turn the rent roll into a few numbers that drive their offer. In the example above, seven of eight units are occupied, so physical occupancy is 87.5%.
Monthly contract rent on the occupied units totals $9,700. Market rent for all eight units totals $12,000, so gross potential rent is $144,000 a year. At market, the seven occupied units would rent for $10,350, so loss-to-lease is $650 a month, or about 6.3% of their market rent. That gap shows a buyer how much rent could rise as leases renew.
Buyers then compare the $9,700 of monthly contract rent with what the T-12 shows was actually collected. If collections are well below the rent roll, they look for bad debt, concessions or vacancy the rent roll doesn’t show.
| Measure | Formula | Example |
|---|---|---|
| Physical occupancy | Occupied units ÷ total units | 7 ÷ 8 = 87.5% |
| Monthly contract rent | Sum of contract rent on occupied units | $9,700 |
| Gross potential rent | Market rent for all units × 12 | $12,000 × 12 = $144,000 |
| Loss-to-lease | Market rent − contract rent on occupied units | $10,350 − $9,700 = $650 a month |
| Delinquency | Balances owed ÷ monthly contract rent | $650 ÷ $9,700 = 6.7% |
How buyers verify a rent roll
Buyers and lenders audit the rent roll during due diligence, so expect every number to be tested. They compare it with signed leases, deposit records, bank statements and the T-12. Many buyers also have tenants sign estoppel certificates before closing to confirm their rent, deposit and lease terms.
Discrepancies found late in diligence are one of the most common reasons for a price reduction. A rent roll that matches the leases and the bank deposits builds a buyer’s trust and helps them hold their price.
Rent roll red flags
These patterns tell a buyer the income needs a closer look:
- Many tenants with large past-due balances, or balances that grow month to month.
- Recent leases signed with big concessions or at rents far above the rest of the building.
- A high share of month-to-month tenants without an explanation.
- Rents on the roll that don’t match the leases or the deposits.
- Units listed as occupied that look vacant on inspection.
- Several leases ending in the same month, which creates turnover risk.
Preparing a rent roll for a sale
Export the rent roll from your property management software, dated within a few weeks of when you send it, and keep its format consistent with your T-12. If you manage with a spreadsheet, use every column in the template above, reconcile it against your leases and explain any special arrangements in the notes column.
Send the rent roll and T-12 together. With both in hand, a buyer can give you a firm number instead of a rough range.
Getting an offer from Skyline
Skyline Capital Investments buys apartment buildings with five or more units nationwide, including buildings with vacancies, delinquent tenants or messy books. Send the address and unit count through the form on this page and let us know if you have a current rent roll and T-12, or call (469) 660-2977. We typically respond within 48 hours.