Portfolio-Level CAM Reconciliation Workflow
20–50 buildings, one Q1 — the capacity math never works without automation
Mid-market PMCs managing 20–50 commercial buildings face a capacity problem during Q1 reconciliation season. Each building requires 20–40 hours of reconciliation work. At 30 buildings, that's 600–1,200 hours of Q1 work for a team that typically has 3–5 property controllers. The only way to manage it is process standardization and automation.
Step-by-Step Process (5 steps)
Portfolio Planning and Prioritization
December–JanuaryInventory 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.
Common errors at this step:
- • No pre-season planning — responding to pressure rather than prioritizing systematically
- • Underestimating building complexity — buildings with 10 net-lease tenants each with unique cap structures take 3x longer than a simple building
Standardize GL Export Format
JanuaryExport 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.
Common errors at this step:
- • Different export formats from different buildings or software versions causing rework
- • Export includes prior-year corrections that need to be separated from current-year actuals
Batch Validation
January–FebruaryRun 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.
Common errors at this step:
- • Starting reconciliation on individual buildings before doing a portfolio-level sanity check
- • Treating each building in isolation — systematic errors often appear across multiple buildings at once
Parallel Processing
January–MarchProcess 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.
Common errors at this step:
- • Sequential processing — waiting for one building to finish before starting the next
- • No handoff protocol when a controller gets blocked — one stuck building delays the whole queue
Portfolio-Level Variance Review
February–MarchBefore 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.
Common errors at this step:
- • Reviewing each building in isolation without comparing to portfolio norms
- • Not investigating when a building's recovery ratio is significantly above or below peer buildings
Timeline
Portfolio reconciliation: January 1 – March 31 for most portfolios. Buildings with tenant audit rights requirements may need to start earlier. Buildings with SB 1103 exposure (California) need audit-ready documentation from day one.
Where CapVeri Fits
CapVeri enables batch processing — upload all buildings' exports at once. Every building gets the same independent validation. Portfolio-level variance reports flag outliers automatically. Controllers review and approve instead of calculate from scratch. The math that took 6 weeks now takes 1–2 weeks of focused review.
Related Resources
Free Tools for This Workflow
Automate the Most Error-Prone Steps
Export your GL data and upload to CapVeri. Independent recalculation of every tenant's reconciliation — with errors flagged before statements go out. First audit is always free.
Start Free Audit