CAM Reconciliation Staffing Plan: Size Your Team Before Season Hits

Reconciliation season arrives on the same date every year. Yet most property management companies still hit a capacity crisis in February and March because staffing planning happened in January, two months after it needed to.

The difference between a smooth season and an all-hands emergency is whether capacity planning started in Q4 or Q1. Here is how to do it right.

When Reconciliation Season Starts

Many teams think reconciliation season starts when GL close happens in January. In practice, it starts in November.

November: Final review of ERP configuration (recovery pool mappings, lease setup, denominator accuracy). Issues found in November can be corrected before year-end. Issues found in February require retroactive corrections that delay everything.

December: Pre-close data gathering (lease abstracts, prior year calculations, denominator updates for tenant changes). Build the "starting kit" for each property so analysts can start as soon as GL close is done.

January: GL close (usually mid-to-late January for most commercial portfolios). Reconciliation calculations begin as soon as GL is final.

February-March: Statement drafting, review, and delivery. Tenant communication and dispute response.

April-May: Cleanup (remaining tenant responses, corrections from disputes, follow-up collections on underpayments).

The effective reconciliation season spans November through April (six months, not three). Staffing planning that only covers February and March misses the November-January prep work that determines whether those months go smoothly.

Workload Estimation by Portfolio Size

Hours per building (analyst time, not including review):

Simple = standard CAM pool, no gross-up or simple gross-up, no caps or 1-2 straightforward caps. Standard = gross-up required, 3-10 tenants with cap provisions, one recovery pool. Complex = multiple recovery pools, anchor exclusions, many tenants with different cap terms, lease amendments during the year.

Total portfolio hours:

Add 25-35% for review time (controller/senior analyst review of each statement).

The Staffing Math

Once you have total hours, the staffing math is simple:

Available hours per analyst for reconciliation season:

The reconciliation season runs roughly 10-12 weeks (January through March). An analyst who is 50% dedicated to reconciliation (the other 50% on ongoing work) has:

10 weeks × 40 hours × 50% = 200 hours available

This is a realistic number. Analysts rarely put more than 50-60% of their time into reconciliation even at peak, because month-end accounting, tenant communications, and other responsibilities continue.

FTE requirement calculation:

For a 30-property portfolio estimating 400 analyst hours: 400 hours ÷ 200 hours per analyst = 2 dedicated analysts

This is a minimum baseline. Add capacity for:

• Unexpected complexity (properties that take longer than estimated)
• Rework (errors discovered mid-process)
• Tenant questions and disputes
• Controller review time (separate from analyst time)

A realistic staffing plan for 30 properties: 2 analysts plus 0.5 FTE controller time for review, with a contingency of 50-75 hours for unexpected work.

Who Does What

Not all reconciliation work needs the same skill level. Matching work to the right roles cuts cost and improves quality:

Controller / Senior Analyst:

• Recovery pool configuration audit (pre-season)
• Complex lease interpretation (anchor exclusions, unusual cap terms)
• ERP configuration corrections
• Final review and approval of all statements before delivery
• Tenant dispute resolution
• Estimated: 25-35% of total hours

Analyst:

• GL data gathering and export
• Standard reconciliation calculations (gross-up, pro-rata, settlement)
• Statement drafting from templates
• First-pass reconciliation for standard properties
• Estimated: 55-65% of total hours

Administrative:

• Statement formatting and assembly
• Tenant communication coordination (statement delivery, question routing)
• File organization and documentation
• Estimated: 10-15% of total hours

Peak vs. Off-Peak Allocation

Reconciliation workload is not distributed evenly across the season:

Peak weeks (February 1 - March 15): Highest analyst demand. Most properties are in active calculation and drafting at the same time. This is when staff capacity is most likely to constrain the timeline.

Pre-season (November - January): Preparation work (configuration audit, data gathering, lease abstract review). This is important work, and it fits within a normal accounting workload. Budget 1-2 hours per property per week.

Post-season (March 15 - April 30): Cleanup (tenant responses, corrections, dispute resolution, final filings). Usually manageable with normal staffing.

Front-loading vs. deadline-driven approaches:

Some teams work steadily from November through March (front-loading). Others start in earnest in January and work hard through March (deadline-driven). Front-loading produces less peak strain and higher quality work. Deadline-driven creates predictable February-March crunches.

Front-loading requires management to treat October-November prep as a real priority, not something that starts "after the holidays."

When to Bring in Outside Help

Bring in outside help when:

• Your calculation shows the team will miss deadlines (and that calculation happens in October, not February)
• A portfolio spike (acquisition, new management contract) temporarily exceeds capacity
• You need specialized expertise for properties with unusual CAM structures

Don't bring in outside help when:

• The real problem is inefficient process (outside help inherits the same process problems)
• The capacity gap is a recurring annual problem (that signals a hiring or process need, not a temporary resource gap)
• The timeline is tight but achievable with process improvements (try automating verification before adding headcount)

Technology as a capacity multiplier:

Before budgeting for more headcount, calculate the capacity impact of automation. CapVeri's independent verification tool cuts manual cross-checking of ERP output against lease terms (work that typically takes 30-40% of analyst time). For a 2-analyst team, that is equivalent to adding 0.7 FTE of capacity without adding headcount.

For a 30-property portfolio, the staffing math changes significantly when verification is automated:

• Manual verification: 400 hours total, need 2 analysts
• With CapVeri verification: ~280 hours total, manageable with 1.5 analysts

The technology cost is a fraction of the salary cost of 0.5 additional FTE.

Related Resources

• How Long Should CAM Reconciliation Take?
• Batch CAM Reconciliation Across Multiple Properties
• Year-End CAM Reconciliation Workflow
• Property controller career path in CRE FinOps - how reconciliation season mastery shapes long-term career development

Sources

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