Skip to content
CamProof › CAM reconciliation calculator

CAM reconciliation calculator

Enter the year's operating expenses and your tenants' lease terms; get each tenant's share, the balance due or credit, and a statement you can send. Nothing is uploaded.

🔒 Ledger & leases never leave your browser📒 QuickBooks · Yardi · AppFolio · Excel🧾 Statements that show the math🆓 Free, no signup

How it works

  1. Enter the property — rentable area, period, occupancy and gross-up target.
  2. Add expenses by hand or drop your QuickBooks or property-management export, then put each account in CAM, Taxes, Insurance or Exclude.
  3. Add tenants with RSF, lease dates, estimates paid and any base year, stop or cap — then print the statements.

Why CamProof

For owners, bookkeepers and small property managers who reconcile CAM, taxes and insurance once a year — and would rather not rebuild the spreadsheet every time.

Starts from your books

Drop a QuickBooks Profit and Loss or transaction detail, or a Yardi, AppFolio or Buildium export. Map each account to a pool once; CamProof remembers it next year.

Real lease mechanics

Pro-rata by GLA, occupied area or fixed %, partial years by day, gross-up of variable costs, base years, expense stops, three kinds of caps, admin fees inside or outside the cap.

Statements tenants accept

One page per tenant with every step of the calculation, the building's expense detail, the balance or credit and the new monthly estimate. Print or save as PDF.

Catches mistakes first

Warnings for missing GLA, tenant areas larger than the building, shares over 100%, credits from reversed signs, caps without a basis and leases outside the period.

Landlord summary

See where every dollar went: billed, absorbed by vacancy, lost to base years and caps, and earned in admin fees — your recovery rate per pool.

Private by design

Rent rolls and ledgers are processed in your browser tab. No account, no upload, no connection to your accounting system. Save the project as a file you keep.

FAQ

How is a tenant's CAM share calculated?

Usually the tenant's rentable square feet divided by the building's rentable (or leasable) area, times the recoverable pool, prorated for the days the lease was in effect during the year. Then the lease's base year or expense stop, caps and admin fee are applied, and the estimates the tenant already paid are subtracted.

What's the difference between the free and Pro plans?

The full calculation, warnings and landlord summary are free for any number of tenants. Statements and exports are free for properties with up to 3 tenants; Pro unlocks them for every tenant.

Is my data uploaded?

No. Your ledger, tenants and lease terms are read and calculated by JavaScript running in your browser tab, and saved only in this browser (or in a project file you download). There's no account and no server copy.

What is a CAM reconciliation?

After the year ends, the landlord compares each tenant's actual share of common area maintenance (and, in NNN leases, taxes and insurance) with the monthly estimates the tenant paid, then bills the shortfall or credits the overpayment.

Which accounting exports work?

QuickBooks Online and Desktop Profit and Loss, General Ledger and Transaction Detail by Account reports, plus Yardi, AppFolio, Buildium, Rent Manager or any CSV/Excel file with account and amount columns. You can also type expenses in.

Does it replace reading the lease?

No. CamProof applies the terms you enter — shares, base years, stops, caps, gross-ups and fees — in the order most leases use. Your lease governs; review each statement before you send it.

What's free?

The full reconciliation on screen for any number of tenants, the landlord summary and all warnings, plus statements, CSV and Excel exports for properties with up to 3 tenants. Pro unlocks statements and exports for every tenant.

More CAM reconciliation tools & guides