CAM reconciliation software

What CAM reconciliation software is for

A CAM reconciliation compares what tenants paid in estimates against what the property actually spent, and bills or credits the difference. The subtraction is trivial. The work is everything before it: deciding which expenses are recoverable, grossing up the variable ones to a stated occupancy, splitting the pool into recovery groups, allocating by each lease’s share, and then applying that lease’s base year and cap in the order its language requires.

CAM reconciliation software exists to hold those decisions between years. The recovery groups, the exclusions, the gross-up policy, the cap mechanics and the shares are stable; only the year’s expenses are new. A system that stores the stable part turns an annual rebuild into an annual run.

The same machinery covers NNN reconciliations, operating-expense escalations over a base year, and expense-stop structures. The terminology differs by region and lease form; the arithmetic does not.

Where the spreadsheet stops working

A workbook is a perfectly reasonable tool for a small portfolio with uniform leases. It stops being reasonable at a predictable set of thresholds:

• Cumulative caps. Once a cap carries unused room forward, this year’s ceiling depends on every prior year’s billed amount. The workbook now has a memory, and the memory is a tab somebody has to not break.
• Non-uniform recovery terms. Different base years, different exclusion lists and different gross-up provisions across leases turn one calculation into one calculation per lease.
• Mid-year lease changes. An expansion, an assignment or an early termination changes the denominator part-way through the year.
• A disputed figure eighteen months later. The workbook holds the answer. It rarely holds the reasoning, and by then the file has been copied forward twice.
• Somebody leaving. The single most common trigger for replacing a spreadsheet is that the person who understood it is gone.

If you are searching for a CAM reconciliation spreadsheet template, the honest answer is that a template solves the first reconciliation and none of the ones after it. What makes the fifth year hard is not the layout; it is that the fifth year depends on the four before it.

What to evaluate

Seven questions separate products that genuinely do this from products that list it as a feature:

• Does it read actual expenses from your accounting system, or do you re-key them? Re-keying is the error source the whole exercise is meant to remove, and which accounts are eligible at all is a question about exclusions before it is a question about software.
• Can it hold your cap mechanic exactly? Simple, compounded, on the prior year’s actual, cumulative with carry-forward — ask which it supports, not whether it supports caps. The four cap mechanics compared sets out what each one does to the bill.
• Does gross-up apply per expense, or to the whole pool? Grossing up fixed costs inflates the pool and is a common cause of a disputed statement — see the gross-up clause explained.
• Can one lease cover several units? A tenant expanding next door does not sign a second lease, and a system that assumes otherwise distorts every share.
• Does the statement show its math? A statement that shows only the total is a number you will have to defend from memory.
• What happens to a locked year? Re-opening a prior year changes every cumulative cap after it. The system should know that.
• Is recovery included in the price you were quoted? On tiered platforms, reconciliation is commonly a mid-tier capability, so the advertised entry price is often not the price for this workflow.

How Ledgerstone approaches it

Ledgerstone keeps QuickBooks Online as the accounting system of record and puts the commercial-lease logic around it. Expenses are read from the books rather than retyped; each lease’s terms are entered once and kept with the lease; the reconciliation applies them and shows the math behind every figure; and the finished recovery is posted back to QuickBooks Online as the billing, so nobody re-keys it. Tenants open the statement online, see how their share was reached, and pay the balance.

It is deliberately narrow. If you need work orders, investor reporting or a general ledger of its own, a broader platform will suit you better, and the comparison page says so plainly.

Read further

• What a CAM reconciliation actually involves — the full sequence with a worked example and the three cap mechanics compared.
• Base year versus expense stop — the two structures that set the floor.
• CAM reconciliation with QuickBooks Online — what the integration does and does not do.
• The CAM calculator — run a pool, a share and a cap against your own numbers.
• The glossary — the terms a lease uses for all of this, defined.