Skip to content
Next Level Property Management
> nlpm://searchLoading index…

  • Quick actions

    Talk to us/contact
  • Reno market data/market-data
  • Find an apartment/rentals
  • Resident portal/go/resident-portal
  • Client portal/go/client-portal
  • Call (775) 502-8287

Free template

Rent roll template

A clean, lender-ready rent roll for up to 200 units, with occupancy, leased percentage, exposure, loss to lease, delinquency and suggested renewal rents calculated for you.

  • Excel, Sheets, Numbers
  • Sample property included
  • 6 tabs

Get the template

Inside the workbook

What you get, tab by tab

Tab 1

Summary

Occupancy, leased percentage, exposure, status counts, rent by unit type, delinquency, lease expirations and plain-English insights.

rent-roll-template.xlsx
The Summary tab of the rent-roll-template workbook, filled in with the sample property
SummaryRent RollRenewalsUnit TypesOwner Summary

Tab 2

Rent Roll

The unit-by-unit roll: 200 rows with dropdowns, calculated loss to lease, expiration buckets, flags and a suggested renewal rent.

rent-roll-template.xlsx
The Rent Roll tab of the rent-roll-template workbook, filled in with the sample property
SummaryRent RollRenewalsUnit TypesOwner Summary

Tab 3

Renewals

Leases coming due in date order with a suggested renewal rent inside your caps and the revenue added if they all renew.

rent-roll-template.xlsx
The Renewals tab of the rent-roll-template workbook, filled in with the sample property
SummaryRent RollRenewalsUnit TypesOwner Summary

Unit Types

Floor plans with beds, baths, square feet and market rent, which fill into the roll automatically.

Owner Summary

A one-page report with your logo and company name for owners or lenders.

Built for

Who it is for

  • Owners preparing for a refinance or sale
  • Managers reporting occupancy monthly
  • Buyers organizing a seller's data

How to use it

Up and running in five steps

  1. 1Enter the property name and the as-of date on Start Here.
  2. 2List each floor plan with beds, baths, square feet and market rent on Unit Types.
  3. 3Enter one row per unit on Rent Roll, picking unit type and status from the dropdowns.
  4. 4For occupied units, add the resident, lease dates, rent, recurring charges, deposit and balance.
  5. 5Set renewal caps and floors on Renewals, review the Summary and print the Owner Summary.

Rather have us run the numbers?

Send us your rent roll and T12 and we will build this for your property and show you what it says.

Talk to us(775) 502-8287

Questions

Rent Roll Template questions

What is a rent roll?
A list of every unit with its status, resident, lease dates, rent, charges, deposit and balance as of one date. Lenders and buyers use it to verify income, so it should match your leases and ledger.
What is the difference between occupancy and leased percentage?
Occupancy counts units with a resident living there today. Leased percentage adds signed future leases and removes units on notice, so it shows where occupancy is heading.
What is loss to lease?
The gap between market rent and the rent in place on each lease. The template calculates it per unit and in total so you can see how much renewals could recover.

Insights

The guide behind it

All articles

More free templates

The rest of the toolkit

Multifamily Operating BudgetSee inside Rent Comp Analysis WorksheetSee inside Capex and Value-Add PlanSee inside Due Diligence ChecklistSee inside Lease-Up TrackerSee inside Multifamily Chart of AccountsSee inside

All free templates