Propertyware CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in Propertyware.
CAM Module
Commercial Lease Charges / GL-Based Expense Tracking
Module Navigation
Navigate to Leases > Commercial Leases from the main menu. Select the lease and go to the Charges tab for recurring CAM charge setup. For expense tracking, go to Accounting > General Ledger. Propertyware does not have a dedicated CAM reconciliation module — the workflow relies on GL account categorization for actuals and recurring charges for estimates.
Recovery Pool Configuration
Propertyware has no native recovery pool concept. Structure your chart of accounts to group CAM-recoverable expenses by category: create a parent GL account (e.g., 6000 - Operating Expenses) with sub-accounts for Maintenance, Landscaping, Utilities, Insurance, and Property Tax. Use Propertyware's property-level filtering when running expense reports to isolate each property's CAM expenses for reconciliation.
Charge Code Setup
Under Accounting > Charge Types, create charge types for CAM, Tax, and Insurance. Apply these as recurring charges on commercial leases with estimated monthly amounts. Propertyware does not auto-calculate estimates from actuals — determine the monthly estimate from your budget and enter it manually. For year-end true-ups, post a one-time additional charge or credit to each lease reflecting the difference between actual expenses and billed estimates.
Export Procedure for CapVeri
Go to Reports > Accounting > General Ledger Report. Filter by property and date range (full fiscal year). Add account filters to include only CAM-related expense accounts. Export to CSV or Excel. Propertyware's export includes Date, Account, Description, Reference, and Amount columns — all fields CapVeri uses for reconciliation. For multi-property portfolios, include the Property column in the export.
Common Mistakes to Avoid
Failing to organize the chart of accounts by CAM category, making it impossible to identify which expenses are recoverable without manual review
Setting recurring CAM estimates at lease inception and never adjusting them, resulting in significant true-up amounts at year-end
Posting capital improvement expenses (roof replacement, HVAC systems) to operating expense accounts, inflating CAM charges
Not filtering the GL export by property when managing multiple properties, causing expenses from one property to contaminate another's CAM calculation
Skipping the year-end true-up entirely due to the manual effort required, leaving CAM amounts unreconciled
How Propertyware Works with CapVeri
Export the General Ledger report as CSV from Propertyware, filtered by property and CAM expense account ranges. Upload to CapVeri to automate pro-rata share calculations, gross-up application, and tenant statement generation — all of which require manual effort in Propertyware's workflow. CapVeri is particularly valuable for Propertyware users managing NNN leases, replacing the Excel-based reconciliation process most Propertyware commercial operators maintain.
About Propertyware
Propertyware is a RealPage-owned platform originally focused on single-family rentals, with limited commercial capabilities added over time. It is used by smaller operators managing simple NNN commercial leases alongside residential properties. Compared to RealPage's commercial platform, Propertyware lacks dedicated CAM recovery logic — making it suitable only for landlords with straightforward lease structures. Operators needing cap tracking, gross-up, or multi-pool recoveries typically outgrow Propertyware quickly.
Troubleshooting Common Propertyware Issues
How do I identify which Propertyware expenses are CAM-recoverable?
Propertyware does not have a 'recoverable' flag on expense accounts. The cleanest approach is to structure your chart of accounts so recoverable expenses have account numbers in a defined range (e.g., 6000–6499 for CAM, 6500–6599 for non-recoverable). When running the GL report, filter by this account range. Alternatively, add a naming convention to account names (e.g., prefix with [CAM]) and manually sort when exporting. CapVeri allows you to specify which GL accounts are recoverable during the upload configuration step.
Propertyware does not track cap compliance — how do I manage this?
Propertyware has no native cap tracking. You must maintain lease-level cap information outside the system, typically in Excel. For each tenant, track: the base year CAM amount, the applicable cap percentage, the cumulative cap ceiling for each year, and actual charges billed. CapVeri automates this entire workflow — upload your Propertyware GL export and enter your lease cap terms, and CapVeri calculates whether each tenant's charges are within their cap for each reconciliation year.
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 Propertyware Exports
Export your GL data from Propertyware 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