ComplianceMicrosoft Excel

Lease Audit Data Preparation

By Angel Campa, Founder · Updated March 2026 · Saves 2–4 hours per lease audit setup

The Problem

Auditing landlord operating expense charges requires knowing your exact lease rights: what is included in CAM, what is excluded, your pro-rata share, your cap provisions, and your audit rights window. Without extracting these terms from the lease, tenants often fail to identify overbillings they are contractually entitled to dispute.

Step-by-Step Workflow

  1. 1
    Locate and upload your executed leaseSource

    Upload your executed lease including all amendments and exhibits to Lextract.

  2. 2
    Extract CAM and audit rights provisionsLextract

    Lextract identifies your pro-rata share, CAM definition, exclusion list, controllable expense cap, gross-up provision, and audit rights clause including the lookback period.

  3. 3
    Review exclusion and cap fieldsLextract

    Verify that all exclusion items and CAM caps have been correctly extracted. These are often in exhibits and may be missed if the exhibit structure is non-standard.

  4. 4
    Download lease rights summaryDestination

    Export the CAM provisions as a structured Excel reference document for your auditor.

  5. 5
    Provide to CRE auditor for expense comparisonDestination

    Share the extracted lease rights summary with your auditor. The auditor compares landlord's actual charges against your lease entitlements to identify overbillings.

Who Uses This Workflow

Tenant RepresentativesLease AuditorsCorporate Real Estate 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 is a typical CAM overbilling rate?

Studies suggest that 30–40% of commercial tenants are overbilled on CAM charges at some point during their tenancy. The audit process requires knowing your exact lease rights, which Lextract extracts.

How far back can I audit CAM charges?

Lextract extracts your audit rights clause, which specifies the lookback period — typically 1–3 years after receipt of the annual CAM reconciliation statement. Beyond that window, your audit rights may be contractually barred.

Related Workflows

Related Articles

Related Resources

Start the Lease Audit Data Preparation 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