Rent Roll Analysis

A rent roll is the starting point for underwriting any income-producing replacement property, but a Portland rent roll only tells the truth once it is checked against the actual lease file line by line.

What a Usable Rent Roll Contains

At minimum, a usable rent roll lists unit or suite number, tenant name, square footage, lease start and expiration, current rent, any concessions, and security deposit held. For multifamily, it should show month-to-month status separately from fixed-term leases; for commercial space, it should show whether rent is gross, modified gross, or NNN, since that single distinction changes the entire expense-recovery picture.

For a commercial property with multiple suites, the rent roll should also note which tenant improvement allowances remain unamortized and whether any tenant holds a right of first refusal or expansion option that could affect future leasing decisions.

Comparing the Rent Roll to the Lease File

Sellers occasionally provide a rent roll that reflects intended rather than actual terms, particularly around concessions, free-rent periods, or verbal renewal agreements that were never documented. Pulling the underlying lease for every tenant above a certain rent threshold, and for any tenant flagged as delinquent or month-to-month, catches the gap between what the spreadsheet says and what the lease actually obligates the tenant to pay.

A second useful check is comparing the rent roll's total scheduled rent against the seller's bank deposit records for the same months; a persistent gap between the two suggests either uncollected rent that was never written off or income that was never scheduled correctly in the first place. This step matters most for larger tenants and for any lease nearing renewal, since a rent roll can show a renewal option as exercised when the tenant has not actually signed anything yet.

Review Checklist

A rent roll review follows a consistent sequence regardless of asset class.

• Confirm lease expiration dates against a rolling twelve-month calendar to flag near-term rollover.
• Cross-check five to ten of the largest tenants against their actual signed leases.
• Separate delinquent accounts from current accounts and get an aging summary.
• Confirm which expenses are recoverable from tenants versus paid by ownership.
• Verify security deposits held match the amounts stated in each lease.
• Flag any related-party leases between the seller and an affiliated tenant.

Red Flags in Concession and Delinquency Lines

A rent roll showing several units at reduced rent with a note like temporary concession deserves specific follow-up on when that concession ends and whether it was ever formalized in writing. Similarly, a delinquency column that was zeroed out right before the property went to market is worth a direct question rather than an assumption that collections improved on their own.

Related-party leases deserve the same scrutiny: a tenant connected to the seller by ownership or family relationship may be paying below-market rent that will need to be reset at closing, and the rent roll rarely flags that relationship on its own.

A pattern of several small adjustments across the rent roll, each individually minor, can add up to a meaningfully different income picture once combined; reviewing the whole schedule line by line rather than sampling a handful of tenants catches that kind of cumulative drift.

Turning the Rent Roll Into an Offer

Once the rent roll is verified against lease files, it becomes the basis for a normalized income figure that a lender and an investor can both rely on, rather than a marketing number based on asking-price math. That verified figure should drive the offer, the loan request, and the identification decision, not the pro forma the listing broker circulated.

Where the rent roll and the lease files disagree in ways that cannot be resolved before the identification deadline, it is reasonable to identify the property conditionally while continuing the review, rather than either abandoning a good candidate or ignoring a real discrepancy under time pressure.

Common 1031 Exchange Questions

Should I trust a rent roll provided by the seller's broker instead of the property manager?

Treat a broker-provided rent roll as a starting point rather than a final source, and ask for the underlying document directly from whoever manages the property day to day; brokers sometimes work from a version that has not been updated with the most recent tenant changes.

What's the difference between a rent roll and a trailing-12 financial statement?

The rent roll shows contractual lease terms tenant by tenant; the trailing-12 shows actual cash collected and expenses paid over the past year. Both are needed together because a rent roll can show rents that were never fully collected.

How current should a rent roll be before I rely on it for an offer?

Request one dated within the prior thirty days, and ask for an updated version again closer to closing since tenant status can change between initial review and the closing date.

What if the rent roll shows month-to-month tenants on a large share of the building?

That is a signal to model turnover and vacancy more conservatively, and to ask why fixed-term renewals were not executed; it may reflect market softness, deferred management, or tenants waiting on ownership change before committing.

Who typically prepares the rent roll I'll be reviewing, the seller or their manager?

Usually the seller's property manager, working from their management software; request it directly from the manager rather than only through the listing broker so questions can be answered by the person who actually maintains it.

Ready to organize the exchange file?