Skip to content
CamProof › CAM reconciliation template (Excel)

CAM reconciliation template (Excel)

Download the free Excel template — expenses, tenants, pro-rata shares, admin fee, estimates and balance with live formulas. When the property outgrows a spreadsheet, the calculator above does caps, gross-ups, stops and statements.

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

How it works

  1. Download the free Excel template (.xlsx, no macros) and fill in the yellow cells.
  2. Or drop your ledger here: CamProof reads QuickBooks, Yardi, AppFolio and Buildium exports so you don't retype expenses.
  3. Send statements — one page per tenant with the math shown, printable or saved as PDF.

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

What does the Excel template include?

An Expenses sheet (account, pool, amount), a Tenants sheet that computes each tenant's pro-rata share, CAM, tax and insurance charges, a 10% admin fee on CAM, estimates paid and balance, and an Instructions sheet. It handles the basic case; base years, expense stops, caps, gross-ups and partial-year tenants are easier in the calculator.

Is the template really free?

Yes. No signup, no email, no macros.

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