Commercial CAM Reconciliation Checklist: A Practical Year-End Process for Landlords
CAM reconciliation gets difficult long before anyone opens a spreadsheet. The lease is in one folder, invoices are in accounting, a prior manager used different expense codes, and an amendment changed a tenant's cap or share. At year-end, the team must turn that record into a charge or credit the tenant can follow.
The goal is not simply to make the numbers tie. It is to create a lease-supported package that shows the expense pool, the tenant's allocation, payments already collected, and the resulting balance. Use this checklist for commercial properties with CAM or NNN recoveries. The executed lease and amendments control; confirm local requirements and obtain qualified legal or accounting advice before issuing charges.
1. Set the Reconciliation Calendar
Start with timing. A correct calculation delivered after a lease deadline can still cause a problem. For each tenant, verify:
- The reconciliation period and fiscal year.
- The deadline for the landlord's statement and the tenant's payment due date.
- The timing for credits or refunds.
- Any review, audit, objection, or records-request window.
- Notice addresses and delivery requirements.
Put these dates in one operating calendar. If leases have different fiscal years or anniversary dates, follow each active obligation instead of forcing every tenant into the accounting team's preferred schedule.
2. Confirm the Active Lease Data
Before calculating a share, pull the original lease and every active amendment, expansion, contraction, assignment, or agreement affecting recoveries. Your working lease record should identify:
- Premises square footage and the allocation denominator.
- The tenant's pro rata share or formula.
- Recoverable CAM, tax, insurance, utility, and other categories.
- Exclusions and special treatment for capital items, management fees, related-party charges, or repairs.
- Caps, base years, gross-up rights, admin-fee rights, and carve-outs.
- Estimated payments actually billed during the period.
Many late corrections start here. A suite expansion may change a share, or an amendment may cap controllable expenses while leaving taxes and insurance outside the cap. Use the current abstract, not last year's workbook, to drive the calculation.
3. Close and Review the Expense Ledger
Build the expense pool from a closed, reviewable ledger. Reconcile property-level detail to the financial statements, then trace material or unusual items to invoices, contracts, work orders, tax bills, insurance statements, or other support.
Before allocating costs:
1. Review account mapping for duplicate, missing, or misclassified entries. 2. Separate owner, leasing, tenant-improvement, debt, and other clearly non-operating items. 3. Investigate material year-over-year variances. 4. Identify credits, rebates, insurance recoveries, vendor refunds, and other offsets that may affect the pool. 5. Preserve support for every material adjustment.
The general ledger is an input, not the authority for recovery. A cost can be properly recorded in accounting and still be excluded, capped, or allocated differently under a particular lease.
4. Map Expenses to the Lease
Create a review table for each material category: gross cost, lease treatment, adjustment, final recoverable amount, and support location. Review landscaping, snow, janitorial, security, maintenance, common utilities, taxes, insurance, repairs, capital work, administrative fees, and costs tied to a vacant area, one tenant, or a separate building.
Do not apply a portfolio-wide rule where a lease says something else. If a category is unclear, flag it for lease and professional review rather than burying a judgment inside a spreadsheet formula.
5. Apply Caps, Exclusions, Gross-Up, and Allocations
First remove excluded items. Then apply caps to the correct expense subset and period. A controllable-expense cap may not apply to taxes, insurance, utilities, or other categories, depending on the lease. Record each adjustment and the reason for it.
If gross-up is permitted, document the trigger, occupancy assumption, affected categories, and method. It is not a default fix for low occupancy; use it only when the lease supports it.
Calculate each tenant's share using the current premises and denominator. A mid-year commencement, expansion, vacancy, or sale may require proration under the governing lease. Keep the dates and assumptions with the calculation so another team member can reproduce it.
6. Compare the Result With Tenant Payments
The true-up is the annual recoverable amount less estimates or direct payments already credited to the tenant. For each tenant, confirm:
- CAM, tax, and insurance estimates billed during the period.
- Credits, write-offs, adjustments, or direct vendor payments affecting the balance.
- Opening and closing receivable balances.
- Whether a credit is applied, refunded, or carried forward.
- The payment due date and how the charge appears on the tenant ledger.
Reconcile the tenant schedule to the total property recovery schedule before statements go out. A correct property-level pool can still produce an incorrect tenant-level result.
7. Prepare a Tenant-Ready Package
A tenant should be able to follow the statement without guessing how the balance was created. The package should include the period and property/tenant identification, recoverable expenses by category, the lease-based share and any cap calculation, estimates or credits received, the balance due or credit, due date, and a contact for permitted support requests.
Keep detailed backup organized and ready: invoices, ledger detail, vendor contracts, tax and insurance support, and calculation worksheets. Consistent file locations and names help when a tenant uses a review right or a buyer requests diligence.
8. Run an Internal Review Before Delivery
Have someone other than the preparer perform a focused pre-send review:
1. Confirm the active lease and amendments. 2. Recalculate pro rata shares and cap math independently. 3. Verify the expense pool against the general ledger and spot-check material support. 4. Confirm estimates, credits, deadlines, notice address, and payment date. 5. Ensure the package contains no private information from other tenants.
Document the reviewer, date, and changes made. This creates a usable audit trail without turning a normal reconciliation into a legal opinion.
9. Manage Questions and Objections as a Workflow
Not every question is a dispute. Log the date received, question, requested support, lease clause, owner, response deadline, and outcome. Respond from the reconciled file set rather than recreating numbers in email or sending unreviewed partial backup.
For a substantive objection, preserve correspondence and follow the lease and advisers' guidance. Consistency matters: use the contract, calculation record, and stated process rather than improvising from memory.
Make Next Year Easier
After this year's package is complete, record the questions that took longest to answer, categories that needed cleanup, missing lease data, and backup that was hard to find. Turn those findings into monthly controls for next year.
PigJet helps commercial landlords keep lease terms, tenant records, CAM workflows, and supporting documents connected, so year-end does not depend on a last-minute hunt through spreadsheets and folders. If your team rebuilds CAM schedules every year, start by centralizing active lease rules and the documentation behind each recovery.