Feature highlights
Year-end reconciliation in one place
Compare actual common area operating expenses against what you collected from commercial residents — without leaving the Accounting section.
Automatic pro-rata allocation
Expenses are split across commercial units by square footage automatically. No manual calculations needed.
Reconciled based on lease types
Ability to select specific lease types to start reconciliation.
Adjusting invoices & credits in one click
Post invoices or credit memos directly to the accounting ledger for every unit in scope, all at once.
Resident statements by email
Send each commercial resident a PDF statement showing their CAM charge breakdown at the same time you post.
Draft auto-saves as you work
Your reconciliation is saved automatically at every step. Close the wizard and pick up exactly where you left off.
How to use
Get started
In the sidebar, go to Accounting and select CAM reconciliation. If a draft already exists, the wizard opens it automatically. Otherwise, a new reconciliation starts.
Step 1 — Set up the reconciliation
1. Choose your reconciliation period: Annual, Quarterly, or Custom, then set the start and end dates.
2. Select which lease types and or properties to include. Only properties with commercial rental units are shown. Gross rent lease types are excluded from the reconciliation.
3. Review the Expense accounts picker. Accounts are grouped by CAM category and show the period total pulled from your ledger. Select the accounts you want to include.
4. Select the CAM revenue accounts used for CAM lease fees.
Step 2 — Review allocations
1. Check the summary strip at the top: total expenses, CAM charges collected, and the net amount to reconcile.
2. The table shows every commercial unit, its square footage, pro-rata share, and whether it owes an invoice or receives a credit.
3. Click any row to open the unit detail panel, which shows the full category and GL breakdown plus payments already collected. You may adjust any expense amounts allocated to a lease at this step.
4. Use Export CSV to download the allocation table if you need it for your records.
5. Click Post invoices & credits to go to the next step
Step 3 — Post invoices & credits
1. Review the list of adjusting invoices and credits. Click Preview on any row to see the statement that can be sent to that resident.
2. Set the posting date, invoice due date, and the GL recovery account.
3. Check Email statement to resident if you want residents notified automatically.
4. Select the units you're ready to post (or select all), then click Post & notify residents.
FAQ
Q: Why don't I see the CAM reconciliation option in Accounting?
CAM reconciliation requires a CAM GL mapping to be configured first. Go to Settings → GL Mappings and set one up. The wizard will be accessible once a mapping exists.
Q: Can I run more than one reconciliation at a time?
No — only one draft can exist per account at a time. If a draft is already in progress, the wizard opens it when you navigate to CAM reconciliation.
Q: Do residential units appear in the reconciliation?
No. CAM reconciliation applies to commercial units only. Residential and condo units are never shown in the property picker, allocation table, or any step of the wizard.
Q: How is the expense split calculated?
Expenses are allocated pro-rata by square footage. Each commercial unit's share is its square footage divided by the total leaseable square footage within that expense category's scope.
Q: Can I come back to my reconciliation later?
Yes. The wizard auto-saves every change you make, so you can close it and return at any time. Navigate back to CAM reconciliation and your draft will open automatically.
Q: Can I edit the reconciliation after posting?
No. Once posted, the reconciliation is locked to preserve the integrity of the ledger entries. To make adjustments, you'll need to create manual journal entries.