Rent roll template for investor loans
A rent roll is a unit-by-unit list of who rents each unit, what they pay, and when their lease ends. Download our free Excel template to build one in the format lenders ask for. It totals occupancy, rent, and deposits for you.
Free, no sign-up. One Excel sheet with room for 52 units. File dated September 28, 2026.
When lenders ask for one
- DSCR loans on 2 to 4 unit properties. Our investor loan document checklist lists a rent roll with unit, tenant, rent, deposit, and lease dates, plus a lease for each occupied unit, or a market rent estimate if the property is vacant. The appraiser often provides that estimate.
- Commercial loans. For five-plus units, mixed use, and other income property, the checklist lists a current rent roll with unit, tenant, rent, and lease start and end dates, next to the T-12 operating statement.
What is in the file
The file has one sheet, named Rent roll, in three parts:
- Property. Property name, address, as-of date, and who prepared it, plus four lines that fill in on their own: total units, total square feet, security deposits held, and units on notice.
- Summary. Occupancy and rent measures, figured from the unit table.
- Unit table. One row per unit, rows 15 to 66, with a totals row underneath.
Shaded cells are for your entries. The header row stays in view as you scroll and repeats on every printed page.
Column by column
| Column | Header in the file | What to enter |
|---|---|---|
| A | Unit | The unit number. Each filled row counts as one unit. |
| B | Bed / bath | For example 1/1, 2/1, or 2/2, as in the file's examples. |
| C | Square feet | Unit size. The file adds them up for total square feet. |
| D | Tenant name | The tenant on the lease. Leave blank for a vacant unit. |
| E | Lease start | First day of the current lease. |
| F | Lease end | Last day of the current lease. |
| G | Monthly rent | What the tenant pays now. Leave blank for a vacant unit. |
| H | Market rent | What the unit would rent for today. Fill it in for vacant units too. |
| I | Security deposit | The deposit you hold for that unit. |
| J | Status | Pick Occupied, Vacant, or Notice from the list. |
| K | Notes | Anything a lender should know, such as month to month, a move-out date, or a renewal offer. |
The summary, and how the file figures it
| Measure in the file | How it is figured |
|---|---|
| Occupied units (Occupied plus Notice) | Units marked Occupied, plus units marked Notice |
| Vacant units | Units marked Vacant |
| Physical occupancy | Occupied units divided by total units listed |
| Total monthly rent (actual) | Sum of Monthly rent |
| Total market rent | Sum of Market rent, for every unit including vacant ones |
| Loss-to-lease, occupied units (monthly) | Market rent minus actual rent, on Occupied and Notice units |
| Annualized rent (monthly rent x 12) | Total monthly rent times 12 |
| Economic occupancy (rent / market rent) | Total monthly rent divided by total market rent |
The file's notes explain one choice in particular: a unit on notice counts as occupied, because a tenant on notice is still in place and paying.
What the example shows
The file opens with Example Apartments, a made-up 12-unit building at 123 Example Street in Tampa. Eleven units are occupied, one of them on notice, and one is vacant, so physical occupancy is about 91.7 percent. Actual rent is $17,425 a month against $19,550 of market rent, so economic occupancy is about 89.1 percent. Loss-to-lease is $425 a month, and annualized rent is $209,100.
Economic occupancy is lower than physical occupancy here because total market rent includes the vacant unit, and some occupied units rent below market.
Mistakes the file's notes help you avoid
- Typing your own status words. Status is a list with three choices. Type anything else and the file shows "Choose Occupied, Vacant, or Notice."
- Putting rent on a vacant unit. The instructions say to leave rent and tenant blank for a vacant unit. Keep its market rent, as the example's vacant unit 105 does.
- Adding units outside the table. Add units in the blank rows under the examples. The totals and summary count rows 15 to 66, so a unit typed below the totals row is left out.
How the rent roll and the T-12 fit together
A rent roll is a snapshot: who pays what on the as-of date. A T-12 operating statement is the history: twelve months of income and expenses ending in NOI. Our two templates use the same example building, and the T-12's monthly gross potential rent in its last six months, $19,550, equals this rent roll's total market rent.
Preview: the columns in the file
| Unit | Bed / bath | Square feet | Tenant name | Lease start | Lease end | Monthly rent | Market rent | Security deposit | Status | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 1/1 | 650 | Tenant A | 11/01/2025 | 10/31/2026 | $1,350 | $1,425 | $1,350 | Occupied | |
| 102 | 1/1 | 650 | Tenant B | 03/01/2026 | 02/28/2027 | $1,400 | $1,425 | $1,400 | Occupied | |
| 103 | 2/1 | 850 | Tenant C | 08/01/2025 | 07/31/2026 | $1,625 | $1,700 | $1,500 | Occupied | Month to month since 08/01/2026 |
| 104 | 2/1 | 850 | Tenant D | 01/15/2026 | 01/14/2027 | $1,650 | $1,700 | $1,650 | Occupied | |
| 105 | 2/1 | 850 | $1,700 | Vacant | Make-ready done, listed 09/01/2026 | |||||
| 106 | 2/2 | 950 | Tenant E | 06/01/2026 | 05/31/2027 | $1,800 | $1,825 | $1,800 | Occupied | |
| 201 | 1/1 | 650 | Tenant F | 11/01/2025 | 10/31/2026 | $1,375 | $1,425 | $1,375 | Notice | Not renewing, moves out 10/31/2026 |
| 202 | 1/1 | 650 | Tenant G | 05/01/2026 | 04/30/2027 | $1,425 | $1,425 | $1,425 | Occupied | |
| 203 | 2/1 | 850 | Tenant H | 02/01/2026 | 01/31/2027 | $1,675 | $1,700 | $1,675 | Occupied | |
| 204 | 2/1 | 850 | Tenant I | 10/01/2025 | 09/30/2026 | $1,600 | $1,700 | $1,500 | Occupied | Renewal offered at $1,700 |
| 205 | 2/1 | 850 | Tenant J | 04/01/2026 | 03/31/2027 | $1,700 | $1,700 | $1,700 | Occupied | |
| 206 | 2/2 | 950 | Tenant K | 07/01/2026 | 06/30/2027 | $1,825 | $1,825 | $1,825 | Occupied | |
| Totals | 9,600 | 12 units listed | $17,425 | $19,550 | $17,200 | 11 of 12 occupied |
Scroll the table sideways to see every column.
Example rows from the file. Replace them with your own.
Sending it
The file's last line asks you to send the completed file to info@aluracapital.com with your loan request. A rent roll names your tenants, so please do not paste it into the scenario form on our homepage. That form is for a short description of the deal.
Ready to talk about the loan?
Run your scenario by us. A licensed loan officer calls you back the same business day.
The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.
Related templates and tools
- T-12 operating statement: twelve months of income and expenses for the same property.
- Schedule of real estate owned: every property you own, on one page.
- DSCR calculator: check a rental's rent against its payment.
- All templates
Frequently asked questions
What does a rent roll include?
A rent roll lists each unit with its tenant, rent, deposit, and lease dates. Ours also has bed and bath, square feet, market rent, a status for each unit, and notes. A summary at the head of the sheet totals occupancy, actual and market rent, loss-to-lease, and security deposits held.
Is a tenant on notice counted as occupied?
Yes, in this template. The file counts Occupied plus Notice as occupied units, because a tenant on notice is still in place and paying. A unit marked Vacant counts as vacant. Use the Notes column to show the move-out date, as the file's example does for unit 201.
What is the difference between physical and economic occupancy?
Physical occupancy is occupied units divided by total units listed. Economic occupancy is actual monthly rent divided by total market rent. In the file's example, 11 of 12 units are occupied, about 91.7 percent, but rent is only about 89.1 percent of market rent, because of the vacant unit and below-market leases.
What is loss-to-lease?
Loss-to-lease is market rent minus actual rent on the occupied units, per month. The file figures it only for units marked Occupied or Notice, so a vacant unit does not count toward it. In the example, the occupied units rent for $425 a month less than their market rent in total.
Do I need a rent roll for a single-family DSCR loan?
Our checklist lists a rent roll for 2 to 4 unit DSCR properties and for commercial loans. For a single rental, it lists the lease for each occupied unit, or a market rent estimate if the property is vacant. Every lender is different, so your loan officer confirms the final list for your loan.
How many units fit in the template?
The unit table runs from row 15 to row 66, which is room for 52 units, and the totals and summary already count every one of those rows. Add units in the blank rows under the examples. The file opens with 12 example units that you replace with your own.
