RealPage Commercial CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in RealPage Commercial.
CAM Module
Commercial Billing / CAM Recovery Module
Module Navigation
Navigate to Commercial > CAM Billing from the main menu. Select the property and billing period. For setup, go to Administration > Commercial Setup > CAM Configuration. RealPage uses a wizard-based setup flow for new CAM pools.
Recovery Pool Configuration
RealPage uses 'CAM Pools' configured under Commercial Setup > CAM Configuration > Pool Setup. Each pool contains: included GL accounts, allocation basis (rentable SF, usable SF, or custom), gross-up settings, and cap rules. RealPage allows per-pool cap configuration — both cumulative and compounding year-over-year caps are supported natively.
Charge Code Setup
Under Commercial Setup > Billing Codes, create codes for each recoverable category. Link billing codes to CAM pools. RealPage's 'Billing Schedule' feature lets you define estimate frequency (monthly, quarterly) and reconciliation timing. Each billing code can have tenant-level overrides for custom share percentages or fixed-amount recoveries.
Export Procedure for CapVeri
Go to Reports > Financial > General Ledger Export. Select the property, fiscal year, and GL account range. Choose CSV format. For CAM-specific exports, use Reports > Commercial > CAM Reconciliation Export, which pre-formats data with pool assignments and tenant shares. Both exports work with CapVeri.
Common Mistakes to Avoid
Not configuring cap rules at the pool level — RealPage defaults to no cap, which may violate lease terms
Mixing residential and commercial GL accounts in the same CAM pool for mixed-use properties
Forgetting to update the allocation basis when a tenant's rentable area changes due to expansion or contraction
Running the CAM reconciliation process before the GL close is finalized for the period
Not verifying that the 'Exclude from CAM' flag is set on capital improvement GL accounts
How RealPage Commercial Works with CapVeri
Export the GL Detail or CAM Reconciliation Export as CSV. Upload to CapVeri for validation. CapVeri auto-detects RealPage's column format. For properties using RealPage's native cap calculations, CapVeri will independently verify cap compliance against your lease terms.
About RealPage Commercial
RealPage's commercial module has improved significantly since the Thoma Bravo acquisition. Native cap support is a differentiator — most competitors require manual cap tracking. However, the commercial module is less mature than its residential offerings, and some firms find the CAM configuration wizard limiting for complex multi-pool scenarios.
Troubleshooting Common RealPage Commercial Issues
How do I configure CAM pool cap rules in RealPage?
CAM pool cap rules are configured in Administration > Commercial Setup > CAM Configuration > Pool Setup, under the Cap Rules tab. RealPage defaults to no cap — you must explicitly configure cap type (cumulative or compounding), the base year, and the cap percentage for each pool. Cumulative caps allow unused capacity to carry forward; compounding caps apply the percentage to the prior year's capped amount. Missing cap rules are the most common RealPage compliance issue.
Why are my RealPage CAM calculations wrong for mixed-use properties?
Mixed-use properties in RealPage require separate CAM pools for residential and commercial components. If residential operating expenses (lobbies, amenity spaces, residential common areas) flow into the commercial CAM pool, commercial tenants are being charged for expenses they should not bear. Verify GL account assignments in CAM Configuration > Pool Setup and ensure residential expense accounts are excluded from commercial pools.
How do I update tenant allocation basis in RealPage after a lease change?
Tenant allocation basis changes — caused by expansions, contractions, or lease amendments — must be updated in the tenant's billing record under Commercial > CAM Billing > Tenant Setup. Update the RSF and effective date of the change. RealPage does not automatically detect or prompt for lease-related changes, so allocation basis errors can persist for an entire reconciliation year if not updated promptly after the lease event.
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 RealPage Commercial Exports
Export your GL data from RealPage Commercial 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