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.
Troubleshooting Common Yardi Voyager Commercial Issues
Why is my Yardi recovery pool not calculating correctly?
The most common causes: (1) Occupancy Type set to Physical instead of Economic in Recovery Pool Setup — change to Economic for weighted-average gross-up. (2) Fixed expenses flagged as Variable, causing incorrect gross-up. (3) GL accounts added mid-year not mapped to the recovery pool. (4) Wrong gross-up threshold — pool set to 90% but lease specifies 95%. Check Recovery Pool Setup → Calculation tab for each of these settings.
Why does my Yardi GL export not balance to my financial statements?
GL export balance issues have five common causes: wrong date range (accrual cutoff vs. fiscal year end), excluded account ranges in your export filter, accrual vs. cash basis mismatch between the export and financial statements, intercompany elimination entries included at entity level, or closed-period adjusting entries not captured. Compare your export total to the trial balance for the same period to identify the gap.
What is the difference between a Yardi charge code and recovery code?
Charge codes control how Yardi generates tenant billing invoices — they define billing frequency, amount, and GL revenue account. Recovery codes link tenants to specific recovery pools and determine which expense pool drives their CAM calculation. A tenant needs both: the recovery code to pull expenses from the right pool, and the charge code to invoice them. Confusing them causes expenses to flow to the wrong pool or tenants to be billed from incorrect data.
How do I fix a CAM calculation error in Yardi Voyager?
Start at the recovery pool configuration (Recovery Pool Setup → Calculation tab) and work outward: verify expense GL account assignments, gross-up settings, and occupancy type. Then check charge code settings and their link to the recovery pool. Check tenant lease setup for correct pro-rata denominator and square footage. Finally, look for any manual overrides at the tenant billing level. Errors in the pool propagate to all tenants; tenant-level errors affect only that tenant.
Related Resources
Need lease data before you reconcile?
lextract.io abstracts commercial leases into 126 structured fields in minutes — CAM definitions, pro-rata share, caps, base year, and more. No manual data entry.
Go to lextract.ioValidate 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 Trial