CAM Reconciliation Excel Template (Free Download)
An Excel spreadsheet with all CAM reconciliation formulas pre-built — pro-rata share, gross-up, cumulative and non-cumulative cap tracking, and true-up calculation.
Last updated: March 2026
Who This Is For
Property accountants who want Excel-based reconciliation with professional formulas and don't yet use dedicated reconciliation software.
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
- Input sheet: building info, occupancy, gross-up threshold
- GL expense import tab (paste from any ERP export)
- Expense categorization and exclusion worksheet
- Gross-up calculation formula tab
- Tenant roster with lease terms (SF, cap %, denominator)
- Per-tenant CAM calculation worksheet
- Summary tab: true-up amounts by tenant
- Prior year comparison for cap validation
Key Features
Frequently Asked Questions
What formulas are included in the CAM reconciliation Excel template?
The template includes pre-built formulas for: pro-rata share calculation (tenant SF ÷ denominator SF), gross-up (variable expenses ÷ actual occupancy % × threshold %), cumulative CAM cap with carry-forward logic, non-cumulative cap ceiling calculation, and true-up (annual obligation − estimated payments received).
How many tenants does the Excel template support?
The standard template supports up to 20 tenants. Each tenant has a row in the tenant roster tab with their leased SF, denominator definition, gross-up threshold, and cap percentage. For larger portfolios, CapVeri's software handles unlimited tenants from a single GL import.
Can I calculate CAM reconciliation in Excel?
Yes. Excel is the most common tool for CAM reconciliation at small to mid-size portfolios. The main risks are formula errors (especially in gross-up and cap calculations) and manual data entry mistakes from copying GL data. CapVeri's automated reconciliation eliminates these risks by importing GL data directly.
Need lease data before you reconcile?
lextract.io abstracts commercial leases into 126 structured fields in minutes — CAM definitions, pro-rata share, caps, base year, and more. No manual data entry.
Go to lextract.ioSkip 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 Trial