How much can a single CAM billing error cost?

A single systematic error — one that repeats every year — compounds over the lease term. An error worth $30,000 per year across a 15-tenant building for three years before detection can total $150,000-$300,000 in refunds, depending on whether the error affects all tenants or a subset. Add interest, audit costs, and the downstream impact on tenant retention, and the total cost often exceeds the direct refund.

What are the most expensive types of CAM billing errors?

Systematic errors that affect every tenant every year are the most expensive: wrong building SF in the denominator (affects all pro-rata shares), capital expenditures classified as operating expenses (inflates the total pool), and gross-up applied to fixed expenses (overcharges every tenant). These errors typically run $20,000-$80,000 per year on a mid-size building.

The $247,000 Spreadsheet Error: Anatomy of a CAM Billing Mistake

By Angel Campa·Founder, CapVeriUpdated March 17, 20264 min read

The Setup

This is based on a real scenario, with details changed to protect the parties involved. The numbers are representative of what we see in practice.

A 180,000 SF Class A office building in a major metro. Fourteen tenants. The property controller managed reconciliation using a spreadsheet inherited from a predecessor who left in 2021. The spreadsheet had been used for six years with minor annual updates.

In 2022, the building added a parking structure. The property management company updated the GL to include parking maintenance, lighting, and security. The controller added these new expense categories to the reconciliation spreadsheet.

Here's where the error happened.

The Error

When adding the parking expense rows to the spreadsheet, the controller created a SUM formula for total recoverable expenses. The formula referenced cells A45:A52 for the new parking categories. But the insurance premium — which sat in cell A44 — was excluded from the range.

The SUM formula should have been =SUM(A12:A52). Instead, it was =SUM(A12:A43,A45:A52). Cell A44 — the $142,000 annual insurance premium — fell through the gap.

The total recoverable expense pool was understated by $142,000 per year.

The Compounding

Year 1 (2022): Insurance premium: $142,000. Not included in the recovery pool. Each tenant was under-billed by their pro-rata share of $142,000. The landlord absorbed $142,000 in recoverable expenses without realizing it.

Year 2 (2023): Insurance premium increased to $156,000. Still excluded. The landlord absorbed $156,000.

Year 3 (2024): Insurance premium: $168,000. Still excluded. The landlord absorbed $168,000.

Total unrecovered insurance over three years: $466,000.

But that's not the number the landlord owed. The landlord owed the opposite — they had been under-billing tenants. The $466,000 was revenue the landlord failed to collect.

So why did the landlord end up owing $247,000?

The Second Error

The controller noticed that the recovery ratio was declining — from 91% in 2021 to 84% in 2022. Rather than investigating, they assumed it was related to a vacancy increase during the same period.

To compensate for the apparent under-recovery, the controller began grossing up expenses more aggressively. Specifically, they started grossing up insurance — a fixed expense that should never be grossed up — to "make up" for what they perceived as a vacancy-driven shortfall.

The insurance gross-up overcharged tenants by approximately $82,000 per year. Over three years: $247,000 in overcharges.

So the landlord simultaneously:

Failed to recover $466,000 in legitimate insurance pass-throughs (revenue lost)
Overcharged tenants $247,000 by grossing up a fixed expense (refund owed)

The Discovery

In late 2024, the building's largest tenant (42,000 SF, 23.3% pro-rata share) hired a tenant audit firm to review three years of reconciliation statements.

The auditor found the insurance gross-up within 30 minutes — it's a standard check. Fixed expenses grossed up at high vacancy is one of the top five findings in every tenant audit.

The auditor calculated the overcharge for their client: $57,500 over three years (23.3% of $247,000). They sent a findings letter requesting a refund.

The landlord's review confirmed the error. But it also revealed the underlying SUM formula problem — which meant the landlord had actually been under-billing insurance across all tenants for three years.

The Resolution

The landlord faced a dilemma:

Owed the audited tenant: $57,500 (their share of the gross-up overcharge)
Under-collected from all tenants: $466,000 (the missing insurance pass-through)
Net position: The landlord was owed more than they owed, in aggregate

But you can't offset a refund owed to one tenant against under-billings owed by all tenants. The audited tenant gets their refund regardless. And attempting to retroactively bill tenants for three years of under-collected insurance — when the error was the landlord's — would trigger lease disputes and potentially additional audits.

Final outcome:

Refunded $57,500 to the audited tenant
Five other tenants hired the same audit firm (word got around). Total refunds: $189,500
The remaining $466,000 in under-collected insurance was written off as unrecoverable
Legal and audit response costs: $18,000
The largest tenant did not renew their lease at expiration (citing "trust concerns with building management")

Total financial impact: $247,000 in refunds + $18,000 in costs + $466,000 in lost revenue + lost tenant (estimated at $150,000/year in net effective rent). Over five years, the total cost of one wrong cell reference exceeded $1M.

The Lessons

1. Recovery ratio is a diagnostic tool. When the recovery ratio dropped from 91% to 84%, that was the signal. A 7-point drop without a corresponding change in lease structure or vacancy pattern means something is wrong with the reconciliation, not the market. Investigate, don't compensate.

2. Never gross up fixed expenses. Property taxes, insurance premiums, and other costs that don't vary with occupancy should never be included in the gross-up calculation. This is the most commonly cited finding in tenant audits because it's easy to prove and the dollar amounts are large.

3. Inherited spreadsheets need validation. When you inherit a reconciliation workbook, trace every formula. Don't assume the previous controller built it correctly. The most dangerous errors are the ones that have been producing wrong numbers for years without anyone noticing.

4. The true cost includes what you didn't collect. The headline number was $247,000 in refunds. But the larger loss was $466,000 in legitimate revenue never billed. Both came from the same root cause.

5. Automation prevents formula errors. A purpose-built reconciliation system doesn't have SUM formulas that miss rows. The expense pool is defined by GL code mapping, not by spreadsheet cell ranges. CapVeri catches this class of error by design — the insurance expense would have been included in the recovery pool automatically based on its GL code.

Related Resources

Top 15 CAM Billing Errors — Prevention checklist
Recovery Ratio Analysis — Using recovery ratio as a diagnostic
Self-Audit CAM Billing — Catch errors before tenants do
Data Migration Off Excel — Moving beyond spreadsheet risk