Statement figures
The link carries these eight figures in the part of the URL after the #, which browsers never send to a server. Whoever you send it to — a landlord, a tenant, a broker, your accountant — opens this worksheet already filled in and can change any input to test their own version of the number.
Transparent result
A positive variance means the modeled share is higher than net billed. A negative variance means net billed is higher. This is arithmetic, not a conclusion about what the lease allows.
Review checklist
Use these prompts to compare the statement with your records. They do not replace professional review.
Use it safely
Everything runs locally. We count only anonymous feature events in local storage, never people, content, IPs, or cookies. A share link is the one thing that carries your figures off this device: they ride in the part of the URL after the #, which browsers never send to any server, but anyone holding the link can read them — so treat it exactly like the downloaded worksheet.
No warranty. This tool is provided free and as-is, without warranty of any kind, express or implied. It is not legal, tax, financial, or real-estate advice, and it does not replace a qualified professional. You are responsible for reviewing and verifying its output before relying on it, and for meeting any obligation it helps prepare for. To the maximum extent permitted by law, the authors accept no liability for any loss or damage arising from its use.
Reconciling processor payouts against the bank feed instead of a landlord's CAM bill? The payment reconciliation workbench matches Stripe, Square, or PayPal payouts to bank deposits by amount and date and lists what does not match — nothing uploaded.
Free and open source. If it caught a CAM reconciliation variance before you signed off, the code is under an MIT licence — support is entirely optional and never changes what the tool does.
Common questions
How is the tenant's area share calculated?
Tenant square footage divided by the building's total rentable area. On the defaults — a 1,000 sq ft suite in a 10,000 sq ft building — that is 10.00%. This is the pro-rata share most CAM clauses use, but some leases fix a share by exhibit instead of by current measured area; check the lease's own definition before treating the ratio as automatic.
What does “modeled tenant share” mean, and how is it different from the billed amount?
Modeled tenant share is annual CAM expenses multiplied by the area share — on the defaults, $120,000 × 10.00% = $12,000. The billed amount is whatever the landlord's statement actually charged, net of credits: $10,000 − $500 = $9,500 net billed. The variance ($12,000 − $9,500 = $2,500) is the arithmetic gap between what the area ratio alone would produce and what the statement actually asked for — it is a starting point for review, not proof of an error.
What does a positive variance mean, and what does a negative one mean?
A positive variance (modeled share above net billed, as in the $2,500 default) means the area-ratio math produces a bigger number than what was billed — worth checking that exclusions, caps, or a different pro-rata method in the lease account for the gap before assuming an undercharge. A negative variance means net billed is above the modeled share, which is the direction worth checking for an overcharge, an estimate true-up, or a category that should not have been included at all.
What is a CAM gross-up, and when should I use it?
A gross-up clause lets a landlord adjust the occupancy-sensitive share of CAM expenses (utilities, janitorial — the costs that track how many suites are occupied, not fixed costs like a management fee) up to what they would have cost at a stated target occupancy, usually 95%, when the building actually ran below that. Leave the gross-up fields blank unless your lease has this clause; entering the variable expense share and the actual and target occupancy percentages adds the adjustment to the modeled expenses before the area share is applied, and the worksheet shows the dollar amount added so it can be checked against the lease's own clause.
What should I actually check before disputing a CAM bill?
Three things in order: that the expense total and the statement cover the same lease year, that rentable and tenant area match the lease's own definitions (not just the current rent roll), and that every category on the statement is one the lease actually allows to be passed through. This tool only checks the arithmetic between those inputs — it does not read the lease and cannot tell you whether a category belongs on the bill.
Does this replace a lawyer, accountant, or property manager?
No. It is a private arithmetic worksheet for spotting a variance worth asking about. Whether that variance is allowed, owed, or worth disputing depends on the lease's own reconciliation clause, which only a qualified reviewer of the actual document can answer.
Is my lease or expense data uploaded anywhere?
No account and no network requests — the calculation runs in your browser and the downloaded worksheet and JSON record save straight to your device. Anonymous feature counts are local-only, optional, and the checkbox above turns them off.
Can I send this reconciliation to the landlord, the tenant, or my accountant?
Yes — “Copy a link to this reconciliation” produces a URL that reopens this page with all eight figures already entered, so the other side can change the rentable area, the expense total, or the gross-up target to whatever their own records say and watch the variance move. That is usually the more useful thing to send than a fixed worksheet, because a reconciliation argument is about the inputs. The figures travel in the part of the URL after the #, which browsers never transmit to a server, but they are readable by anyone the link reaches; share it the same way you would share the statement itself.
How much CAM do you owe based on square footage? — a worked table across six suite sizes in the same building.
This worksheet vs. reconciling CAM by square footage alone — why a gross-up clause can add thousands a year that area share alone misses.
This calculator vs. Yardi Voyager CAM reconciliation — when a free five-field worksheet is the right tool and when a full property-management platform is.
This calculator vs. AppFolio CAM reconciliation — when a free five-field worksheet is the right tool and when a configured property-management platform is.