Skip to main content

CAM Expense Reconciliation Process: GL Mapping to Final Billing

By Angel Campa·Founder, CapVeri

Quick Answer

The CAM expense reconciliation process has five phases: GL mapping and exclusions, controllable/non-controllable split, gross-up calculation (if occupancy is below threshold), cap math, and pro-rata share billing. Getting the GL mapping right is the foundation — errors there compound through every downstream calculation.

Why the Process Order Matters

CAM expense reconciliation isn't a single calculation — it's a sequence of decisions, each dependent on the one before. A property accountant who gross-ups before removing non-recoverable expenses will overstate the pool. One who applies the cap before the gross-up may create a calculation the lease doesn't support.

This guide walks through the process in the correct order, with worked dollar examples at each stage.

If you need a step-by-step task list, use the CAM reconciliation checklist alongside this guide.


Phase 1: GL Account Mapping

Building the Account Map

Every CAM reconciliation starts with a complete GL export for the property year. Your first job is assigning every GL account a disposition: includable, excludable, or partial.

A standard mapping table looks like this:

GL AccountAccount NameDispositionLease Clause
5100Janitorial ServicesInclude§7.1(a)
5200LandscapingInclude§7.1(b)
5300Building MaintenancePartial§7.1(c), §7.3
5400Management FeeInclude (capped)§7.2 — max 3% opex
5500Capital ImprovementsExclude§7.4
5600DepreciationExclude§7.4
5700Real Estate TaxesInclude (non-controllable)§8.1
5800InsuranceInclude (non-controllable)§8.2

The "Partial" accounts require transaction-level review. Account 5300 (Building Maintenance) might contain both a $4,200 quarterly HVAC service contract (includable) and a $45,000 HVAC compressor replacement (excludable). Pull the underlying transactions and split them.

For a full inclusion/exclusion breakdown, see what is included in CAM expenses.

Management Fee Cap

Management fees are nearly always includable but frequently capped. Common cap structures:

  • 3% of total operating expenses (most common in retail)
  • 4% of gross revenues
  • A fixed dollar amount per square foot

Example: 200,000 SF property, $1,800,000 in total operating expenses. Management fee cap at 3% of opex = $54,000. If actual management fees billed = $72,000, the excess $18,000 is excluded from the pool.


Phase 2: Controllable vs. Non-Controllable Split

Once you have a clean includable expense pool, split it into controllable and non-controllable categories. This split drives the cap calculation — caps only apply to controllable expenses in most leases.

Controllable expenses (typically): janitorial, landscaping, parking lot maintenance, security, common area utilities, management fees, general repairs.

Non-controllable expenses (typically): real estate taxes, property insurance, snow and ice removal (in some leases), utility costs for uncontrollable municipal rate changes.

See controllable vs non-controllable expenses for how different lease types classify each category.

Example Split

Property: 350,000 SF retail center Year-end includable expenses: $2,100,000

CategoryAmountClassification
Janitorial$280,000Controllable
Landscaping$140,000Controllable
Parking lot maintenance$95,000Controllable
Security$210,000Controllable
Common area utilities$175,000Controllable
Management fee$54,000Controllable
Repairs and maintenance$146,000Controllable
Real estate taxes$700,000Non-controllable
Insurance$300,000Non-controllable
Total$2,100,000

Controllable subtotal: $1,100,000 Non-controllable subtotal: $1,000,000


Phase 3: Gross-Up Calculation

When Gross-Up Applies

The lease will specify an occupancy threshold — typically 90% or 95%. If actual average occupancy for the year falls below that threshold, variable CAM expenses get grossed up to what they would have been at the threshold occupancy.

Why this matters: if a building is 70% occupied, the landlord is covering more common area maintenance per occupied tenant than they would at full occupancy. Without gross-up, tenants benefit from a windfall reduction. The gross-up clause restores the per-tenant cost to a stabilized-occupancy level.

The Math

Formula: Grossed-up expense = (Actual variable expense ÷ Actual occupancy %) × Gross-up threshold %

