Skip to content

Glossary

Rent Roll Template and Guide for Apartment Buildings

A rent roll is a unit-by-unit list of who lives in a building, what each tenant pays and on what lease terms, and a rent roll template gives you the standard columns to fill in. This page is for apartment building owners getting ready to sell or refinance: a free template you can copy, a filled-in example, the math buyers run from it and the red flags they look for.

  • Clear feedback on your deal, typically within 48 hours
  • 5 to 100+ units, stabilized or distressed, listed or off-market
  • Owners, agents, and brokers welcome; every conversation is confidential

We buy:Tired landlordsEstate & trust sales1031 exchangesDeferred maintenanceHigh vacancyPartnership splits

On This Page: Free rent roll template · Filled-in example · Occupancy and loss-to-lease math · How buyers verify it · Red flags to fix

By Skyline Capital Investments · · 3 min read

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.

ColumnWhat to enter
UnitUnit number exactly as it appears on the lease
Unit typeStudio, 1 bed/1 bath, 2 bed/1 bath and so on
Square feetInterior square footage of the unit
StatusOccupied, vacant, notice to vacate, down for repairs, model or employee unit
TenantTenant name or an ID if names are withheld until later in diligence
Move-in dateDate the current tenant moved in
Lease startStart date of the current lease
Lease endEnd date of the current lease, or month-to-month
Contract rentMonthly rent under the current lease
Market rentWhat the unit would rent for today if vacant
Other chargesMonthly parking, pet, storage, utility bill-back or other fees
ConcessionsFree rent or discounts still in effect
SubsidyHousing voucher or other subsidy amount, if any
Security depositDeposit held for the unit
Balance owedUnpaid rent and charges as of the rent roll date
NotesPending 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.

UnitTypeStatusLease endContract rentMarket rentDepositBalance
1011 bedOccupied03/31/2027$1,250$1,350$1,250$0
1021 bedOccupiedMonth-to-month$1,150$1,350$1,000$0
1032 bedOccupied08/31/2027$1,600$1,650$1,600$0
1042 bedVacant——$1,650——
2011 bedOccupied12/31/2026$1,300$1,350$1,300$650
2021 bedOccupied06/30/2027$1,350$1,350$1,350$0
2032 bedOccupied01/31/2027$1,550$1,650$1,500$0
2042 bedNotice to vacate11/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.

MeasureFormulaExample
Physical occupancyOccupied units ÷ total units7 ÷ 8 = 87.5%
Monthly contract rentSum of contract rent on occupied units$9,700
Gross potential rentMarket rent for all units × 12$12,000 × 12 = $144,000
Loss-to-leaseMarket rent − contract rent on occupied units$10,350 − $9,700 = $650 a month
DelinquencyBalances 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.

Common Questions

What is a rent roll?

A rent roll is a list of every unit in a rental property on one date, showing the tenant, lease start and end dates, monthly rent, security deposit and any balance owed. Buyers and lenders use it to measure a building’s income, its occupancy and the gap between current and market rents.

What should a rent roll include?

At minimum: unit number and type, status, tenant, lease start and end dates, contract rent, market rent, other charges, concessions, security deposit and balance owed. Our free template above lists every column buyers expect, including subsidies and notes.

How often should a rent roll be updated?

Most professionally managed properties produce one every month. For a sale or refinance, provide a rent roll dated within the last few weeks, and expect to send an updated one shortly before closing.

Is a rent roll the same as a T-12?

No. A rent roll is a snapshot of leases at one point in time, while a T-12 shows the income and expenses the property actually had over the last twelve months. Buyers compare the two to confirm that the rent on paper is the rent being collected.

What is loss-to-lease on a rent roll?

Loss-to-lease is the difference between market rent and the rent tenants actually pay under their current leases. If occupied units would rent for $10,350 a month but pay $9,700, loss-to-lease is $650 a month, which a buyer may expect to capture as leases renew.

Do I have to share tenant names on a rent roll?

Buyers need lease details to underwrite the building, but tenant names can often be withheld or replaced with IDs until later in due diligence, subject to privacy laws and the purchase agreement. Full lease copies are usually shared once the deal is under contract.

How do buyers verify a rent roll?

They compare it with signed leases, deposit records, bank statements and the T-12, and they often have tenants sign estoppel certificates confirming rent, deposit and lease terms. Differences that show up late in diligence often lead to a price reduction.

Can I sell an apartment building with a messy rent roll?

Yes. Some buyers, including Skyline, buy buildings with vacancies, tenants behind on rent or incomplete records and price that uncertainty into the offer. Cleaning up the rent roll first usually gets you a firmer number and a faster close.

Two Ways To Work With Us

Bring Us A Deal, Or Invest In One

For Agents, Brokers & Owners

Have A Multifamily Property?

We buy apartment buildings and income-producing residential assets nationwide — listed or off-market, stabilized or value-add.

  1. 1
    Send the basicsAddress, units and asking price.
  2. 2
    We review itAgainst our buy box, confidentially.
  3. 3
    Clear answer in 48 hoursA yes, a no, or the questions we need answered.
See our buy box
Takes 60 seconds
For Investors

Looking To Invest In Multifamily?

Join our investor network to learn how we structure partnerships and to be notified when new opportunities are available to qualified investors.

  • Disciplined, conservative underwriting
  • Professionally managed, passive ownership
  • Clear reporting and direct access to the team
  • Education first — no pressure, no hype
Call Text Submit Deal Invest