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.
Troubleshooting Common MRI Commercial Management Issues
How does MRI Share Type affect CAM calculations?
MRI's Share Type field determines whether a tenant's pro-rata share is calculated against building-level or floor-level total rentable area. Building-level uses total building RSF as denominator; floor-level uses only the RSF for the floor where the tenant is located. If a tenant has dedicated floor access (e.g., a single-tenant floor in a multi-tenant building), floor-level is usually correct. Wrong share type causes systematic over- or under-billing for every affected tenant.
Why is my MRI recovery billing producing wrong tenant shares?
Check three things in order: (1) Share Type — building vs. floor level. (2) Expense Participation settings for the recovery group — verify the gross-up threshold and which expense types are eligible. (3) Recovery group GL account assignments — confirm all operating expense accounts are mapped and no mid-year additions are missing. The 'Actual Expense Update' process must also be run before generating reconciliation statements.
How do I fix gross-up errors in MRI recovery billing?
MRI gross-up is controlled in Recovery Setup → Recovery Groups → Expense Participation tab. Verify: (1) the occupancy threshold matches lease terms (typically 90–95%), (2) only variable expense types are eligible for gross-up (not fixed expenses like property taxes and insurance), and (3) the economic occupancy calculation method is selected. After changing settings, re-run the Actual Expense Update and regenerate reconciliation statements.
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 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 Trial