CAM Reconciliation Audit Trail: What Landlords Need

Why Spreadsheets Fail the Audit Trail Test

When a tenant invokes audit rights, the question is not only whether your math is correct. It is whether you can prove it. A spreadsheet usually cannot answer that question by itself.

Excel can show recent workbook edits in Microsoft 365, but Microsoft says Show Changes is limited to up to 60 days. A CAM dispute often reaches back months or years. That makes spreadsheet history a weak substitute for a durable audit trail, especially when the reconciliation moved through email attachments, copied tabs, manual overrides, or renamed files.

Concord's audit trail guide draws the practical line: an audit trail should be chronological and tamper-proof, with a record of what changed, who made the change, and when it happened. A workbook that can be copied, overwritten, or edited without a durable record does not satisfy that standard.

PredictAP cites a Tango Analytics analysis finding that 40% of CAM reconciliations contain material errors. The point is not that landlords are careless. The point is that CAM work depends on a long chain of invoice coding, lease interpretation, allocation math, approvals, and year-end adjustments. If the system cannot preserve that chain, the tenant auditor sees gaps instead of proof.

There is also a single-person dependency. The person who built the spreadsheet often carries the logic in their head. When they leave, the audit trail effectively ends. A tenant auditor requesting records for a reconciliation prepared by a former controller faces a landlord who cannot explain their own methodology. That is a weak position in a dispute.

What a Defensible Audit Trail Must Contain

A CAM reconciliation audit trail that holds up when a tenant auditor arrives needs four things.

Every modification to a reconciliation should be recorded with a timestamp, the identity of the user who made the change, the prior value, and the new value. The record itself should be write-protected: reviewable but not editable. A log that the same user who made the change can also delete is not tamper-proof.

The audit trail must tie billed allocations to source-level vendor invoices. This means a tenant auditor can select any line in your CAM statement, follow it to the GL entry, follow that to the invoice, and follow that to the payment record. Gaps in this chain are what auditors describe as "missing documentation." Missing documentation shifts the dispute toward the tenant's position.

Every instance where a user overrides a calculated value must be logged with the reason for the override. This is the record that distinguishes a legitimate judgment call, such as amortizing a capital item over a defensible useful life, from an unexplained adjustment that looks like manipulation.

The lease controls the retention period. Many leases require landlords to retain CAM support for several years, often long enough to cover the tenant's audit window plus a dispute buffer. California SB 1103 adds a specific obligation for covered small-business tenancies: building operating cost support must be provided within 30 days of a qualifying written request. Documentation that exists but cannot be assembled on time fails in practice.

What Tenant Auditors Look For When They Arrive

Audit clauses often give tenants a defined window to request documentation retroactively. A dispute that seems settled can reopen when a lease renewal prompts a legal review, when the property is acquired, or when the tenant's CFO notices a discrepancy in their balance sheet under ASC 842.

Cost-shifting language changes the economics of the dispute. Many leases require the landlord to reimburse audit costs when the audit finds overcharges above a stated threshold. LegalClarity notes that lease audits often cost several thousand dollars to tens of thousands of dollars depending on property size and scope. A reconciliation that cannot produce documentation is more exposed to that cost.

For a full breakdown of what auditors target and how to respond before they arrive, see the tenant auditor guide.

Landlords with common billing errors, wrong gross-up factors, CapEx misclassified as OpEx, and cap rate data entry mistakes face compounded exposure when the audit trail is thin. The CAM reconciliation errors guide covers the seven patterns auditors flag most often.

CapVeri's Audit Trail: What It Produces

CapVeri's reconciliation engine is built around the documentation requirement, not the calculation alone.

Once a reconciliation is finalized, the database rejects row-level modifications. There is no version where a user can retroactively alter a gross-up factor and save over the prior calculation. The snapshot is the record: readable, exportable, and write-protected at the infrastructure level. When a tenant auditor asks what the gross-up factor was in Year 2, the answer is a specific record with a specific timestamp, not a recollection.

Every calculation uses BOMA 2024-compliant deterministic math. Every instance where a user overrides a calculated value is logged with the user identity, the timestamp, the original system value, the override value, and the reason field. The log cannot be cleared or edited. When a tenant's auditor asks why the gross-up factor differs from the formula output, the answer is a log entry, not a conversation.

CapVeri exports a structured documentation package: the reconciliation statement, the calculation trace linking each line to its inputs, the GL entries supporting each allocation, and the audit log. For California landlords operating under SB 1103, the building operating cost support can be assembled for the 30-day statutory deadline. For landlords in any state facing a tenant document request, the binder covers the core items auditors request at first contact.

For California landlords specifically, the SB 1103 compliance requirements create a documentation obligation that goes beyond what most property management systems produce. See SB 1103 compliance for the full requirements.

Related Resources

• CAM Reconciliation Guide - Complete step-by-step reconciliation process
• CAM Reconciliation Process - Build a defensible workflow
• CAM Reconciliation Errors - Common errors that trigger audits
• CAM Reconciliation Deadlines - Timing requirements by state
• Reconciliation Statement Generator - Audit-ready statement template
• Audit Risk Scorecard - Score your per-tenant audit vulnerability

Sources

1. PredictAP - Why 40% of CAM Reconciliations Contain Material Errors
2. California Legislative Information - SB 1103 Commercial Building Operating Costs
3. Microsoft Support - Show Changes That Were Made in a Workbook
4. Concord - Contract Audit Trails: The Complete Guide
5. LegalClarity - Lease Auditing: Common Billing Errors and How to Recover