Common Rent Roll Errors and How to Catch Them Before Underwriting
A rent roll is the foundation for underwriting occupancy, revenue, lease terms, payment status, and valuation. When its data is inaccurate, every assumption built on top of it can be distorted. The risk is not theoretical: in one documented case, assigning a vacant shopping-center unit to the wrong floor underestimated potential rent and nearly cost the business €1 million.
Where Rent Rolls Commonly Go Wrong
The most frequent issues involve stale or incomplete data. Expired leases may remain active, while recent move-ins, move-outs, renewals, or approved rent increases may not be reflected. Manual transcription creates additional exposure, including incorrect unit numbers, transposed figures, misplaced decimals, and other errors that can accumulate across a large property.
Misclassified units and lease statuses can overstate or understate occupancy. A signed lease that has not begun, a renewal that has not been recorded, or a concession omitted from the file can change the apparent income profile. Missing payment and balance updates may also cause an underwriter to treat delinquent tenants as current, overstating cash flow.
Checks to Complete Before Underwriting
Acquisitions and asset management teams should verify the rent roll against independent sources of truth:
- Reconcile the listed unit count with the property's total units, including vacant, held, and offline units.
- Compare lease expirations, move-in dates, and move-out dates with the property management system.
- Match rent amounts and concessions to executed lease documents.
- Compare payment status and outstanding balances with the accounts receivable ledger.
- Recalculate total rent and occupied units, then compare the results with the report summary.
- Review the file for internal consistency and confirm that it is current as of the underwriting date.
Interpret the Data Correctly
A rent roll shows gross in-place income, not the property's complete financial picture. It does not include expenses such as maintenance, taxes, or vacancy, and it does not show market rent. Loss to lease—the difference between in-place and market rent—must be analyzed separately.
Automation can reduce risk by replacing manual transcription with standardized extraction from property management systems such as Yardi, RealPage, and Entrata. It also makes it easier to compare records, identify discrepancies, and create repeatable underwriting workflows. For institutional teams, that consistency helps ensure rent roll data can be trusted across deals and investment committee reviews.