CAM Expense Reconciliation Process: GL Mapping to Final Billing
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 Account | Account Name | Disposition | Lease Clause |
|---|---|---|---|
| 5100 | Janitorial Services | Include | §7.1(a) |
| 5200 | Landscaping | Include | §7.1(b) |
| 5300 | Building Maintenance | Partial | §7.1(c), §7.3 |
| 5400 | Management Fee | Include (capped) | §7.2 — max 3% opex |
| 5500 | Capital Improvements | Exclude | §7.4 |
| 5600 | Depreciation | Exclude | §7.4 |
| 5700 | Real Estate Taxes | Include (non-controllable) | §8.1 |
| 5800 | Insurance | Include (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
| Category | Amount | Classification |
|---|---|---|
| Janitorial | $280,000 | Controllable |
| Landscaping | $140,000 | Controllable |
| Parking lot maintenance | $95,000 | Controllable |
| Security | $210,000 | Controllable |
| Common area utilities | $175,000 | Controllable |
| Management fee | $54,000 | Controllable |
| Repairs and maintenance | $146,000 | Controllable |
| Real estate taxes | $700,000 | Non-controllable |
| Insurance | $300,000 | Non-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:
| Expense | Total | Variable Portion |
|---|---|---|
| Janitorial | $280,000 | 85% = $238,000 |
| Landscaping | $140,000 | 30% = $42,000 |
| Parking lot maintenance | $95,000 | 20% = $19,000 |
| Security | $210,000 | 40% = $84,000 |
| Common area utilities | $175,000 | 70% = $122,500 |
| Management fee | $54,000 | 0% = $0 |
| Repairs and maintenance | $146,000 | 25% = $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
| Tenant | SF | Pro-Rata Share | CAM Charge |
|---|---|---|---|
| Tenant A | 15,000 | 5.56% | $116,899 |
| Tenant B | 8,500 | 3.15% | $66,229 |
| Tenant C | 22,000 | 8.15% | $171,354 |
| Anchor | 80,000 | Excluded | $0 (or flat fee) |
| (remaining tenants...) | 144,500 | 53.52% | — |
| Vacant | 80,000 | — | Not 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:
- GL export with account mapping notations
- Management fee cap calculation
- Controllable/non-controllable split schedule
- Variable/fixed expense split for gross-up
- Gross-up calculation worksheet
- Cap calculation worksheet (with prior-year comparison)
- Pro-rata share denominator source (rent roll)
- 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.