CAM Reconciliation for Commercial Property Managers: The Annual Cycle That Holds Under a Tenant Audit

Updated for 2026. The annual cycle still holds, and commercial PM platforms now ship agentic reconciliation features that need the same workpaper discipline before tenant counsel will accept them. See our AI trust accounting controls for property management and the 2026 PM software selection guide for the current platform picture. We have audited Common Area Maintenance reconciliations across office, retail, and mixed-use commercial portfolios, and the consistent finding is that the dispute rate against a CAM reconciliation correlates almost perfectly with the quality of the underlying workpapers rather than with the dollar amount of the reconciliation itself. Tenants and their auditors do not push back because the number is large; they push back because the supporting documentation will not survive a basic walkthrough. A tenant's CPA opens the reconciliation, asks for the GL detail behind a single line item, asks how the gross-up percentage was calculated, asks why a specific expense category was included this year and excluded last year, and within forty minutes either accepts the package or initiates a formal audit that consumes the property manager's time for six months and frequently ends in a settlement adjustment. The pattern across the firms we have engaged with, both third-party fee managers and owner-operators, is that the CAM cycle is treated as a finance task rather than a contractual settlement. The accounting team produces the calculation. The property management team signs off. Nobody reads the underlying leases against the reconciliation. The workpapers get filed. Two years later, a tenant exercises an audit right that everyone forgot was in the lease, and the firm has to reconstruct the methodology from people who have since left. This guide describes the CAM cycle we install on engagements where the commercial portfolio has reached the scale at which tenant audits are inevitable, and it is the cycle that has held under the audits we have observed conducted by the major tenant-side CAM auditors. The system context, Yardi Voyager Commercial, MRI Commercial Suite, Entrata's commercial module, RealPage's commercial offering, matters less than the methodology. We have seen clean reconciliations come out of all of those systems, and we have seen indefensible reconciliations come out of all of them too. The system is the calculator; the workpapers are the defense. The lease abstraction is the prerequisite, not an optional input Every CAM reconciliation we have seen fail under tenant audit failed because the calculation was performed against the firm's standard CAM methodology rather than against the specific terms of the specific tenant's lease. Commercial leases are negotiated documents. The standard CAM clause in the firm's letter-of-intent template is the starting point of negotiation, not the ending point, and the lease that gets executed routinely contains tenant-specific exclusions, caps, gross-up adjustments, and audit-rights mechanics that diverge from the firm's standard CAM methodology in ways that the property management software does not enforce automatically. The abstraction discipline is a per-lease, per-amendment review that produces a structured CAM provisions sheet and stores it inside the lease administration system in a way that the CAM calculation engine actually reads. The abstraction captures the inclusions list, the exclusions list, controllable versus uncontrollable categorization, the base year if applicable, the cap structure if applicable (annual, cumulative, or both), the gross-up methodology, the proportionate share calculation method, the audit rights window, the audit rights documentation requirements, and any tenant-specific concessions such as caps on management fees or exclusions of capital expenditures. Inclusions and exclusions diverge per lease and per landlord precedent. A national tenant negotiating against the firm's standard form will routinely exclude specific expense categories that the standard form would include, capital improvements, certain insurance categories, marketing expenses, leasing commissions, executive salaries, and the cost of services provided to specific other tenants. The exclusions list in the abstraction has to be granular enough that the GL coding can map to it. We have seen reconciliations where the lease excluded "capital improvements" but the abstraction recorded only "capex excluded," and the tenant's auditor identified that the reconciliation included roof-repair expenses that the lease's specific definition would have excluded but the firm's general definition allowed. The dispute resolution cost the firm more than the original recovery. Controllable versus uncontrollable matters because of the cap. Many leases cap the year-over-year increase in CAM passthroughs to a defined percentage on controllable expenses while leaving uncontrollable expenses uncapped. The categorization is lease-specific; what the lease defines as uncontrollable, typically real estate taxes, insurance premiums, snow removal, and utilities, has to match the operating expense category structure in Yardi or MRI exactly. The reconciliation has to show the controllable subtotal, the cap applied to that subtotal, the uncontrollable subtotal flowing through unaffected, and the resulting tenant share. Cross-link to the lease abstraction discipline guide for the upstream abstraction process; the CAM cycle depends on that abstraction being right. Audit rights windows expire and matter. Many leases grant the tenant a specific window, commonly twelve months from the date the reconciliation statement is delivered, to dispute the calculation and exercise audit rights. The firm's policy needs to track that window per lease, calendar it, and treat the expiration as a material control event. We have seen firms agree to "audit our books going back five years" because they did not realize the lease language had already barred audit rights for the earlier years. Gross-up is the single most-disputed line in any CAM workpaper Gross-up calculations exist because operating expenses in a partially-occupied building do not scale with occupancy in the way landlords need them to for fair tenant cost recovery. Variable expenses, janitorial, utilities allocated to common areas, certain management fee structures, are lower when the building is half-occupied than when it is fully occupied, and the gross-up methodology adjusts those variable expenses to the level they would have been at a defined occupancy threshold (typically 95% or 100%) so that the tenants currently in occupancy pay their proportionate share of what the building actually costs to operate at full occupancy. The lease specifies the gross-up percentage and the categories subject to gross-up, and the reconciliation has to apply the methodology in a way that an auditor can reproduce from the source data. The workpaper structure that holds shows the unadjusted GL expense by category, the actual occupancy percentage used in the calculation, the gross-up factor applied to each category, the resulting grossed-up expense, and a reconciliation back to the unadjusted total demonstrating that only variable expenses were grossed up. The non-grossed-up categories, fixed expenses such as insurance premiums and real estate taxes, flow through at their actual amount. Occupancy percentage is contested, not assumed. The denominator in the gross-up calculation is the rentable square footage; the numerator is the leased and occupied square footage. The complications are around tenants who have signed leases but not yet taken occupancy, tenants who are in free-rent periods, vacant suites under renovation, and management's own occupied space. The lease typically defines which of those count toward "occupancy" for gross-up purposes, and the calculation has to use the lease's definition rather than the firm's standard occupancy report. We have seen firms calculate gross-up against the leased percentage when the lease specified occupied, and the difference produced a five-figure reconciliation adjustment in the tenant's favor. The methodology document is signed off annually. The firm should produce a CAM gross-up methodology document at the start of each calendar year, have it reviewed by the asset management team and the property management leadership, and reference it in every reconciliation workpaper. The document specifies the categories subject to gross-up, the threshold percentage, the occupancy definition, and the treatment of edge cases. When a tenant audits, the workpaper points to the methodology document, and the methodology document points to the lease language. That chain of reference is what closes audits cleanly. Base-year mechanics are where multi-year reconciliations break Base-year leases, typical in office portfolios, recover from the tenant only the increase in operating expenses over the level established in the base year. The base year is set at lease commencement, the operating expense pool is calculated for that year using the firm's standard methodology, and every subsequent year's reconciliation calculates the increment over base. The mechanics are conceptually simple and operationally treacherous, because the base-year calculation has to be reproducible across multiple years, multiple bookkeepers, and multiple amendments to the firm's standard methodology. The pattern we see across engagements is that the base year was calculated correctly in year one, the methodology was modified in year three for a defensible reason, nobody recalculated the base year against the new methodology, and now the reconciliation is comparing apples to oranges. The fix, and the discipline that prevents recurrence, is a base-year recalculation that runs every time the firm's methodology changes, with both the original and the recalculated base year stored against every base-year lease in the system. The reconciliation cites which base year it is using and why, and the auditor has a clear path to validate the comparison. Base-year exclusions are negotiated and lease-specific. Sophisticated tenants negotiate base-year exclusions for non-recurring expenses that artificially deflated the base, major repairs, special assessments, settlement payments, to prevent the landlord from establishing a low base that produces large recoveries in subsequent years. The abstraction has to capture those exclusions, and the year-one calculation has to apply them. We have seen leases where the tenant successfully argued for a base-year recalculation in year four when the original base had not excluded a non-recurring item the lease explicitly excluded. Caps interact with base year. Some base-year leases also include a cap on the year-over-year increase in CAM. The cap is typically applied to the increment over base, not to the absolute dollar amount, and the workpaper has to show the calculation at every step: actual current-year expenses, current-year minus base, the resulting increment, the cap applied, and the tenant's proportionate share of the capped increment. Mistakes at any step compound across the lease term and produce material adjustments at audit. Capital expenditures and management fees are the recurring fight The two CAM categories that tenants challenge most frequently in audits are capital expenditures and management fees, and the firms that handle them cleanly do so by establishing a written policy at the firm level and applying it consistently across the portfolio rather than fighting the question lease by lease. Capital expenditure pass-throughs. Most modern commercial leases either exclude capital expenditures from CAM entirely, allow them only with amortization over the useful life, or allow them only when they reduce operating expenses or are required by law. The firm's policy needs to specify how capital expenditures are identified in the GL, the chart of accounts has to actually have a separate capital expenditure category, how they are amortized when the lease allows, and what the documentation package for each capex item looks like. We have seen firms include large capex items in CAM with no amortization, no lease support, and no engineering analysis, and the tenant audit produced a complete clawback plus a punitive adjustment. Management fee structures vary widely. Some leases cap the management fee at a percentage of gross receipts. Some cap it at a percentage of operating expenses excluding the management fee itself (a circular calculation that produces different results depending on the order of operations). Some define the management fee as a flat dollar amount per square foot. The reconciliation has to apply the lease-specific definition, and the workpaper has to show the calculation explicitly. The firms we have engaged with who treat the management fee as "whatever the standard is" produce reconciliations that fail audits routinely. Marketing and promotional expenses are retail-specific. In retail and mixed-use portfolios, marketing fund contributions are often a separate billing item from CAM but are governed by similar mechanics, the marketing budget, the actual expenditures, the tenant's proportionate share, and the reconciliation cycle. The workpapers and the policies are similar but not identical, and the firm needs to maintain them as separate cycles rather than collapsing them. The workpaper package is what the audit consumes The deliverable that survives a tenant audit is a structured workpaper package, produced once per reconciliation, that contains: a cover memo summarizing the reconciliation result and citing the applicable lease provisions; the lease abstraction in effect at the time of the reconciliation; the gross-up methodology document; the GL trial balance for the reconciliation period filtered to operating expense categories; a reclassification schedule documenting any expenses moved between categories during the reconciliation; the gross-up calculation worksheet; the controllable cap calculation worksheet if applicable; the base-year comparison worksheet if applicable; the proportionate share calculation; the tenant billing detail by month; the reconciliation summary tying actual to estimated billings; and the resulting under- or over-billing adjustment. The firms we have engaged with who produce this package as a matter of course pass tenant audits with minimal disruption. The firms who produce a single-page reconciliation summary and tell the auditor to "ask if you have questions" produce protracted audits that frequently end in concessions the underlying numbers did not require. The audit response timeline is governed by the lease. The lease typically specifies how quickly the firm has to produce documents in response to a tenant's audit request, and the firm's policy should commit to producing the workpaper package within that window. We have seen firms whose lease required ten business days take six weeks to assemble the package, and the tenant's auditor used the delay as leverage in negotiating the final adjustment. Settlement entries are documented and signed off. When an audit produces an adjustment, whether the tenant overpaid or underpaid, the settlement entry has to be documented with the audit memo, the agreed adjustment, the journal entries posted to the GL and the property management system, and the broker or asset manager's sign-off. Settlement entries that are not properly documented produce repeat audits in subsequent years on the theory that the prior year's adjustment may not have been fully reflected. The annual cadence holds the cycle together The CAM cycle is not a one-time annual event; it is a sequence of monthly, quarterly, and annual disciplines that produce the inputs the annual reconciliation consumes. The firms we have engaged with who treat the cycle as continuous produce defensible reconciliations on a predictable timeline; the firms who treat it as an annual scramble produce reconciliations that miss the lease-specified delivery window and create immediate audit-rights triggers. Monthly. Operating expenses are reviewed against budget, GL coding is validated, accruals are posted for known invoices not yet received, and the running estimate of CAM passthrough is updated. Monthly billings to tenants are based on the prior year's reconciled CAM divided by twelve plus an estimated escalation, and the firm tracks the variance between billed and estimated actual to surface reconciliation pressure before year-end. Quarterly. The asset management team and the property management leadership review the CAM trajectory, identify expense categories trending materially above or below budget, and decide whether to adjust monthly tenant billings to smooth the year-end reconciliation. Lease abstractions for new tenants and amendments executed during the quarter are reviewed for CAM provisions and entered into the system. Annual. The reconciliation is performed within the lease-specified window after year-end (commonly ninety to one hundred twenty days), the workpaper package is produced for every base-building reconciliation, the tenant statement is issued with the supporting detail the lease requires, and the resulting under- or over-billing is collected or credited. Audit rights windows are calendared from the date of statement delivery, and the firm tracks expirations to know when the year is closed for audit purposes. What we recommend The commercial property managers we have audited where CAM is genuinely under control share a small set of practices that any firm operating a portfolio at scale can implement within two reconciliation cycles. The cost of implementation is meaningful; the cost of an aggressive tenant audit against an unprepared firm is dramatically higher. First, install lease abstraction as a discipline and require every CAM reconciliation to cite the abstraction in effect at the time. Second, document the gross-up methodology and controllable-versus-uncontrollable categorization at the firm level, with annual sign-off from asset management. Third, maintain base-year recalculations whenever the methodology changes, and store both the original and the recalculated base year against every base-year lease. Fourth, write a capital expenditure policy that the chart of accounts can actually enforce, and amortize capex pass-throughs in the way the lease specifies. Fifth, produce a structured workpaper package for every reconciliation rather than a summary, and store it where an auditor can reach it within the lease-specified document production window. Sixth, calendar audit-rights windows per lease and treat their expiration as a closed-year milestone the asset team can rely on. The firms that operate with this discipline find that tenant audits become routine, produce the package, walk through the methodology, close the audit, rather than existential. The investment shows up as defended revenue, reduced settlement adjustments, and a CAM cycle that the controller can complete on a predictable timeline rather than a perpetual scramble. For the upstream lease discipline that makes this all possible, see the lease abstraction guide. For the broader operational leaks that CAM mistakes are part of, see the six hidden leaks piece.