CAM Reconciliation Timeline: Month-by-Month Checklist for Property Controllers

Why Timing Matters

Late reconciliation statements cost money two ways. First, delayed billing pushes cash collection into the next fiscal year. Second, many leases include audit windows that start ticking when the statement arrives — the later you send it, the longer you extend tenant audit exposure.

The industry standard is 90–120 days after fiscal year-end. Some leases impose specific deadlines with penalties for late delivery. California's SB 1103 adds documentation obligations with 30-day response windows. Getting ahead of the timeline is the single highest-leverage process improvement a property controller can make.

This checklist assumes a December 31 fiscal year-end. Adjust dates if your portfolio uses a different fiscal year.

January: Close the Books

Goal: Complete year-end GL close so reconciliation data is final.

• Post all December accrual entries (property tax, insurance, utilities)
• Reverse any mid-year estimate accruals that were placeholders
• Reconcile all bank accounts tied to operating expense payments
• Verify that all Q4 vendor invoices have been entered
• Run a preliminary GL trial balance for each property
• Flag any GL accounts with unusual balances (year-over-year variance > 15%)
• Confirm property tax payments match assessed amounts (no pending protests or refunds)

Common pitfall: Rushing to close before all vendor invoices arrive. Late invoices from snow removal, holiday security, and year-end maintenance can materially change expense totals. Accrue known unbilled amounts.

February: Validate Expense Data

Goal: Ensure expense data is accurate before starting per-tenant calculations.

• Run year-over-year expense comparison by GL account for each property
• Investigate any line items that changed > 10% from prior year
• Verify CapEx items are properly classified and excluded from CAM pools
• Confirm management fee calculations match lease terms (% of gross revenue, not CAM pool)
• Check that insurance premiums reflect actual policy costs, not estimates
• Validate utility allocations (common area vs. direct-to-tenant vs. sub-metered)
• Cross-reference property tax bills with county assessor records

Common pitfall: CapEx miscoding. A $50,000 HVAC compressor replacement coded to R&M instead of Capital creates a $50K CAM overstatement that will be caught by any competent tenant auditor.

March: Run Reconciliation Calculations

Goal: Calculate each tenant's actual CAM obligation and compare to estimates collected.

• Pull the current rent roll — verify tenant square footage, lease dates, and CAM provisions
• Build or update the lease abstract matrix for each property (caps, exclusions, base years, admin fees)
• Calculate building-level totals by expense pool (CAM, Tax, Insurance if billed separately)
• Apply gross-up adjustments to variable expenses where occupancy is below threshold
• Calculate each tenant's pro-rata share using the correct denominator for their lease
• Apply CAM caps (cumulative or non-cumulative, per lease terms)
• Calculate base year excess where applicable
• Determine admin/management fee per lease terms
• Subtract estimates already collected during the year
• Generate a true-up (or credit) amount per tenant

Common pitfall: Using a single denominator for all tenants. Different leases may define the building's rentable area differently — some exclude anchor space, some use a different BOMA measurement year. Each tenant's pro-rata share must use their lease-defined denominator.

April: Quality Review and Approval

Goal: Catch errors before statements go to tenants.

• Cross-check every tenant's pro-rata share against their lease
• Verify cap application logic — cumulative caps carry forward unused amounts; non-cumulative caps reset annually
• Run the pre-send checklist (see our CAM Pre-Send Checklist)
• Have a second controller or accountant review calculations for top 10 tenants by SF
• Compare this year's true-up amounts to prior year — investigate any tenant with a swing > 20%
• Verify that any mid-year lease modifications (expansions, contractions, early terminations) are reflected
• Get asset manager or property manager sign-off on final numbers

Common pitfall: Skipping the second-person review. The controller who built the reconciliation is the worst person to QA it — they'll make the same assumptions twice. A fresh set of eyes catches errors the builder can't see.

May–June: Deliver Statements

Goal: Send reconciliation statements to all tenants with supporting documentation.

• Generate tenant-facing reconciliation statements from your property management system
• Write cover letters explaining significant year-over-year changes (> 5% increase warrants an explanation)
• Include backup documentation proactively — category-level expense summaries at minimum
• For California properties: identify all QCTs (< 10,000 SF, < $5M revenue) and prepare SB 1103-compliant packages
• Send statements via certified mail or tracked email for delivery documentation
• Log delivery dates per tenant — the audit clock starts when they receive the statement
• Bill true-up amounts (or issue credits) per lease terms

Common pitfall: Sending statements without context. A tenant who receives a $15,000 true-up bill with no explanation will call their broker, who will recommend an audit. A cover letter explaining that insurance increased 18% due to market conditions preempts the dispute.

July–August: Handle Disputes and Questions

Goal: Respond to tenant inquiries promptly and document everything.

• Track all tenant questions and audit requests with dates and response deadlines
• For SB 1103 QCTs: respond to documentation requests within 30 days (statutory requirement)
• Prepare books-and-records packages for tenants exercising audit rights
• Document any adjustments made in response to tenant feedback
• If a tenant hires an auditor, notify asset management and prepare a defense file (see our Tenant Audit Defense Playbook — coming soon)

Common pitfall: Ignoring audit requests. Non-response doesn't make the audit go away — it escalates it. In California, failure to respond to a QCT request within 30 days triggers treble damages exposure.

September–October: Set Next Year's Estimates

Goal: Forecast next year's operating expenses and set monthly CAM estimates.

• Review current-year actuals through August — identify any run-rate changes
• Factor in known changes: insurance renewal premiums, property tax reassessments, new maintenance contracts
• Apply inflation assumptions to each expense category (don't use a single blanket rate — utilities and insurance inflate differently)
• Calculate new monthly estimates per tenant
• Send estimate adjustment letters to tenants (many leases require 30-day notice before adjusting)
• Update your property management system with new charge codes and amounts

Common pitfall: Setting estimates based on last year's actuals without forward-looking adjustments. If you know insurance is renewing 15% higher, build that in now — a large year-end true-up damages tenant relationships more than a modest mid-year estimate increase.

November–December: Year-End Prep

Goal: Prepare for next year's reconciliation cycle.

• Verify all lease abstracts are current (any new leases, renewals, or amendments from the past year)
• Confirm building square footage measurements are up to date (especially if BOMA 2024 remeasurement occurred)
• Review any open tenant disputes or credits from the current year
• Ensure Q4 accruals are being set up for property tax, insurance, and utility true-ups
• Document any building changes that affect CAM (new amenities, renovation, redevelopment)
• If using CapVeri: export your year-end GL data and run a pre-reconciliation audit to catch errors early

Building This Into Your Workflow

The 12-month cycle above assumes one person managing the process. For multi-property portfolios, the math changes:

The bottleneck is never the math — it's the data validation, lease interpretation, and quality review. Automation eliminates the calculation errors. Your time shifts from building spreadsheets to reviewing results and communicating with tenants.

Related Resources

• CAM Pre-Send Checklist — 12-point QA checklist before sending statements
• What Is CAM Reconciliation? — Fundamentals guide
• Gross-Up Calculation Guide — Step-by-step methodology
• CAM Leakage Guide — Finding underbilled expenses