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

The Manual Process (And Why It's Broken)

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

1. Open last year's estimate letter template in Word
2. Pull the tenant's data from the reconciliation workbook
3. Manually update: tenant name, suite, old estimate, new estimate, effective date
4. Calculate the monthly amount (annual estimate / 12)
5. Review the letter for errors
6. Print, sign, and mail (or PDF and email)
7. 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:

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

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

Sources

1. Fiserv: Reconciliation whitepaper
2. J.P. Morgan: What Are CAM Charges in CRE?