How Long Should CAM Reconciliation Take? Benchmarks by Portfolio Size

By Angel Campa·Founder, CapVeri4 min read

Property management teams often don't know whether their reconciliation process is on pace or falling behind because there are no widely published benchmarks for CAM reconciliation timelines. Without benchmarks, it's impossible to tell whether a process taking 10 weeks is efficient, average, or a sign of a serious bottleneck.

Here are the benchmarks — by portfolio size, complexity, and process maturity.

Why Timeline Varies

Before the numbers: CAM reconciliation timeline is driven by more than portfolio size. These factors all affect elapsed time:

Portfolio size and complexity: More properties and more complex leases mean more total work. But elapsed time (calendar days from GL close to last statement delivered) is also driven by how well work is parallelized.

ERP configuration quality: Portfolios with clean, well-maintained ERP configurations complete reconciliations faster because they don't spend time investigating discrepancies caused by configuration errors.

Staff capacity and workload: Reconciliation season often competes with other month-end and year-end accounting work. Available analyst hours are a significant constraint.

GL close timing: Reconciliation cannot start until the GL is closed. Organizations with a November/December soft close (pre-staging most adjustments) start reconciliation earlier. Organizations that close in late January start late.

Process maturity: Teams with a documented, standardized reconciliation process complete work faster and with fewer rework cycles than teams where each analyst applies their own approach.

Benchmark by Portfolio Size

These benchmarks represent elapsed calendar time from GL close to last reconciliation statement delivered, for organizations with standard commercial lease complexity:

Portfolio SizeElapsed Time (Good)Elapsed Time (Average)Elapsed Time (Slow)
1-5 properties2-3 weeks4-6 weeks8+ weeks
6-20 properties4-6 weeks6-10 weeks12+ weeks
21-50 properties5-8 weeks8-12 weeks14+ weeks

Per-property analyst time:

Lease ComplexityFastAverageSlow
Simple (1-5 tenants, standard pool)4-6 hours8-12 hours15+ hours
Moderate (5-15 tenants, one or two complex leases)8-12 hours12-20 hours25+ hours
Complex (anchor exclusions, multiple pools, many caps)12-18 hours20-30 hours35+ hours

The 7 Things That Slow Reconciliation Down

1. Late GL close: Every week the GL close slips is a week the reconciliation start slips. Organizations that begin reconciliation in February instead of January effectively give themselves one fewer month to meet a March 31 deadline.

2. Data gathering from multiple systems: When lease abstracts live in one system, GL data lives in the ERP, and prior year calculations live in spreadsheets with no central repository, gathering the right data for each property takes hours before reconciliation work can begin.

3. Manual ERP output verification: Cross-checking every tenant's calculation against lease terms by hand is necessary but slow. For a 15-tenant property, manual verification can add 4-8 hours per property.

4. Late-cycle error discovery: Finding a calculation error after 12 of 15 tenant statements are prepared triggers rework across all prepared statements, not just the one with the error. When pool-level errors are discovered late, every tenant in the pool is affected.

5. Tenant communication lag: Some tenants respond quickly to statements; others take weeks to confirm receipt or raise questions. Building response time into the timeline is necessary but often not planned for.

6. Dispute resolution: When tenants challenge a reconciliation calculation, resolution can take weeks — particularly if the challenge requires reviewing multiple prior-year calculations.

7. Review bottlenecks: When a single senior reviewer must approve every statement before delivery, their availability becomes the constraint. Properties ready for delivery wait in queue.

Fast vs. Slow Markers

Signs your process is efficient:

  • GL close is complete by January 15
  • Data gathering is automated (standard exports, central repository)
  • Reconciliation starts within one week of GL close
  • ERP configuration errors are caught before reconciliation starts, not during
  • Statements are delivered in batches (week 3, week 5, week 7) rather than one at a time
  • Tenant questions are resolved within 5 business days

Signs your process is inefficient:

  • GL close slips past January 31
  • Analysts spend more than 2 hours gathering data per property
  • The same calculation error appears in multiple properties
  • Statements are delivered individually as each is completed, creating an uneven tenant experience
  • Senior reviewers are the bottleneck — properties sit in review queue for weeks
  • Tenant questions are tracked via email, not a structured process

How to Reduce Timeline Without Cutting Corners

Pre-close preparation (October-December): Start gathering data before fiscal year close. Pull lease abstracts, prior year calculations, and denominator data in Q4. When GL close happens, data gathering is already done.

Parallel processing: Don't process properties sequentially. Start simple properties immediately on GL close while complex properties are still being set up. Having 8 properties in progress simultaneously takes the same calendar time as 8 sequential properties if the staff has capacity.

Automated verification: Instead of manual cross-checking (reviewing each tenant's calculation against lease terms), use CapVeri's independent recalculation to flag discrepancies automatically. What takes 4-8 hours manually takes minutes with automated verification.

Batch delivery: Group tenants for coordinated delivery (all statements for a property go out on the same day, all properties in a portfolio go out within the same week). This creates a cleaner tenant experience and reduces the review bottleneck by batching review work.

Standardize statement format: A consistent format means reviewers know where to look for issues — review time per statement drops from 30 minutes to 10 minutes when the format is predictable.

CapVeri's reconciliation workflow tools — including automated verification and statement generation — are designed specifically to address the bottlenecks that cause good-faith processes to run 4-8 weeks longer than necessary.

Related Resources