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.
Accounting
Can you run a CAM reconciliation in QuickBooks Online?
What a QuickBooks Online company file can do for a CAM reconciliation, what it has no place for, the workarounds people try, and a division of labor.
November 20, 2026 · 11 min
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
Comparisons
AppFolio vs. Yardi Breeze: commercial CAM reconciliation
What AppFolio and Yardi Breeze publish about commercial CAM reconciliation, what moving the books off QuickBooks Online means, and a decision table by case.
November 13, 2026 · 11 min
Comparisons
Stratafolio alternatives for owners on QuickBooks Online
Six tools to shortlist instead of Stratafolio, what each is built around, what each does with the QuickBooks Online books, and when Stratafolio is still right.
November 10, 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
Accounting
A QuickBooks Online setup for CAM recovery
How to structure a QuickBooks Online company file so the CAM reconciliation can be pulled from it: entities, classes and locations, and the chart of accounts.
October 20, 2026 · 12 min
Leases
What Is COI Tracking in Commercial Real Estate?
How commercial property managers track certificates of insurance, monitor expiration dates, and keep tenant and vendor documentation organized and current.
August 24, 2026 · 4 min