AnalysisMicrosoft Excel

Rent Roll Verification

By Angel Campa, Founder · Updated March 2026 · Saves 1–2 hours per property for verification

The Problem

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.

Step-by-Step Workflow

  1. 1
    Obtain rent roll and lease PDFs from sellerSource

    Collect the seller-provided rent roll (Excel or PDF) and all executed lease PDFs from the data room.

  2. 2
    Upload all lease PDFs to LextractLextract

    Process each lease PDF through Lextract to generate an independent abstract for every tenant.

  3. 3
    Export abstracts as ExcelLextract

    Download the extracted lease data for all tenants into a consolidated Excel export.

  4. 4
    Build side-by-side comparison in ExcelDestination

    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.

  5. 5
    Flag and escalate variancesDestination

    Identify discrepancies in base rent, expiration date, escalation terms, and option status. Prepare a variance summary for legal review and seller representation confirmation.

Who Uses This Workflow

Due Diligence AnalystsAcquisition Teams

How Lextract integrates with Microsoft Excel

Learn about the full integration between Lextract and Microsoft Excel, including supported export formats and critical fields.

View Microsoft Excel integration →

Frequently Asked Questions

What discrepancies does rent roll verification commonly catch?

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.

How long does it take to verify a 20-tenant rent roll?

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.

Related Workflows

Related Articles

Related Resources

Start the Rent Roll Verification workflow

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