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.
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