CAM Reconciliation Season Staffing Plan: Capacity Planning for Property Managers
Reconciliation season arrives on the same date every year. Yet most property management companies still experience capacity crises in February and March because staffing planning happened in January — two months after it needed to happen.
The difference between a smooth reconciliation season and an all-hands emergency is whether capacity planning started in Q4 or Q1. Here's 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. Building the "starting kit" for each property so analysts can start immediately after GL close.
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 accounts for February and March misses the November-January preparation work that determines whether February and March go smoothly.
Workload Estimation by Portfolio Size
Hours per building (analyst time, not including review):
| Property Type | Simple | Standard | Complex |
|---|---|---|---|
| Single-tenant NNN | 2-4 hours | — | — |
| Multi-tenant retail (5-15 tenants) | 6-10 hours | 10-15 hours | 15-25 hours |
| Multi-tenant office (5-15 tenants) | 8-12 hours | 12-18 hours | 20-30 hours |
| Anchored retail center | — | 20-30 hours | 30-45 hours |
| Multi-building campus | — | — | 40-60 hours |
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:
| Portfolio Size | Approximate Total Analyst Hours |
|---|---|
| 1-5 properties | 30-100 hours |
| 6-15 properties | 80-250 hours |
| 16-30 properties | 200-500 hours |
| 31-50 properties | 400-900 hours |
Add 25-35% for review time (controller/senior analyst review of each statement).
The Staffing Math
Once you have total hours, staffing math is straightforward:
Available hours per analyst for reconciliation season:
The reconciliation season runs approximately 10-12 weeks (January through March). An analyst who is 50% dedicated to reconciliation (the other 50% on ongoing responsibilities) has:
10 weeks × 40 hours × 50% = 200 hours available
This is a realistic estimate. Analysts rarely dedicate more than 50-60% of their time to reconciliation work even during peak season 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 requires the same skill level. Matching work to appropriate roles reduces 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 in active calculation and drafting phases simultaneously. 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. Important work, but generally compatible with normal accounting workload. 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 intensively through March (deadline-driven). Front-loading produces less peak strain and higher quality work; deadline-driven creates predictable February-March crunches.
Front-loading requires buy-in from management that reconciliation season preparation is a real October-November 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 the 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 additional headcount, calculate the capacity impact of automation. CapVeri's independent verification tool eliminates manual cross-checking of ERP output against lease terms — work that typically consumes 30-40% of analyst time. For a 2-analyst team, that's 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.