LeaseQuery CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in LeaseQuery.
CAM Module
Operating Expense Provisions / CAM Obligation Tracking
Module Navigation
Navigate to Leases from the main dashboard. Select a lease and go to the Operating Expenses tab to view abstracted CAM provisions. LeaseQuery manages CAM through lease abstraction similar to Visual Lease — CAM terms are stored in the lease record as provision data. For portfolio-level reporting, use Reports > Operating Expenses > CAM Summary.
Recovery Pool Configuration
LeaseQuery does not use recovery pools. CAM obligations are captured during the lease abstraction workflow in each lease's Operating Expense section. Abstract the following for accurate CAM tracking: recoverable expense categories, expense stop or base year amount, gross-up provision (yes/no and occupancy threshold), annual cap provisions (cumulative or compounding), and any landlord obligation exclusions. These provision terms are what LeaseQuery uses to calculate CAM obligations and compare to actual charges.
Charge Code Setup
CAM is tracked in LeaseQuery through Operating Expense payment entries rather than charge codes. For each lease, create payment items of type 'Operating Expense Reimbursement' or 'CAM' on the lease payment schedule. Enter the monthly estimate amount and frequency. LeaseQuery tracks estimated payments against actual charges when reconciliation data is entered. The lease record's CAM provision fields drive the calculation logic for overage or credit amounts.
Export Procedure for CapVeri
Go to Reports > Lease Reports > Operating Expense Detail. Filter by property portfolio, date range, and lease status. Export to CSV. The report includes lease-level CAM provision terms alongside payment history. For a format suitable for CapVeri, include the following columns in the export: Lease ID, Tenant, Property, Pro-Rata Share, Base Year/Stop Amount, Cap Percentage, and Monthly Estimate. LeaseQuery also supports data export via its API for automated workflows.
Common Mistakes to Avoid
Not abstracting CAM cap provisions during lease entry, causing the system to show no cap limits when caps actually exist in the lease
Entering incorrect expense stop amounts during abstraction — even small errors compound over multi-year leases
Using LeaseQuery as the sole CAM reconciliation tool without importing actual GL expense data from the accounting system
Failing to update lease records after lease amendments that modify CAM terms, leading to incorrect obligation calculations
Not linking operating expense payments to the correct lease provision type, causing payment history to appear disconnected from CAM tracking
How LeaseQuery Works with CapVeri
Export the Operating Expense Detail report from LeaseQuery as CSV to capture lease-level CAM provision terms. Pair this with a GL expense export from your accounting system (Yardi, MRI, Sage Intacct, QuickBooks, etc.). Upload both files to CapVeri: the LeaseQuery export provides the provision terms (caps, stops, gross-up), and the GL export provides actual costs. CapVeri reconciles the two sources and generates tenant statements reflecting each lease's specific terms.
About LeaseQuery
LeaseQuery is a lease accounting platform focused on ASC 842 / IFRS 16 compliance for both lessees and lessors. Like Visual Lease, it is not a property management system — it does not manage payables or post GL entries. Its strength is lease obligation accounting and compliance reporting. CAM tracking is through provision abstraction, and actual reconciliation requires a separate GL data source. Used by mid-market and enterprise companies for lease compliance across both real estate and equipment leases.
Troubleshooting Common LeaseQuery Issues
LeaseQuery shows a different CAM obligation than my Yardi reconciliation — which is correct?
The discrepancy likely stems from a mismatch between the lease terms abstracted in LeaseQuery and the recovery pool configuration in Yardi. Check four things: (1) Does LeaseQuery's base year stop amount match what's in the signed lease? (2) Does Yardi's gross-up setting match the lease's gross-up provision? (3) Are the same expense categories included in both systems? (4) Does the pro-rata share percentage match between systems? The signed lease document is the arbiter — correct whichever system has the error.
How do I track CAM audit rights in LeaseQuery?
LeaseQuery includes audit rights fields in the lease abstraction workflow under Operating Expenses > Audit Rights. Abstract the audit deadline (typically 90–180 days after receiving the reconciliation statement), the audit methodology permitted (agreed-upon procedures, full audit, etc.), and any audit cost reimbursement provisions. Set up critical date alerts in LeaseQuery for audit deadlines — missed audit windows forfeit tenants' rights to dispute charges, which is a significant liability risk.
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 LeaseQuery Exports
Export your GL data from LeaseQuery 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