Presenting CAM Reconciliation Results to Ownership and Asset Managers
The Communication Gap
Property controllers speak in GL accounts, pro-rata shares, and gross-up percentages. Asset managers and ownership groups speak in NOI, cap rates, and value per SF. The gap between these languages is where miscommunication — and missed opportunities — live.
A controller who reports "CAM reconciliation is complete, 47 statements sent, 3 credits issued" has given ownership zero actionable information. A controller who reports "Recovery ratio improved 2.3 points to 91.4%, adding $25,300 to NOI — equivalent to $421,667 in property value at our current cap rate" has made the case for every hour spent on reconciliation.
This article covers how to build reporting that bridges that gap.
The Executive Summary: One Page, Five Numbers
Every CAM reporting package to ownership should start with a one-page summary containing five numbers:
| Metric | Current Year | Prior Year | Change |
|---|---|---|---|
| Total recoverable operating expenses | $1,141,833 | $1,072,000 | +6.5% |
| Total CAM billed to tenants | $1,043,555 | $941,280 | +10.9% |
| Recovery ratio | 91.4% | 87.8% | +3.6 pts |
| Net true-up impact (amount due from tenants) | $62,200 | $94,800 | ($32,600) |
| Open disputes | 2 ($18,400 exposure) | 5 ($47,200 exposure) | Improved |
Why these five numbers:
- Total recoverable expenses tells ownership what the building costs to operate and whether costs are growing faster than revenue.
- Total CAM billed shows how much of those costs tenants are covering.
- Recovery ratio is the efficiency metric — are we capturing what we're entitled to?
- Net true-up impact tells ownership how much incremental cash to expect in Q1/Q2 and whether estimates were set accurately.
- Open disputes quantifies the risk of having to refund or write off billed amounts.
Recovery Ratio Trending
A single year's recovery ratio is a data point. Three to five years of trending tells a story.
Example — Westpark Tower portfolio recovery trending:
| Year | Recoverable Expenses | CAM Billed | Recovery Ratio | NOI Impact of Gap |
|---|---|---|---|---|
| 2022 | $985,000 | $817,550 | 83.0% | ($167,450) |
| 2023 | $1,020,000 | $877,200 | 86.0% | ($142,800) |
| 2024 | $1,072,000 | $941,280 | 87.8% | ($130,720) |
| 2025 | $1,141,833 | $1,043,555 | 91.4% | ($98,278) |
The narrative: Over four years, the recovery gap narrowed by $69,172 annually. At a 6% cap rate, that $69,172 improvement represents $1,152,867 in added property value. The improvement came from three specific fixes: correcting GL mapping gaps (2023), applying gross-up at actual occupancy (2024), and adding previously excluded recoverable categories (2025).
This is the kind of reporting that gets a controller noticed by ownership — and that justifies investment in better reconciliation tools and processes.
Variance Explanations for Non-Accountants
Asset managers don't want to see a 30-row GL account comparison. They want to know three things: What went up? What went down? Why?
Format that works:
Expenses That Increased Materially
| Category | Change | Per SF Impact | Cause |
|---|---|---|---|
| HVAC Maintenance | +$49,500 (+55.6%) | +$0.41/SF | Compressor replacement on RTU-3 (reclassified from R&M to CapEx — removed from CAM pool) |
| Janitorial | +$18,200 (+11.7%) | +$0.15/SF | New vendor contract at market rates; prior vendor 15% below market |
| Property Taxes | +$16,000 (+5.0%) | +$0.13/SF | County reassessment; appeal filed, hearing scheduled Q3 |
Expenses That Decreased
| Category | Change | Per SF Impact | Cause |
|---|---|---|---|
| Utilities — Electric | ($12,000) (5.7%) | ($0.10)/SF | LED retrofit completed Q2; full-year savings expected at $18,000 |
Key principle: Lead with the cause, not the number. "County reassessment" is actionable information. "$16,000 increase" is not.
Dispute Reporting
Disputes are risk. Ownership needs to know the exposure, the timeline, and the likely outcome.
Dispute summary format:
| Tenant | SF | Dispute Amount | Category | Status | Expected Outcome |
|---|---|---|---|---|---|
| Meridian Partners LLC | 8,200 | $12,400 | CapEx classification | Under review | Likely valid — recommend $8,200 credit |
| DataFlow Inc. | 4,500 | $6,000 | Gross-up methodology | Responded | No merit — gross-up per lease Section 8.3 |
Total dispute exposure: $18,400 Expected resolution cost: $8,200 (credit to Meridian) Expected retained: $10,200
For each dispute, ownership wants to know: Is this a real error we need to fix, or a negotiating tactic we need to push back on? Your recommendation matters — make one.
True-Up Cash Flow Impact
True-up invoices are a cash flow event. Ownership needs to know when the money arrives and how much to expect net of credits and disputes.
True-up summary:
| Category | Amount |
|---|---|
| Gross true-up invoiced | $78,400 |
| Less: credits issued (3 tenants) | ($16,200) |
| Net true-up billed | $62,200 |
| Less: disputed amounts (pending) | ($18,400) |
| Less: estimated uncollectible | ($3,100) |
| Expected net collection | $40,700 |
| Expected collection period | 45–90 days |
Compare this to the prior year: if last year's true-up was $94,800 and this year's is $62,200, it means estimates were more accurate — tenants paid closer to actuals throughout the year, reducing the Q1 cash flow spike.
Why this matters to ownership: A $62,200 true-up arriving in March affects Q1 cash flow projections, distribution timing, and operating account balances. Ownership needs this number before it arrives, not after.
Portfolio-Level Reporting
For owners with multiple properties, the property-level data needs to roll up into a portfolio view:
| Property | Recoverable Expenses | Recovery Ratio | YoY Change | True-Up | Disputes |
|---|---|---|---|---|---|
| Westpark Tower | $1,141,833 | 91.4% | +3.6 pts | $62,200 | 2 ($18,400) |
| Meridian Plaza | $890,000 | 93.2% | +1.1 pts | $28,400 | 0 |
| Lakeside Commons | $2,100,000 | 88.5% | -0.8 pts | $142,000 | 4 ($61,200) |
| Gateway Business Park | $680,000 | 94.8% | +2.2 pts | $12,800 | 1 ($4,200) |
| Portfolio Total | $4,811,833 | 91.0% | +1.8 pts | $245,400 | 7 ($83,800) |
The portfolio view immediately highlights Lakeside Commons as the problem property — recovery ratio declining, largest true-up, most disputes. That's where management attention should focus.
Translating to Asset Value Language
The conversion that matters most to ownership: CAM performance to property value.
Formula: NOI impact / Cap rate = Value impact
Example calculations for the board deck:
| Improvement | Annual NOI Impact | Value at 6% Cap | Value at 7% Cap |
|---|---|---|---|
| Recovery ratio +1 point (on $1.14M base) | $11,418 | $190,300 | $163,114 |
| Recovery ratio +3.6 points | $41,106 | $685,100 | $587,229 |
| Eliminating $8,200 in disputed credits | $8,200 | $136,667 | $117,143 |
| Accurate budgeting (-$32,600 in true-ups) | $0 (cash timing only) | $0 | $0 |
Note that the last line is intentionally $0 — accurate budgeting doesn't change NOI, it changes cash timing. Being honest about what does and doesn't create value builds credibility with ownership.
Reporting Cadence
| Timing | Report | Content |
|---|---|---|
| Q1 (post-reconciliation) | Annual CAM Results | Full package: executive summary, variance memo, dispute log, true-up schedule |
| Q2 | Collection Update | True-up collection status, dispute resolutions, any audit requests received |
| Q3 | Mid-Year Estimate Review | Are current estimates tracking actual? Any mid-year adjustments needed? |
| Q4 | Budget and Estimate Proposal | Next year's budget, proposed estimates, expected recovery ratio |
Common Mistakes in Ownership Reporting
Reporting data without interpretation. "Janitorial increased 11.7%" is data. "Janitorial increased 11.7% due to market-rate contract renewal; fully recoverable, no cap impact" is information.
Burying bad news. If there's a dispute with material exposure or an error that requires credits, lead with it. Ownership hates surprises more than they hate problems.
Ignoring the denominator. Reporting total dollars without per-SF context makes year-over-year comparison meaningless when occupancy changes.
Not connecting to NOI. Every number in the report should be traceable to its NOI impact. If it doesn't affect NOI, it probably doesn't belong in the executive summary.
How CapVeri Supports Ownership Reporting
CapVeri generates the data underlying every section of this reporting package — recovery ratios, variance analysis, true-up calculations, and dispute tracking. The platform produces per-property and portfolio-level metrics that export directly into your ownership reporting format. Instead of spending 8–12 hours per property assembling reconciliation data into presentable reports, you get the numbers automatically and spend your time on interpretation and recommendations.
Related Resources
- CAM Billing KPIs — The four metrics every controller should track
- Recovery Ratio Analysis — Deep dive on the most important ownership metric
- CAM Variance Analysis — Building the variance explanations ownership needs
- Defensible Reconciliation Package — Documentation that supports your numbers