How to Check CAM Expenses Before You Bill Tenants
The landscaping invoice was posted in August. It’s marked recoverable in the property ledger. When the reconciliation goes out, the expense is nowhere in the allocation schedule.
Start with the expense and the allocation
If you work in Excel, bring the expense ledger, approved CAM allocation schedule, and estimated charges already billed. Include property, expense account, posting date, and reconciliation period.
If you use Yardi, start with the recoverable expense detail and your CAM billing or reconciliation worksheet in spreadsheet form. Compare estimated charges with the actual expenses recorded in recoverable accounts.
Check what reached the schedule
Match expenses to the property and recovery pool. Check for recoverable items that are missing, duplicated, or assigned to the wrong pool. If the schedule is summarized, compare totals by account and trace the variance back to the detail.
In this example, an $8,400 landscaping expense appears in the ledger and is absent from the schedule. Review the coding and eligibility against the approved lease terms and allocation rules before deciding what to charge.
What to ask Jolene.pro
Which recoverable expenses are missing from the CAM schedule? Group them by property and account and show the source rows.
Clear the exceptions before the reconciliation goes out.