Free Tool: Template

Free CAM Reconciliation Template

Download our Excel worksheet to verify your year-end CAM reconciliation math and catch landlord overcharges before the dispute window closes.

Why this matters: Year-end CAM reconciliation statements contain the final overcharge: the difference between what your landlord estimated and what they actually spent. Errors in the pro-rata denominator, excluded expense categories, and management fee caps compound here. This template makes those errors visible in minutes.

CAM Reconciliation Audit Template

Free Excel template · No account required

A structured spreadsheet for verifying year-end CAM reconciliation statements. Enter your lease figures, actual expenses, and estimated payments to see where your landlord's math diverges from what your lease allows.

Year-end CAM reconciliation worksheet
Pro-rata share verification tab
Management fee cap tracker
CAM cap (non-cumulative and cumulative) checker
Variance and dispute notes column
Pre-built formulas for all standard calculations

Get the free Excel template

Frequently Asked Questions

What is a CAM reconciliation template?

A CAM reconciliation template is a spreadsheet that helps commercial tenants verify the math on their year-end CAM reconciliation statements. It organizes actual vs. estimated expenses, calculates the correct pro-rata share, checks management fee caps, and flags the variance between what you paid and what you owe.

How do I use a CAM reconciliation template?

Enter your lease pro-rata share percentage, total actual CAM expenses from your landlord's reconciliation, your estimated payments made during the year, and any applicable CAM caps. The template calculates your correct charge, compares it to the landlord's billed amount, and highlights any discrepancy, which you can then investigate or dispute.