How to Export CAM Reconciliation Data from Yardi Voyager
Quick Answer
To export CAM data from Yardi Voyager, you need three reports: Recovery Analysis (Commercial > Recovery > Recovery Analysis), GL Detail (Accounting > General Ledger Analytics), and Rent Roll (Leasing > Reports > Rent Roll with Lease Charges). Export each to Excel using the toolbar icon, then save as CSV. This guide covers the exact navigation paths, field selections, and common pitfalls for each export.
Yardi Voyager stores everything you need for CAM reconciliation, but getting the data out in a usable format requires knowing which reports to pull and how to configure them. This guide covers the three core exports — Recovery Analysis, GL Detail, and Rent Roll — plus two supplementary exports that are useful for audit defense and variance analysis.
Before You Start
Required Permissions
You need the following Yardi Voyager security roles to access these reports:
| Export | Required Role | Menu Path |
|---|---|---|
| Recovery Analysis | Commercial Recovery Analyst or Property Accountant | Commercial > Recovery |
| GL Detail | General Ledger Viewer or Accountant | Accounting > General Ledger |
| Rent Roll | Leasing Analyst or Property Manager | Leasing > Reports |
| Charge Schedule | Commercial Recovery Analyst | Commercial > Recovery |
If you cannot access a report, contact your Yardi administrator to verify your security profile. The exact role names vary by organization — some shops rename the default Yardi roles.
Version Notes
This guide is based on Yardi Voyager 7.S (the current cloud release as of early 2026). Navigation paths are consistent across Voyager 7.S builds, but some menu labels may differ if your organization uses customized menu configurations. Screenshots reference the default Yardi menu structure.
Export 1: Recovery Analysis Report
The Recovery Analysis report is the single most important export for CAM reconciliation. It shows, for each tenant and each recovery pool, what was estimated, what was actually spent, and what the variance is. This is Yardi's version of the reconciliation calculation.
Navigate to Recovery Analysis
Go to Commercial > Recovery > Recovery Analysis. If your menu is organized differently, search for "Recovery Analysis" in the Voyager search bar (magnifying glass icon, top right).
Select the property
In the Property field, select the property you are reconciling. For multi-property portfolios, you can select multiple properties, but it is cleaner to export one property at a time.
Set the reconciliation period
Set the From Date and To Date to the full calendar year (January 1 through December 31 of the reconciliation year). Yardi defaults to the current month — make sure you override this to the full year.
Select recovery pools
In the Recovery Pool dropdown, select the pools you want to analyze. Common pools include CAM, Tax, Insurance, and Management Fee. Select all recoverable pools if you want the complete picture. Leave blank to include all pools.
Set detail level
Under Report Options, select Detail (not Summary). The detail view shows individual GL accounts within each recovery pool, which you need for expense classification and variance analysis.
Generate the report
Click Submit to generate the report. Depending on property size and the number of tenants, this may take 10-30 seconds.
Export to Excel
Click the Export to Excel icon in the report toolbar (it looks like a green spreadsheet). Voyager will generate an .xlsx file. Save it to your local drive.
Save as CSV
Open the Excel file and review it for completeness. Then go to File > Save As and select CSV (Comma delimited) as the format. This is the format CapVeri accepts for recovery analysis imports.
Key columns in the export:
| Column | Description |
|---|---|
| Tenant Code | Yardi's internal tenant identifier |
| Tenant Name | Tenant display name |
| Suite | Unit/suite number |
| Recovery Pool | CAM, Tax, Insurance, etc. |
| GL Account | Account number within the recovery pool |
| GL Description | Account name |
| Actual Amount | What was actually spent (from GL postings) |
| Estimated Amount | What was billed to the tenant as estimates |
| Variance | Actual minus Estimated — positive means under-billed |
| Pro-Rata Share % | Tenant's share of the recovery pool |
| Tenant Share $ | Tenant's allocated portion of actual expenses |
Common Issues
Issue: Report shows $0 for Actual Amount on some GL accounts. This usually means the GL account is mapped to the recovery pool but no transactions were posted to it during the period. Verify in the GL that transactions exist. If they are posted to a different account, the recovery pool mapping may need updating.
Issue: Recovery pool totals do not match GL totals. Yardi's recovery pool pulls from the GL accounts mapped in the recovery setup (Commercial > Recovery > Recovery Setup). If an expense account is not mapped to a pool, it will not appear in the Recovery Analysis. Check your pool-to-GL mappings.
Issue: Report includes tenants who moved out mid-year. This is correct. Yardi prorates recovery charges for partial-year tenants. The report should show their prorated share for the months they were in occupancy.
Export 2: General Ledger Detail
The GL Detail export gives you every transaction posted to your recoverable expense accounts. This is the line-by-line backup for the expense totals in the Recovery Analysis.
Navigate to General Ledger Analytics
Go to Accounting > General Ledger Analytics. This is the most flexible GL reporting tool in Voyager.
Set the property and date range
Select your property and set the date range to January 1 through December 31 of the reconciliation year.
Set the account range
In the From Account and To Account fields, enter the range of your operating expense accounts. If your chart of accounts uses a standard structure (5000-series for operating expenses), enter 5000 to 5999. If you are unsure of the range, leave it blank to pull all accounts, then filter in Excel.
Select detail level
Set the report to Transaction Detail (not Summary or Account Summary). You want every individual posting — date, vendor, description, debit, credit.
Submit and export
Click Submit to generate. Then click the Export to Excel icon. For properties with thousands of GL transactions, this export may take 30-60 seconds.
Save as CSV
Open in Excel, verify the data is complete (check that beginning and ending balances make sense), and save as CSV.
Key columns in the export:
| Column | Description |
|---|---|
| Account | GL account number |
| Account Description | Account name |
| Date | Transaction posting date |
| Reference | Invoice or journal entry number |
| Description | Transaction description (vendor name, invoice detail) |
| Debit | Debit amount |
| Credit | Credit amount |
| Balance | Running account balance |
Tips for Clean GL Exports
- Filter out non-recoverable accounts before importing. If you exported the full GL, remove accounts that are not part of your CAM pools (debt service, depreciation, capital reserves that are not passed through).
- Watch for year-end adjustments. Accruals and reversals posted in January for the prior year should be included in the reconciliation year if they relate to that period. Yardi posts these to the period they belong to, not the date they were entered — but verify.
- Check for manual journal entries. Sort by Reference and look for JE-prefixed entries. These are manual postings that may represent reclassifications, corrections, or accruals. Each one should have a clear description. Unexplained manual entries are audit red flags.
Export 3: Rent Roll with Lease Charges
The Rent Roll export provides tenant square footage, lease dates, and pro-rata shares — the denominator side of the reconciliation equation.
Navigate to Rent Roll
Go to Leasing > Reports > Rent Roll with Lease Charges.
Set the report date
Set the As Of date to December 31 of the reconciliation year. This gives you the tenant roster as of year-end. For weighted average occupancy calculations, you may also want a January 1 snapshot — run the report twice.
Select the property
Choose your property. For multi-property reconciliations, export one property at a time.
Include all tenants
Under options, make sure Include Expired Leases is checked if you want to capture tenants who moved out during the year. Their partial-year occupancy affects gross-up calculations and pro-rata share allocation.
Generate and export
Click Submit, then Export to Excel, then save as CSV.
Required columns for CapVeri import:
| Column | Required? | Notes |
|---|---|---|
| Unit/Suite | Yes | Unique identifier for each space |
| Tenant Name | Yes | Current tenant occupying the space |
| Rentable SF | Yes | Tenant's rentable square footage per lease |
| Lease Start | Yes | Lease commencement date |
| Lease End | Yes | Lease expiration date |
| Monthly Rent | Recommended | Base rent for variance analysis |
| Pro-Rata Share % | Recommended | Yardi's calculated share — CapVeri will verify this |
Export 4: Charge Schedule (Supplementary)
The Charge Schedule shows what was actually billed to each tenant for estimates during the year. This is useful for verifying that estimate billings match the Recovery Analysis.
Navigate to Charge Schedule
Go to Commercial > Recovery > Charge Schedule (or Commercial > Charges > Charge Schedule, depending on your menu configuration).
Set property, period, and charge type
Select the property, set the period to the full reconciliation year, and filter to recovery-related charge codes (CAM, TAX, INS, MGT, or your organization's equivalents).
Generate and export
Submit, export to Excel, save as CSV.
This export is not required for CapVeri import but is valuable for audit defense documentation. When a tenant questions the estimate amount on their reconciliation statement, the Charge Schedule is the backup.
Export 5: Recovery Setup (Reference)
This is not a data export — it is a configuration reference. The Recovery Setup screen (Commercial > Recovery > Recovery Setup) shows how your recovery pools are configured: which GL accounts feed each pool, which tenants are included, what the gross-up settings are, and what caps or floors apply.
Before starting reconciliation, review this screen to confirm:
- All recoverable GL accounts are mapped to the correct pool
- Tenant inclusion/exclusion matches lease terms
- Gross-up thresholds match lease language
- Cap settings are current
Screenshot or export this configuration as part of your reconciliation working papers. If settings change mid-year, you want a record of what was in place during the reconciliation period.
Preparing Yardi Exports for CapVeri Import
CapVeri accepts CSV files from Yardi Voyager. For the cleanest import:
- Use consistent property identifiers. If your Yardi property code is "OFC-101," use that same code across all three exports so CapVeri can match them.
- Remove Yardi header/footer rows. Voyager Excel exports include report headers (property name, date range, report title) and footers (page totals, grand totals). Delete these rows — CapVeri expects data rows only, with a single header row.
- Verify column headers. CapVeri's Yardi parser recognizes standard Voyager column names. If your organization has customized column labels, CapVeri's column mapper will prompt you to match them during import.
- Export one property per file. Multi-property exports work, but single-property files are easier to validate and troubleshoot.
- Check for special characters. Tenant names with ampersands (&), quotes, or commas can cause CSV parsing issues. Voyager usually handles this correctly, but verify that multi-word tenant names are properly quoted in the CSV.
For a broader overview of export workflows across multiple property management systems, see the general export guide.
Related Resources
- How to Export from Yardi, MRI, AppFolio & RealPage — Overview of all PM system exports
- GL Analysis Explained — What to look for in your GL export
- GL Coding Guide — Best practices for expense account structure
- Data Migration Off Excel — Moving from spreadsheets to structured reconciliation
Import Your Yardi Data in Minutes
Export your Recovery Analysis, GL Detail, and Rent Roll from Voyager. Upload all three to CapVeri. The platform maps your Yardi data automatically, runs the reconciliation math, and flags discrepancies before statements go out.
Start Free AuditFrequently Asked Questions
What reports do I need to export from Yardi Voyager for CAM reconciliation?
You need three core exports: (1) the Recovery Analysis report, which shows actual vs estimated recoveries by tenant and expense pool; (2) the GL Detail report filtered to your recoverable expense accounts for the reconciliation year; and (3) the Rent Roll with Lease Charges report showing current tenant square footage and lease terms. Together, these three files give you the complete picture of what was billed, what was spent, and who is responsible for what share.
How do I export Yardi data as CSV for external analysis?
Yardi Voyager does not export directly to CSV from most report screens. The standard workflow is: generate the report in Voyager, click the Export to Excel icon (spreadsheet icon in the toolbar), open the file in Excel, then use File > Save As > CSV (Comma delimited). For large datasets, use the General Ledger Analytics screen which supports direct Excel export with all detail rows intact.