CAM Reconciliation for Property Controllers
The person who actually runs the math — and gets blamed when it's wrong
What Keeps You Up at Night
Manually reconciling 20–40 buildings in Q1 using spreadsheets inherited from predecessors
Yardi or MRI configurations that don't match current lease terms — found only when tenants dispute
Gross-up calculations applied to fixed expenses that shouldn't be grossed up
Cap calculations that reset incorrectly after lease renewals
GL accounts added mid-year that never got mapped to recovery pools
Your Typical Reconciliation Workflow
January: pull year-end GL export from Yardi or MRI. Load into Excel. Manually reconcile each tenant's estimated payments against actuals. Apply gross-up per lease. Check caps. Generate statements. Send. Repeat for every building. Duration: 6–10 weeks.
Time Spent on CAM
Property controllers at mid-market PMCs (20–50 buildings) report spending 40–60% of Q1 on CAM reconciliation tasks.
Common Errors in Your Role
Gross-up applied to fixed expenses (property taxes, insurance) — should only apply to variable costs
Wrong occupancy threshold used for gross-up (lease says 95%, ERP configured at 90%)
Non-cumulative cap applied when lease specifies cumulative — compounds into significant overcharge over time
Pro-rata denominator not updated after tenant move-outs or new construction
GL coding errors not caught until tenant auditor finds them 2 years later
How CapVeri Helps
Upload your ERP export. CapVeri recalculates every tenant's reconciliation from scratch — independently of your ERP's configuration — and flags every discrepancy with the specific lease clause it violates. Catches the errors before statements go out instead of after tenant auditors find them.
Time Savings
Property controllers report reducing CAM reconciliation time by 60–75% per building. For a 30-building portfolio: from 6–8 weeks of manual work to 1–2 weeks of review and approval.
Resources for Property Controllers
Free Tools for Property Controllers
See What CapVeri Finds in Your Reconciliations
Export your GL data from Yardi, MRI, or any ERP. Upload to CapVeri for independent verification of every calculation — the same errors tenant auditors look for, caught before statements go out. First audit is always free.
Start Free Audit