DoorLoop CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in DoorLoop.
CAM Module
Recurring Charges / Expense Tracking
Module Navigation
From the main dashboard, go to Properties > select the property > Leases. Select the commercial lease and navigate to the Charges tab for recurring charge setup. For expense tracking, go to Accounting > Expenses and filter by property. DoorLoop does not have a dedicated CAM module — CAM is managed through recurring charge templates combined with manual expense tracking.
Recovery Pool Configuration
DoorLoop has no formal recovery pool system. To approximate CAM pool tracking, create expense categories in Accounting > Chart of Accounts for each recoverable cost type (Maintenance, Landscaping, Utilities, Insurance, Property Tax). Tag all CAM-related expense transactions to these categories. Year-end reconciliation requires exporting these categorized expenses and calculating tenant shares manually or via CapVeri.
Charge Code Setup
Under Accounting > Charge Types, create charge types for CAM, Tax, and Insurance. For each commercial lease, add recurring charges on the lease Charges tab with the estimated monthly amount. Set billing frequency to monthly. DoorLoop does not auto-calculate CAM estimates from actuals — enter the estimated amount manually based on your budget. Year-end true-ups are posted as one-time charges or credits on each lease.
Export Procedure for CapVeri
Navigate to Accounting > Reports > General Ledger. Set the date range to the full fiscal year and filter by property. Export to CSV using the Export button. DoorLoop does not have a CAM reconciliation report — the GL detail export is the source of truth for actual expenses. For a clean dataset, filter the export by the CAM expense categories you configured in your chart of accounts.
Common Mistakes to Avoid
Not creating distinct expense categories for each CAM cost type, making it impossible to identify recoverable vs. non-recoverable expenses at year-end
Setting recurring charge amounts and never updating them as actual costs increase, leading to chronic under-collection
Forgetting to post the year-end true-up as a charge or credit on each lease after reconciliation is complete
Using DoorLoop's residential property features for commercial leases, which omits commercial-specific fields
Not tagging expenses to the correct property when managing multiple properties, making per-property CAM calculations impossible
Relying on DoorLoop's cash-basis expense reports without reconciling to bank statements and vendor invoices
How DoorLoop Works with CapVeri
Export the General Ledger report as CSV from DoorLoop, filtered by property and CAM expense categories. Upload to CapVeri to automate the reconciliation process DoorLoop does not provide natively. CapVeri calculates pro-rata shares by tenant based on lease square footage, applies gross-up if required, and generates reconciliation statements — replacing the manual Excel workflow most DoorLoop commercial users maintain.
About DoorLoop
DoorLoop launched in 2019 and has grown rapidly among small-to-medium residential landlords. Commercial CAM capabilities are basic — the platform excels at lease tracking, maintenance requests, and payment collection, but has no dedicated CAM reconciliation module. Landlords managing simple NNN leases with 5 or fewer commercial tenants can make DoorLoop work with manual effort. Larger or more complex commercial portfolios require a dedicated property management platform.
Troubleshooting Common DoorLoop Issues
How do I track CAM expenses by property in DoorLoop?
In DoorLoop, every expense transaction has a Property field — always assign it to the correct property when recording expenses. Create a chart of accounts structure with CAM sub-categories (Maintenance, Landscaping, Utilities, etc.) under a parent CAM Expenses account. When you run the General Ledger report, filter by property and these accounts to isolate recoverable expenses for reconciliation.
DoorLoop doesn't calculate pro-rata shares — how do I reconcile?
DoorLoop does not compute pro-rata shares natively. Export your GL detail for the fiscal year, then either use CapVeri (which calculates shares automatically from your lease square footage data) or perform the calculation manually in Excel: divide each tenant's RSF by the total leasable building RSF to get their pro-rata percentage, then multiply by total pool expenses. CapVeri eliminates this manual step and applies gross-up and cap rules automatically.
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 DoorLoop Exports
Export your GL data from DoorLoop 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