ComplianceMicrosoft Excel

CAM Reconciliation Prep

By Angel Campa, Founder · Updated March 2026 · Saves 2–4 hours per property annually

The Problem

Preparing for CAM reconciliation requires knowing each tenant's pro-rata share, CAM cap provisions, exclusion lists, and base year — all buried in lease documents. Without accurate extraction, landlords may over-bill or under-bill tenants, and tenants may miss their right to dispute.

Step-by-Step Workflow

  1. 1
    Upload tenant lease PDFsSource

    Upload the executed lease for each tenant subject to CAM reconciliation.

  2. 2
    Extract CAM-relevant fieldsLextract

    Lextract identifies pro-rata share, CAM cap type and rate, base year, exclusions, controllable vs. non-controllable expense definitions, and tenant audit rights.

  3. 3
    Review CAM cap and exclusion fieldsLextract

    CAM caps and exclusions are frequently buried in exhibits and riders. Review confidence scores on these fields carefully and cross-check against the lease exhibit.

  4. 4
    Download CAM summary ExcelDestination

    Export a per-tenant CAM summary showing each tenant's share, cap, and exclusion list in a side-by-side Excel format.

  5. 5
    Build CAM reconciliation workbookDestination

    Load the per-tenant CAM data into your reconciliation model. Apply each tenant's cap and exclusions to the actual operating expenses to compute final CAM charges.

Who Uses This Workflow

Property ManagersTenant Representatives

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 CAM fields does Lextract extract?

Lextract extracts pro-rata share percentage, CAM cap type (cumulative or non-cumulative), annual CAM cap rate, base year for controllable expenses, exclusion list items, and tenant audit rights window.

Can Lextract identify gross-up provisions?

Yes. Lextract flags gross-up clauses that allow the landlord to normalize operating expenses to a specified occupancy level, which affects the CAM denominator.

Related Workflows

Related Articles

Related Resources

Start the CAM Reconciliation Prep 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