Imagine you’re looking at a rent roll on a mid-market multifamily LOI. The purchase price hinges on the income the seller represents. How to read a rent roll becomes the single most important file in the data room. Read it wrong and your model, your offer, and your negotiation leverage all break.
The core idea
How to read a rent roll is simple: treat it like raw evidence, not a summary. Don’t take totals at face value. Break the rent roll down to unit level, verify every line against a lease or remittance, and connect the dots to the T12/T3 (a practical guide to commercial real estate underwriting). That’s the workflow underwriters live by. It’s the difference between accurate underwriting and a nasty surprise after close.
1) What’s actually on the rent roll — and what to check first
Start with the basics on each row: unit identifier, tenant name, square footage, current gross rent, rent components (base rent vs. fees), lease start/end, and occupancy status. Don’t just glance — confirm those fields match the lease and the property brochure.
- Unit identification: Make sure unit numbers line up with the floor plan and lease schedule. Mismatched IDs can hide rekeyed or consolidated units.
- Rental rates & fees: Check whether the rent column includes parking, storage, or utility pass-throughs. If fees are mixed into rent, your base rent is overstated.
- Occupancy & vacancy: Note vacancy status and vacancy start dates. A unit vacant for a month is different from one vacant for a year — that affects short-term cash flow and turnover capex.
- Square footage: Calculate rent per square foot yourself using the exclusive area on the lease. Rent per square foot is how you compare to market. See How to underwrite small retail strip centers for an example of using rent-per-square-foot comparisons.
These checks are the minimum. If the rent roll doesn’t have these fields, push for an export that does.
2) Verification: cross-check every suspicious line
A rent roll is the owner’s representation. Underwriters treat it as a hypothesis — verify.
- Match to leases. If the rent on the roll isn’t in the lease, ask why. Management sometimes lists gross rent including non-contractual credits or concessions. If documents are messy, read how disconnected documents slow LOIs and due diligence for common failure modes.
- Match to remittance and bank statements. Confirm the money actually hit the owner’s accounts on a sample of units.
- Connect to the T12 and T3. The rent roll shows current contract rents. The T12/T3 show realized income and trend items like vacancy loss or RUBS. Reconcile them; look for missing RUBS, parking income, or late fees that explain gaps.
- Ask for aged receivables and collections data. A high number of late pays or old receivables is a red flag.
Don’t accept summaries like “gross scheduled rent” without the unit-level backup in Excel. If you get a PDF, ask for the native spreadsheet.
3) Spotting red flags that change valuation
Once you’ve verified the numbers, look for issues that affect future revenue.
- Lease term concentration. If a high share of leases expire the same quarter, your model must reflect renewal risk and downtime.
- Month-to-month concentration. A cluster of month-to-month tenants means revenue is fragile. You can’t underwrite that as stable income.
- Below-market rents tied to long-term tenants. Those can be a value-opportunity if you can reprice, but you need a timeline and a release assumption.
- Hidden income sources. Parking, storage, utility pass-throughs, and ancillary fees often live off the rent roll in owner spreadsheets. Make sure you capture them in income.
These items change your forward-looking assumptions. They don’t always change the headline price, but they should change your model and your negotiation points.
4) How we turn rent roll facts into underwriter actions
An underwriter needs to translate the rent roll into cash-flow assumptions. That means doing a few practical things:
- Build a unit-level pivot. Use the raw Excel to create a pivot by lease end date, lease type, and rent band. You’ll find concentration and seasonality fast — and keep repeatable processes if you’re doing multiple deals (see underwriting workflow software recommendations).
- Set conservative release assumptions. Don’t assume immediate market rent on turn. Use realistic loss-to-lease and downtime assumptions based on property type and local market intel.
- Adjust the T12. If verification shows some income on the T12 is non-recurring or owner-specific, normalize it before applying cap rates or debt models.
- Create negotiation asks. Weak collections or heavy month-to-month exposure are reasons to reduce your offer or require escrow holdbacks tied to specific remediation.
Mini-case: the ‘missing parking’ problem
We once reviewed a rent roll that showed attractive average rents. At first glance the math looked clean. After digging we found parking income was recorded in a separate spreadsheet and only half of it flowed to the T12. Management collected parking daily in cash and credited some to miscellaneous revenue. Once we reconciled remittance records with bank deposits, the true net income picture changed. That mismatch became a negotiation lever — we pushed for a price reduction and a holdback until the seller could prove steady parking collections.
Tools and tactics underwriters actually use
Underwriters don’t rely on software buzzwords. They use a handful of tactical moves that work in every deal.
- Demand native spreadsheets. Pivot tables and filters expose oddities that PDFs hide (see how growing CRE shops outgrow spreadsheets for when to switch).
- Sample everything. Pull three to five leases at random and reconcile rent, deposit, and tenant name to the roll and payments ledger.
- Ask for a lease abstract. If management won’t provide one, create it from the native lease. Key fields only: renewal options, rent escalations, concessions, and parking assignments.
- Make the seller run a simple reconciliation. Ask them to reconcile total scheduled rent on the roll to total rent posted on the T12 and bank deposits, and explain any gaps in writing.
Where a CRE-specific tool helps
If next steps and follow-ups are getting lost during underwriting, a CRE tool that supports an Investment pipeline, Action Center, and deal-stage triggers can help. Those features turn stage moves into prioritized follow-ups and keep property- and deal-level tasks visible to the team — so missing items become fewer and easier to manage. If you want to try tracking this workflow, track your acquisitions pipeline in CREflow.
Key takeaways
- Treat the rent roll as a starting hypothesis, not proof. Verify unit-level details against leases and remittance.
- Connect the rent roll to the T12/T3. Reconcile differences and normalize non-recurring items before valuation.
- Spot concentrations and lease types that threaten forward cash flow, and bake conservative release assumptions into the model.
- Use simple Excel tactics — pivots, filters, and sampling — to find hidden income or risk quickly.
FAQ
How long should I spend reviewing a rent roll?
Spend as long as it takes to be confident you can reconcile it to leases and financials. For a small deal that’s a few hours of focused unit-level checks. For larger portfolios, budget time for sampling and reconciliation across asset clusters.
What if management refuses to produce native spreadsheets?
Push back. PDFs hide problems. If they won’t provide native files, make your offer conditional on receiving them or on a due-diligence period long enough to manually transcribe and verify key leases.
How do I handle concessions shown on the rent roll?
Identify the concession type and the accounting treatment. Are concessions deducted from rent in the roll or booked elsewhere? Normalize concessions into your pro forma so they reduce effective rent where appropriate.
When should I expect to negotiate price versus ask for escrow?
If verification shows systemic income issues or large unknowns (collections, month-to-month risk, missing ancillary income), those are direct price items. Escrow or holdbacks are for specific, verifiable remediation items the seller can fix post-close.
Before you read a rent roll, check this:
- Get the native spreadsheet, not a PDF.
- Ask for lease abstracts or a sample of actual leases.
- Request the T12, T3, and bank remittance reports for reconciliation.
- Prepare a simple pivot to group by lease end date, rent band, and occupancy.
- Flag month-to-month units and any line items that don’t match between files.
If you do these things, the rent roll becomes your best negotiating tool instead of a guessy summary. Read it like evidence, not a promise.
Try CREflow’s free commercial real estate underwriting calculator to model NOI, cap rate, DSCR, and IRR without a spreadsheet.