VTS Lease Management CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in VTS Lease Management.
CAM Module
Lease Administration / Operating Expense Clause Tracking
Module Navigation
Navigate to Lease Administration from the VTS dashboard. Select a property and then a deal or lease to access the lease record. CAM provisions are tracked in the Operating Expenses section under Lease Details. Portfolio-level CAM reporting is under Analytics > Lease Reports. VTS primarily manages CAM through lease abstraction — it is a leasing CRM and asset management platform, not a full-featured CAM reconciliation system.
Recovery Pool Configuration
VTS does not use recovery pools. CAM obligations are captured during lease abstraction in each lease record's Operating Expenses section. For each lease, abstract: recovery type (NNN, gross, modified gross), CAM expense categories included and excluded, base year or expense stop amount, gross-up provision and threshold, and annual cap terms. These abstracted terms feed into VTS's portfolio analytics for estimated CAM obligation forecasting — actual reconciliation requires a separate GL data source.
Charge Code Setup
VTS tracks CAM through lease obligations and payment schedules rather than charge codes. In the lease record, add operating expense payment items with estimated monthly amounts to track estimated vs. actual CAM receipts. VTS's leasing CRM features focus on deal pipeline, touring, and lease execution — the lease administration features, including CAM tracking, are newer additions to the platform and less feature-rich than dedicated lease administration tools.
Export Procedure for CapVeri
Navigate to Analytics > Reports > Lease Detail Report. Configure the report to include operating expense fields: estimated annual CAM, CAM provision type, base year amount, cap percentage, and pro-rata share. Export to CSV or Excel. VTS also supports data export via API for enterprise customers with data warehouse integrations. For CapVeri, pair the VTS lease provision export with a GL expense export from your accounting system or ERP.
Common Mistakes to Avoid
Using VTS as a CAM reconciliation tool — VTS tracks lease terms and deal pipeline, not GL-level expense data; actual reconciliation requires a separate process
Not abstracting CAM exclusion clauses during deal execution when the lease is being abstracted in VTS, requiring expensive retroactive lease re-abstraction
Entering estimated CAM amounts in VTS without documenting the basis for the estimate (budget, prior year, market rate), making year-end variance analysis difficult
Conflating VTS deal pipeline data with actual executed lease terms — ensure lease terms are updated in VTS after lease execution and any subsequent amendments
Ignoring VTS's CAM critical date tracking features, missing reconciliation deadlines or tenant audit rights windows documented in the platform
How VTS Lease Management Works with CapVeri
Export lease provision data from VTS (Operating Expense Detail or Lease Detail report) as CSV to capture CAM terms for each lease. Export GL actual expenses from your accounting system separately. Upload both to CapVeri: the VTS export provides the lease terms (base year, cap, exclusions, gross-up) that govern the reconciliation, and the accounting system export provides actual costs. CapVeri applies lease terms to actuals and generates tenant reconciliation statements. This two-source workflow is the standard approach for institutional VTS customers using CapVeri.
About VTS Lease Management
VTS is primarily a commercial real estate leasing and asset management platform used by institutional landlords, REITs, and asset managers. It excels at deal pipeline management, leasing CRM, and portfolio analytics — not at property-level accounting or CAM reconciliation. Lease administration features including CAM clause tracking have been added over time but remain secondary to VTS's leasing CRM core. Large institutional landlords often use VTS alongside Yardi or MRI — VTS for leasing and asset management, Yardi/MRI for accounting and CAM billing. For those customers, CapVeri validates the CAM output from Yardi/MRI using the lease terms tracked in VTS.
Troubleshooting Common VTS Lease Management Issues
How do I reconcile VTS lease data with our Yardi CAM calculations?
Export the lease provision data from VTS (base year, cap, exclusions, pro-rata share) and the recovery pool reconciliation data from Yardi. Compare the two to identify discrepancies: (1) pro-rata share percentage — VTS lease terms vs. Yardi recovery pool allocation; (2) CAM exclusions — items excluded in the VTS lease abstract that may be included in the Yardi recovery pool; (3) gross-up provision — whether VTS and Yardi agree on whether gross-up applies and the threshold. Discrepancies usually mean either the lease was abstracted incorrectly in VTS or the Yardi pool is configured incorrectly. The signed lease is the authoritative source.
VTS does not calculate CAM reconciliation amounts — how do institutional landlords handle reconciliation?
Institutional landlords using VTS typically run a three-system workflow: (1) VTS for lease abstraction and asset management; (2) Yardi or MRI for GL accounting, recovery pool billing, and estimate generation; (3) CapVeri or a dedicated reconciliation tool to cross-validate the Yardi/MRI reconciliation output against the lease terms in VTS. CapVeri accepts exports from all three systems and automates the cross-validation step, flagging discrepancies between what leases permit (from VTS) and what Yardi/MRI calculated.
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 VTS Lease Management Exports
Export your GL data from VTS Lease 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