CAM Reconciliation: The Complete Guide for Landlords and Property Managers

Every commercial lease that passes operating costs through to the tenant ends the year the same way: the landlord adds up what the building actually cost, works out each tenant's share under the terms of each lease, compares it with what was billed in advance, and sends a statement. That exercise is CAM reconciliation — common area maintenance reconciliation — and for most property managers it is the most consequential arithmetic of the year. It decides real money, it goes out under your name, and a tenant's lease administrator will read it line by line.

This guide is the whole of it: what the reconciliation is, the vocabulary, the calculation in the order it has to be done, the check that proves a statement, and the errors that let a wrong statement balance. It is written for the people who do the work — landlords, property managers, lease administrators — and it follows the trade's own teaching: IREM's reconciliation course, the standard lease forms, and the worked examples every lease administrator learns from.

What CAM reconciliation is

A commercial tenant pays rent, and on most leases pays a share of the building's operating expenses on top of it — the cost of keeping the common areas running. Under a triple net (NNN) lease that share covers three things: common area maintenance, property taxes and insurance. Under a gross or modified-gross lease it covers the amount by which those costs exceed a reference year.

Nobody knows what a year will cost until it is over. So during the year the landlord bills an estimate, usually monthly, based on last year's costs or a budget. After year end the actual invoices are in, and the difference between what was billed and what was owed is settled: the tenant pays the shortfall, or receives a credit for the excess. That settlement is the true-up, and the work of getting there — classifying every expense, applying every lease's clauses, producing a statement per tenant — is the reconciliation.

If that is all you needed, the short answer stops there. It happens once a year, in the first quarter, for every building at once. A manager with seventy-five leases typically spends about sixty hours on it. The hours are not the problem. The problem is that a wrong statement looks exactly like a right one — until somebody who knows what to look for reads it.

The vocabulary

Ten words carry the whole subject.

• CAM — common area maintenance: the costs of the parts of the building every tenant uses. Landscaping, snow removal, parking-lot lighting, security, janitorial, management. (What CAM charges cover, and what a lease keeps out.)
• NNN (triple net) — a lease under which the tenant pays taxes, insurance and maintenance on top of base rent.
• Pool — a group of expenses shared by a group of leases over one denominator. A building usually has several: CAM, taxes, insurance, utilities — and a mixed-use building has one per use as well.
• Pro-rata share — the tenant's fraction of a pool, normally their leased area divided by the denominator the lease names (the whole building, or the leased area, or a fixed percentage).
• Gross-up — restating the variable expenses to what they would have been at a standard occupancy (often 95%), so a tenant in a half-empty building is not charged half the janitorial bill.
• Base year (and expense stop) — on a modified-gross lease, the tenant pays only the amount by which a pool's costs exceed a reference year (or a fixed dollar amount, the stop).
• Cap — a ceiling on how much the tenant's controllable expenses may rise in a year. Three kinds exist and they give three different numbers.
• Administrative fee — a percentage the landlord adds on top of the tenant's share. It is landlord revenue, not an expense, and it often excludes taxes and insurance.
• True-up — the year-end balance: what is still owed, or what is credited back.
• Recovery ratio — the share of what the landlord spent that came back from tenants. The gap is the money the landlord absorbed, and it always has causes.

How the calculation goes — and why the order matters

The reconciliation is a sequence, and the sequence is fixed. Swapping two of these steps produces a different number, which is the first thing to understand about why spreadsheets go wrong.

1. Import and classify. Every line of the year's expense ledger is placed against a category — landscaping, real estate tax, management fee — by the label the accountant gave it.
2. Recoverable or not. Some costs never pass through: capital improvements, leasing commissions, the landlord's own financing. They are set aside before anything is shared.
3. Assign to pools. Each recoverable category goes into its pool.
4. Gross up the variable costs only. Never taxes, never insurance, never the fixed service contracts.
5. Per lease, in this order: the pro-rata share; the lease's exclusions; the gross share; the base-year or stop deduction; the cap; the administrative fee; the proration for a tenant who was not there all year.
6. Compare with the estimates billed.
7. The true-up: balance due, or credit.
8. The check.

Everything below is one of those steps, explained. To see the whole sequence run on one small building with every figure shown, the worked example takes four tenants from the ledger to their balances.

Pools, and why the split decides the price

The most consequential decision in a reconciliation is made before any arithmetic: how many pools the building has. It looks like bookkeeping. It is money.

IREM's teaching example runs the same building both ways. With one pool, a tenant whose base year was $11.00 per square foot and whose current year is $11.50 owes $0.50. With four pools — CAM, utilities, insurance, taxes — the same totals give:

Pool	Base year	This year	Tenant owes
CAM	$5.00	$4.00	$0 — a fall earns no credit
Utilities	$2.00	$1.75	$0
Insurance	$1.50	$1.75	$0.25
Taxes	$2.50	$4.00	$1.50
Total	$11.00	$11.50	$1.75

