MRI Commercial Management CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in MRI Commercial Management.
CAM Module
Recovery Billing / Expense Recovery Module
Module Navigation
In MRI Commercial Management, navigate to Lease Administration > Recovery Billing. Select the property and recovery group. The Recovery Billing module handles pool setup, estimate generation, and year-end reconciliation. For configuration, go to System Administration > Recovery Setup.
Recovery Pool Configuration
MRI uses 'Recovery Groups' to define expense pools. Under Recovery Setup > Recovery Groups, create groups for each CAM category (Operating, Tax, Insurance). Within each group, assign GL account ranges that feed into the pool. Set the recovery method per group: pro-rata share, direct bill, or metered. MRI's 'Expense Participation' settings control gross-up rules — configure the occupancy threshold and which expense types are eligible.
Charge Code Setup
Under Lease Administration > Charge Code Setup, create charge codes linked to recovery groups. Each charge code defines: billing frequency, recovery group association, estimate calculation method (prior year, budget, or fixed), and the tenant's proportionate share basis (rentable SF, usable SF, or custom). MRI's 'Share Type' field is critical — it determines whether the tenant pays on building-level or floor-level pro-rata share.
Export Procedure for CapVeri
Go to Reports > Financial > General Ledger Detail Report. Filter by property, date range, and account range for CAM expenses. Export as CSV or Excel. For reconciliation-specific output, use Reports > Recovery > Recovery Reconciliation Report, which shows estimated vs. actual by tenant. Export to Excel for CapVeri import.
Common Mistakes to Avoid
Misconfiguring the 'Share Type' field — building-level vs. floor-level pro-rata produces materially different tenant shares
Not linking new GL accounts to the correct recovery group after chart of accounts changes
Setting the gross-up occupancy threshold incorrectly in Expense Participation settings
Forgetting to run the 'Actual Expense Update' process before generating reconciliation statements
Using the wrong fiscal year calendar in recovery group setup for properties with non-calendar fiscal years
Not excluding below-grade or storage areas from the rentable area used in pro-rata calculations
How MRI Commercial Management Works with CapVeri
Export the GL Detail Report as CSV with property, account, description, and amount columns. Upload to CapVeri — MRI's standard export format is auto-detected. For multi-entity portfolios, ensure the property identifier column is included so CapVeri can separate property-level expenses.
About MRI Commercial Management
MRI Commercial Management is the second most popular CRE ERP after Yardi. Its Recovery Billing module is robust but uses different terminology than Yardi (recovery groups vs. recovery pools, share types vs. allocation methods). Firms migrating between MRI and Yardi frequently encounter reconciliation differences due to these naming and configuration differences.
Related Resources
Validate Your MRI Commercial Management Exports
Export your GL data from MRI Commercial Management 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