RealPage CAM Pool Configuration: Setup Guide and Common Errors
RealPage Commercial's CAM pool configuration wizard walks you through setup step by step — which makes it easy to get started but also easy to accept defaults that don't match your leases. The errors that result aren't obvious immediately; they show up when reconciliation statements go out and tenants start asking why their numbers don't match what the lease says.
RealPage CAM Pool Architecture Overview
RealPage structures CAM recovery in three layers:
- Expense Pools: Aggregate GL accounts → calculate total recoverable expenses for a category
- Recovery Schedules: Define allocation methodology (how the pool total is divided among tenants)
- Lease Recovery Records: Apply the recovery schedule to each tenant, with tenant-specific overrides
Each layer can be configured correctly or incorrectly. Errors at the pool layer affect every tenant in the pool. Errors at the lease record layer affect only that tenant.
Understanding this layered structure is essential for diagnosing problems — before you can fix an error, you need to know which layer it lives in.
Step 1: GL Account Assignment
The GL Account Mapping tab in each Expense Pool controls which accounts contribute to the recoverable expense total. This is where the most costly errors occur, because every dollar that's miscategorized — either included when it shouldn't be or excluded when it should be — affects every tenant's reconciliation.
What belongs in a CAM pool:
- Common area maintenance (janitorial, landscaping, snow removal)
- Common area utilities
- Management fees (per lease terms — typically a percentage of operating expenses)
- Insurance (if the lease includes it as recoverable)
- Real estate taxes (if the lease includes them as recoverable — often in a separate pool)
- Repairs and maintenance for common areas
What does not belong:
- Capital expenditures (replacements rather than repairs — confirm with lease language)
- Tenant improvement costs
- Leasing commissions
- Mortgage payments or debt service
- Depreciation and amortization
- Corporate overhead not attributable to the property
- Residential amenity costs (if the property is mixed-use)
Validation step: After mapping accounts, run a test expense total for the prior year and compare to your manually calculated recoverable expense total for that year. Any difference indicates a mapping error.
Step 2: Allocation Basis
RealPage supports three primary allocation bases:
- RSF (Rentable Square Footage): Most common. Pro-rata share = tenant RSF / building RSF.
- USF (Usable Square Footage): Used when leases define share by usable area rather than rentable.
- Custom: Allows a manually defined numerator and denominator for special lease situations.
Common allocation basis errors:
Using USF when the lease says RSF: In a 100,000 RSF building with a 10% load factor, USF is ~90,000. A tenant with 10,000 RSF would have 11.1% share under USF vs. 10% under RSF. Over a $500,000 pool, that's a $5,500 annual overcharge.
Not updating RSF after TI construction: If a tenant expansion changes their RSF and RealPage isn't updated, every subsequent billing uses the old number.
Wrong building total: RealPage uses the denominator defined in the pool setup, not automatically from all active leases. If you add or remove space from the building, update the pool denominator manually.
Step 3: Cap Rules
RealPage supports multiple cap configurations, and this is where defaults are most dangerous. The wizard defaults to non-cumulative cap logic, but many commercial leases — particularly office leases from 2015 onward — specify cumulative caps.
Non-cumulative cap: CAM cannot increase more than X% per year, regardless of what happened in prior years. Unused headroom disappears.
Cumulative cap: CAM cannot increase more than X% per year compounded. Unused headroom carries forward. If CAM increased only 2% in a 5%-cap year, the 3% unused headroom accumulates and can be applied in future years.
Financial impact over time: In a 5-year lease with a 5% cumulative cap and actual CAM increases of 3%, 3%, 3%, 8%, 8%:
- Non-cumulative cap: Year 4 and 5 capped at 5% — landlord collects less
- Cumulative cap: Unused capacity from years 1-3 (2%+2%+2%=6%) allows year 4 to increase 8% without hitting the cap; year 5 still has remaining headroom
The difference compounds. For a tenant with $100,000 annual CAM, the five-year billing difference between cumulative and non-cumulative can exceed $15,000.
How to configure in RealPage: Navigate to the tenant's Lease Recovery Record → Cap Settings tab. Confirm:
- Cap Type: Cumulative or Non-Cumulative (match your lease)
- Cap Base Amount: The base period's CAM amount
- Cap Base Year: Should match lease commencement or renewal date
- Cap Percentage: Must match lease exactly — not rounded
Common Configuration Errors
No cap rules configured at all: The pool calculates an uncapped amount, and RealPage sends it to tenants who have cap protection in their leases. This is the single most common RealPage overbilling scenario. Always configure cap rules for any lease that contains CAM cap language.
Mixed-use account contamination: Properties with both residential and commercial tenants in the same RealPage database are at risk of residential-specific GL accounts being mapped to commercial CAM pools. Audit the account list for any amenity costs, residential maintenance, or apartment-specific accounts.
Wrong allocation basis for anchor tenants: Major tenants (grocery anchors, big-box retailers) frequently negotiate a fixed CAM contribution or an excluded-from-denominator status rather than pro-rata billing. If RealPage has them contributing to the denominator when they shouldn't be, all remaining tenants are undercharged.
Cap base year not updated at renewal: When a lease renews and the CAM cap resets, RealPage requires manual update of the base year in the lease record. This does not happen automatically. If the base year is still set to the original lease commencement, cap calculations are wrong for the renewal term.
Validation Checklist
Before sending reconciliation statements, verify:
- GL account mapping reviewed against chart of accounts — no capital accounts included
- Allocation basis matches lease definitions — RSF or USF confirmed per lease
- Denominator is correct — updated for any space changes
- Cap type is correct — cumulative vs. non-cumulative per lease language
- Cap base year is current — updated for any renewals
- Cap base amount is correct — matches actual CAM billed in base year
- Mixed-use accounts excluded — no residential-specific accounts in commercial pools
- Anchor tenant denominator treatment is correct per lease
CapVeri's CAM cap calculator models cumulative vs. non-cumulative cap scenarios against your actual expense history, showing the correct cap limit for each tenant before reconciliation statements go out.