Multi-unit franchise operators face a compounding problem: every location generates a CAM reconciliation every year, audit windows are running on each one independently, and the administrative burden of reviewing all of them simultaneously is prohibitive.
The answer isn't to audit everything at once. It's to rank locations by expected recovery potential and audit window urgency, then work through the list in priority order.
Step 1: Build the Portfolio CAM Matrix
Start with a simple spreadsheet. One row per location, one column per data point:
- Location identifier (address or unit number)
- Lease commencement date
- Current lease year
- Years remaining in current term
- Annual CAM billed (last 3 years)
- CAM per RSF (rentable square feet) for each year
- Landlord entity (flag if same landlord across multiple locations)
- Date last reconciliation received
- Audit window expiration per year (calculate from reconciliation delivery date and lease audit rights clause)
- Audit status (not started, in progress, dispute filed, resolved)
This matrix is your operations dashboard for the portfolio CAM review. It tells you at a glance what the exposure is, where the urgency is highest, and which locations share common landlords.
Step 2: Calculate CAM Per RSF and Flag Outliers
With the matrix populated, calculate CAM per RSF for each location for each of the last 3 years. This normalizes the comparison across locations of different sizes.
Flag any location where:
- CAM per RSF has increased more than 10% in any single year
- CAM per RSF is more than 20% higher than your portfolio median
- CAM per RSF increased in a year when the landlord had a management transition
These flags don't prove overcharges. They identify the locations where overcharges are most likely and the absolute dollar exposure is highest. That's your audit priority list.
Step 3: Apply the Landlord Portfolio Filter
Check your matrix for landlord entity patterns. If 4 of your 10 locations are owned by the same landlord entity — or managed by the same property management company — those locations have correlated risk.
Property management companies apply standardized calculation methodologies across all properties they manage. When that methodology doesn't match the lease-specific provisions of any single tenant, the same error shows up across all affected locations. You audit one, you've effectively surfaced the error for all of them.
This is one of the highest-value patterns in multi-unit portfolio auditing: one finding at a same-landlord location is strong evidence that the same error exists at all same-landlord locations, even before you've audited them. Flag these locations as high priority regardless of their individual CAM trend, because the correlated error multiplier increases total recovery potential.
Step 4: Check Audit Window Status for Each Open Year
This is the urgency filter. Sort your matrix by the audit window expiration date for each open reconciliation year. Any location or year where the audit window expires within 90 days is an emergency — audit it now, regardless of its recovery ranking.
The audit window is a hard deadline. A year-3 overcharge at a location with modest recovery potential is still worth auditing if the window is closing. A year-1 overcharge at a high-recovery location can wait 6 months if the window has 2 years remaining.
Urgency tier structure:
- Tier 1: Window expires within 90 days — audit now
- Tier 2: Window expires in 90–180 days — audit within 60 days
- Tier 3: Window expires in 180+ days — schedule within the current quarter
- Tier 4: Window is not open (expired or not yet triggered) — document and move on
Step 5: Rank by Expected Recovery Potential
Within each urgency tier, rank by recovery potential. Expected recovery is a function of:
- Annual CAM pool size (larger pool = larger absolute overcharge for same percentage error)
- Number of open audit years (more open years = more recoverable)
- Landlord portfolio overlap (correlated error multiplier applies)
- Prior-year trend flags (higher probability of finding errors)
A location with a $150,000 CAM pool, 3 open years, and a management fee trend flag has much higher expected recovery potential than a location with a $40,000 pool, 1 open year, and flat CAM trend.
This ranking doesn't need to be precise. You're not calculating exact recovery amounts — you're prioritizing where to spend audit effort first. Rough expected recovery tiers are sufficient.
Working Through a 10-Location Portfolio in 2–3 Weeks
With your priority ranking established, the workflow is:
Week 1: Upload the top 3 Tier-1 (closing window) locations to CAMAudit. Review findings, quantify overcharges. If findings are material ($3,000+), draft and send dispute letters for those locations.
Week 2: Upload the next 3–4 priority locations (Tier 2 plus any high-pool Tier 3 locations). Review findings. Note any same-landlord findings that indicate portfolio-wide errors.
Week 3: Address same-landlord portfolio errors — audit the remaining same-landlord locations to confirm whether the correlated error is present. Draft portfolio-level dispute letters where the same error appears across multiple locations.
The key discipline: don't wait to receive responses from Week 1 disputes before proceeding to Week 2 audits. The audit and dispute process runs in parallel. You're not waiting for resolution — you're building the full dispute inventory.
The CFO Lens: CAM Recovery as a Recurring Line Item
For operators with 6+ locations, CAM audit activity should be built into the annual calendar rather than treated as an ad-hoc project. The pattern repeats every year: reconciliations arrive, they need to be reviewed, audit windows are running, and recovery potential compounds with each deferred year.
Build it as a quarterly process: Q1 (February–April) is reconciliation season. Q2 is the primary audit and dispute window. Q3 is follow-up and resolution. Q4 is renewal analysis for locations with near-term expiration.
That cadence treats CAM recovery as a managed revenue line — not as a problem you get to when you have time.
Upload your first location now. The portfolio review starts with a single reconciliation.
Frequently Asked Questions
Do I need separate audits for each location, or can I batch them?
Each location is a separate lease, so each generates a separate audit. CAMAudit processes each reconciliation individually. The portfolio prioritization framework tells you which ones to audit first, not whether they can be combined.
What if different locations have different lease audit rights windows?
That's common. The audit window is a lease-specific provision. Build the expiration date for each location into your portfolio matrix and treat them independently. Don't assume all your leases have the same window.
If I find the same error at a same-landlord location, can I use one dispute to cover all of them?
No. Each lease is a separate contract and requires a separate dispute filed under that lease's audit rights provision. You can reference the other locations as pattern evidence in your dispute letters, but each must stand independently.
How do I handle a location where I don't have the full 3 years of reconciliations?
Request the missing reconciliations in writing from your landlord. You're entitled to them. In the meantime, audit what you have — findings in available years are recoverable regardless of whether you have all years.
Is it worth auditing a location that's closing or not being renewed?
Yes, if the audit window is still open. Credits can be negotiated as part of lease termination discussions, and overcharges during the operating term are recoverable regardless of whether you're renewing. Don't leave money on the table at expiration.