When should CAM estimates be adjusted?

CAM estimates should be adjusted at least annually based on the prior year's reconciliation results. Mid-year adjustments are appropriate when actual expenses are tracking more than 10% above or below estimates, when a major expense event occurs (tax reassessment, insurance renewal, new service contract), or when a significant lease event changes the building's pro-rata denominator.

What information must an estimate adjustment letter include?

At minimum: the tenant's name and suite, the current monthly estimate amount, the new monthly estimate amount, the effective date of the change, and the reason for the adjustment. Best practice also includes the per-SF rate, the annual total, and a reference to the lease section authorizing estimate adjustments.

Automating CAM Estimate Letters: Stop Spending 3 Days on Mail Merge

By Angel Campa·Founder, CapVeriUpdated March 17, 20264 min read

The Manual Process (And Why It's Broken)

Here's how most controllers generate estimate adjustment letters after annual reconciliation:

Open last year's estimate letter template in Word
Pull the tenant's data from the reconciliation workbook
Manually update: tenant name, suite, old estimate, new estimate, effective date
Calculate the monthly amount (annual estimate / 12)
Review the letter for errors
Print, sign, and mail (or PDF and email)
Repeat for every tenant

For a single building with 15 tenants: 15 × 15 minutes = 3.75 hours.

For a 5-building portfolio with 60 tenants: 60 × 15 minutes = 15 hours (nearly 2 full business days).

For a 20-building portfolio: 3-4 full business days of letter generation.

The problem isn't just the time. It's the error rate. When you're manually copying numbers from one document to another 60 times in a row, transposition errors are inevitable. Tenant A gets Tenant B's estimate. Suite 400 shows Suite 300's rate. The annual total doesn't match the monthly amount times 12.

Each error requires a correction letter, an apology, and 30 minutes of rework.

The Systematic Approach

Step 1: Build a Data Source

Instead of pulling numbers from the reconciliation workbook ad hoc, create a single data table that feeds the letter generation:

Property	Tenant	Suite	SF	Old Monthly	New Monthly	New Annual	New PSF	Effective Date	Reason
Building A	Acme Corp	200	5,000	$2,708	$2,917	$35,000	$7.00	2026-04-01	Annual adjustment per 2025 reconciliation
Building A	Beta LLC	300	8,500	$4,604	$5,100	$61,200	$7.20	2026-04-01	Annual adjustment per 2025 reconciliation

Build validation into the table:

New Annual = New Monthly × 12 (formula check)
New PSF = New Annual / SF (formula check)
All required fields populated (no blanks)
Effective date is consistent across all tenants in the same building

Step 2: Create a Template With Merge Fields

Build one letter template with merge fields that map to your data source. The template should include:

[Date]

[Tenant Name] [Suite Address]

Re: [Property Name] — Operating Expense Estimate Adjustment

Dear [Tenant Contact],

Effective [Effective Date], your monthly estimated operating expense contribution will be adjusted from $[Old Monthly] to $[New Monthly] ($[New PSF] per square foot annually, totaling $[New Annual] for the year).

This adjustment reflects the [Year] actual operating expense reconciliation results and projected [Year+1] operating costs. The primary drivers of the change are:

[Reason line 1]
[Reason line 2 if applicable]

This adjustment is made pursuant to Section [Lease Section] of your lease agreement dated [Lease Date].

If you have questions, please contact [Controller Name] at [Email] or [Phone].

Sincerely,

[Controller Name] [Title]

Step 3: Batch Generate and Validate

Use your property management system's mail merge capability, or a simple script that reads the data table and populates the template. Most PMS platforms (Yardi Voyager, MRI Software) have built-in letter generation for estimate adjustments.

After generation, run a batch validation:

Spot-check 3-5 letters against the data table
Verify monthly × 12 = annual on each letter
Confirm tenant names match the rent roll
Ensure effective dates are correct

Step 4: Deliver and Record

Email is faster and creates a delivery record. PDF the letters and email them to the contact on file. BCC the property manager and controller email for records.

Log the delivery: date sent, method (email/mail), and the estimate amounts. This becomes your reference when the next reconciliation compares estimates to actuals.

Time Comparison

Task	Manual	Systematic
Data preparation	2 hours (pulling from multiple sources)	30 min (reconciliation feeds the table)
Letter generation (60 tenants)	15 hours	30 min (batch merge)
Review and validation	3 hours	1 hour (spot-check + formula validation)
Delivery	2 hours (print, fold, mail)	30 min (batch email)
Total	22 hours	2.5 hours

The systematic approach is 9x faster. More importantly, the error rate drops from 3-5% (manual copying) to near zero (formula-driven merge).

When to Adjust Mid-Year

Annual adjustments happen after reconciliation. But mid-year adjustments are appropriate when:

A property tax reassessment adds more than $0.50/SF to expenses
Insurance renewal increases premiums by more than 15%
A major tenant vacates, changing occupancy by more than 10 points
A significant unbudgeted expense occurs (emergency repair, new regulation compliance)

Use the same systematic process for mid-year adjustments. Update the data table, generate the letters, and include a brief explanation of why the adjustment is happening outside the normal cycle.

Related Resources

CAM Estimate Forecasting — Setting accurate estimates from the start
Mid-Year CAM True-Up — When and how to adjust mid-year
Reconciliation Cover Letter Template — The cover letter that prevents disputes
CAM Reconciliation Timeline — Fitting estimates into the annual cycle