CAM Reconciliation Statement Template
The standard template for the annual reconciliation statement sent to tenants. Covers the full reconciliation from GL expenses to per-tenant true-up amounts.
Last updated: March 2026
Who This Is For
Property controllers and landlords sending annual reconciliation statements to NNN and modified gross tenants.
Get This Template
Enter your data and generate a formatted reconciliation statement instantly. No signup required.
Use Online GeneratorPre-formatted Excel file ready to populate with your property data.
Download TemplateWhat's Included
- Reconciliation period header (property, tenant, lease reference)
- Recoverable expense summary by GL category
- Non-recoverable exclusion detail with lease section references
- Gross-up calculation (fixed vs. variable split)
- Pro-rata share calculation with denominator definition
- CAM cap comparison (prior year vs. current)
- Estimated payments received summary
- True-up balance due or credit
Key Features
Frequently Asked Questions
What should a CAM reconciliation statement template include?
A complete CAM reconciliation statement template includes: a header with property name, tenant name, lease reference, and reconciliation period; a recoverable expense summary with GL codes and exclusions; a gross-up calculation section; a pro-rata share calculation; a CAM cap comparison; estimated payment summary; and the final true-up balance.
Can I use this template with data from Yardi or MRI?
Yes. Export your GL report as a CSV or Excel from Yardi, MRI, AppFolio, or any ERP, then paste the expense totals into the template. CapVeri's online reconciliation generator also accepts GL exports directly for fully automated calculation.
Is this template compliant with SB 1103 in California?
The template includes an SB 1103 compliant layout for California commercial leases, with expense line item disclosure format and required allocation basis documentation for small business tenants.
Related Tools
Skip the Template — Automate the Whole Reconciliation
Import your GL export from Yardi or MRI. CapVeri calculates pro-rata share, gross-up, and caps automatically — and flags the errors your current process misses.
Start Free Audit