Training Property Accountants on CAM Reconciliation
Why CAM Training Breaks Down
Most property accountants do not struggle with CAM because the arithmetic is hard. They struggle because the calculation sits at the intersection of lease language, GL coding, rentable-area denominators, recovery pools, estimates, true-ups, caps, exclusions, and tenant communication.
BOMA's Revenue Administration MicroCredential describes CAM reconciliation as the annual process of calculating CAM expenses, comparing them with tenant payments, and determining whether tenants overpaid or underpaid. BOMA's budgeting and accounting course also lists recoverable and nonrecoverable operating expenses, lease abstracts, budget variances, tenant communications, rent rolls, and CAM reconciliations as training topics.
That is the right shape of the curriculum. A new property accountant needs more than last year's spreadsheet. They need to understand why each charge exists, where it came from, and how to defend it if a tenant asks.
This 90-day plan is a practical onboarding framework. It is not an industry credential. Use BOMA and IREM coursework for formal education, then use this plan to turn the concepts into portfolio-specific production work.
Before Day 1: Set Up the Training Materials
Do not start with a blank folder. Before the new hire begins, prepare:
| Material | Why It Matters |
|---|---|
| Three prior-year reconciliation packages | Shows final output, variance explanations, and tenant statement format |
| Lease abstract template | Forces lease terms into a consistent review format |
| GL-to-CAM-pool mapping | Shows which accounts feed each recovery pool |
| Manual calculation template | Teaches the math behind system output |
| QA checklist | Gives the senior reviewer a repeatable review path |
| Escalation guide | Tells the new hire when to ask for legal, asset management, or senior accounting input |
The goal is not to make the new hire memorize every edge case. The goal is to teach the control points they must never skip.
Phase 1: Foundation (Days 1-30)
Week 1: Lease and Recovery Basics
Goal: Understand why a tenant owes CAM and where the lease creates the obligation.
Cover:
- NNN, modified gross, and full-service gross structures
- Base rent vs. additional rent
- Recoverable vs. nonrecoverable expenses
- Pro-rata share language
- Caps, exclusions, expense stops, base years, and admin fees
- Estimate billing vs. annual reconciliation
Exercise:
- Read one NNN lease, one modified gross lease, and one full-service gross lease from the portfolio.
- For each lease, identify the recoverable expense clause, tenant share, denominator, caps, exclusions, base year or expense stop, and admin fee language.
- Compare the new abstract to the existing abstract on file.
Assessment: Can the new hire explain what the tenant owes, why the tenant owes it, and which lease clause supports the answer?
Week 2: GL Flow and Expense Classification
Goal: Trace expenses from invoice to GL account to CAM pool.
Cover:
- Property chart of accounts
- Revenue and expenditure cycles
- Operating expenses vs. capital expenditures
- Tenant-specific charges vs. shared common-area charges
- GL account mapping to recovery pools
- Variance explanations for large year-over-year changes
BOMA's budgeting and accounting course specifically calls out record-keeping, revenue and expenditure cycles, financial statements, lease abstracts, income and expense budgeting, recoverable and nonrecoverable operating expenses, capital expenditures, and budget variance explanations. Those are not separate from CAM training. They are the accounting base CAM depends on.
Exercise:
- Pull prior-year GL detail for one building.
- Map each recoverable account to a CAM pool.
- Pick five large invoices and document why each is recoverable, excluded, capital, or tenant-specific.
Assessment: Can the new hire explain why a cost belongs in or out of the pool?
Week 3: Manual CAM Calculation
Goal: Calculate a tenant true-up without relying on the system module.
Cover:
- Building the recoverable expense pool
- Applying exclusions
- Calculating tenant share
- Applying caps
- Applying base year or expense stop language
- Deducting estimates paid
- Preparing the true-up amount
Manual exercise:
- Building recoverable expenses: $1,100,000
- Tenant premises: 5,500 SF
- Building denominator: 110,000 SF
- Tenant share: 5.0%
- Estimates paid: $51,000
- Prior-year CAM: $9.50/SF
- Non-cumulative cap: 5%
- Admin fee: 15% of CAM pool
Calculation:
- Admin fee = $1,100,000 x 15% = $165,000
- Recoverable pool = $1,265,000
- Uncapped CAM = $1,265,000 / 110,000 SF = $11.50/SF
- Cap = $9.50 x 1.05 = $9.975/SF
- Tenant obligation = $9.975 x 5,500 SF = $54,862.50
- True-up = $54,862.50 - $51,000 = $3,862.50
Assessment: Can the new hire explain why the cap changed the billed amount?
Week 4: Systems and Data Extraction
Goal: Pull clean source data from the property management system and reconcile it to control totals.
Cover:
- GL reports by property and fiscal year
- Trial balance tie-out
- Rent roll export
- Lease dates, square footage, and recovery setup
- Recovery pool setup
- System reconciliation module output
- CapVeri upload workflow, if used
Exercise:
- Pull GL detail and reconcile it to the trial balance.
- Pull the rent roll and verify three tenants against lease documents.
- Run the system reconciliation for one building and compare selected tenants to the Week 3 manual template.
Assessment: Can the new hire produce the source files needed for a reviewable reconciliation?
Phase 2: Supervised Practice (Days 31-60)
Weeks 5-6: Shadow a Reconciliation
The new hire works beside a senior accountant on an actual reconciliation or a recent reconciliation rerun for training.
The senior accountant should narrate:
- Which reports are pulled
- Which GL accounts are excluded
- Which lease clauses matter
- Where denominators come from
- Why a cap or gross-up does or does not apply
- How the variance memo is built
The new hire should independently:
- Validate the GL total
- Recalculate three tenants
- Write down each assumption
- Compare their answer to the senior accountant's answer
Weeks 7-8: Build One Reconciliation with Full Review
The new hire completes one full building reconciliation. A senior accountant reviews every output before anything is sent.
Senior review checklist:
| Check | Pass/Fail |
|---|---|
| GL data ties to trial balance | |
| Recoverable accounts match pool mapping | |
| Nonrecoverable and tenant-specific costs are excluded | |
| CapEx items are removed or handled under lease language | |
| Gross-up is applied only where permitted | |
| Tenant denominators match lease terms | |
| Caps are applied per lease terms | |
| Base year or expense stop math is correct | |
| Admin fee matches lease provision | |
| Estimates are deducted correctly | |
| True-up arithmetic is correct | |
| Variances are documented |
Treat this review as training, not just quality control. Every correction should include the lease clause, report, or calculation step that proves the right answer.
Phase 3: Independent Work with QA (Days 61-90)
Weeks 9-12: Solo Reconciliations with Targeted Review
The new hire completes two or three standard building reconciliations. The senior accountant shifts from full review to targeted QA.
Review:
- Top five expense categories by dollar amount
- Three or four tenant calculations
- At least one capped tenant
- At least one base-year or expense-stop tenant, if present
- Variance memo
- Statement format and arithmetic
- Any variance above the team's review threshold
By the end of the period, the new hire should be able to:
- Complete a standard multi-tenant reconciliation with QA review.
- Read a lease and identify CAM-relevant provisions.
- Explain cumulative vs. non-cumulative caps.
- Apply gross-up only when lease language permits it.
- Prepare a variance memo.
- Answer basic tenant questions.
- Escalate unclear lease language or dispute-risk items.
IREM's CAM, tax, and insurance recoveries course frames CAM reconciliation as a necessary process for property managers and property accountants, moving from general ledger adjustment to tenant invoices. That is a useful production model: GL first, lease-controlled calculation next, tenant invoice last.
Ongoing Development After Day 90
The 90-day plan gets the accountant ready for supervised production. Mastery takes more than one reconciliation season.
Year 1 goals:
- Complete the first year-end cycle with QA support
- Handle routine tenant questions
- Observe at least one tenant audit or dispute response
- Cross-train on a second property type or system
Year 2 goals:
- Complete standard reconciliations with limited QA
- Lead first-draft responses to tenant audit requests
- Train a new hire on the manual calculation template
- Improve one repeatable control in the close process
IREM's ACoM certification page describes early-career commercial property management training as covering commercial property accounting, budgeting, capitalization, commercial lease types, and communication with owners, tenants, and investors. CAM training fits inside that broader skill set. It is accounting work, but it is also lease administration and tenant communication.
Common Training Failures
Following last year's spreadsheet without checking the lease. Last year's workbook may contain useful structure, but it is not the source of truth. The lease is.
Skipping manual calculation. If the accountant cannot calculate a tenant true-up by hand, they cannot validate a system output.
Treating denominators as universal. Different tenants can have different denominators because of anchor exclusions, BOMA measurement language, premises changes, or lease-specific definitions.
Reviewing only the final statement. QA should start with source data, not the tenant-facing PDF. Tie the GL, verify the lease terms, test the calculation, then review presentation.
Not documenting judgment calls. If an expense is included after review, write down why. The note is what protects the answer later.
How CapVeri Supports Training
CapVeri gives new property accountants a structured reconciliation workflow instead of a loose spreadsheet trail. A trainee can see:
- Which expenses are in the pool
- Which expenses are excluded
- Which denominator is used
- Whether a cap applies
- How estimates were deducted
- What created the true-up amount
That makes QA faster because the senior reviewer can inspect the calculation path. It also gives the new hire immediate feedback when a denominator, gross-up, cap, or recoverability rule looks wrong.
Related Resources
- What Is CAM Reconciliation?
- GL Coding Guide for CAM
- CAM Pre-Send Checklist
- Top 15 CAM Billing Errors
Sources
- BOMA International - Revenue Administration MicroCredential
- BOMA International - Budgeting and Accounting
- IREM Learning - CAM, Tax, and Insurance Recoveries for the Property Manager
- IREM - Accredited Commercial Manager Certification
Frequently asked questions
How long does it take to train a new property accountant on CAM reconciliation?
For a new property accountant with general accounting experience but no CAM background, plan for roughly 90 days before independent production work. The first month should focus on lease language, recoverable expenses, GL flow, and manual calculations. The second month should use supervised practice. The third month should shift to solo reconciliations with QA review.
What should CAM reconciliation training cover first?
Start with lease reading and expense recovery logic before system workflows. A property accountant needs to know which lease clause creates the charge, which expenses are recoverable, which denominator applies, and how tenant payments are compared with actual costs before relying on a reconciliation module.
What is the biggest mistake new property accountants make with CAM?
The biggest early mistake is treating CAM as a spreadsheet task instead of a lease-controlled calculation. That shows up as wrong denominators, expenses included without checking recoverability, caps applied incorrectly, and year-over-year variances that cannot be explained.