CAM Reconciliation Spreadsheet: Free Excel Template for Tenants

A CAM reconciliation spreadsheet is a structured Excel or Google Sheets file that lets a commercial tenant independently verify whether the landlord's annual CAM statement is mathematically accurate and consistent with the lease terms. It organizes the landlord's expense line items, recalculates the allowable charge using your lease's formulas, and flags categories where the landlord's number differs from what the lease permits.

This guide explains what a tenant-side reconciliation spreadsheet should contain, walks through the key calculations, and provides the verification logic behind each section.

Key Takeaways

• A tenant-side spreadsheet does not replace the landlord's reconciliation statement: it verifies it.
• The four calculations every tenant should run are: (1) management fee re-verification, (2) pro-rata share check, (3) gross-up variable vs. fixed test, and (4) CAM cap compliance.
• Tango Analytics (2023) found material errors in 40% of commercial CAM reconciliations. A spreadsheet is the lowest-cost way to catch them before you pay.
• The most common spreadsheet error tenants make is using the landlord's stated pro-rata percentage instead of recalculating it from square footage.
• BOMA's retail standard (ANSI/BOMA Z65.5) defines how gross leasable area should be measured: use this as your denominator benchmark.

What a Tenant-Side CAM Reconciliation Spreadsheet Should Include

A complete tenant verification spreadsheet has five sections:

Section 1: Expense Line Item Reconciliation

Copy every line item from the landlord's reconciliation statement into column A. Add three additional columns:

Every line item in column C should trace to a specific provision in your lease. If you cannot find a lease provision permitting the charge, that item warrants a dispute.

Section 2: Management Fee Verification

Most leases define the management fee as a percentage of a specified base. The most common base definitions are:

• Percentage of gross revenues
• Percentage of total operating expenses
• Percentage of controllable operating expenses
• A fixed dollar cap

Formula to verify: Lease-Permitted Fee = Fee Rate (%) × Allowable Base

If the landlord's stated fee exceeds this result, the excess is an overcharge.

Example verification:

• Lease cap: 5% of controllable operating expenses
• Controllable operating expenses per statement: $480,000
• Permitted fee: $24,000
• Landlord's stated fee: $31,000
• Overcharge: $7,000

Fee-on-fee situations arise when the management fee percentage is applied to a base that already includes a prior management charge. If your lease defines the base as "total operating expenses" and another version of the management fee appears within those expenses, recalculate the base excluding all management-type charges.

Section 3: Pro-Rata Share Recalculation

Do not use the landlord's stated percentage. Recalculate from the denominator.

Formula: Tenant Pro-Rata Share = Tenant RSF ÷ Denominator RSF

The denominator should match your lease's definition exactly. Common denominator definitions:

In Payless Shoesource, Inc. v. Joye (E.D. Cal. 2014), the court examined a denominator dispute where the lease formula allocated CAM based on the ratio of tenant premises to the total gross leasable floor area of "completed buildings within the Development." The case was ultimately vacated on settlement, but illustrates how denominator definitions drive overcharge disputes. (Source)

Tolerance test: If the landlord's stated percentage differs from your recalculated percentage by more than 0.1%, the denominator used by the landlord differs from your lease's definition.

Section 4: Gross-Up Test

If your landlord applied a gross-up adjustment, verify it was applied only to variable expenses.

Permitted for gross-up: utilities, janitorial, trash removal, certain security and maintenance costs that scale with occupancy.

Not permitted for gross-up: property taxes, property insurance, landscaping contracts with fixed pricing, financing costs, management fees.

Create a column next to each expense:

For each row where a fixed-cost category received gross-up, calculate the amount of the adjustment: Gross-Up Error = Grossed-Up Amount - Original Amount. This is your potential overcharge for that line.

Section 5: CAM Cap Compliance

If your lease has a CAM increase cap, test whether this year's allocation complies.

Key question first: Is your cap cumulative (arithmetic) or compounded (exponential)?

Non-cumulative cap formula: Maximum Allowed Year N = Prior Year Actual × (1 + Cap Rate)

Cumulative cap formula: Maximum Allowed Year N = Base Year × (1 + Cap Rate × (N-1))

Compounded cap formula: Maximum Allowed Year N = Base Year × (1 + Cap Rate)^(N-1)

Over a 10-year term, a tenant whose landlord applies a compounded cap where the lease language supports only a cumulative cap overpays by roughly $32,789 on a $100,000 base. For larger controllable CAM allocations, this scales proportionally.

Step-by-Step: How to Use the Reconciliation Spreadsheet

Step 1: Gather Your Documents

You need:

• The current year's CAM reconciliation statement from your landlord
• Your lease (specifically the CAM, management fee, pro-rata share, and cap provisions)
• Prior year reconciliation statements (for cap testing and year-over-year comparison)

