How to Export CAM Data from MRI Software
Quick Answer
To export CAM data from MRI Software, pull four reports: Recovery Reconciliation (Commercial > Recovery > Reconciliation), GL Transaction Detail (General Ledger > Reports > Transaction Detail), Rent Roll (Commercial > Reporting > Rent Roll), and Tenant Billing History (Commercial > AR > Billing History). MRI exports directly to CSV or Excel from the report viewer. This guide walks through each export with navigation paths, filter settings, and preparation tips.
MRI Software (formerly MRI Real Estate) is widely used by institutional owners, REITs, and large management companies. Its recovery module is powerful but has a steeper learning curve than Yardi's. The good news: once you know which reports to pull and how to configure them, the exports are clean and well-structured.
This guide covers MRI Commercial (the on-premise and hosted versions). If you are using MRI X (the newer cloud platform), the navigation differs slightly but the report names and data structures are the same.
Before You Start
Required Permissions
MRI uses role-based security with granular report access. You need:
| Export | Required Permission | MRI Menu Path |
|---|---|---|
| Recovery Reconciliation | Recovery Module access | Commercial > Recovery |
| GL Transaction Detail | General Ledger Reporter | General Ledger > Reports |
| Rent Roll | Commercial Reporting | Commercial > Reporting |
| Tenant Billing History | Accounts Receivable Viewer | Commercial > AR |
If a menu path is grayed out, your user profile lacks the required permission group. Contact your MRI administrator.
Version Notes
This guide applies to MRI Commercial versions 11.x and 12.x, and MRI X. Navigation paths use the standard MRI menu structure. Organizations that use MRI's configurable menu system may have different menu labels — the report names remain the same.
Export 1: Recovery Reconciliation Report
The Recovery Reconciliation report is MRI's equivalent of the CAM reconciliation statement. It calculates each tenant's share of actual expenses, compares it to what was billed as estimates, and produces the over/under billing amount.
Navigate to Recovery Reconciliation
Go to Commercial > Recovery > Reconciliation. In MRI X, this may be under Recovery Management > Reconciliation.
Select the entity and property
Choose the legal entity (if your MRI instance uses multi-entity structure) and the property. MRI uses entity-property hierarchy — make sure you select the correct entity first.
Set the reconciliation period
Enter the Period From and Period To dates. For annual CAM reconciliation, this is January through December of the reconciliation year. MRI uses period numbers (1-12) rather than calendar dates — Period 1 is January, Period 12 is December.
Select recovery pools
MRI calls these Recovery Types. Select the types you want to reconcile: CAM, Real Estate Tax, Insurance, Management Fee, or All. Each recovery type pulls from a defined set of GL accounts configured in the recovery setup.
Choose the report format
Select Detail to see individual expense accounts within each recovery type. The Summary format shows only pool totals, which is insufficient for reconciliation analysis.
Run the report
Click Run Report or Execute. MRI generates the report in its report viewer.
Export to CSV or Excel
In the report viewer toolbar, click the Export icon. Select CSV for a flat file or Excel for a formatted workbook. CSV is preferred for import into CapVeri or other analysis tools.
Key columns in the export:
| Column | Description |
|---|---|
| Tenant ID | MRI's internal tenant code |
| Tenant Name | Tenant display name |
| Suite | Unit/suite identifier |
| Recovery Type | CAM, Tax, Insurance, etc. |
| Account Number | GL account within the recovery pool |
| Account Description | Expense category name |
| Actual Expense | Total spent (from GL postings) |
| Tenant Share % | Pro-rata share percentage |
| Tenant Expense Share | Tenant's allocated portion |
| Estimated Billed | Amount billed as estimates during the year |
| Over/(Under) | Variance — positive means tenant owes more |
Common Issues with MRI Recovery Exports
Issue: Recovery types show different GL account mappings than expected. MRI's recovery setup is configured per property. If you recently added expense accounts to the chart of accounts, they may not be mapped to a recovery type yet. Check the mapping at Commercial > Recovery > Setup > Account Mapping.
Issue: Partial-year tenants show incorrect pro-rata shares. MRI prorates tenant shares based on occupancy days. If a tenant moved in on March 15, their share is calculated for 292 days (March 15 to December 31), not the full year. This is correct behavior, but verify that the proration method matches the lease (some leases prorate by months, not days).
Issue: Report does not include gross-up adjustment. MRI applies gross-up only if it is configured in the recovery setup for each recovery type. Go to Commercial > Recovery > Setup and verify that the gross-up threshold and occupancy method are set for each applicable pool. If gross-up is not configured, MRI reconciles against actual (non-grossed-up) expenses.
Export 2: General Ledger Transaction Detail
The GL Transaction Detail gives you every individual posting to your operating expense accounts — the line-by-line backup behind the recovery reconciliation totals.
Navigate to GL Transaction Detail
Go to General Ledger > Reports > Transaction Detail. In MRI X: General Ledger > Reporting > Transaction Detail.
Set the entity, property, and period
Select the entity and property. Set the period range to 1-12 (full year). MRI also allows date-range filtering — use January 1 through December 31 of the reconciliation year.
Set the account range
Enter the beginning and ending account numbers for your operating expense accounts. If your chart of accounts follows MRI's default structure, operating expenses typically fall in the 6000-6999 or 5000-5999 range. If you are unsure, pull all accounts and filter afterward.
Select transaction types
Include all transaction types: AP (accounts payable), JE (journal entries), AR (accounts receivable adjustments). Excluding any type creates gaps in your GL detail that auditors will question.
Choose sort order
Sort by Account Number for reconciliation work. This groups all transactions by expense category, making it easy to tie back to recovery pool totals.
Run and export
Execute the report and export to CSV or Excel. For properties with high transaction volumes (10,000+ entries), the report may take 1-2 minutes to generate. The CSV export is faster than Excel for large datasets.
Key columns:
| Column | Description |
|---|---|
| Account | GL account number |
| Account Name | Account description |
| Period | Posting period (1-12) |
| Date | Transaction date |
| Source | Transaction type (AP, JE, AR) |
| Reference | Invoice or JE number |
| Description | Transaction description / vendor name |
| Debit | Debit amount |
| Credit | Credit amount |
Tips for Clean MRI GL Exports
- Include period 13 and 14 adjustments. MRI supports adjustment periods (periods 13 and 14) for year-end accruals and audit adjustments. If your accounting team posts to these periods, include them in your export — they contain legitimate reconciliation-year expenses.
- Watch for intercompany entries. Multi-entity MRI instances may have intercompany transactions that cross properties. These should be excluded from CAM pools unless they represent genuine shared operating expenses.
- Verify the beginning balance. The first entry for each account should be the opening balance. If it does not match the prior year's closing balance, there may be mid-year account restructuring or data migration issues to resolve.
Export 3: Rent Roll
The Rent Roll provides tenant square footage, lease terms, and the denominator for pro-rata share calculations.
Navigate to Rent Roll
Go to Commercial > Reporting > Rent Roll. In MRI X: Lease Management > Reports > Rent Roll.
Select property and date
Choose the property and set the As Of date to December 31 of the reconciliation year. For weighted average occupancy calculations, also pull a January 1 snapshot.
Include expired leases
Check the option to Include Expired/Terminated Leases within the reporting period. Tenants who vacated during the year still owe their prorated share of actual expenses and must appear in the reconciliation.
Select columns
Ensure the export includes: Suite, Tenant Name, Tenant ID, Rentable SF, Usable SF (if available), Lease Start Date, Lease End Date, and Monthly Base Rent.
Run and export
Execute and export to CSV.
Required columns for CapVeri import:
| Column | Required? | Notes |
|---|---|---|
| Suite | Yes | Space identifier |
| Tenant Name | Yes | Current occupant |
| Tenant ID | Recommended | For matching against recovery and billing exports |
| Rentable SF | Yes | Square footage per lease |
| Lease Start | Yes | Commencement date |
| Lease End | Yes | Expiration date |
| Monthly Rent | Recommended | For revenue analysis |
Export 4: Tenant Billing History
The Billing History shows what was actually invoiced to each tenant as estimate charges during the reconciliation year. This is the counterpart to the Recovery Reconciliation's "Estimated Billed" column — it gives you the invoice-level detail.
Navigate to Billing History
Go to Commercial > AR > Billing History (or Accounts Receivable > Reports > Billing History).
Set filters
Select the property, set the date range to the reconciliation year, and filter to recovery-related charge codes. MRI charge codes vary by organization — common codes include CAM, TAX, INS, and MGMT.
Select detail level
Choose Transaction Detail to see individual invoice lines. The summary view only shows monthly totals, which is insufficient for reconciling against estimates.
Export
Run and export to CSV.
This export is not required for CapVeri import but is valuable for two purposes:
- Estimate verification — Confirm that estimate billings match the amounts in the Recovery Reconciliation. Discrepancies indicate billing errors or mid-year estimate adjustments that were not captured.
- Audit defense — When a tenant questions their estimate charges, the billing history is the backup documentation. Include it in your audit records package.
MRI-Specific Reconciliation Considerations
Recovery Pool Configuration
MRI's recovery module is configured at the property level. Each recovery type (CAM, Tax, Insurance) has its own:
- GL account mapping — which accounts feed the pool
- Allocation method — pro-rata by SF, pro-rata by percentage, fixed dollar amount
- Gross-up settings — threshold, occupancy method, variable/fixed classification
- Cap settings — cumulative vs non-cumulative, base year, annual limit
Before running the reconciliation, review the recovery setup at Commercial > Recovery > Setup. Changes made during the year (adding a GL account to a pool, changing a gross-up threshold) affect the reconciliation output and should be documented.
Multi-Entity Considerations
Many MRI instances use a multi-entity structure where the legal owner, the management company, and the property each have separate entity codes. Operating expenses may be posted to the management entity, the ownership entity, or the property entity depending on your accounting workflow.
When exporting GL data, make sure you are pulling from the entity where operating expenses are booked. If your management company posts expenses to its own entity and then allocates them to properties via intercompany entries, you need the property-level allocated amounts — not the management company's gross postings.
MRI X Migration Notes
If your organization recently migrated from MRI Commercial to MRI X, verify that recovery configurations carried over correctly. Common migration issues include:
- Recovery type mappings that reference old GL account numbers
- Gross-up thresholds that reset to default values
- Historical billing data that did not migrate to the new billing module
Run a side-by-side comparison of the Recovery Reconciliation output from both systems for at least one property to confirm consistency.
Preparing MRI Exports for CapVeri Import
CapVeri's MRI parser recognizes standard MRI report formats. For the smoothest import:
- Use CSV format. MRI's CSV exports are well-structured — headers in row 1, data starting in row 2, no embedded subtotals or page breaks.
- Export one property per file. Multi-property exports work but are harder to validate.
- Include the Tenant ID column. CapVeri uses Tenant ID (not tenant name) to match records across the rent roll, recovery, and billing exports. Tenant names may have slight variations; the ID is unique.
- Do not manually edit the exports. MRI's CSV formatting is consistent. Manual edits (merging cells, adding custom columns) can break the parser. If you need to add notes, do it in a separate file.
- Verify period coverage. Confirm that the GL export includes all 12 periods (plus period 13/14 adjustments if applicable). Missing periods mean missing expenses.
For a general overview of export workflows across property management systems, see the export guide.
Related Resources
- How to Export from Yardi, MRI, AppFolio & RealPage — Overview of all PM system exports
- How to Export CAM Data from Yardi Voyager — Detailed Yardi export guide
- GL Coding Guide — Best practices for expense account structure
- Recovery Ratio Analysis — Measuring recovery performance across properties
Import Your MRI Data in Minutes
Export your Recovery Reconciliation, GL Detail, and Rent Roll from MRI. Upload to CapVeri for automated reconciliation verification, expense classification, and variance analysis. No manual mapping required.
Start Free AuditFrequently Asked Questions
What MRI reports do I need for CAM reconciliation?
You need four reports from MRI Commercial: (1) the Recovery Reconciliation report showing actual vs estimated recovery amounts per tenant; (2) the General Ledger Transaction Detail report filtered to recoverable expense accounts; (3) the Rent Roll report for tenant square footage and lease terms; and (4) the Tenant Billing History for what was actually invoiced as estimates during the year. The first three are essential; the fourth is important for audit defense.
Can MRI export directly to CSV?
Yes. MRI's report viewer includes a direct CSV export option. When viewing any report, click the export icon and select CSV or Excel format. MRI's CSV exports are generally cleaner than other PM systems — column headers are consistent and data rows do not include embedded subtotals. For the GL Transaction Detail report, use the Excel export if you need to preserve account hierarchy groupings.