$0.50 against $1.75 — three and a half times more, on identical building totals. The reason is in the next section: under a base year, a pool that falls below its base pays nothing and never offsets a pool that rose. So the number of pools is not a convention to copy from the last building. It is a structure of this building, chosen once, and a reconciliation tool that quietly created four pools because four is usual would have decided, silently, that every tenant owes three and a half times more.

Gross-up: variable costs only, at the standard occupancy

A building that was 70% occupied all year had 70% of the janitorial and 70% of the trash — but the tenants who were there would each pay only their share of that reduced bill, and the landlord would absorb the rest. The gross-up clause corrects for it: the variable expenses are restated to what they would have been at a standard occupancy, usually 95% or 100%.

The multiplier is the standard occupancy divided by the actual:

Actual occupancy 70%, standard 95% → multiplier 95 / 70 = 1.357. Variable costs of $100,000 are restated to $135,700.

Three things the clause does not do, and each is a common error:

• It never touches fixed costs. Property taxes, insurance and most monthly service contracts cost the same whether the building is full or empty. Grossing them up bills tenants for money nobody spent.
• It is per lease, not per building. IREM is explicit: grossing up one tenant's pool does not mean every tenant's pool is grossed up. Two tenants in the same building can face two different pools for the same year, because one lease has the clause and the other does not.
• It never runs downward. A building at 98% occupancy with a 95% standard is not grossed down.

Occupancy is measured month by month and averaged — a suite leased in September counts for four months, not for a year. The gross-up piece works through IREM's month-by-month example and the three errors in full.

Base years and expense stops: pool by pool, and never below zero

On a modified-gross lease the landlord carries the first year's costs and the tenant pays only the increase. The reference is either a base year (the actual costs of a named year) or an expense stop (a fixed dollar amount per square foot).

Three rules, and the lease forms state all three:

1. The deduction is pool by pool. Each pool has its own base amount. The lease language is typically: each Expense Category is treated separately.
2. A pool that falls pays zero — not a credit. If Operating Expenses, Insurance Expenses, Utility Expenses or Taxes decrease below the base amount respectively, tenant's proportionate share for such year shall be $0, and the tenant is not entitled to a credit against anything else. This is the mechanism behind the $0.50-versus-$1.75 table above.
3. The deduction is made at the building level, before the pro-rata share. Actual costs, less the base year's costs, then multiplied by the tenant's share. That matters when a tenant's share changed during the year — an expansion, a contraction — because the two orders give different answers.

Caps: three kinds, three numbers

A cap limits how much the tenant's controllable expenses may rise from one year to the next. Controllable usually excludes taxes, insurance, utilities and — often — the management fee; the cap is applied to the controllable pool at the building level, and the uncontrollable costs are added back in before the share is taken.

There are three kinds, and the vocabulary is not standardized — one source's "cumulative" is another's "compounded". Never trust the name; trust the number.

Kind	Year 3 ceiling on a $48,000 base at 5%	Formula
Non-cumulative	$50,400	base × 1.05, against last year's actual
Cumulative	$55,200	base × (1 + 0.05 × 3)
Cumulative compounding	$55,566	base × 1.05³

The published worked examples agree with the compounding formula to the dollar — 5% in year 2 gives 110.25%, in year 4 gives 121.55%; 4% in year 5 gives 116.98%. A statement should show the computed ceiling next to the kind, so the lease administrator recognises their lease by the figure and not by the label.

One question the trade leaves to the lease: whether the cap is applied before the base-year deduction or after. There is no convention. It is a parameter of the lease, and it changes the result whenever a base year is involved.

Administrative fees: revenue on top, never in the pool

The landlord may add an administrative fee — typically 10% to 15% — on top of the tenant's share. Two things about it decide whether a statement is right.

It is landlord revenue, not an expense. It is added on top of the tenant's share, after everything else. Folded into the pool it does something worse than overcharge: it makes the reconciliation balance on a wrong total, because every tenant's share now includes a slice of a cost nobody incurred, and the check adds up anyway. This is the classic silent error of the trade.

Its base is a lease term. Most leases exclude taxes and insurance from the base — and the administrative fee is not the management fee, which is a cost inside the pool (the two, taken apart). Whether the fee is calculated on the expenses as incurred or on the grossed-up figure is a second question the lease answers — a 4% fee on $1.0 million as incurred is $40,000; on a grossed-up $1.1 million it is $44,000, and one of those is a percentage of money that was never spent.

Proration: by the day

A tenant who moved in on March 15 owes March 15 onward. The share is prorated by the days of the lease that fall in the reconciliation year — not by a fraction typed by hand, and not by whole months unless the lease says so. A suite that was vacant is not billed to anybody; its share of the pool is what the landlord absorbs, and it is named as vacancy on the recovery report.

The check: the one equation that proves a statement

Here is the test that makes a reconciliation checkable by somebody who does not do this for a living:

