Training Property Accountants on CAM Reconciliation: A 90-Day Plan

Why CAM Training Is Broken

Most property accounting hires learn CAM reconciliation the same way: they're handed a binder of last year's statements, told "do it like this," and left to figure it out. The prior year's work becomes the template — including whatever errors were in it. When the experienced accountant who built those statements leaves, institutional knowledge walks out the door.

The result is predictable: errors compound, leases get misread, and nobody can explain why the reconciliation works the way it does. The new accountant can produce a statement that looks right but can't defend it in a tenant audit because they don't understand the underlying logic.

A structured training program fixes this. It takes 90 days, it requires time from a senior team member, and it pays for itself the first time a new hire catches an error that would have become a tenant credit.

Prerequisites: What the New Hire Should Already Know

This training plan assumes the new property accountant has:

• A bachelor's degree in accounting or equivalent experience
• Familiarity with double-entry bookkeeping and GL structure
• Basic proficiency in Excel (formulas, pivot tables, VLOOKUP)
• Experience with at least one accounting system (Yardi, MRI, or similar)
• No prior CAM reconciliation experience (the plan works for experienced hires too — they'll move through weeks 1–4 faster)

Phase 1: Foundation (Days 1–30)

Week 1: Industry and Lease Fundamentals

Objective: Understand why CAM exists and how leases create the obligation.

Topics:

• Commercial lease structures: NNN, modified gross, full-service gross
• What "additional rent" means and how it differs from base rent
• The concept of operating expense recovery — tenants pay their share of building costs
• How CAM fits into the building's financial structure (revenue vs. cost recovery)
• The difference between estimates (monthly payments) and reconciliation (annual true-up)

Exercises:

1. Read three actual leases from the portfolio — one NNN, one modified gross, one full-service gross. For each lease, identify: (a) which expenses are recoverable, (b) the tenant's pro-rata share, (c) any caps or exclusions, (d) the base year (if applicable), (e) the admin fee structure.

2. Create a lease abstract for each lease in a standard template. Compare to the existing abstract on file. Identify any discrepancies.

Assessment: Can the new hire explain, in plain language, what a tenant owes and why? Can they point to the lease section that creates the obligation?

Week 2: GL Structure and Expense Classification

Objective: Understand how building expenses flow from invoices to the GL to CAM pools.

Topics:

• The building's chart of accounts — which GL ranges map to which expense categories
• Operating expenses vs. capital expenditures (the CapEx distinction)
• Common classification errors (HVAC replacement coded to R&M, tenant-specific costs in common area accounts)
• How GL data feeds the reconciliation calculation
• Gross-up: why it exists and when it applies

Exercises:

1. Review the prior year's GL detail for one building. Identify every account that flows into the CAM pool and every account that's excluded. Document the mapping.

2. Find three invoices over $10,000 in the R&M accounts. For each, determine whether the expense is properly classified as operating or should be capital. Write a one-paragraph justification.

3. Calculate a simple gross-up: building has $180,000 in variable janitorial expenses, 75% occupancy, and the lease requires gross-up to 95%. What's the grossed-up amount? ($180,000 / 0.75 x 0.95 = $228,000)

Assessment: Can the new hire trace an invoice from receipt to GL posting to CAM pool inclusion? Can they explain why a specific expense is or isn't recoverable?

Week 3: The Reconciliation Calculation

Objective: Understand the math behind a CAM reconciliation statement.

Topics:

• Building the expense pool: total expenses less exclusions
• Calculating pro-rata share: tenant SF / building SF (and why the denominator matters)
• Applying caps (cumulative and non-cumulative)
• Base year calculations and expense stops
• Admin/management fee calculation methods
• Determining the true-up: actual obligation less estimates collected

Exercises:

1. Manual calculation exercise. Given the following inputs, calculate Tenant A's CAM true-up:

   • Building total recoverable expenses: $1,100,000
   • Tenant A premises: 5,500 SF
   • Building rentable area: 110,000 SF
   • Tenant A's pro-rata share: 5.0%
   • Tenant A's annual CAM estimate paid: $51,000
   • Tenant A's cap: 5% non-cumulative over prior year
   • Prior year CAM per SF: $9.50
   • Admin fee: 15% of CAM pool

   Solution: CAM pool = $1,100,000. Admin fee = $165,000. Total recoverable pool = $1,265,000. Per SF = $11.50. Cap = $9.50 x 1.05 = $9.975/SF. Tenant is capped. Tenant A obligation = $9.975 x 5,500 = $54,862.50. True-up = $54,862.50 - $51,000 = $3,862.50.

2. Repeat with three actual tenants from a completed reconciliation. Compare results to the prior year's statements. Results should match within rounding.

Assessment: Can the new hire produce a correct reconciliation calculation by hand? Do they understand why the cap limited the tenant's obligation in the exercise above?

Week 4: Systems Training

Objective: Learn to use the property management system for reconciliation.

Topics:

• Running GL reports filtered by property and date range
• Pulling rent rolls with current tenant SF and lease terms
• Entering or verifying recovery pool setup
• Running the system's reconciliation module (if applicable)
• Exporting data for manual calculation or review
• Uploading data to CapVeri (if applicable)

Exercises:

1. Pull the GL detail for one building for the most recent fiscal year. Export to Excel. Reconcile the total to the system's trial balance.

2. Pull the rent roll. Verify three tenants' square footage and lease dates against the actual lease document.

3. Run the system's reconciliation calculation for one building. Compare the output to the manually calculated results from Week 3.

Assessment: Can the new hire navigate the system independently to extract the data needed for reconciliation?

Phase 2: Supervised Practice (Days 31–60)

Weeks 5–6: Shadow a Reconciliation

The new hire works alongside a senior accountant on an actual reconciliation (or a recent one being re-run for training purposes).

Activities:

• Senior accountant narrates each step as they work through the reconciliation
• New hire takes notes and asks questions
• New hire reviews and validates the GL data independently
• New hire calculates three tenants and compares to the senior's results
• Discuss any discrepancies — understand whether the new hire's error or a legitimate difference

Weeks 7–8: Complete a Reconciliation with Oversight

The new hire completes a full building reconciliation independently, but the senior accountant reviews every output before anything is sent.

Review checklist for the senior:

Expected outcome: The first solo reconciliation will have 3–5 errors that the review catches. This is normal. The review is the training — walking through each error and explaining the correct approach builds understanding faster than classroom instruction.

Phase 3: Independent Work with QA (Days 61–90)

Weeks 9–12: Solo Reconciliation with QA Review

The new hire completes reconciliations independently for 2–3 buildings. A senior accountant performs a QA review of the output, but the new hire is responsible for the work product.

QA review shifts from "check everything" to "spot check and validate":

• Verify the top 5 expense categories by dollar amount
• Check 3–4 tenant calculations (including at least one with a cap and one with a base year)
• Review the variance memo
• Confirm the statement format and arithmetic
• Ask the new hire to explain any variance over 10%

By the end of week 12, the new hire should be able to:

1. Complete a reconciliation for a standard multi-tenant building (15–25 tenants) in 12–18 hours
2. Read a lease and correctly identify all CAM-relevant provisions
3. Explain the difference between cumulative and non-cumulative caps
4. Apply gross-up adjustments correctly
5. Produce a variance memo identifying material year-over-year changes
6. Respond to basic tenant questions about the reconciliation
7. Know when to escalate (complex lease provisions, tenant disputes, potential errors)

Ongoing Development (After Day 90)

The 90-day plan gets a new hire to competence. Mastery takes 2–3 full reconciliation cycles (years).

Year 1 development goals:

• Complete first full year-end reconciliation cycle with QA support
• Handle 3–5 tenant inquiries independently
• Participate in at least one tenant audit (as observer or supporting role)
• Cross-train on a second property management system

Year 2 development goals:

• Complete reconciliation cycle with minimal QA
• Lead response to tenant audit requests
• Train new hires using this framework
• Identify and implement one process improvement

Common Training Failures

"Just follow last year's spreadsheet." This teaches procedure without understanding. The new hire can replicate the template but can't adapt when lease terms change, tenants move in/out, or expenses shift between categories.

No lease reading. A property accountant who has never read the actual lease is billing tenants based on someone else's interpretation. When that interpretation is wrong, the errors propagate indefinitely.

No manual calculation. If the new hire has only used the system's automated reconciliation module, they can't validate the output or troubleshoot when numbers look wrong. Every property accountant should be able to calculate a reconciliation by hand in Excel.

No QA review of early work. The first 3–5 reconciliations a new hire produces will have errors. If those go out to tenants without review, you've created disputes and potentially legal exposure. The QA investment in months 2–3 pays for itself permanently.

Building a Training Library

Maintain these reference materials for new hires:

How CapVeri Supports Training

CapVeri provides a structured, auditable reconciliation workflow that enforces the correct calculation methodology. New hires can see exactly how each tenant's charge is calculated — which expenses are in the pool, how the pro-rata share is determined, whether a cap applies, and what the true-up amount is. The platform's validation checks catch common errors (wrong denominator, missing gross-up, cap miscalculation) in real time, providing immediate feedback during the learning process. Instead of discovering errors during QA review weeks later, the new hire learns from the error at the moment it happens.

Related Resources

• What Is CAM Reconciliation? — Foundational overview for new hires to read on day one
• GL Coding Guide for CAM — Detailed reference for expense classification
• CAM Pre-Send Checklist — The QA checklist used in Phase 2 and 3 reviews
• Top 15 CAM Billing Errors — Common mistakes to watch for during training