A rent roll is a snapshot of who occupies each unit, what they pay, and how the tenancy is structured. That apparent simplicity is exactly why it deserves hard scrutiny in an acquisition. The document is generated by the seller's property management system, exported on the seller's timeline, and shaped by whatever conventions the on-site team happens to use. Your entire underwriting model sits on top of it, so the review has to go well beyond reading down the columns.
Rent roll due diligence is the process of proving that the snapshot is complete, internally consistent, reproducible from source systems, and reconcilable to the money that actually landed in the bank. What follows is a working sequence for doing that, plus the exceptions that should change your offer price.
What Rent Roll Due Diligence Is Meant to Prove
During due diligence, buyers use the rent roll to verify the seller's income claims, assess rollover risk, identify below-market leases, and confirm the tenancy structure that supports the asking price. Those four objectives should drive every test you run.
It also helps to separate two transactions that share the same name. Buying a rent collection book as a business is one thing, and that process often runs 60 to 90 days from initial agreement to settlement, including roughly two to three weeks of due diligence. Buying a multifamily property is another. In a property deal, the rent roll is evidence about the asset, and the review window is whatever the purchase agreement allows. Confirm the deadline with counsel before you build a testing plan.
Assemble the Source Documents First
Analysis quality collapses if you work from a retyped PDF. Request the raw export and the supporting evidence at the same time, so the tests can actually run.
- Current rent roll exported directly from the property management system, not a reformatted spreadsheet.
- Trailing twelve month operating statement.
- Bank statements covering the review period.
- Lease files or lease abstracts for occupied units.
- Delinquency and accounts receivable aging.
- Lease expiration schedule and any monthly rent roll history the seller will release.
If the seller's book is not clean and organized before marketing begins, every downstream request slows down. Missing statements are one of the most common causes of delay in any acquisition diligence process, so raise documentation gaps early and in writing.
Step 1: Validate Completeness and Structure
Before testing any number, confirm that the unit population is real. Tie the unit count on the rent roll to the unit mix, the floor plans, and any prior rent rolls the seller provides. Then hunt for the categories that quietly distort totals.
- Duplicate unit numbers, or units listed twice under different tenant names.
- Units that exist on the rent roll but not in the physical unit count.
- Units missing from the roll entirely, particularly recently vacated units.
- Model units, employee units, and common area or commercial spaces carrying zero rent.
- Units marked occupied with no rent, no lease dates, or no security deposit.
- Holdover tenants still listed on expired terms.
Each of these items changes either revenue, occupancy, or both. Note them individually rather than netting them into a single adjustment, because they carry different risk.
Step 2: Recompute Scheduled Rent and Compare to the Operating Statement
Multiply each unit's rent by its occupancy status and rebuild the gross potential rent figure independently. Do not accept the total printed on the report. Then map your rebuilt total to the rent income line on the trailing twelve month statement.
The two numbers will rarely match exactly, and they are not supposed to. Vacancy, concessions, loss to lease, non-revenue units, ancillary charges, and billing timing all create legitimate gaps. What matters is that every gap has a documented explanation. An unexplained variance between the rent roll and the operating statement is the single most reliable signal that something in the seller's reporting needs a follow-up question.
Step 3: Trace Collections to the Bank
Reported rent is a billing figure. Cash is evidence. During the diligence process, the buyer's team should verify the rent roll against bank statements to confirm that collections actually occurred. A practical approach is to select representative months, tie tenant receipts to deposits, and reconcile the difference to the delinquency report.
Watch for patterns rather than single items: deposits that arrive in round lump sums, receipts recorded in one month but banked in another, prepayments that flatter a recent period, and collection rates that improve sharply in the months immediately before marketing. Each of these can be legitimate. None should be accepted without support.
Step 4: Test Occupancy, Vacancy, and Loss to Lease
Separate physical occupancy from leased occupancy. A unit under a signed lease with a future move-in date is not the same as an occupied unit, and neither is the same as a unit on notice to vacate. Build the bridge explicitly: occupied units, occupied but on notice, leased but not yet moved in, vacant and ready, vacant and down for turnover, and units held off market.
Loss to lease is the gap between in-place rent and market rent on the same units. Reviewing it unit by unit reveals whether the in-place rent roll has been managed to market or allowed to drift. A large, broad gap suggests upside, but only if the market rent assumption itself is defensible. A gap concentrated in a handful of long-tenured tenants is a different story and usually points to a renewal decision, not an automatic mark to market.
Step 5: Read the Lease Expiration Schedule for Rollover Risk
Sort every lease by expiration month and look at concentration. A property that loses a large share of its leases in a single quarter carries more risk than a property with the same average lease term spread evenly across the year. Pay particular attention to month-to-month tenancies and short initial terms, since both compress the window in which you must renew or replace tenants.
Rollover risk is not only a revenue question. It drives turnover cost, leasing commissions, and downtime in your proforma. Any concentration you find should be reflected in the capital plan, not just mentioned in the investment memo.
Step 6: Isolate Concessions and Non-Standard Charges
Concessions hide inside notes columns, ancillary income lines, and one-time credits. Pull every unit with free rent, waived fees, employee or manager discounts, or a rent figure that does not match its lease. Then classify each item as recurring or one-time, because the classification changes stabilized revenue.
On the income side, separate base rent from ancillary charges such as utility billing, pet rent, parking, storage, and fees. Confirm which charges are contractual and which are discretionary. A rent roll that reports one blended number per unit is a request for the underlying ledger, not a number to underwrite.
Step 7: Match Tenant-Level Detail to Leases and Delinquency
Sample across the roll, including the largest balances and the longest tenancies. For each sampled unit, confirm the tenant name, lease start and end dates, rent and escalation schedule, security deposit, and any side agreements. Then tie the balance on the rent roll to the delinquency aging report.
Balances are where rent rolls and reality diverge most often. A tenant carrying a large receivable may also have an open dispute, a payment plan, or a pending legal action, and each of those has a different recovery probability. Review the write-off history for evidence of how the operator has handled nonpayment in the past.
Exception Log: What to Document and Where to Look
Keep a single exception log through the review. It becomes the agenda for follow-up calls and the basis for underwriting adjustments.
| Check | Primary source | What triggers follow-up |
|---|---|---|
| Unit population | Rent roll, unit mix, floor plans | Duplicate, missing, or non-revenue units |
| Gross potential rent | Rent roll, trailing twelve month statement | Unexplained variance between rebuilt and reported rent |
| Collections | Bank statements, delinquency aging | Receipts that do not tie to deposits |
| Occupancy status | Rent roll, notices, leasing reports | Occupied units on notice or with no lease dates |
| Expiration schedule | Rent roll lease end dates | Concentrated rollover or heavy month-to-month |
| Concessions | Rent roll notes, lease files | Recurring discounts treated as one-time |
| Tenant balances | Delinquency report, lease files | Large receivables, disputes, or payment plans |
Turn Exceptions Into Underwriting Adjustments
Diligence findings only matter if they reach the model. Every open exception should either be resolved with documentation or converted into an adjustment: a reduction to stabilized revenue, an increase to turnover and leasing costs, a reserve for disputed balances, or a price concession. Leaving findings in a narrative memo without a corresponding line in the proforma is how deals get underwritten to the seller's story.
Inconsistent or incomplete documentation is one of the most frequently cited problems in rent roll review, on both sides of a transaction. Sellers who clean the book before marketing and buyers who test it systematically both spend less time arguing about the same numbers.
Where Automated Parsing Fits
Most of the steps above are mechanical until judgment is required. Parsing a rent roll out of Yardi, RealPage, or Entrata and standardizing unit level fields is repetitive work that consumes a disproportionate share of a short diligence window. Coastwise Analytics handles that parsing and standardization, which reduces manual transcription error and moves the team more quickly to the questions that actually require analysis: whether the variances are explainable, whether the rollover is priced, and whether the in-place rents hold up.
The judgment still belongs to the analyst. Software can tell you that the rent roll does not tie to the operating statement. It cannot tell you whether the seller's explanation is credible, and that remains the core of the work.
Frequently Asked Questions
What should I check first in a rent roll?
Start with completeness, not rent. Confirm the unit count matches the unit mix and that no units are duplicated, missing, or sitting at zero rent without explanation. A rent roll with structural gaps produces unreliable totals further down, and every later test, including the tie-out to the operating statement and the collections review, becomes harder to trust.
Should the rent roll tie exactly to the trailing twelve month statement?
No. Small differences are normal and come from vacancy, concessions, loss to lease, ancillary charges, and billing timing. What you need is a documented explanation for each gap you find. An unexplained variance between rebuilt rent and reported rent income is a strong signal that the seller's reporting needs a direct follow-up question before you finalize pricing.
How do I identify below-market leases?
Compare in-place rent to a defensible market rent for each unit type, then review the resulting gap unit by unit. A broad gap across the portfolio suggests upside. A gap concentrated among long-tenured tenants points to individual renewal decisions rather than an automatic mark to market, and the timing of those renewals belongs in your rollover analysis.
How long does rent roll due diligence take?
In rent roll acquisitions where the asset being purchased is the rent collection book itself, the process often runs 60 to 90 days from initial agreement to settlement, including roughly two to three weeks of diligence. For a property acquisition, the window is set by the purchase agreement, so confirm the deadline with counsel before scoping the review.
What if the seller cannot provide bank statements?
Without bank statements you cannot confirm that reported rent was actually collected, which weakens the core income claim. Ask for alternative support such as deposit summaries or management system receipts, document the gap, and escalate to counsel and your lender. Treat unverified collections as an open item in the underwriting rather than resolving it in the seller's favor.
A rent roll is only a starting document. Its value in diligence comes from what you do with it: rebuilding the totals, tracing the cash, testing the leases behind each line, and turning every unexplained item into either a documented answer or a number in the model. Deals that close cleanly are usually the ones where that work happened early, while there was still time to reprice.
