Portfolio-Level CAM Reconciliation Workflow

Inventory all buildings by reconciliation complexity: number of tenants, lease structure diversity (net vs. base year), cap type distribution, buildings with prior-year disputes. Assign processing order: simple buildings first to establish cadence, complex buildings with dedicated attention.

Export GL data from all buildings in a consistent format. For Yardi or MRI portfolios, standardize the export template across all properties. Document any buildings that use different software or export formats. They require separate handling.

Run all buildings through a validation process before individual reconciliation work begins. Check for obvious errors: negative expense categories, missing GL accounts, expense totals that deviate significantly from prior year without explanation.

Process buildings in parallel across the team. Each controller handles their assigned buildings with the standardized methodology. Establish a daily check-in to surface blockers (missing lease amendments, GL discrepancies, tenant contact needed) before they delay the whole portfolio.

Before finalizing statements, review portfolio-level variance: recovery ratios across comparable buildings, year-over-year expense trends, gross-up adjustment percentages. Outliers warrant a second review. They may indicate errors or they may be legitimate.