GL Code Mapping for CAM Recovery: Building a Complete Chart of Accounts Mapping Table

Every CAM reconciliation starts with the same question: which GL accounts go into the recoverable pool? The answer should be documented in a mapping table — a line-by-line assignment of every GL account to a recovery category. In practice, most property accounting teams do not have one. They rely on tribal knowledge, prior-year templates, or the ERP's default recovery configuration, which may or may not match the lease terms.

The result is predictable. Recoverable expenses get excluded because nobody mapped the new GL account. Non-recoverable expenses get included because someone assumed the account code "looked right." Capital expenditures flow into operating pools because the 1500-series account was mapped as recoverable during initial setup and nobody revisited it.

A mapping table is not complex to build. It is tedious. That is why it does not get done. But the cost of not having one — measured in leakage, overbilling exposure, and audit defense hours — far exceeds the cost of spending a day building it.

Why Mapping Tables Matter

The Leakage Problem

When a new GL account is created and not mapped to a recovery pool, the expense sits in the GL but never flows into the CAM reconciliation. The landlord paid the expense. The lease authorizes recovery. But the expense is invisible to the reconciliation process.

This is the most common source of CAM leakage in portfolios that have undergone chart-of-accounts restructuring or ERP migration. A Yardi-to-MRI migration that adds 40 new GL accounts can create 40 potential leakage points if the mapping table is not rebuilt from scratch.

The Overbilling Problem

The reverse is equally dangerous. When a non-recoverable account is mapped as recoverable — a capital improvement account coded into the operating pool, or a management company overhead account included in common area expenses — every tenant is overbilled. This is the #1 finding in forensic tenant audits and the #1 trigger for audit rights disputes.

The Consistency Problem

Without a mapping table, recovery decisions are made by whoever is running the reconciliation. Person A includes GL 6810 (amortized capital improvements). Person B excludes it. Person A leaves. Person C has no idea what the prior treatment was. The reconciliation is different every year, and the landlord cannot explain why.

The Standard Mapping Table

The following table covers the most common GL accounts in commercial property accounting, mapped to CAM recovery categories. Your chart of accounts will differ — account numbers vary by ERP and by company — but the expense categories and recovery logic are standard across the industry.

Fully Recoverable Operating Expenses

These accounts pass through to tenants under a standard NNN or modified gross lease. They represent routine operating costs that maintain the property in its current condition.

Non-Recoverable Accounts

These accounts must never flow into the CAM pool. They represent capital expenditures, landlord overhead, or tenant-specific costs.

Conditionally Recoverable Accounts

These accounts require lease-specific review. The same expense can be recoverable or excluded depending on the lease language.

Common Mapping Errors

Error #1: New Accounts Not Mapped

When the chart of accounts is restructured or a new GL account is created, the new account may not be added to the CAM recovery mapping. The expense posts to the GL, the property P&L looks correct, but the reconciliation never picks it up.

How to detect: Run a list of all GL accounts with non-zero balances for the property. Compare against your mapping table. Any account with a balance that does not appear in the mapping table is a gap.

Real cost: A property adds GL 6315 (Ice Management) as a subaccount under Snow Removal. The reconciliation template still references only 6310. The $18,000 in ice management costs never enter the CAM pool. On a 150,000 SF building, that is $0.12/SF in pure leakage — $12,000+ in unrecovered expense if the building is 65% recoverable.

Error #2: Capital Accounts Mapped as Operating

During initial ERP setup, someone maps GL 1520 (HVAC Capital) into the recoverable pool. For three years, every HVAC capital project flows into tenant billings. The cumulative overbilling exposure grows with each year.

How to detect: Review all accounts in the 1000-series and 7000-series. None of these should be mapped as recoverable without explicit lease authorization and BOMA EER justification.

Error #3: Rollup Accounts Masking Detail

Some charts of accounts use parent-child structures where GL 6100 (R&M General) is the parent of 6110 through 6160. If the mapping references only the parent account, detailed entries posted directly to child accounts may or may not flow through depending on the ERP's rollup configuration.

How to detect: Map at the lowest level of the chart of accounts. If your ERP has 6110 through 6160 as distinct accounts, map each one individually. Do not rely on parent account rollups for recovery classification.

Error #4: Expense Pool Mismatch

A retail center has two CAM pools: common area maintenance and tax/insurance. GL 6510 (Real Estate Taxes) should be in the tax/insurance pool, not the CAM pool. If it is mapped to the wrong pool, the tax pass-through calculation is wrong and the CAM cap calculation is also wrong because it includes an expense that should be uncapped.

How to detect: For properties with multiple recovery pools, verify each GL account is assigned to the correct pool. Taxes and insurance are almost always in a separate uncapped pool.

Error #5: Controllable/Uncontrollable Misclassification

Many leases distinguish between controllable expenses (subject to an annual cap, typically 3-5%) and uncontrollable expenses (taxes, insurance, utilities — passed through without cap). If a controllable expense is mapped as uncontrollable, it bypasses the cap. If an uncontrollable expense is mapped as controllable, it gets artificially capped.

How to detect: Review your controllable/uncontrollable split against the lease language for your largest tenants. The lease definition of "controllable" varies — some leases define it explicitly, others use exclusion lists.

Building the Mapping Table

Step 1: Export Your Chart of Accounts

Pull every GL account used for the property in the past three years. Include account number, account name, and the most recent annual balance. This gives you the universe of accounts that need mapping.

Step 2: Classify Each Account

For each account, assign one of four categories:

• R — Fully recoverable
• NR — Non-recoverable
• CR — Conditionally recoverable (requires lease review)
• EX — Excluded from all pools (owner expense)

Step 3: Assign to Recovery Pool

For properties with multiple pools (CAM, tax/insurance, utility), assign each recoverable account to the correct pool. This determines which cap applies and how the expense is allocated.

Step 4: Map Controllable vs. Uncontrollable

For each recoverable account, flag whether it is controllable (subject to annual cap) or uncontrollable (pass-through). This mapping drives the cap calculation.

Step 5: Document the Lease Basis

For conditionally recoverable accounts, document which lease clause authorizes recovery. This is your audit defense. "GL 6810 is recoverable per Section 4.2(b)(iii) — amortized cost-saving capital improvements" is defensible. "We've always included it" is not.

Step 6: Validate Against Prior Year

Compare your new mapping table to the prior year's actual recovery. Account for any differences. If the prior year included an account your mapping excludes, determine whether the prior year was wrong or the mapping needs adjustment.

Maintaining the Mapping Table

A mapping table is a living document. It needs updating when:

• A new GL account is created
• The chart of accounts is restructured
• A property is acquired with a different GL structure
• A lease amendment changes the recoverable expense list
• A tenant audit challenges the inclusion or exclusion of a specific account
• The ERP is migrated and account numbers change

Assign ownership to one person — typically the property controller or senior accountant. Review the full mapping table annually before reconciliation season begins.

Related Resources

• GL Coding Guide — Detailed recoverable vs. non-recoverable classification rules
• CapEx Detection in CAM — Catching capital expenditures before they enter the pool
• What Is Included in CAM Expenses — Standard CAM expense categories
• Recovery Ratio Analysis — Measuring how much you actually recover