What Is CAM Reconciliation?

Common Area Maintenance (CAM) reconciliation is the annual process of settling the difference between what a commercial tenant paid throughout the year in estimated CAM charges and what they actually owe based on real expenses.

In a triple net (NNN) or modified gross lease, tenants agree to pay their proportionate share of operating expenses — things like landscaping, parking lot repairs, roof maintenance, insurance premiums, and property taxes. Because exact expenses aren't known in advance, landlords estimate these costs at the start of each year and bill tenants monthly. At year end, once actual figures are in, you reconcile.

If the tenant overpaid, they receive a credit. If they underpaid, you send a reconciliation statement with the balance due. Simple in concept — complicated in execution.

Why CAM Reconciliation Is Difficult

Most property managers underestimate how many variables go into a single reconciliation statement. Even a modest NNN portfolio creates significant complexity:

• Lease-specific caps — Many tenants negotiate annual CAM cap increases (e.g., 5% per year), limiting how much their share can grow
• Controllable vs. uncontrollable expense splits — Utilities, insurance, and taxes are typically "uncontrollable" and exempt from caps; management fees and maintenance labor are "controllable" and subject to them
• CAM exclusions — Capital improvements, leasing commissions, and structural repairs are frequently excluded from recoverable expenses by lease language
• Anchor tenant carve-outs — In multi-tenant properties, anchor tenants often negotiate reduced CAM contributions or exclusions that shift costs to smaller tenants
• Pro-rata share variations — Some leases calculate pro-rata based on occupied square footage, others on total leasable area; some exclude anchor tenant space from the denominator
• Gross-up provisions — If occupancy drops below a threshold (often 90–95%), some leases allow landlords to "gross up" variable expenses as if the building were fully occupied
• Base year caps — Tenants whose leases include a base year only pay for expense increases above that baseline

Managing all of this across even five tenants using spreadsheets invites errors — and errors create disputes, damaged relationships, and potential legal liability.

The Step-by-Step CAM Reconciliation Process

Here is a straightforward walkthrough of how a manual NNN CAM reconciliation works from start to finish:

Step 1: Pull Actual Annual Expenses From Your Books

Export all operating expenses for the property from QuickBooks (or your accounting system) for the calendar year being reconciled. Organize them by category: maintenance, utilities, insurance, management fees, taxes, landscaping, repairs, etc.

Step 2: Apply Exclusions Per Each Lease

Go lease by lease and remove any line items the tenant's lease excludes from CAM. Capital improvements are the most common exclusion. Document every adjustment and keep the source lease language accessible for dispute resolution.

Step 3: Calculate Pro-Rata Shares

For each tenant, divide their rentable square footage (RSF) by the total property RSF (or denominator defined in the lease) to get their pro-rata percentage. Apply that percentage to each applicable expense category.

Step 4: Apply CAM Caps

For tenants with CAM caps, calculate the maximum recoverable amount using the cap formula from their lease. Compare the uncapped allocation to the cap. Bill the lower of the two — and document the capped amount for your records.

Step 5: Compute the Overage or Credit

Subtract what the tenant actually paid in monthly CAM estimates throughout the year from their final calculated obligation. The result is either a balance due (invoice) or a credit to apply against future rent.

Step 6: Generate Reconciliation Statements

Produce a clear, itemized statement showing: total expenses, the tenant's pro-rata percentage, their capped allocation, what they paid, and the resulting amount owed or credited. Attach a backup expense exhibit.

Before you finalize statements, use this CAM reconciliation pre-billing checklist to confirm that the accounting, lease, exception, and supporting-document details are ready for tenant review.

Step 7: Send to Tenants

Most leases give landlords 90–180 days after year-end to deliver reconciliation statements. Send them certified if your lease requires it (or if you anticipate disputes). Many leases give tenants the right to audit — so your backup documentation needs to hold up.

Common CAM Reconciliation Disputes — and How to Prevent Them

Disputes almost always stem from one of three sources: incorrect exclusions, misapplied caps, or unclear documentation.

> Pro tip: Always attach a detailed cost backup exhibit to your reconciliation statement. Tenants who receive an itemized breakdown with supporting documentation almost never dispute. Tenants who receive just a lump number almost always do.

Other prevention strategies:

• Keep a lease abstract for every tenant that lists their CAM cap formula, base year, exclusions, and pro-rata denominator
• Reconcile monthly in your accounting system rather than waiting for year-end — you'll catch overruns and errors earlier
• Never commingle expenses across properties in QuickBooks — map every bill to the correct property class
• Document management fee calculations separately; management fees are frequently contested

What Happens When You Manage 10+ Properties

Multiply the process above by 10 properties, each with 3–8 tenants. Now you have 30–80 individual reconciliations, each with unique lease terms. Even with organized spreadsheets, you're looking at 3–6 weeks of intensive work each year — plus the ongoing risk of errors that compound when formulas are manually maintained.

The most common failure points at scale:

• Expense data pulled from QuickBooks doesn't match general ledger due to manual re-entry
• CAM cap formulas in spreadsheets drift from lease language when leases are renewed
• Pro-rata denominators become stale as vacancies change and spaces are re-tenanted
• Staff turnover means institutional knowledge about tenant-specific quirks walks out the door

How PigJet Can Streamline the Process

PigJet can help organize the CAM reconciliation workflow by bringing lease terms, expense data, and allocation details into one place. Before finalizing a statement, review the accounting data, lease-specific caps and exclusions, any exceptions, and the supporting documentation for the period.

Its CAM tools can support more consistent calculations and tenant-ready statements, while your team retains responsibility for validating the inputs and assembling the backup appropriate for each reconciliation.

For portfolios managing between 3 and 25 NNN properties, PigJet can reduce spreadsheet work and help standardize the reconciliation process. See how it works →

You can also try our free CAM Calculator to run manual estimates for any tenant allocation scenario.