Free Lease Clause Extraction Matrix

The 15 CAM-critical lease fields captured in the matrix are: (1) denominator definition (fixed, floating, or gross-up), (2) gross-up occupancy threshold, (3) gross-up percentage, (4) cap type (cumulative, non-cumulative, or none), (5) cap percentage, (6) base year definition and amount, (7) controllable vs. non-controllable expense split, (8) management fee cap or definition, (9) CAM exclusion list (e.g., capital expenditures, structural repairs), (10) estimated CAM obligation, (11) reconciliation delivery deadline, (12) tenant audit rights window, (13) dispute resolution procedure, (14) audit cost allocation, and (15) lease year definition (calendar vs. fiscal). Missing or incorrect data in any of these fields will produce calculation errors.

Abstracting the 15 CAM fields from a well-organized commercial lease typically takes 20 to 45 minutes per lease for an experienced lease administrator. Complex leases with multiple amendments, side letters, or unusual CAM structures can take longer. The matrix is designed to minimize abstraction time by providing exact field definitions, the typical location in a commercial lease where each clause appears, and guidance on how to interpret ambiguous language. For portfolios with more than 20 to 30 leases, consider abstracting in batches during the pre-reconciliation period.

Yes. The matrix works for office, retail, industrial, flex, and mixed-use commercial leases. NNN leases, modified gross leases, and full gross leases all have CAM implications — the specific fields that apply will vary (a full gross lease may not have a separate CAM reconciliation provision, for example), and the matrix includes guidance on how to handle each lease type. The built-in validation flags fields that are required for the lease type you select and marks as not-applicable the fields that do not apply.

The matrix should be updated whenever a lease is amended, renewed, or assigned. At minimum, review all abstracts annually at the start of the reconciliation preparation period to confirm that any amendments executed during the year have been captured. The most common source of reconciliation errors at large portfolios is stale abstract data — a gross-up threshold that was changed in a lease amendment but never updated in the system. The matrix includes a last-reviewed date field and a flag column for leases that are due for re-review.