CAM & recovery
CAM reconciliation and pro-rata share calculator
Run a CAM reconciliation from the expense pool to one tenant’s true-up, with the gross-up, pro-rata shares and three cap mechanics, on your own figures.
November 24, 2026 · 7 min
Blog
Blog
Working notes on CAM reconciliation, NNN recoveries and commercial lease administration.
Explainers on CAM reconciliation, NNN expense recovery and commercial lease administration — written for owners and property managers who run recoveries against books kept in QuickBooks Online.
Most of it is mechanics rather than opinion: how a pro-rata share is derived, what a cap or a base year does to the arithmetic, where gross-ups come from, and how certificates and escalation dates end up driving the work. If you want to run the numbers, the CAM calculator does the arithmetic in your browser, and the reconciliation checklist is the step-by-step. Unfamiliar wording is in the glossary. If you are evaluating tools, start with CAM reconciliation software or how the accounting integration works.
CAM & recovery
CAM reconciliation spreadsheet template: where it breaks
The eight tabs a CAM reconciliation workbook needs, the formulas in words, the checks that catch errors, and the five points where it stops working.
November 17, 2026 · 11 min
CAM & recovery
When a tenant disputes a CAM charge: how to respond
How a landlord’s accountant answers a tenant’s CAM dispute or audit request: the clause, the documents to send, the usual findings, and fixing a real error.
November 6, 2026 · 12 min
CAM & recovery
Recoverable vs. non-recoverable expenses: the list
The CAM exclusions list: what is usually recoverable, what is usually excluded, the gray areas argued every year with the test for each, and a worked example.
November 3, 2026 · 14 min
CAM & recovery
CAM caps: cumulative, non-cumulative and compounding
What a CAM cap limits, the three cap mechanics worked through five years on one tenant, how carry-forward and ordering change the bill, and what to record.
October 30, 2026 · 14 min
CAM & recovery
Gross-up clauses, explained with the arithmetic
What a gross-up clause does, which expenses it covers, the formula with a worked example, the base-year trap, and how to show it on the statement.
October 27, 2026 · 11 min
CAM & recovery
The CAM reconciliation checklist
A dated, numbered CAM reconciliation checklist from December accruals to statements sent, with what goes wrong at each step and the evidence to keep.
October 23, 2026 · 11 min
CAM & recovery
Base year and expense stop are not the same thing
Two clauses that look interchangeable and are not. What each one fixes, how each behaves as expenses rise, and why the distinction shows up in year three.
July 9, 2026 · 4 min
CAM & recovery
What a CAM reconciliation actually involves
A walk through the CAM reconciliation from expense pool to tenant statement, with a worked example and the three cap mechanics compared.
June 18, 2026 · 8 min