Skip to main content

Lease Expense Reconciliation: Framework for CAM, Taxes, and Insurance

By Angel Campa·Founder, CapVeri7 min read

Lease expense reconciliation — the annual process of comparing actual property operating costs to tenant estimate payments — covers three distinct expense categories under most commercial leases: common area maintenance (CAM), real estate taxes, and property insurance. Each has different accounting sources, different exclusion rules, and sometimes different cap structures.

Most property accountants treat these as a single process, but the GL coding and calculation logic for taxes and insurance are different enough from CAM that they warrant separate treatment within the reconciliation workflow.


The Three Expense Categories

Common Area Maintenance (CAM)

CAM covers the operating costs of maintaining shared property areas: janitorial, landscaping, security, parking lot maintenance, common area utilities, and property management. These expenses come from multiple GL accounts and require the most work to reconcile — account mapping, controllable/non-controllable split, gross-up, and cap math all apply primarily to this category.

For a complete treatment of CAM reconciliation, see what is CAM reconciliation and CAM expense reconciliation process.

Real Estate Taxes

Real estate taxes are the annual property tax assessed by the local jurisdiction. Unlike CAM, they come from a single or small number of GL accounts and the gross-up and cap provisions in most leases don't apply to them (they're non-controllable by definition).

The reconciliation complexity for taxes arises from:

  • Multi-parcel properties (the tax bill covers multiple parcels, some of which may not be part of the tenant's building)
  • Portfolio-level tax appeals (the landlord won a tax appeal — how is the refund distributed?)
  • Base year stop structures (office leases that only bill tax increases above the base year)
  • Tax escrow accounting (if the landlord collects and holds tax estimates in escrow)

Property Insurance

Property insurance covers the building against loss. Like taxes, it typically comes from a single GL account or a small number of accounts. The reconciliation complexity:

  • Portfolio policies allocated across multiple properties
  • Self-insurance arrangements
  • Deductible amounts (recoverable? depends on the lease)
  • Coverage types that may not be property-specific

GL Coding Guide by Expense Category

CAM GL Accounts (Typical)

Account RangeCommon Account NamesCAM Treatment
5100–5199Janitorial, CleaningInclude
5200–5299Landscaping, Snow RemovalInclude (check lease for snow)
5300–5399Building Maintenance, RepairsInclude (split out capital)
5400–5499SecurityInclude
5500–5599Utilities (common area)Include
5600–5649Management FeeInclude (subject to cap)
5650–5699Administrative, OfficeCheck lease
5700–5799Capital ImprovementsExclude (or amortize per lease)
5800–5899DepreciationExclude

The 5300–5399 range is the most dangerous. In most accounting systems, routine maintenance and capital repairs both post to "Building Maintenance." Reviewing individual transactions for accounts in this range isn't optional — it's how you catch the $60,000 HVAC replacement that doesn't belong in CAM.

Real Estate Tax GL Accounts

AccountNameTreatment
6100Real Estate Taxes — CurrentInclude (verify correct parcel)
6110Real Estate Tax AppealsReduce pool if refund received
6120Special AssessmentsCheck lease — often excluded
6130Business Improvement DistrictCheck lease

Parcel verification: Pull the actual tax bill and confirm the parcel number matches your property. Portfolio-managed properties sometimes have a master tax account that includes adjacent land, parking structures under separate ownership, or other parcels the tenant doesn't occupy.

Special assessments: These are one-time levies for infrastructure improvements (street repaving, utility upgrades). Most leases either explicitly include or exclude them — check before including.

Insurance GL Accounts

AccountNameTreatment
6200Property Insurance — BuildingInclude
6210Commercial General LiabilityInclude (common areas)
6220Umbrella/Excess LiabilityInclude (if property-specific)
6230Directors & OfficersExclude
6240Crime/FidelityExclude
6250Loss of IncomeExclude
6260Earthquake/FloodCheck lease

Portfolio allocation: If the landlord holds a portfolio policy covering 15 properties, the allocation to your property needs to be supportable. The standard method is to allocate based on insured value (replacement cost of the building). An arbitrary allocation — or one based on square footage when building values differ significantly — is grounds for dispute.


Operating Expense Reconciliation: Three Lease Structures

Structure 1: Full NNN Pass-Through

The most straightforward structure. Tenants pay their pro-rata share of actual taxes + actual insurance + actual CAM, less any excluded items.

Formula:

  • Tax pool: Actual taxes − excluded items (special assessments if excluded)
  • Insurance pool: Actual insurance − excluded types (D&O, crime, etc.)
  • CAM pool: Actual CAM − excluded items + gross-up adjustments − cap adjustments
  • Total pool: Tax + Insurance + CAM
  • Tenant charge: Total pool × pro-rata share %

Example (200,000 SF retail center, 10,000 SF tenant with 5.0% pro-rata share):

CategoryPool AmountTenant Share (5.0%)
CAM$1,100,000$55,000
Real estate taxes$600,000$30,000
Insurance$180,000$9,000
Total$1,880,000$94,000

Annual estimate paid: $88,000 True-up amount: $6,000

Structure 2: Base Year Stop (Office)

Tenants pay their pro-rata share of operating expenses above the base year amount. This is common in office leases and significantly changes the billing math.

Example:

  • Base year (2022) total operating expenses: $4,200,000
  • Current year (2025) total operating expenses: $5,100,000
  • Increase above base: $900,000
  • Tenant pro-rata share: 4.5%
  • Tenant's operating expense charge: $900,000 × 4.5% = $40,500

The tenant's lease may have a base year stop of $21.00/SF (the 2022 operating cost per square foot). If 2025 per-SF costs are $25.50, the billable increment is $4.50/SF × tenant's square footage.

For lease expense reconciliation with a base year stop, you need the base year operating expense records — not just the current year data. Landlords who've switched accounting systems since the base year sometimes lose this data, which creates disputes.

Structure 3: Modified Gross with Partial Pass-Through

Some leases pass through only specific categories. A modified gross lease might say: "Tenant pays its pro-rata share of real estate tax increases above the base year amount and 100% of insurance, but no CAM."

For these leases, reconcile each category separately and apply the correct methodology to each.


Exclusions by Category

CAM Exclusions (Most Common)

  • Capital expenditures and capital replacements
  • Depreciation and amortization (unless amortized capex is specifically permitted)
  • Management fees above the lease cap (typically 3–5% of operating expenses)
  • Costs of leasing space (commissions, TI allowances, legal fees for lease negotiation)
  • Executive salaries above the property management function
  • Income taxes and franchise taxes on the landlord's income
  • Costs attributable to other tenants (their TI, their specific utilities)
  • Financing costs (mortgage interest, loan fees)

For the complete list, see what is included in CAM expenses and CAM exclusion list complete guide.

Tax Exclusions

  • Taxes on landlord's income or franchise
  • Estate, inheritance, or transfer taxes
  • Special assessments (in many leases)
  • Taxes on capital improvements made solely for the benefit of another tenant
  • Penalties or interest on late tax payments (landlord's fault)

Insurance Exclusions

  • Coverage that benefits only the landlord (D&O, crime, key-man life)
  • Coverage for tenant improvements not included in the base building
  • Deductibles (unless the lease specifically includes them — some do)
  • Self-insured retentions above the lease's stated coverage requirement
  • Loss-of-income or business interruption coverage

CAM Caps and Tax/Insurance Caps

CAM caps limiting year-over-year increases are common in retail leases. Tax and insurance caps are much less common — most leases treat taxes and insurance as non-controllable expenses and do not subject them to caps.

When a lease does cap taxes or insurance, the cap usually applies to the combined operating expense pool rather than each category separately. Check the lease carefully — a cap on "operating expenses" that includes taxes and insurance is significantly more valuable to the tenant than a cap on "controllable CAM" only.

For detailed cap math on controllable CAM, see CAM cap types.


The Reconciliation Workflow

For a full-cycle lease expense reconciliation, follow the same sequence as CAM reconciliation checklist, applied to each expense category:

  1. Pull GL for all three categories
  2. Apply category-specific exclusions
  3. Verify tax bill against actual parcel records
  4. Verify insurance allocation basis
  5. Compute CAM pool (gross-up and cap as applicable)
  6. Compute each tenant's share by category (or combined, per lease)
  7. Reconcile against estimates by category (or combined)
  8. Generate statement showing all three categories

Common Errors in Lease Cost Reconciliation

Including the wrong tax parcel: Especially common with properties on multiple parcels or where a parking structure has a separate tax parcel not covered by the tenant's lease.

Allocating portfolio insurance incorrectly: The allocation should be based on insured value, not arbitrary floor area or prior-year precedent.

Netting the wrong accounts: Tax refunds from a successful tax appeal should reduce the billable tax pool — not be netted against CAM expenses. Keep the categories separate.

Missing the base year data: For office leases with expense stops, losing the base year operating expense records makes the stop uncomputable and creates a significant dispute exposure.

For a comprehensive list of billing errors across all categories, see cam reconciliation errors guide and top 15 cam billing errors.


Tenant Response: Reviewing a Lease Expense Reconciliation

Tenants receiving a combined operating expense reconciliation should check each category separately:

  • Taxes: Compare the billed amount to publicly available tax records. County assessor websites typically publish current-year assessed value and tax amounts for each parcel.
  • Insurance: Request the insurance declarations page for the policy year. Compare the premium allocated to your property against the total premium and the allocation basis.
  • CAM: Review using the methodology in tenant cam dispute.

If you identify a discrepancy in any category, the dispute process in cam charges dispute process applies to operating expenses broadly, not just CAM.

Need lease data before you reconcile?

lextract.io abstracts commercial leases into 126 structured fields in minutes — CAM definitions, pro-rata share, caps, base year, and more. No manual data entry.

Go to lextract.io