Commercial CAM Underbilling: An Expense-Recovery Audit Checklist

Commercial CAM Underbilling: An Expense-Recovery Audit Checklist

CAM underbilling rarely looks dramatic at first. It may be a utility invoice coded to the wrong account, an expense pool that was never updated after a lease amendment, or a tenant estimate that stayed flat while operating costs climbed.

Those small misses add up. By the time you prepare a CAM or NNN reconciliation, the work can turn into a hunt across leases, vendor bills, spreadsheets, and prior statements. The result is not just lost recovery. It is a harder conversation with tenants because the numbers are difficult to explain.

This checklist gives commercial landlords and property managers a practical way to audit potential underbilling before finalizing a tenant charge or credit. Every lease is different, so the lease language controls what is recoverable, how costs are allocated, any caps or exclusions, and the timing and support required for a statement. Use qualified legal and accounting advice when an interpretation or treatment needs it.

Start With a Defined Audit Period

Choose the period you are reviewing before you pull reports. That might be the current year to date, the prior reconciliation year, or the period since a new lease or amendment took effect.

Write down four basics:

• The property or properties included.
• The beginning and ending dates.
• The tenant roster and any move-ins, move-outs, expansions, contractions, or vacancies during the period.
• The question you are trying to answer, such as whether all recoverable costs were billed or whether estimates need to change.

Without a clear cutoff, it is easy to mix a late bill, a prior-period adjustment, and a current-year expense into the same review. Keep exceptions visible rather than forcing them into a number that cannot be supported yet.

1. Reconfirm What Each Lease Allows You to Recover

Do not begin with the general ledger. Begin with the lease abstract and the executed lease documents.

For each tenant, verify the provisions that affect recovery:

• Whether the lease uses CAM, operating expenses, taxes, insurance, or another defined recovery structure.
• The tenant's stated share, allocation method, and any denominator definition.
• Included categories, stated exclusions, caps, gross-up provisions, and special carve-outs.
• Whether the tenant has an individual meter, exclusive-use cost, or separate billing arrangement.
• The estimate, reconciliation, notice, audit, and payment provisions that apply.
• Amendments, side letters, renewals, or concessions that changed the original terms.

A cost may be ordinary at the property level and still be nonrecoverable for a particular tenant. The audit trail should show both the expense and the lease rule that governs it.

> Practical rule: Flag uncertain treatment for review instead of assuming a cost is recoverable because it was billed in a prior year.

2. Build an Expense Map Before Looking for Missing Charges

An expense map connects the way costs are coded in accounting to the way they are treated under the lease. It can be a report, a spreadsheet, or a property-management workflow, but it should answer the same questions.

For each expense account or recurring vendor category, record:

| Expense category | Typical support | Proposed pool | Lease treatment to verify | | --- | --- | --- | --- | | Landscaping | Vendor invoice and contract | Common area | Included work, exclusive areas, cap treatment | | Utilities | Invoice, meter data, service period | Common area or tenant-specific | Meter responsibility and allocation method | | Repairs and maintenance | Invoice, work order, scope | Common area, building-wide, or excluded | Repair versus capital treatment and exclusions | | Insurance and taxes | Policy, tax bill, payment support | Separate pass-through pool or operating expense pool | Lease definition and timing | | Management or administration | Invoice or internal support | Administrative pool if permitted | Fee limits, caps, and included services |

The purpose is not to create a universal list of recoverable expenses. It is to find the gap between your accounting categories and your lease-specific recovery rules.

3. Trace Actual Expenses Back to Source Documents

Run the detailed expense report for the audit period and review the categories that are large, unusual, newly created, or frequently adjusted. Then trace material entries to the invoice, contract, work order, tax bill, payroll record, or other supporting document.

Ask these questions for each item:

1. Is the property and service period correct? 2. Is the expense recorded once, rather than duplicated or netted against another entry? 3. Does the coding match the actual work performed? 4. Is the expense in the correct recovery pool? 5. Is there a credit, rebate, insurance payment, vendor allowance, or other offset that should be considered? 6. Is the documentation sufficient to explain the charge if a tenant asks?

This step often identifies underbilling that is not caused by a missing invoice. A cost may be posted correctly but routed to a nonrecoverable account, left out of a schedule, or assigned to the wrong pool.

4. Test Expense Pools and Allocation Denominators

Once the expenses are mapped, test the math that turns property costs into tenant charges.

