Free CAM Reconciliation Spreadsheet Template (2026)
What a proper CAM reconciliation spreadsheet needs to include, the most common calculation errors, and how to verify landlord CAM statements.
Simplify CAM reconciliation with Lextract. Extract cap structures, exclusion lists, base years, and pro rata shares from every lease. Detect CAM billing risks automatically.
By Angel Campa, Founder · Updated March 2026
Year-end CAM reconciliation is one of the most complex and error-prone processes in commercial real estate. Property managers must compare actual operating expenses against estimated charges for every tenant, applying each lease's unique cap structure, exclusion list, base year, and pro rata share. Tenants and their representatives must verify that landlord reconciliation statements comply with lease terms. Manual reconciliation across a portfolio of even 20 leases can consume weeks of staff time, and errors in cap application or exclusion enforcement result in over- or under-billing that triggers disputes.
Lextract extracts every CAM-relevant field from each lease — cap percentages, cap types, base years, gross-up provisions, exclusion lists, management fee caps, pro rata shares, and reconciliation schedules. With this structured data, property managers can set up accurate reconciliation calculations and tenants can verify landlord statements against actual lease terms. Red flag detection automatically identifies leases with missing caps, absent gross-up provisions, or undefined reconciliation schedules before they become billing disputes.
Manual Process
4-8 hours per lease
With Lextract
Under 3 minutes per lease
Time Saved
97% time reduction
Upload Leases
Upload all tenant leases for the property or portfolio undergoing CAM reconciliation.
Extract CAM Provisions
Lextract extracts cap percentages, cap types, base years, exclusion lists, gross-up provisions, management fee caps, and pro rata shares for each lease.
Review Red Flags
Examine flagged leases with missing CAM caps (RF-003), cumulative caps (RF-004), absent gross-up provisions (RF-005), missing exclusions (RF-006), or undefined reconciliation schedules (RF-014).
Compare Against Statements
Use extracted lease terms to verify that the landlord reconciliation statement correctly applies each tenant's cap, exclusions, and pro rata share.
Export Reconciliation Data
Download structured CAM data as Excel for integration with reconciliation worksheets or property management billing systems.
Lextract extracts the lease terms that govern CAM reconciliation — caps, exclusions, base years, pro rata shares, and gross-up provisions. It does not perform the reconciliation calculation itself, but it provides the accurate lease data needed to set up or verify reconciliation worksheets.
By extracting the exact CAM provisions from the lease, Lextract enables tenant reps and attorneys to compare the landlord's reconciliation statement against actual lease terms. This makes it straightforward to identify if a cap was exceeded, an exclusion was ignored, or a management fee was overcharged.
Lextract detects eight CAM-related red flags: excessive management fees (RF-001), missing audit rights (RF-002), no CAM cap (RF-003), cumulative caps (RF-004), missing gross-up provisions (RF-005), absent exclusion lists (RF-006), no base year gross-up (RF-013), missing reconciliation frequency (RF-014), and short audit windows (RF-015).
What a proper CAM reconciliation spreadsheet needs to include, the most common calculation errors, and how to verify landlord CAM statements.
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 extracted in minutes. Perfect for cam reconciliation. Just $20 per lease.
Upload Your Lease