Step 2: Enter the Landlord's Line Items

Transcribe every line item from the reconciliation statement into Section 1 of the spreadsheet. Do not aggregate categories: keep each expense line separate.

Step 3: Classify Each Expense

For each line item, determine:

• Is this category permitted by your lease's CAM definition?
• Is this expense capital (should be depreciated) or operating (current-year expensible)?
• Is this a fixed cost or a variable cost?

Capital items are governed by IRS Rev. Proc. 2019-43, which establishes the "UNICAP" framework and useful-life thresholds. Under that guidance, improvements with useful lives exceeding 12 months must be capitalized rather than expensed in a single year. (Source)

Step 4: Run the Four Verification Calculations

Execute each formula in Sections 2 through 5 in order. Note every discrepancy between your calculation and the landlord's stated amount.

Step 5: Compile Your Findings

For each discrepancy, document:

• The expense category
• The landlord's stated amount
• The amount the lease permits
• The dollar difference
• The specific lease provision that supports your position

Step 6: Assess Whether to Dispute

Review the total discrepancy amount against your lease's dispute deadline. If the total exceeds the cost of a dispute letter and your dispute window is open, the economics favor challenging the overcharges.

Spreadsheet Limitations

A tenant-side spreadsheet does three things well: it catches mathematical errors in the landlord's stated amounts, it flags categories that appear to exceed lease permissions, and it identifies cap compliance failures.

It does not do three things: it cannot access the landlord's general ledger to verify that stated amounts match actual invoices, it cannot verify vendor contracts, and it cannot evaluate whether charges are reasonable by market standards.

For disputes above $10,000, a CPA-led audit that requests general ledger backup, vendor invoices, and occupancy records provides substantially more evidence than a spreadsheet review alone.

Interpreting Your Spreadsheet Results

After completing all five sections, you have a picture of whether the landlord's reconciliation is accurate and lease-compliant. Three outcomes are possible:

No discrepancies found. The landlord's math checks out against your lease provisions on all categories. You may still request backup documentation under your audit rights clause to verify that stated amounts match actual invoices. The reconciliation is verified to be lease-compliant at the surface level.

Minor discrepancies under $2,000 total. Whether to dispute depends on the effort-to-recovery ratio. Some tenants dispute every dollar; others focus on discrepancies large enough to justify the time investment. The dispute letter itself is the main effort. CamAudit generates dispute letter drafts automatically from findings, reducing this to minutes.

Material discrepancies above $2,000. The economics clearly favor a formal dispute. A dispute letter citing specific lease provisions and your calculation methodology is your opening position. Most landlords respond with a revised calculation or request for additional verification. True forensic auditors with general ledger access can verify whether the landlord's revised numbers are supported by actual invoices.

When the Landlord Refuses to Correct

If the landlord disputes your findings, you have three escalation paths: (1) request audit rights access to the general ledger under your lease's audit clause, (2) engage a CPA to issue a formal audit opinion on the discrepancy, or (3) pursue mediation or litigation if the landlord continues to refuse after formal demand.

Most disputes resolve before litigation. The existence of a formal dispute letter with specific lease citations and mathematical proof is usually sufficient to prompt negotiation.

Common Errors Tenants Make When Using Reconciliation Spreadsheets

Error 1: Accepting the landlord's pro-rata percentage. The landlord states "your share is 12.4%." Most tenants enter 12.4% in their spreadsheet without recalculating from square footage. If the landlord used the wrong denominator, the percentage is wrong from the start.

Error 2: Accepting the stated management fee base. If the lease caps the fee at 5% of controllable operating expenses, tenants need to identify which expenses are "controllable" per the lease definition. This often excludes taxes, insurance, and utilities, significantly reducing the permitted base.

Error 3: Missing gross-up on the base year. For modified gross leases, the base year expenses should be grossed up to a stabilized occupancy level before being used as the comparison floor. An un-grossed base year creates a structural overcharge that repeats every year.

Error 4: Testing only the current year's cap. CAM caps apply year-over-year. If you are in year 5 of a lease and the landlord has been compounding when the lease requires cumulative math, the overcharge began in year 2 and has grown each year.

Error 5: Missing the dispute deadline. Completing the spreadsheet after the dispute window closes eliminates your right to recover even a provable overcharge under the account stated doctrine.

Related Resources

Verification tools:

• CAM Overcharge Estimator : Estimate your potential overcharge from monthly bill inputs
• CAM Gross-Up Calculator : Verify gross-up was applied to variable expenses only

Guides:

• CAM reconciliation review checklist : 12 pre-payment verification steps
• Pro-rata share calculation errors : Common denominator manipulation patterns
• Management fee overcharge in CAM : How fee-on-fee stacking works

Dispute:

• How to dispute CAM charges : Process and template
• CAM reconciliation deadlines: tenant dispute timelines