CAM Billing KPIs Every Property Controller Should Track
The Four Numbers
Most property controllers can tell you their building's NOI, vacancy rate, and average rent per square foot. Ask about their CAM recovery ratio or reconciliation cycle time and you'll get a blank stare.
These four KPIs measure whether your reconciliation process is actually working — or just producing statements.
1. Recovery Ratio
Formula: Total CAM Billed / Total Recoverable Operating Expenses
What it measures: How much of what you're entitled to bill you actually bill.
How to calculate:
- Start with total building operating expenses from the GL
- Subtract capital expenditures (non-recoverable)
- Subtract lease-excluded items
- That's your recoverable pool (denominator)
- Sum all CAM charges billed to tenants (numerator)
- Divide
Benchmarks:
| Property Type | Target | Red Flag |
|---|---|---|
| NNN Office | 85–95% | Below 80% |
| Full-Service Gross | 50–70% | Below 45% |
| Retail Center | 80–90% | Below 75% |
| Industrial | 90–98% | Below 85% |
Why it matters: Every percentage point of recovery on a $1.1M expense pool is $11,000 per year. At a 6% cap rate, that's $183,333 in property value.
Common causes of low recovery:
- GL accounts not mapped to recovery pools
- CapEx over-exclusion (recoverable maintenance coded as capital)
- Gross-up not applied at low occupancy
- New expense categories not added to billing
- Anchor exclusions reducing the billable base
2. Dispute Rate
Formula: Number of Tenant Disputes / Number of Reconciliation Statements Sent × 100
What it measures: How often tenants challenge your reconciliation.
How to calculate: Count any tenant communication that questions or contests a CAM charge — from informal questions to formal audit requests.
Benchmarks:
| Level | Dispute Rate | Interpretation |
|---|---|---|
| Excellent | < 5% | Clean statements, good communication |
| Acceptable | 5–15% | Normal range for multi-tenant buildings |
| Concerning | 15–25% | Process or communication problems |
| Critical | > 25% | Billing errors likely; audit risk high |
Why it matters: Each dispute costs 4–8 hours of controller time to research and resolve. A formal tenant audit costs 20–40 hours. At $75/hour fully loaded, a 20% dispute rate on a 50-tenant building (10 disputes) costs $3,000–$6,000 in labor — before any financial adjustments.
Common causes of high dispute rates:
- Late statement delivery (statements arriving 6+ months after year-end)
- Large year-over-year increases without explanation
- Missing or insufficient backup documentation
- Errors visible on the face of the statement (math mistakes, wrong SF)
- No cover letter explaining material changes
3. Cycle Time
Formula: Days from fiscal year-end to final reconciliation statement delivery
What it measures: How long your reconciliation process takes.
How to calculate: Use the date the last tenant's statement is delivered (not the first). If your fiscal year ends December 31 and the last statement goes out April 15, your cycle time is 105 days.
Benchmarks:
| Level | Cycle Time | Context |
|---|---|---|
| Best-in-class | < 75 days | Automated systems, clean year-end close |
| Good | 75–90 days | Well-organized manual process |
| Acceptable | 90–120 days | Industry standard |
| Concerning | 120–180 days | Late vendor invoices or process bottlenecks |
| Critical | > 180 days | Lease deadline risk, audit exposure extension |
Why it matters: Late delivery extends your audit exposure window, delays cash collection, and damages tenant trust. In California, SB 1103 creates additional compliance risk for late reconciliation.
A 20-building portfolio with a 150-day average cycle time has $300,000+ in delayed receivables (assuming $15K average true-up per building).
Common causes of long cycle times:
- Slow year-end GL close
- Late vendor invoices (snow removal, holiday security, Q4 maintenance)
- Insufficient staffing during reconciliation season
- Serial processing (one building at a time) instead of parallel
- Manual spreadsheet processes that can't be parallelized
4. Error Rate
Formula: Number of Amended Reconciliation Statements / Total Statements Sent × 100
What it measures: How often you have to correct and resend statements.
How to calculate: Count every statement that required amendment after delivery — whether the error was caught internally, by the tenant, or by an auditor.
Benchmarks:
| Level | Error Rate | Interpretation |
|---|---|---|
| Excellent | < 2% | Strong QA process |
| Acceptable | 2–5% | Normal for manual processes |
| Concerning | 5–10% | QA process needs improvement |
| Critical | > 10% | Systemic process failure |
Why it matters: Amended statements destroy credibility. A tenant who receives a corrected statement (especially one that reduces their charge) will audit every future statement. The auditor knows you've had problems.
Common causes of high error rates:
- No second-person review before delivery
- Stale lease abstracts (wrong SF, caps, base years)
- Formula errors in inherited spreadsheets
- Mid-year lease events not reflected (expansions, terminations)
- Year-end accrual adjustments posted after statements were generated
Building a Dashboard
Track all four KPIs at the property level, quarterly:
| Property | Recovery Ratio | Dispute Rate | Cycle Time | Error Rate |
|---|---|---|---|---|
| Building A | 92% | 8% | 95 days | 2% |
| Building B | 87% | 15% | 130 days | 6% |
| Building C | 95% | 3% | 80 days | 0% |
| Portfolio Avg | 91% | 9% | 102 days | 3% |
Building B in this example is the problem child: below-target recovery, above-average disputes, slow cycle time, and elevated errors. It's the first building to self-audit.
Year-over-year trends matter more than absolute numbers. A recovery ratio declining from 93% to 88% over two years signals a growing problem — even though 88% is still within the acceptable range.
How CapVeri Affects These KPIs
| KPI | Manual Process | With CapVeri |
|---|---|---|
| Recovery ratio | 80–90% typical | 90–96% (catches missed recovery) |
| Dispute rate | 10–20% typical | < 5% (errors caught before delivery) |
| Cycle time | 90–150 days | 45–90 days (calculation automated) |
| Error rate | 3–8% typical | < 1% (systematic validation) |
The improvement comes from automation of the detection step — finding errors before they reach tenants, not from changing the math.
Related Resources
- Recovery Ratio Analysis — Deep dive on the #1 KPI
- CAM Reconciliation Timeline — Optimize cycle time
- Self-Audit CAM Billing — Reduce error rate
- Transparent CAM Billing — Reduce dispute rate