QuickBooks (Manual CAM Tracking) CAM Reconciliation Setup Guide
How to configure CAM reconciliation, export data, and avoid common mistakes in QuickBooks (Manual CAM Tracking).
CAM Module
No dedicated CAM module — tracked via GL accounts and Excel
Module Navigation
QuickBooks does not have a CAM reconciliation module. CAM tracking is done by: (1) creating GL expense accounts for each CAM category in Chart of Accounts, (2) recording CAM-related expenses against those accounts, and (3) exporting the GL detail to Excel for manual reconciliation and tenant share calculations.
Recovery Pool Configuration
There are no recovery pools in QuickBooks. Instead, create a GL account structure that mirrors your CAM categories: a parent account (e.g., '5000 - CAM Expenses') with sub-accounts for each category (Maintenance, Landscaping, Utilities, Insurance, Taxes, etc.). Use Classes or Locations in QuickBooks Online to separate expenses by property.
Charge Code Setup
QuickBooks does not have charge codes for CAM recovery. To track estimates billed to tenants, create a revenue sub-account (e.g., '4200 - CAM Recoveries') with sub-accounts per tenant or use the Customer field on invoices. Monthly CAM estimates are billed as manual invoices. Year-end true-ups are separate invoices or credit memos.
Export Procedure for CapVeri
Go to Reports > Accounting > General Ledger (QBO) or Reports > Accountant & Taxes > General Ledger (Desktop). Filter by date range and CAM expense accounts. Export to Excel or CSV. In QBO, click the Export button; in Desktop, use File > Export to Excel. Ensure the property Class/Location column is included for multi-property portfolios.
Common Mistakes to Avoid
Not using Classes or Locations to separate expenses by property, making per-property CAM allocation impossible
Posting CAM expenses to generic accounts (e.g., 'Miscellaneous Expense') instead of specific CAM sub-accounts
Forgetting to exclude capital expenditures from CAM — QuickBooks does not enforce this automatically
Not reconciling invoiced CAM estimates against actual GL expenses, leading to missed true-ups
Losing the Excel reconciliation spreadsheet or using an outdated version with wrong square footage data
Applying the same pro-rata share to all tenants without verifying each lease's specific allocation method
How QuickBooks (Manual CAM Tracking) Works with CapVeri
Export your General Ledger detail as CSV from QuickBooks. Upload to CapVeri, which replaces the manual Excel reconciliation process entirely. CapVeri calculates pro-rata shares, applies gross-up, tracks caps, and generates tenant reconciliation statements — all from your QuickBooks GL export. This is the highest-impact integration for firms still using spreadsheets.
About QuickBooks (Manual CAM Tracking)
QuickBooks is used by smaller CRE firms (1–10 properties) that lack the budget or complexity to justify Yardi or MRI. CAM reconciliation in QuickBooks is entirely manual — all calculations happen in Excel. This is the most error-prone setup in the industry and the use case where CapVeri provides the greatest value. Common errors include wrong square footage, missed expenses, incorrect gross-up, and no cap tracking.
Related Resources
Validate Your QuickBooks (Manual CAM Tracking) Exports
Export your GL data from QuickBooks (Manual CAM Tracking) 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