Confirm that each pool has a defined population of expenses and tenants. Common examples include a center-wide common-area pool, a building-only pool, a tenant-specific charge, or a separate tax or insurance calculation. Mixing those pools can make a valid expense look unrecoverable—or charge a tenant for a cost the lease does not assign to them.

Then confirm the denominator and effective dates behind each allocation. Depending on the lease, that may involve rentable square feet, occupied square feet, leased area, a fixed percentage, or another stated method. Check for changes during the period, including a new tenant, a vacancy, a suite expansion, or a lease amendment.

Keep the source for each denominator with the calculation. A tenant statement is easier to defend when you can show where the percentage came from and when it applied.

5. Compare Actual Recoveries With What Was Billed

Now compare the recoverable actual expenses for each tenant or pool with the amounts already collected through monthly estimates or other billings.

Your review should distinguish among:

• Expenses that were recoverable and already included in estimates.
• Recoverable expenses that were omitted from estimates but may be addressed in a reconciliation, subject to the lease.
• Expenses that were included in estimates but became nonrecoverable after review.
• Timing differences, credits, or adjustments that need an explanation rather than a second charge.

Do not treat a variance as an automatic bill. First determine why it exists. A large difference may point to an underbilling opportunity, but it may also reveal a cap, an exclusion, an allocation error, or a missed credit.

6. Review Caps, Exclusions, and Special Lease Terms Separately

Caps and exclusions are where an apparently simple recovery calculation can change quickly. Treat them as a separate audit step, not a footnote after the total is calculated.

For every affected tenant, document:

• The exact lease language and the category it applies to.
• The base year or comparison period, if applicable.
• Whether the cap is cumulative, annual, compounded, or limited to certain costs.
• Any excluded categories or pass-through categories outside the cap.
• The calculation and supporting records used to apply the provision.

If the language is unclear, preserve the facts and raise the interpretation for qualified review. A clean audit file is more useful than an aggressive assumption.

7. Reconcile Credits and Offsets Before Issuing a Statement

Underbilling audits should look for offsets as carefully as they look for expenses. Review vendor credits, refunds, insurance recoveries, rebates, utility adjustments, prior overbillings, and payments that were posted to the wrong period or tenant.

This protects both sides of the reconciliation. It helps avoid a statement that overstates a tenant's share and makes the final recovery calculation more credible.

Maintain a short adjustment log with the date, amount, reason, affected pool or tenant, and support location. If an item remains unresolved, show it as an open exception rather than quietly removing it from the file.

8. Prepare a Tenant-Ready Support Package

Before sending a charge or credit, make sure someone other than the preparer can follow the calculation from the lease rule to the final number.

A useful support package typically includes:

• The relevant lease abstract and any amendment notes.
• The expense-pool summary and detailed expense report.
• The allocation schedule and denominator support.
• A comparison of actual recoveries against estimates or prior billings.
• The cap, exclusion, credit, and adjustment calculations where applicable.
• A concise explanation of the charge or credit and the payment timing required by the lease.

The goal is not to overwhelm a tenant with every internal record. It is to retain enough support to answer reasonable questions promptly and consistently.

Commercial CAM Underbilling Audit Checklist

Use this final pass before approving a reconciliation or changing estimates:

1. Define the audit period, property, tenant roster, and review objective. 2. Confirm executed lease terms, amendments, allocation rules, caps, exclusions, and deadlines. 3. Map accounting categories to lease-specific recovery pools. 4. Trace material, unusual, and newly coded expenses to source documents. 5. Verify property, service period, category, and pool for each reviewed item. 6. Confirm allocation denominators and effective dates. 7. Compare recoverable actuals with estimates and other amounts billed. 8. Calculate caps and exclusions separately for each affected tenant. 9. Review credits, rebates, refunds, and prior adjustments. 10. Document unresolved items, owners, and next steps. 11. Assemble a support package that explains the final tenant charge or credit. 12. Review the completed calculation against the lease before issuing the statement.

Make the Next Reconciliation Easier

The best underbilling audit is not a once-a-year rescue project. It becomes easier when lease terms, expense coding, allocation data, and supporting documents are maintained throughout the year.

For a broader walkthrough of the true-up process, read our NNN CAM reconciliation guide. You can also use the CAM calculator to test allocation assumptions before finalizing a schedule; the lease and supporting records remain the source of truth for each tenant.

PigJet helps commercial landlords keep lease obligations, operating expenses, and tenant follow-up work organized in one place—so there is less to reconstruct when it is time to review CAM recoveries. See how PigJet supports commercial property operations.