Free CAM reconciliation template and review spreadsheet

What the CAM reconciliation template includes

The workbook is designed for commercial tenants, bookkeepers, accountants, and tenant advisors who need a structured first pass. It keeps the landlord statement, lease rules, calculations, missing support, and status notes in one traceable file.

• Review sheet with 30 editable expense lines
• Formula-driven billed, allowed, and difference totals
• Lease Rules worksheet with clause and page references
• Drop-down fields for treatment, support, and review status
• Document checklist and deadline-first instructions

1. Start with the deadline and governing documents

Record when the reconciliation was received, the number of days allowed to object, the required notice method, and whether payment is required while a dispute is reviewed. Use the signed lease and every amendment rather than relying on a summary or proposal.

2. Enter the landlord statement

For each category, enter the property-level expense, tenant share, and tenant amount billed. The template includes common categories such as taxes, insurance, utilities, maintenance, management fees, administration fees, capital items, and reserves.

3. Apply the lease rule and calculate the comparison

Use the Lease Rules worksheet to record the exact clause, page, exclusion, cap, share, or amortization method. Enter the property amount allowed after applying that rule. The workbook calculates the corresponding tenant charge and the difference to investigate.

4. Turn differences into document requests

A positive difference is not automatically a refund. It is a prompt to request the ledger, invoice, allocation schedule, gross-up worksheet, capital schedule, or fee calculation needed to resolve the item.

• Property general ledger and chart of accounts
• Tenant allocation and occupancy schedule
• Gross-up calculation
• Tax, insurance, and major invoice support
• Capital project and amortization schedule
• Administration and management fee calculation