Continuing the example above:

  • Property: 350,000 SF, 245,000 SF occupied = 70% occupancy
  • Gross-up threshold per lease: 95%
  • Variable controllable expenses: $1,100,000

But wait — not all controllable expenses are variable. The $54,000 management fee contract is a flat fee regardless of occupancy. The $146,000 in repairs is mostly reactive (same vacancy percentage doesn't reduce repair calls much). A reasonable variable/fixed split:

ExpenseTotalVariable Portion
Janitorial$280,00085% = $238,000
Landscaping$140,00030% = $42,000
Parking lot maintenance$95,00020% = $19,000
Security$210,00040% = $84,000
Common area utilities$175,00070% = $122,500
Management fee$54,0000% = $0
Repairs and maintenance$146,00025% = $36,500

Total variable portion: $542,000

Gross-up: ($542,000 ÷ 0.70) × 0.95 = $735,143

Fixed portion: $558,000 (unchanged)

Grossed-up controllable CAM: $735,143 + $558,000 = $1,293,143

For a deeper walkthrough of gross-up with multiple scenarios, see the CAM gross-up calculation guide.


Phase 4: Cap Calculation

Applying the Cap

With the grossed-up pool in hand, test the controllable portion against the lease's cap. Assume the cap is 5% per year and prior-year controllable CAM was $1,050,000.

Maximum allowed increase: $1,050,000 × 1.05 = $1,102,500

Grossed-up controllable CAM: $1,293,143

Cap applies. Capped controllable CAM: $1,102,500

Final billable pool: $1,102,500 (controllable, capped) + $1,000,000 (non-controllable) = $2,102,500

Note: without the gross-up, this property's actual controllable expenses ($1,100,000) would have been just under the cap. The gross-up created the cap-triggering situation — which is why documenting the sequencing matters.

For more on cap structures, see CAM cap types.


Phase 5: Pro-Rata Share Billing

Computing Each Tenant's Share

Pro-rata share = tenant's rentable SF ÷ denominator

Denominator is typically total leasable area, but leases vary. Retail leases often exclude anchor tenant space. Some office leases use rentable area on a floor-by-floor basis.

For the pro-rata share calculation in detail, see that resource. For this example:

Property GLA: 350,000 SF Anchor tenant (excluded from denominator per lease): 80,000 SF Effective denominator: 270,000 SF

TenantSFPro-Rata ShareCAM Charge
Tenant A15,0005.56%$116,899
Tenant B8,5003.15%$66,229
Tenant C22,0008.15%$171,354
Anchor80,000Excluded$0 (or flat fee)
(remaining tenants...)144,50053.52%
Vacant80,000Not billed

Reconciling Against Estimates

Each tenant paid monthly estimates during the year. The final reconciliation computes:

Final charge − Total estimates paid = True-up amount

Positive true-up: tenant owes additional payment Negative true-up: landlord issues credit against next month's rent

For the mechanics of handling credits and disputes, see CAM true-up.


Building the Audit Trail

Every calculation step should be documented with the source data attached:

  1. GL export with account mapping notations
  2. Management fee cap calculation
  3. Controllable/non-controllable split schedule
  4. Variable/fixed expense split for gross-up
  5. Gross-up calculation worksheet
  6. Cap calculation worksheet (with prior-year comparison)
  7. Pro-rata share denominator source (rent roll)
  8. Tenant billing summary with estimate reconciliation

This documentation package is what you hand over if a tenant exercises their audit rights. See defensible reconciliation package for what "audit-ready" looks like.


Where CapVeri Fits

CapVeri automates Phases 1–5 after you import your GL export. The account mapping table is configured once per property and reused each year. Gross-up and cap parameters are set per lease. Pro-rata share denominators pull from your rent roll import.

The platform produces the audit trail documentation as a byproduct of the calculation — not a separate manual step.

Use the CAM reconciliation checklist alongside CapVeri to make sure no pre-import steps (like lease abstract review) get skipped.

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