Apply now on NEXA Mortgage's site, opens in a new tab

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:

  1. 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.
  2. Summary. Occupancy and rent measures, figured from the unit table.
  3. 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 by column
ColumnHeader in the fileWhat to enter
AUnitThe unit number. Each filled row counts as one unit.
BBed / bathFor example 1/1, 2/1, or 2/2, as in the file's examples.
CSquare feetUnit size. The file adds them up for total square feet.
DTenant nameThe tenant on the lease. Leave blank for a vacant unit.
ELease startFirst day of the current lease.
FLease endLast day of the current lease.
GMonthly rentWhat the tenant pays now. Leave blank for a vacant unit.
HMarket rentWhat the unit would rent for today. Fill it in for vacant units too.
ISecurity depositThe deposit you hold for that unit.
JStatusPick Occupied, Vacant, or Notice from the list.
KNotesAnything 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

The summary, and how the file figures it
Measure in the fileHow it is figured
Occupied units (Occupied plus Notice)Units marked Occupied, plus units marked Notice
Vacant unitsUnits marked Vacant
Physical occupancyOccupied units divided by total units listed
Total monthly rent (actual)Sum of Monthly rent
Total market rentSum 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

Columns in the file, with the example rows
UnitBed / bathSquare feetTenant nameLease startLease endMonthly rentMarket rentSecurity depositStatusNotes
1011/1650Tenant A11/01/202510/31/2026$1,350$1,425$1,350Occupied
1021/1650Tenant B03/01/202602/28/2027$1,400$1,425$1,400Occupied
1032/1850Tenant C08/01/202507/31/2026$1,625$1,700$1,500OccupiedMonth to month since 08/01/2026
1042/1850Tenant D01/15/202601/14/2027$1,650$1,700$1,650Occupied
1052/1850$1,700VacantMake-ready done, listed 09/01/2026
1062/2950Tenant E06/01/202605/31/2027$1,800$1,825$1,800Occupied
2011/1650Tenant F11/01/202510/31/2026$1,375$1,425$1,375NoticeNot renewing, moves out 10/31/2026
2021/1650Tenant G05/01/202604/30/2027$1,425$1,425$1,425Occupied
2032/1850Tenant H02/01/202601/31/2027$1,675$1,700$1,675Occupied
2042/1850Tenant I10/01/202509/30/2026$1,600$1,700$1,500OccupiedRenewal offered at $1,700
2052/1850Tenant J04/01/202603/31/2027$1,700$1,700$1,700Occupied
2062/2950Tenant K07/01/202606/30/2027$1,825$1,825$1,825Occupied
Totals9,60012 units listed$17,425$19,550$17,20011 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

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.