Σ every tenant's share (before administrative fees) + what the landlord absorbed (vacancy, exclusions, stops, caps, rounding) = the recoverable pool (what was actually spent)

It has to balance to the cent. If it does not, something was counted twice or not at all, and the year cannot be closed until it is found.

The trade has a name for the second line: slippage. IREM's course puts it plainly — a building that is 100% leased should recover 100% of operating expenses; where tenants have caps and exclusions it will not, and it is important to understand where the slippage is coming from. Document adjustments. A reconciliation that produces one unexplained total is not finished. One that names every dollar the landlord did not recover — this much to vacancy, this much to a cap on suite 100, this much to a lease that excludes marketing — is.

The check has one condition that is easy to break: the administrative fee must be outside it. Put the fee in the pool and the equation still balances, on the wrong number.

The statement the tenant receives

The reconciliation is not the spreadsheet. It is the statement that lands on a tenant's desk, is read on paper, is often photocopied, and is the basis on which their lease administrator decides whether to contest it. What that reader looks for:

• The pool totals, and which categories are in each.
• The tenant's share as a fraction — area over denominator — and the denominator itself.
• Every adjustment with its cause and its figure: the gross-up multiplier, the base-year deduction, the cap and its ceiling, the exclusions.
• The administrative fee shown separately, with its base.
• The estimates billed, and the balance.
• Where the supporting detail is: the invoices behind each pool.

A statement that shows a share and a total and cannot show the invoices behind them is the spreadsheet they were already sent.

The five mistakes that let a wrong statement balance

1. The administrative fee inside the pool. The check balances; every tenant is overcharged.
2. Gross-up applied to the whole column, taxes and insurance included.
3. The wrong kind of cap — cumulative read as non-cumulative, or compounding read as simple. The three ceilings differ by thousands.
4. One base year for the whole building instead of one per pool, so a pool that fell offsets one that rose and the tenant is undercharged — the landlord's loss, and silent.
5. A hand-typed proration fraction for a tenant who moved in mid-year.

Every one of these produces a statement that adds up. That is why the check is not enough on its own: it proves the arithmetic is consistent with the rules applied, not that the rules applied are the lease's.

Tenant audits and disputes

Most commercial leases give the tenant a right to audit the reconciliation, usually within a window of 60 to 180 days after the statement. A large tenant's lease administrator will exercise it as a matter of routine. What they ask for is always the same: what is actually in this pool? — the invoices, the classification, the denominator, the cap arithmetic.

A dispute handled well is a conversation on the record: the tenant's challenge, the manager's answer, and the statement beside both. (How to answer a CAM dispute, and what an audit asks for.) A dispute handled badly is a corrected statement quietly replacing the one that was sent. Never correct a statement that went out; issue a new version, and keep both — the tenant is entitled to the document their invoice was based on.

The calendar, and a checklist

Reconciliation season is the first quarter. Before you start:

• The year's ledger is closed and exported, with the format you export it in written down (separators, decimal mark, date format).
• Every ledger label has a category, and every category has a pool.
• Occupancy is recorded month by month.
• Every lease's clauses are entered: share basis, exclusions, gross-up standard, base year or stop per pool, cap kind and rate, administrative fee rate and base.
• Last year's frozen statements are at hand, for the year-on-year comparison.

Then run the year, read the check, name the slippage, review every statement, freeze the year, send. If you are doing it in a workbook, the free template runs the whole sequence above and checks itself — and says on its first sheet what it cannot do.

Spreadsheet or software

A workbook can do all of the above. What it cannot do is refuse: it will balance on whatever it is given, apply one cap formula to three kinds of cap, gross up a column that includes taxes, and copy last year's proration fraction into this year. CAM reconciliation software exists to make the order fixed, the check mandatory, and every adjustment named — and to remember the building so that next year is an import and a run rather than sixty hours.

ChargeRecoveries is built on exactly that: the eight steps in their order, the check that gates freezing, and a statement per tenant that shows its work. Open the demo — no sign-up — and watch it run on a real building's year.

Frequently asked questions

What is the difference between CAM reconciliation and a CAM audit? The reconciliation is the landlord's year-end calculation and statement. The audit is the tenant's right to verify it, usually within a window the lease sets.

When is CAM reconciliation due? Most leases require the statement within 90 to 120 days of year end — the first quarter. The lease is the authority.

Is gross-up applied to property taxes? No. Gross-up applies to expenses that vary with occupancy — janitorial, utilities, trash, sometimes management fees. Taxes and insurance are fixed and are never restated.

Can a tenant get a credit if expenses fall below the base year? Under the standard forms, no. A pool that falls below its base amount pays zero for that pool; there is no credit against the other pools or against rent.

Is the administrative fee part of operating expenses? No. It is landlord revenue added on top of the tenant's share, and it must be kept outside the pool or the reconciliation balances on a wrong total.