Multi-Property CAM Reconciliation: Scaling From 5 to 50 Buildings

Five Buildings Is Not Fifty

At five buildings, reconciliation is a spreadsheet problem. One controller exports the GL from Yardi or MRI, maps expenses to lease categories, runs the pro-rata calculations in Excel, and produces statements. The work takes two to three weeks. Errors get caught because the same person who built the spreadsheet reviews the output.

At fifty buildings, reconciliation is a workflow problem. Five to eight people touch the process. GL data comes from multiple property management systems (the buildings you acquired last year are still on their seller's MRI instance). Lease terms vary across 300+ tenants. The timeline compresses because the same 90-day window applies whether you have 5 buildings or 50.

The math does not change at scale. The coordination does.

Staffing Models

Model 1: Decentralized (5–15 Buildings)

Each property accountant reconciles their assigned buildings. A senior controller or VP of finance reviews the output before statements go out.

Pros: Accountants know their buildings intimately. They catch property-specific anomalies (that $12,000 spike in R&M was the parking garage gate motor replacement).

Cons: No consistency across buildings. Each accountant builds their own spreadsheet. Cap calculations may use different methodologies. Gross-up formulas may not match. When an accountant leaves, the successor inherits a spreadsheet they did not build and cannot fully understand.

Typical capacity: 8–12 buildings per accountant during reconciliation season.

Model 2: Centralized Team (15–40 Buildings)

A dedicated reconciliation team of 2–4 specialists handles all buildings. Property accountants provide the GL data and answer questions about specific line items, but the reconciliation calculations are centralized.

Pros: Consistent methodology. Standardized templates. Cross-property quality checks. Specialists develop deep expertise in cap calculations, gross-up mechanics, and lease interpretation.

Cons: The reconciliation team does not know the buildings as well as the property accountants. They will miss the parking garage gate motor context unless the property accountant flags it. Communication overhead increases.

Typical capacity: 10–15 buildings per specialist during reconciliation season.

Model 3: Hybrid (40+ Buildings)

A central team owns the methodology, templates, and quality review. Property accountants prepare the initial data package (GL export, rent roll, lease abstract updates). The central team runs calculations and produces draft statements. Property accountants review drafts for property-specific accuracy before final delivery.

Typical capacity: 12–18 buildings per specialist with property accountant support.

Those hour estimates assume spreadsheet-based reconciliation. Software that automates GL mapping, pro-rata calculation, and statement generation reduces the per-building time by 40–60%, which means the same team handles more buildings within the same 90-day window.

Prioritization: Which Buildings First

Not all buildings are equal. A 40-tenant retail center with 15 capped leases and 3 base-year tenants takes four times longer than a 5-tenant office building with simple NNN leases. Prioritize based on:

Tier 1: Reconcile First (Weeks 1–3)

• Buildings with lease-mandated delivery deadlines. Some leases specify that reconciliation statements must be delivered within 90 days of fiscal year-end, with remedies for late delivery (tenant can withhold future CAM payments, or estimated amounts become the final amount).
• Buildings with active tenant audit history. If a tenant audited you last year, they are watching this year's statement closely. Deliver it early and clean.
• Buildings with the largest expected true-ups. A $200,000 aggregate true-up across a building's tenants represents cash you are not collecting until the statement goes out. Every week of delay costs you the time value of that money.

Tier 2: Reconcile Second (Weeks 3–6)

• Buildings with complex lease structures (multiple cap types, base-year tenants, separate expense pools). These take longer and benefit from the team having warmed up on Tier 1 buildings.
• Buildings acquired during the fiscal year. Partial-year reconciliation requires blending the seller's data with your data, which introduces additional validation steps.

Tier 3: Reconcile Last (Weeks 6–10)

• Simple NNN buildings with straightforward pass-through leases, no caps, no base years, and consistent tenancy throughout the year. These are the fastest to reconcile and the least likely to generate disputes.
• Buildings with pending GL issues (late vendor invoices, unresolved accruals, property tax protests). Pushing these to the end gives more time for outstanding items to resolve.

Timeline Management for a 50-Building Portfolio

Assuming a December 31 fiscal year-end and a 90-day target for statement delivery (March 31):

This timeline has about one week of buffer. Lose it to a late GL close or an unresolved property tax protest, and Tier 3 buildings slip past the 90-day mark.

The Five Bottlenecks That Kill Multi-Property Timelines

1. Late GL Closes

If property accountants cannot deliver closed trial balances by January 15, the entire timeline shifts. The most common cause: late vendor invoices for December services. The fix is December accruals (see /resources/year-end-close-checklist-cam).

2. Stale Lease Abstracts

The lease abstract matrix — tenant name, SF, lease dates, CAM provisions, caps, exclusions, base years, admin fees — must be current as of the reconciliation period. If the last lease abstract update was done during leasing and no one maintained it through amendments, renewals, and tenant changes, the reconciliation team spends 30–50% of their time re-reading leases instead of running calculations.

On a 300-tenant portfolio, re-abstracting leases during reconciliation season adds 200–400 hours to the process. That is three to five weeks of work for one person, crammed into a window that is already tight.

3. Inconsistent GL Structures Across Properties

A portfolio assembled through acquisitions typically has properties on different chart-of-accounts structures. Building A codes janitorial to GL 6110. Building B codes it to GL 5200. Building C splits janitorial between GL 6100 (day cleaning) and GL 6105 (night cleaning).

Before reconciliation calculations can start, someone must map every property's GL to a common expense category structure. On a 50-building portfolio with 3–4 different GL structures, this mapping exercise takes 40–80 hours the first time. After the initial mapping, annual maintenance is 5–10 hours.

In Yardi Voyager, the chart of accounts is configurable per entity. In MRI, account trees can be standardized through the General Ledger > Account Structure module, but only if someone does the work. Most portfolios that grew through acquisition never did.

4. Missing or Conflicting Square Footage Data

The denominator for pro-rata share calculations — the building's total leasable or rentable area — must be consistent across all tenants' calculations. But different leases may reference different measurements:

• Lease A uses 185,000 RSF (BOMA 2010 measurement).
• Lease B uses 182,500 RSF (BOMA 1996 measurement from the original lease, never updated).
• Lease C uses 190,000 RSF (landlord's marketing brochure number, not a BOMA measurement at all).

Each tenant's pro-rata share must use the denominator defined in their lease. This means you may be running three different denominators on the same building. At scale, tracking which denominator applies to which tenant across 50 buildings is a data management problem that spreadsheets handle poorly.

5. Review and Approval Bottlenecks

If one senior controller must review all 50 buildings, and each review takes 2–3 hours, that is 100–150 hours of review time. Spread across the reconciliation window, the controller must review 4–5 buildings per week while handling every other responsibility of the role.

Solutions: parallel review tracks (two controllers splitting the portfolio), exception-based review (full review for complex buildings, spot-check for simple ones), or automated variance checks that flag only the calculations that need human attention.

Technology Requirements at Scale

Below 10 buildings, spreadsheets work if the controller is disciplined about templates and version control.

Above 10 buildings, you need:

Data management: A system that can ingest GL exports from multiple property management platforms (Yardi, MRI, RealPage, AppFolio) and normalize them to a common structure. Without this, 30% of reconciliation time is spent on data preparation.

Lease data storage: A structured database of CAM provisions per tenant — not a PDF of the lease, but extracted, validated data fields: cap percentage, cap type, base year amount, exclusion list, admin fee percentage, gross-up threshold, and denominator. This is the lease abstract matrix, and it must be maintained continuously, not rebuilt each year.

Calculation engine: Automated pro-rata share calculations that apply the correct lease terms per tenant. The engine must handle caps (cumulative and non-cumulative), base-year excess, gross-up, multiple expense pools, and partial-year occupancy. Manual calculation across 300+ tenants is where errors multiply.

Audit trail: Every calculation must be traceable from the final statement back to the source GL entry. When a tenant auditor asks why their share of R&M is $3.42/SF, you need to show the GL detail, the total pool, the denominator, and the pro-rata percentage in under five minutes.

Statement generation: Templated output that produces consistent, professional reconciliation statements across all buildings. Manual statement formatting at scale consumes 20–30% of total reconciliation time.

CapVeri handles GL ingestion from Yardi, MRI, and generic CSV exports, normalizes the data, stores lease terms in structured format, runs calculations with full audit trails, and generates downloadable reconciliation statements. The platform is designed for portfolios where spreadsheet-based reconciliation has become a bottleneck.

For the month-by-month reconciliation checklist that underlies this timeline, see /resources/cam-reconciliation-timeline-checklist. For guidance on building a reconciliation package that withstands tenant audits, see /resources/defensible-reconciliation-package.