How to Verify a Rent Roll During Due Diligence
A systematic process for verifying an acquisition rent roll against executed lease documents, including common discrepancies and how to find them.
By Angel Campa, Founder · Updated March 2026 · Saves 1–2 hours per property for verification
Sellers provide rent rolls that may not accurately reflect executed lease terms — rents may be overstated, expiration dates may be wrong, and option terms may be omitted. Verifying each line item against source documents is critical for acquisition due diligence but is extremely time-intensive without extraction tooling.
Collect the seller-provided rent roll (Excel or PDF) and all executed lease PDFs from the data room.
Process each lease PDF through Lextract to generate an independent abstract for every tenant.
Download the extracted lease data for all tenants into a consolidated Excel export.
Create a comparison workbook with the seller rent roll alongside Lextract-extracted values. Use VLOOKUP or Power Query to align rows by tenant and flag discrepancies.
Identify discrepancies in base rent, expiration date, escalation terms, and option status. Prepare a variance summary for legal review and seller representation confirmation.
Learn about the full integration between Lextract and Microsoft Excel, including supported export formats and critical fields.
View Microsoft Excel integration →Common issues include overstated in-place rents, incorrect or omitted expiration dates, missing free rent periods, undisclosed rent concessions, and option terms that alter projected cash flows.
With Lextract, processing 20 leases takes approximately 1 hour for extraction plus review time. Manual verification of the same 20 leases typically takes 2–4 days.
A systematic process for verifying an acquisition rent roll against executed lease documents, including common discrepancies and how to find them.
What accuracy can you realistically expect from AI lease abstraction tools? We break down field-level accuracy rates, where AI excels, where it struggles, and how to validate output.
Compare the top AI lease abstraction tools for commercial real estate in 2026. We review Lextract, Prophia, Kolena, Leasecake, MRI Software, and more — with pricing, accuracy, and use-case guidance.
Upload your lease PDF and get 125+ structured fields ready to import into Microsoft Excel. Just $20 per lease — no subscription required.
Start Extracting — $20/lease