Sage Intacct Real Estate CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in Sage Intacct Real Estate.
CAM Module
Real Estate Expense Pools / Recovery Billing
Module Navigation
Navigate to Real Estate > Expense Pools from the top menu. Select the entity and property. Sage Intacct uses dimension-based accounting — CAM pools are defined by combining Location, Property, and GL Account dimensions. For recovery billing, go to Real Estate > Recovery Billing > Reconciliation.
Recovery Pool Configuration
Sage Intacct defines expense pools using its multi-dimensional GL structure. Under Real Estate > Expense Pool Setup, create pools by selecting dimension combinations (Location + Department + GL Account). Each pool supports pro-rata, direct, and metered allocation methods. Gross-up rules are configured in the 'Occupancy Adjustment' section of each pool. Intacct's dimensional approach allows sophisticated pool definitions but requires careful dimension planning.
Charge Code Setup
Under Real Estate > Billing Setup > Recovery Charge Codes, create codes for each recoverable category. Link charge codes to expense pools and define the billing frequency. Intacct's 'Smart Events' can automate estimate recalculation when actuals are posted. Each charge code has a 'Tenant Share Basis' field — set to rentable area, usable area, or custom allocation.
Export Procedure for CapVeri
Go to Reports > Real Estate > General Ledger Detail. Use Intacct's report builder to filter by property dimension, date range, and expense account range. Export to CSV or Excel. For reconciliation output, use Reports > Real Estate > Recovery Reconciliation, which shows pool-level detail with estimated vs. actual comparisons.
Common Mistakes to Avoid
Misconfiguring GL dimensions, causing expenses to land in the wrong expense pool or be excluded entirely
Not setting up the Location dimension consistently across all expense entries, breaking property-level reporting
Forgetting to activate 'Smart Events' for automatic estimate recalculation, leading to stale monthly estimates
Using Intacct's standard (non-real-estate) GL reports instead of the Real Estate module reports, which miss dimensional context
Not reconciling the expense pool totals against the GL trial balance — dimension mismatches can cause silent discrepancies
How Sage Intacct Real Estate Works with CapVeri
Export the GL Detail Report as CSV using Intacct's report builder. Include the Location/Property dimension, GL Account, Description, and Amount columns. Upload to CapVeri — Intacct's CSV format is auto-detected. For multi-entity portfolios, include the Entity column so CapVeri can separate property-level data.
About Sage Intacct Real Estate
Sage Intacct Real Estate is popular among institutional owners and REITs because of its multi-dimensional GL and consolidation capabilities. The dimensional approach is powerful but adds complexity to CAM pool configuration compared to Yardi or MRI. Firms migrating from QuickBooks to Intacct often underestimate the dimensional setup effort required for accurate CAM tracking.
Related Resources
Validate Your Sage Intacct Real Estate Exports
Export your GL data from Sage Intacct Real Estate 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