Planon Real Estate Management CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in Planon Real Estate Management.
CAM Module
Service Charge / Lease Management Recovery Module
Module Navigation
Navigate to Real Estate Management > Service Charges from the main menu. Select the property and service charge period. Planon refers to CAM as 'Service Charges' in its European-origin terminology. For configuration, go to Administration > Real Estate Setup > Service Charge Configuration. Planon's CAM/service charge module is part of its broader lease management and IWMS platform.
Recovery Pool Configuration
Planon uses 'Service Charge Pools' (equivalent to CAM recovery pools) configured under Service Charge Configuration. Create pools for each cost category (Operating, Tax, Utilities, Insurance). Assign GL cost accounts to each pool. Configure allocation keys — Planon's term for the pro-rata allocation method — which can be based on rentable area, usable area, custom percentages, or headcount. Gross-up rules are configured per pool under Occupancy Adjustment settings. Planon supports multi-currency pools for international portfolios.
Charge Code Setup
Under Administration > Charge Code Setup, create codes for each service charge category. Link charge codes to service charge pools and define billing frequency. Planon's 'Turnover Rent' and 'Service Charge' billing modules work together — ensure CAM charges are configured under Service Charge rather than Turnover Rent. Each charge code has a tenant-level contract mapping in the lease record that defines the share basis and any lease-specific overrides.
Export Procedure for CapVeri
Navigate to Reports > Real Estate > Service Charge Detail Report. Filter by property portfolio, fiscal year, and cost category. Export to CSV or Excel. Planon also supports reporting via Crystal Reports and Power BI integrations for institutional users. For CapVeri upload, use the Service Charge Detail export which includes cost pool assignments, actual amounts, and tenant allocation data. Alternatively, export the GL Cost Detail from the financial module with property and cost category filters.
Common Mistakes to Avoid
Confusing Planon's 'allocation keys' with static pro-rata shares — allocation keys can be formula-driven and must be validated annually when tenant RSF changes
Not configuring multi-currency rounding rules correctly for international portfolios, causing small but cumulative billing discrepancies
Treating Planon's IWMS facilities data as automatically reconciled to financial data — facilities management costs require manual GL mapping to service charge pools
Failing to update service charge pool configurations when the lease administration team adds new tenants with unique CAM exclusion terms
Not running the service charge period close before generating tenant statements, capturing incomplete cost postings
How Planon Real Estate Management Works with CapVeri
Export the Service Charge Detail report or GL Cost Detail from Planon as CSV. Upload to CapVeri for independent reconciliation validation. Planon's export format includes property, cost pool, category, and amount fields that CapVeri maps automatically. For international portfolios using multi-currency, export amounts in the functional currency (USD or your reporting currency) to ensure CapVeri's calculations use consistent units.
About Planon Real Estate Management
Planon is a Dutch IWMS/CAFM platform with strong adoption in Europe and growing presence in North America among large corporate real estate teams. Its real estate management module handles lease administration, space management, and service charge (CAM) billing in an integrated platform. Multi-currency and multi-country capabilities make it suitable for global real estate portfolios that most US-centric PM platforms cannot serve. Implementation is complex — typically 6–18 months for enterprise deployments. Used primarily by large corporations, universities, and institutional landlords with international portfolios.
Troubleshooting Common Planon Real Estate Management Issues
How do I configure Planon service charge pools for US-style NNN CAM reconciliation?
Planon's service charge module is designed for European 'turnover rent' and service charge structures, which differ from US NNN CAM conventions. To configure for US NNN: (1) create service charge pools for Operating, Tax, and Insurance separately; (2) set the allocation key to Rentable Area (not Gross Area — a common European default); (3) configure the reconciliation period to match the US calendar or fiscal year; (4) enable the gross-up adjustment if leases contain gross-up provisions; and (5) configure cap rules per pool if leases include controllable CAM caps. Document the US-specific configuration separately from Planon's default European setup.
Why do Planon service charge allocations differ from my expected pro-rata shares?
Planon uses 'allocation keys' which can be static (fixed percentage) or dynamic (formula-based on current occupancy data). If tenants have changed space or RSF has been updated in Planon's space management module, the allocation key may have changed automatically. Check the allocation key configuration for the service charge pool under Service Charge Configuration > Allocation Keys and verify that the RSF values match your lease records. Dynamic allocation keys recalculate when space data changes — this is a feature but can cause unexpected share shifts.
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 Planon Real Estate Management Exports
Export your GL data from Planon Real Estate Management 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