The CAM Reconciliation Worksheet

A CAM reconciliation statement arrives as a single number — you owe this, or you’re credited that — sitting on top of a year of building expenses you never saw itemized. Most tenants pay it. The ones who check it regularly find something: a capital project billed as an operating expense, an admin fee above the lease cap, or a pro-rata share computed on the wrong denominator. None of that requires an accountant. It requires a method and an afternoon.

This worksheet is that method. Download the Excel workbook — the pro-rata share, year-over-year change, and true-up math compute themselves as you fill it in — then pull your lease and the reconciliation statement alongside it, and work down the columns. It’s written to be useful from either side of the table — a tenant checking a bill, or a landlord and property manager who’d rather send a statement that survives scrutiny.

Step 1 — Recompute your pro-rata share

Start with the number everything else multiplies against. Your share is normally your rentable square footage divided by the building’s total rentable (or leased) square footage. Two traps live here. First, the denominator: a lease that shares costs across leased area produces a different number than one using total area, and in a half-empty center that gap is large. Second, the gross-up: many leases let a landlord gross up variable expenses to full occupancy, which is legitimate but changes the math. Recompute your share from your own lease language and compare it to the percentage on the statement. If they differ, that’s question one.

Step 2 — Walk the expense pool line by line

Put each expense category from the statement into the worksheet next to the prior year’s figure. You’re looking for two things: exclusions and swings. Your lease almost certainly excludes some costs from CAM — capital improvements, leasing commissions, ownership-entity costs, depreciation, reserves, and sometimes the cost of correcting original construction defects are common exclusions. Any of those appearing in the pool is a flag. Then scan year-over-year: a line that jumped 40% deserves a question, and a big new line item deserves a “what is this and does the lease allow it?”

Step 3 — Test the caps

Many leases cap the controllable portion of CAM — often the total, or specifically the management/administrative fee — at a fixed percentage or a year-over-year escalation limit. Two checks: is the management or admin fee within the percentage your lease allows, and did controllable expenses exceed any annual cap or cumulative cap? Caps are one of the most common places a statement quietly overshoots, because they require applying the lease terms, not just adding receipts.

Step 4 — Check the true-up math

The arithmetic itself is worth verifying. Confirm that (your recomputed share × the reconcilable pool) minus what you actually paid in monthly estimates equals the balance shown. Then confirm the estimate for next year is reasonable — landlords reset monthly CAM based on the new actuals, and an inflated reset quietly raises your carrying cost all year.

Step 5 — Build the questions list, then mind the clock

Everything you flagged goes in the worksheet’s questions column with the lease section it relates to. Send it as a single, specific, professional request — not a dispute, a reconciliation. Most of what turns up is honest error, and a clean list gets it fixed fast. The one hard deadline: your audit window. Leases commonly give tenants a limited period — often 60 to 120 days after the statement — to request backup or audit the charges, and that right expires. Note your window at the top of the worksheet and don’t let it lapse.

For landlords and managers

The same worksheet is a pre-send checklist. A reconciliation that already separates excluded costs, applies the caps correctly, states the pro-rata basis plainly, and shows its math generates far fewer tenant disputes and gets paid faster. Transparency here is a retention tool: tenants who trust the CAM statement renew with less friction. For the deeper landlord-side walk-through — gross-ups, common exclusions, and audit-response practice — see the companion guide.