A rent roll tells the truth.
Or at least, it gets closer than almost anything else.
Because while the T12 shows what happened, the rent roll shows what is happening right now.
Unit by unit. Lease by lease. Tenant by tenant.
And if you know how to read it properly, it will tell you very quickly whether the revenue story is real or just well-presented.
This article is part of the MSA Digest underwriting series. Start with What Is Multifamily Underwriting? for the broader underwriting framework.
What a rent roll actually is
Most people think a rent roll is an occupancy report.
It is not.
It is a live revenue-quality report.
A rent roll is a detailed, unit-by-unit report of every lease in a property at a specific point in time.
At minimum, a clean rent roll includes:
- Unit number
- Unit type
- Square footage
- Tenant status
- Lease start and end dates
- Contract rent
- Market rent
- Concessions or credits
- Outstanding balance or delinquency
- Occupancy status
That is the structure.
The real value is what the structure reveals.
A T12 tells you what the property reported earning over the last twelve months. A rent roll tells you what every single unit is doing today. For a deeper read on the historical side of that pairing, see our T12 analysis guide.
One is averaged history.
The other is a live snapshot.
Both matter. But they matter for different reasons, and they need to agree with each other before you trust either one.
Good underwriters do not ask, "Is the property full?" They ask, "Is the revenue real?"
What a rent roll does not tell you
A rent roll is powerful, but it is still just one document.
Treating it like the whole story is one of the more common mistakes I see, especially from newer underwriters who think occupancy plus rent multiplied out equals revenue.
It does not.
A rent roll does not tell you:
- whether rent is being collected consistently month over month
- whether expenses are under control
- whether rent levels are sustainable in the current market
- whether concessions are temporary or structural
- whether income is improving, flat, or quietly drifting down
It tells you what the leases say.
It does not tell you what the bank account agrees with.
That is why the rent roll should never be read alone. It needs to be reconciled against the T12, collections detail, and ideally bank statements before its numbers become underwriting inputs.
How to read a rent roll like an underwriter
Reading a rent roll is not a top-to-bottom exercise.
The order matters.
Some questions only make sense after you answer earlier ones.
Here is the sequence I trust.
Step 1: Ignore occupancy at first
This sounds wrong.
It is not.
Occupancy is the number every broker leads with, and it is the number that fools the most people.
A property can be 96% physically occupied and still have a soft revenue engine.
The headline number is just a count of units with bodies in them. It does not tell you whether those residents are paying, paying full rent, paying on time, or planning to renew.
So before I look at occupancy, I ask a different question:
What are people actually paying?
That one shift catches more underwriting traps than almost anything else on the rent roll.
Once you see the rent roll as a revenue document instead of an occupancy document, the whole file reads differently.
Step 2: Compare in-place rent vs market rent
Most rent rolls have two columns worth comparing closely: contract rent and market rent.
Contract rent is what the lease says.
Market rent is what the property management system thinks the unit could rent for today.
The relationship between those two numbers tells you a lot.
| Relationship | What it tells you |
|---|---|
| In-place rent < market rent | Possible loss-to-lease upside, if the market rent is real |
| In-place rent ≈ market rent | Property is stabilized near market, with limited organic upside |
| In-place rent > market rent | Possible trade-out risk at renewal or turnover |
Two warnings.
First problem: market rent in a rent roll is usually whatever somebody last typed into the property management system.
It is not a comp study.
It can be aspirational, stale, or just wrong.
Always validate market rent against actual signed leases on similar units in the surrounding submarket before treating it as real.
Second problem: loss-to-lease is not free money.
A 7% loss-to-lease on a Class B asset where renewal trade-outs are actually running 3% does not mean you capture the full 7% during your hold.
Underwrite the gap that can actually be captured.
Not the gap that looks good in a formula.
Step 3: Check lease trade-outs
This is where market rent claims either start to hold up or fall apart.
A property can show meaningful loss-to-lease and still have weak rent growth if actual trade-outs are soft.
That is why I care less about what the PMS says market rent is and more about what recent signed leases are actually achieving.
Look at:
- new lease trade-outs
- renewal trade-outs
- recent signed lease rents by unit type
- rent changes over the last 30, 60, and 90 days
The lease trade-out report usually tells the truth faster than the marketing deck does.
If market rent says there is 8% upside but recent renewals are only achieving 2%, you do not have 8% upside.
You have a question.
Step 4: Scan for concessions
Concessions distort everything.
A property can look 96% occupied and still underperform if the leases are propped up by free rent, credits, or discounts.
The first problem is finding them.
Some rent rolls have a clean concessions column.
Many do not.
On a rent roll without a concessions column, the clues are usually indirect:
- lease start dates clustered in the most recent two months
- scheduled rent that does not match actual rental income on the T12
- new leases signed at "market" while collections lag
- contract rents that are unusually consistent across a diverse unit mix
The second problem is reading the pattern.
There is a big difference between $50 per month off scattered across several units and $400 per month off concentrated in a handful of leases.
One may be normal seasonal leasing.
The other may be telling you the property is struggling to hold rent.
Step 5: Check delinquency and balances
If residents are not paying, the revenue is not real.
That is the simple version.
The harder version is reading the delinquency aging.
A clean rent roll separates balances into current, 30-day, 60-day, and 90+ day buckets.
The shape of that breakdown matters more than the total.
Three units at 90+ days delinquent is usually worse than ten units at 30 days.
Why?
Because at 30 days, many residents catch up or move out and the unit turns. At 90+ days, you are looking at residents who are functionally not paying and have not yet been removed.
That may be an eviction process problem.
Or a property management problem.
Or both.
Either way, the new owner inherits it.
Step 6: Identify down units and offline status
Not all vacancy is equal.
The rent roll often treats it like it is.
That is a mistake.
| Category | What it means |
|---|---|
| Vacant rent-ready | Unit is leasable today |
| Down or offline | Unit is not currently rentable due to damage, deferred capex, or renovation |
| Model or admin | Non-revenue unit used for leasing, staff, or operations |
This is one of the most common places the story gets too clean.
"95% occupied" can include paying residents, future residents, down units, model units, and admin units blended together in one headline number.
The actual revenue-generating occupancy may be much lower.
A down-unit count above 5% of total units is usually worth pausing on.
It may point to deferred capex, a stalled renovation program, or operational issues the seller has not solved.
Step 7: Review the lease expiration schedule
The expiration column tells you when revenue is at risk.
Look for clustering.
A property with twenty leases expiring in the same month has concentrated rollover risk.
If the market softens in that window, the property feels it harder than a property with evenly distributed expirations.
Lease expiration concentration matters even more when it overlaps with refinance windows or major renovation periods.
A property with 35% of leases rolling during a soft leasing environment can pressure occupancy, collections, and lender confidence simultaneously.
The expiration schedule tells you when the revenue story gets tested.
Physical occupancy vs economic occupancy
This distinction matters more than almost anything else on the rent roll.
Physical occupancy tells you how many units have a resident assigned to them.
Economic occupancy tells you how much of the scheduled rent is actually being realized in cash.
They are not the same number.
Sometimes they are not even close.
A property can be 95% physically occupied and 84% economically occupied if concessions, delinquency, non-paying residents, and non-revenue units are all hitting at once.
That gap is real revenue.
That is the difference between the deal you think you are underwriting and the deal you are actually buying.
| Metric | What it tells you | What it misses |
|---|---|---|
| Physical occupancy | How many units are occupied | Whether rent is being paid |
| Economic occupancy | How much rent is actually realized | Forward leasing activity |
| Pre-leased | Future demand pipeline | Current cash flow |
Underwrite to economic occupancy.
Physical occupancy is often a marketing number.
Quick example: the 95% occupancy trap
Here is a scenario I see often.
A 120-unit Class B garden property comes to market.
The broker package leads with 95% physical occupancy at $1,500 average rent.
That looks like 114 occupied units generating roughly $171,000 per month, or about $2.05 million annually in scheduled rent.
First pass: the deal looks fine.
Then you open the rent roll.
- 6 units are in the 60+ day delinquency bucket
- 4 units are future residents with move-ins scheduled 30 to 45 days out
- 3 units are down/offline due to deferred capex
- 18 units have concessions between $200 and $300 per month
- 31 leases expire in a 90-day window
Now run the math.
- Physical occupancy: 114 of 120 units = 95%
- Subtract 6 delinquent units = 108
- Subtract 4 future residents = 104
- Subtract 3 down units = 101
True economic occupancy is closer to 101 of 120 units, or roughly 84%.
Same property.
Same rent roll.
Different reality.
This is why you do not underwrite to the headline.
How to reconcile the rent roll to the T12
This is the most useful check in early-stage underwriting.
The rent roll and the T12 should agree.
When they do not, the disagreement is information.
| Rent Roll | T12 |
|---|---|
| Current point-in-time snapshot | Rolling 12 months of historical performance |
| Lease-level detail | Aggregated income and expense lines |
| What should happen this month | What did happen over the trailing year |
The four reconciliation checks I trust most:
- Scheduled rent check: Scheduled rent on the rent roll should roughly align with T12 gross potential rent.
- Vacancy check: Vacancy implied by the rent roll should make sense against T12 vacancy loss.
- Concessions check: Concessions should help explain the gap between scheduled and collected rent.
- Delinquency check: Delinquency aging should align with bad debt and credit loss trends.
If these do not tie within reasonable rounding, slow down.
Either the documents are stale, the categories are different, or one of them is wrong.
Rent roll red flags by line item
Single red flags are easy to dismiss.
The danger is when several appear together.
| Line Item | What raises concern |
|---|---|
| Contract rent | Inconsistent across similar unit types without clear reason |
| Market rent | Materially above signed leases on comparable units |
| Concessions | Increasing in recent months, especially on renewals |
| Outstanding balances | Rising in the 60+ and 90+ day aging buckets |
| Occupancy | High physical occupancy with weak economic occupancy |
| Unit status | Multiple down/offline units without a clear plan |
| Lease expirations | Concentrated in one or two months |
| File structure | Messy formatting, missing fields, inconsistent unit numbering |
After enough reps, you start to recognize the shape of a clean rent roll versus a problem one.
The pattern is consistency.
Strong rent roll vs weak rent roll
| Strong Rent Roll | Weak Rent Roll |
|---|---|
| Consistent rents within unit types | Wide variability in similar units |
| Low and stable delinquency | Growing balances in 60+ aging |
| Minimal concessions | Frequent or concentrated concessions |
| Clean data structure | Messy formatting or missing fields |
| Even lease expirations | Clustered expirations |
| Reconciles cleanly to the T12 | Does not reconcile without explanation |
The strongest rent rolls are boring.
Consistent. Reconcilable. Predictable.
That is exactly what you want.
Where technology actually helps
Most of the time spent on rent roll analysis is not analysis.
It is cleanup.
PDF exports with merged cells. Unit numbers out of order. Missing concession columns. Lease dates formatted three different ways in the same file.
This is the friction that pushed me to build MSA.
QuicRollAI structures messy rent rolls, including broker exports that arrive as PDFs with merged cells and inconsistent formatting.
MSA Direct moves the cleaned rent roll data directly into the underwriting workflow.
MSA Analyzer turns the rent roll and T12 into a full underwriting model.
MSA IQ layers in submarket data so the rent roll's market-rent assumptions can be tested against what is actually happening in the market.
That is where technology belongs.
It removes the cleanup tax.
It gives time back to judgment.
Fast workflows are helpful.
Fake certainty is not.
Final takeaway
A rent roll is the closest thing you have to the truth in a multifamily deal.
But only if you question it.
The job is not to verify that the headline occupancy number is real.
The job is to ask whether the revenue underneath that number is durable, payable, and reconcilable to what actually happened.
A good underwriter does not ask:
"Is the property full?"
They ask:
"Is the revenue real?"
That is the habit.
The rent roll is where it gets built.
FAQ
What is a rent roll?
A rent roll is a unit-by-unit report of every lease in a property at a specific point in time. It usually includes unit number, unit type, tenant status, lease dates, contract rent, concessions, balances, and occupancy status.
Why is the rent roll important in underwriting?
Because it shows what is happening right now. The T12 shows historical performance. The rent roll shows the current lease-level reality.
What is the biggest mistake people make with rent rolls?
Focusing too much on physical occupancy. A property can look occupied and still have weak revenue if concessions, delinquency, and non-revenue units are hidden underneath the headline number.
What is the difference between a rent roll and a T12?
A rent roll is a current lease-level snapshot. A T12 is a trailing twelve-month operating statement. Strong underwriting uses both because each catches things the other misses.
How recent should a rent roll be?
Ideally within 7 days of analysis. Absolutely within 30 days. Rent rolls go stale quickly because concessions, delinquency, move-ins, move-outs, and unit status can change fast.
Can a rent roll be misleading?
Yes. Concessions can be hidden, future residents can inflate occupancy, down units can get blended into vacancy, and market rent can be overstated. None of that requires fraud. Sometimes it is just messy data. Either way, the underwriter has to separate it out.
Disclaimer
This article is for educational purposes only. It is not investment advice, an offer to buy or sell any property, or a guarantee of underwriting outcomes. All examples are illustrative and do not reflect a specific transaction. Underwrite every deal on its own merits, with current data and your own diligence team.