Yardi Voyager Commercial CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in Yardi Voyager Commercial.
CAM Module
Recovery Reconciliation / CAM Reconciliation Module
Module Navigation
Navigate to Commercial > Recovery > Recovery Reconciliation. Select the property, fiscal year, and recovery pool. From the Recovery Reconciliation screen you can review estimated vs. actual expenses, tenant share calculations, and generate reconciliation statements.
Recovery Pool Configuration
Recovery pools define which expense GL accounts are included in each CAM category. Set up under Commercial > Setup > Recovery Pool Setup. Each pool needs: expense accounts, recovery type (pro-rata, direct, metered), and gross-up rules. Use the 'Expense Account Assignment' tab to map GL accounts to pools. Variable vs. fixed classification is set per account — this drives gross-up eligibility.
Charge Code Setup
Charge codes map to tenant billing. Under Setup > Charge Codes, define codes for each recoverable expense category (CAM, Tax, Insurance). Link charge codes to recovery pools for automated billing. Each charge code has a billing frequency (monthly/quarterly/annual) and a recovery method. Ensure the charge code's 'Recovery Pool' field matches the pool you configured.
Export Procedure for CapVeri
Run Recovery Reconciliation Report: Commercial > Reports > Recovery > Reconciliation Statement. Export to Excel via the Export button. For CapVeri import, export the GL Detail Report filtered by recovery pool expense accounts as CSV. Path: Reports > Financial > GL Detail, set date range to fiscal year, filter by CAM expense account range (e.g., 5000–5999), and click Export > CSV.
Common Mistakes to Avoid
Applying gross-up to the entire recovery pool instead of only variable expense categories
Not updating the recovery pool when new expense GL accounts are added mid-year
Misconfigured tenant square footage in lease setup causing pro-rata share errors
Running reconciliation before all year-end accrual entries are posted
Using 'Recovery Code' instead of 'Charge Code' — they serve different purposes in Voyager
Forgetting to set the occupancy gross-up threshold (defaults to 100%, effectively disabling gross-up)
Not excluding capital expenditure GL accounts from the operating expense recovery pool
How Yardi Voyager Commercial Works with CapVeri
Export your GL Detail Report as CSV filtered by CAM expense accounts. Upload directly to CapVeri — no API connection needed. CapVeri reads Yardi's standard CSV export format natively, mapping GL account numbers, descriptions, and amounts automatically. For multi-property portfolios, export one CSV per property or use the consolidated export with the property column included.
About Yardi Voyager Commercial
Yardi Voyager is the most common ERP among mid-market PMCs (20–50 properties). The Recovery Reconciliation module is powerful but complex — most errors stem from pool configuration, not the math engine itself. Voyager's reconciliation engine handles pro-rata, direct allocation, and metered recovery types. The system can auto-generate tenant reconciliation statements, but many firms export and reformat in Excel before sending to tenants.
Related Resources
Validate Your Yardi Voyager Commercial Exports
Export your GL data from Yardi Voyager Commercial as CSV. Upload to CapVeri for automated CAM reconciliation validation — catch gross-up errors, cap violations, and allocation mistakes before tenants find them.
Start Free Audit