CAM Reconciliation Software Buyer's Guide for Commercial Landlords
Joe Leach
CAM Reconciliation Software Buyer's Guide for CRE Landlords
14:00
By: Joe Leach, Founder & CEO, Elysium
The short answer
To choose CAM reconciliation software, test it on the leases that are hardest to bill: ones with amended caps, tenant-specific exclusions, base-year resets and unusual pro-rata shares. Score each option on five things. Can you click from every recovery rule to the clause that created it? Does it apply later amendments in order? Does it handle cumulative and non-cumulative caps, gross-ups and exclusions at the tenant level? Can it compare those rules to what was actually billed? Does it read your documents where they already live, and leave a record of who checked what?
A tool that only tells you a lease "has a 5% CAM cap" won't catch much. The leakage usually sits in how that cap works over time and how the amendments changed it.
What is CAM reconciliation?
CAM reconciliation is the annual true-up between what tenants paid in estimated common area maintenance and operating expense charges during the year and what they actually owe under their leases. The landlord totals the actual expenses, removes anything the lease excludes, applies caps, gross-ups and base-year or expense-stop math, works out each tenant's pro-rata share, and then bills or credits the difference.
The landlord and the tenant look at the same exercise from opposite sides. For a landlord, a reconciliation that's too conservative leaves recoverable expense on the table every year. One that's too aggressive invites tenant audits, credits and disputes. Many leases give tenants a window after the statement to audit the landlord's books, and some shift the audit cost to the landlord if the overcharge passes a set threshold.
In an acquisition the question changes again. The buyer is underwriting recoveries it didn't calculate, built on lease logic it hasn't read yet, and usually inherits the true-up for the year in progress at closing. If the seller's reconciliations have been applying the wrong cap or missing an amendment, that gap goes straight into the buyer's NOI and basis. We wrote about this in more detail in OpEx pass-through leakage in CRE acquisitions.
Where does CAM leakage hide?
In my experience it rarely sits in one clause. It shows up where the original lease, the amendments and the accounting setup disagree. These are the places I'd check first.
Caps: cumulative vs non-cumulative. With a non-cumulative cap, any room the landlord doesn't use in a year is gone. With a cumulative cap, unused room carries forward, and a compounded cap grows on itself each year. The difference is real money in a year when expenses jump after a quiet year.
Amendment overwrites. An amendment can rewrite the cap method or revoke an exclusion years after the original lease was abstracted. In our NOI traps example, a 2022 amendment replaced "non-cumulative" with "cumulative and compounded" and revoked a snow removal exclusion. If billing still runs off the 2018 terms, both are wrong.
Controllable vs uncontrollable expenses. Most caps only apply to controllable expenses. Taxes, insurance, utilities and sometimes snow removal are often carved out. When an amendment moves an item from one bucket to the other and the system isn't updated, the cap gets applied to the wrong pool.
Exclusions applied at the wrong level. Exclusions are negotiated tenant by tenant. A common mistake is applying one tenant's exclusions to the whole building, or applying building-level exclusions to a tenant who never negotiated them. Typical items include capital expenditures (or the rules for amortizing them), leasing costs, management fees above a set percentage and specialized services that should be billed directly.
Base-year resets and expense stops. Renewals and expansions often reset the base year for the new term or the new space. If the reset isn't picked up, the tenant gets billed against the wrong base, and that mistake repeats every year after.
Pro-rata share and gross-up. The share depends on the denominator: leasable area, leased area, or a pool that excludes certain tenants. Remeasurements and anchor carve-outs change it. Gross-up clauses that adjust variable expenses to an assumed occupancy level can be missing from the calculation, or applied to the wrong expenses.
Admin and management fees. Whether the fee is a percentage of CAM, whether it applies to taxes and insurance, and whether it sits inside or outside the cap are all lease-specific.
Vendor contracts that outpace recoveries. Janitorial, waste, HVAC and security contracts often carry escalators or minimums. If a contract rises faster than the lease lets the landlord recover, the difference becomes a recurring unrecoverable cost.
An illustrative example of a cap mismatch
This example is illustrative and isn't customer data.
A tenant leases 50,000 square feet. Controllable CAM in the base year is $8.00 per square foot, with a 5% cap. Year 2 comes in at $8.16 (a 2% increase), and year 3 jumps to $8.81 (an 8% increase).
| Cap method | Year 3 cap | Year 3 recoverable | Year 3 at 50,000 sf |
|---|---|---|---|
| Non-cumulative (5% over prior year) | $8.57/sf | $8.57/sf | $428,400 |
| Cumulative, compounded (5% per year from base) | $8.82/sf | $8.81/sf | $440,500 |
If an amendment changed this lease to cumulative and compounded and the reconciliation still uses the non-cumulative method, the landlord under-bills about $12,100 for this one tenant in this one year. If the change went the other way, the tenant is overbilled by the same amount and has a good audit claim. Multiply that across a rent roll and a hold period and it shows up in valuation.
Which approach do I need?
| Approach | What it is | Good fit | Watch-outs |
|---|---|---|---|
| Spreadsheets and manual review | Analysts read leases and build the rec in Excel | Small portfolios; simple NNN leases | Slow; hard to audit; depends on who built the file |
| Property management system CAM modules | Recovery setup inside your accounting or PMS | Running the annual rec once terms are set up | Only as good as the setup; amendments often not re-keyed |
| CAM reconciliation and audit services | Firms that review CAM and pass-through charges against the leases | A one-off audit or a disputed rec | Scope and turnaround per engagement; findings often don't feed back into your systems |
| CRE document/data engine (for example Elysium) | AI that reads leases, amendments and vendor contracts together and turns recovery terms into structured rules | Acquisition diligence; checking recovery setup across a portfolio | Confirm how your ledger and PMS data get in; confirm security |
| General chatbot | Upload a lease and ask questions | A quick read of one clause | No audit trail; weak on multi-document lease files |
These approaches often work together. A PMS still runs the billing, and a service firm may still sign off on a disputed year. What changes with a document engine is that the recovery rules in your system get checked against the full lease file, amendments included, before the rec goes out or before you close.
What should I evaluate? (scorecard)
| Criterion | Question to ask | Why it matters |
|---|---|---|
| Source traceability | Can I click any recovery rule and see the page and clause? | You'll need to defend it to a tenant, auditor or IC |
| Lease and amendment coverage | Does it read the lease, all amendments, exhibits and side letters together? | Amendments overwrite caps and exclusions |
| Amendment order | Show me a cap changed by a later amendment. | The latest controlling language has to win |
| Cap logic | Does it handle cumulative, non-cumulative and compounded caps? | Each method gives a different recoverable number |
| Exclusions and buckets | Are exclusions and controllable items tracked per tenant? | Building-wide rules cause over- and under-billing |
| Base year and pro-rata | Does it catch base-year resets, share changes and gross-ups? | One missed reset repeats every year |
| Ledger comparison | Can it compare lease rules to actual expenses and billed amounts? | That's where the leakage gets quantified |
| Vendor contracts | Does it read service contracts and their escalators? | Contracts can outpace what the lease recovers |
| Integrations | Can it read from Google Drive, Dropbox, SharePoint, Box and Egnyte? | No re-uploading data rooms or rebuilding folders |
| Output | Excel, CSV or JSON you can load into your PMS or model? | Avoids re-keying |
| Audit trail | Who validated each rule, and when? | Gives you a record for disputes and IC |
| Security | Where is data stored? Is it used for training? What access controls exist? | Get the answers in writing |
| Pricing | Per property, per seat or per document? | Acquisitions come in bursts, so fixed seats can be a poor fit |
Elysium reads leases, amendments, exhibits, vendor agreements and rent rolls as one document set. It reconstructs the logic behind recovery terms, such as cap method, cumulative math and commencement triggers, and every extracted value links back to the document, page and section it came from. Each field carries a confidence score, and reviewers can validate it with a timestamp. When a new amendment arrives, Elysium reconciles it against what's already there. You can also bring in a CAM or expense export from your property system (for example a Yardi export) and compare those billed amounts and expense lines to the recovery rules in the leases, without needing a live Yardi sync (solutions).
Elysium connects to Google Drive, Dropbox, SharePoint, Box and Egnyte, and exports to Excel, CSV, JSON, PDF or DOCX (integrations). Pricing is consumption-based, priced per document.
How do I run a fair pilot?
- Pick one property or a set of 10 to 20 tenants, and include your worst files: amended caps, renewals with base-year resets, expansions, anchor carve-outs and medical or specialty tenants.
- Use a reconciliation year you've already closed, so you have a known answer. Build a hand-checked answer key for each tenant's cap method, exclusions, base year, pro-rata share and gross-up.
- Add three or four trap scenarios, such as a cap rewritten by an amendment, a revoked exclusion, a base-year reset on renewal and a vendor contract with an escalator above the cap.
- Point every option at the same folder as it is today, without cleaning it up first. Elysium organizes documents inside Elysium and leaves your folders untouched (auto-organize post).
- Score rule accuracy, trap detection, the dollar variance each option finds against your closed rec, time to reviewed output, and how many clicks it takes to verify a rule.
What does it cost, and how much time does it save?
Most vendors quote on request, and audit services often price per engagement or as a share of recoveries. Elysium is priced per document, so you pay for what you run through it.
On time, the ROI calculator on our solutions page uses an 85% time reduction observed across Elysium deployments. The calculator labels its estimates as illustrative.
For a real example, Saber-Hightower used Elysium to review 150+ leases and amendments on a portfolio acquisition in under 4 hours, compared with 40 to 50 hours by hand, and got its LOI out in a day (Saber-Hightower case study). On a medical office acquisition, ABJNY reconciled about 200 leases, amendments and service contracts against recovery rules in under 12 hours (ABJNY case study).
FAQ
What software automates CAM reconciliation for commercial landlords?
Property management systems run the annual reconciliation once recovery terms are set up. CRE document engines like Elysium automate the part that usually breaks: reading every lease and amendment, turning caps, exclusions, base years and pro-rata shares into structured rules, and linking each one back to the clause.
How can I audit CAM charges against lease terms automatically?
Extract each tenant's recovery rules from the full lease file, amendments included, then compare them to the expenses and amounts actually billed. Look for a tool that shows the source clause for every rule, so each variance can be checked and defended.
How do I find operating-expense pass-through leakage in a CRE acquisition?
Write down the recovery assumptions in your underwriting first. Then rebuild the recovery logic for major tenants across the lease, amendments and vendor contracts, test it against the seller's historical reconciliations, and put a dollar figure on each mismatch before closing.
What's the difference between a cumulative and a non-cumulative CAM cap?
With a non-cumulative cap, unused room in a year is lost. With a cumulative cap, unused room carries forward, and a compounded cap also grows on the prior year's cap, so the recoverable amount can be noticeably higher after a quiet year.
Can I use ChatGPT to audit CAM charges?
For reading one clause, often yes. For a rent roll's worth of leases and amendments, you need amendment order, tenant-level rules and an audit trail, which a chat window doesn't give you (paper trail post).
Do I need to reorganize our document folders first?
Not with Elysium. Connect the folders as they are and Elysium sorts them by tenant or property inside Elysium. Your originals keep their names and locations.
Check your own recoveries
If you'd like us to run one property's leases and amendments through Elysium, and compare those recovery rules to a CAM or expense export from how you bill today, reach out here and we'll set it up. Your files can stay in Google Drive, Dropbox, SharePoint, Box or Egnyte.
Joe Leach
Founder & CEO
Elysium
www.elysium-cre.com
