If you manage commercial property, you know what CAM season looks like. Five tabs of an aging spreadsheet. A box of invoices on your desk. A calculator with the percentages rubbed off the keys. Three coffees deep, and you still haven't figured out why Suite 204's number doesn't tie out.
The math behind Common Area Maintenance reconciliation isn't actually hard. The problem is the way most landlords end up doing it — by hand, once a year, from a frozen snapshot of expenses that may or may not include everything. Let's walk through what it should look like.
What CAM actually is
CAM is the bucket of expenses you incur running a property that don't belong to any one tenant — landscaping, snow removal, common-area lighting, building insurance, property taxes (in some lease types), management fees, and so on. Under a triple-net (NNN) lease, those costs pass through to tenants in proportion to how much of the building they occupy. The landlord doesn't profit from CAM; it's reimbursement.
The standard structure: throughout the year, tenants pay an estimated monthly CAM charge (the "additional rent"). At year-end, you total what you actually spent, calculate each tenant's pro-rata share, and reconcile against what they paid. Some tenants owe you. Some get a credit.
The math, simply
The basic formula for any single tenant's CAM share in a given year is:
The first two factors are straightforward — you know your CAM total, and you know each tenant's square footage. The third one is where most spreadsheets quietly break.
Why mid-year handoffs trip everyone up
Suite 204 was occupied by Tenant A from January through June, then sat vacant for July, then leased to Tenant B from August through December. Tenant A's share is 5/12 of the unit's full-year CAM share. Tenant B's is 5/12. The remaining 2/12? That's a landlord cost — vacancy means the landlord covers their own CAM during the gap.
Spreadsheets miss this. The typical mistake is assigning all of Suite 204's CAM to whoever the current tenant is, or splitting 50/50 because both tenants occupied the suite for "half" the year (ignoring the vacancy month). Either way, somebody gets billed wrong.
Where the actual pain comes from
CAM math itself isn't difficult. The pain comes from four operational issues:
- Expense capture is incomplete. The roof repair from August got coded to "Property A" but actually belongs to "Property B." The insurance bill was paid in December but covers the calendar year — does it count for this year's CAM or next? Without a discipline of tagging every expense as you go, you'll be reconstructing six months of receipts from memory.
- Estimated CAM doesn't match collected CAM. Tenant A's lease says their estimated CAM is $1,200/month. They paid that for 12 months — but did they? Did they short-pay in March? Did you remember to add the partial payment for May? Your reconciliation needs to compare to actual cash collected, not to what should have been billed.
- Mid-year rent changes. A rent escalation hit in July. Did the estimated CAM increase too? If you renegotiated a lease mid-year and changed the CAM structure, your spreadsheet has to model both periods separately. Most don't.
- Producing the statements. Even after you've computed the right numbers, you still have to package each tenant's result as a defensible statement — what they paid, what they owed, the math you used, and any backup detail they ask for. This is where landlords lose another two days.
What a tool actually does
The reason CAM reconciliation feels hard isn't the math. It's that the math depends on data your tools weren't designed to keep clean. The expense ledger lives in one place, the rent ledger in another, the leases in a third, and you reconcile by copying numbers between them.
What changes when you have a system designed around the calculation:
- Every expense is tagged to a property and a date at the moment you enter it. No retro-coding in December.
- Every payment is logged against a specific tenant and month. Partial payments and back-rent stay attached to their period, so the reconciliation knows exactly what was collected when.
- Each lease carries its own start/end dates, its own CAM structure, and its own pro-rata share. Mid-year handoffs are just two leases on the same unit.
- Reconciliation is a button. Pick a property, pick a year, get a statement per tenant with the math shown.
None of that is magic — it's just discipline applied at the right moment (data entry) instead of the wrong one (year-end). The reason it feels magical is the time you get back.
The customer-facing piece
One often-overlooked detail: how the reconciliation gets to the tenant. The statement is a tenant-facing artifact. They're going to read it, question line items, and — if they owe you money — write a check or argue. A clean PDF with the math broken out reduces disputes by about half. A spreadsheet screenshot or a Word doc with manually typed numbers invites them.
This is one of the small things that compounds. The tenant who got a clean reconciliation statement last year doesn't push back this year. The tenant who got a confusing one wants a meeting.
See what reconciliation should look like.
RentRoll auto-generates year-end CAM statements — pro-rated by sqft, lease dates, and actual collections. Free 14-day trial, no card required.
Start free →The bottom line
CAM reconciliation isn't conceptually hard. It's operationally brutal because the input data lives across three or four tools and you only consolidate it once a year. The fix isn't to do the math better. It's to capture the data at the moment it happens, so the year-end calculation is a derivation rather than a reconstruction.
The landlords who run this well don't have a CAM season. They have a CAM week.