CAM Reconciliation for NNN Retail: A Practical Checklist Before You Bill Tenants
The hardest CAM reconciliations are rarely hard because of one complicated formula. They are hard because a routine year-end true-up exposes months of small disconnects: a vendor invoice coded to the wrong bucket, a lease cap buried in a PDF, a tenant that started midyear, or an estimate schedule that does not tie to what was actually billed.
That is when a property manager ends up reconstructing the year from spreadsheets, email threads, and general-ledger exports while a tenant waits for an explanation of a bill they do not recognize.
For NNN retail owners, the better approach is to treat reconciliation as a reviewable operating file before it becomes a tenant invoice. The checklist below helps you verify the inputs, document judgment calls, and give tenants a statement that is easier to understand.
This is operational guidance, not legal, tax, or accounting advice. Lease provisions and applicable local rules vary. Use the controlling lease for each tenant, and involve qualified counsel or accounting professionals when interpretation or compliance is in question.
Start With the Tenant and Lease Roster
Do not start by adding up property expenses. First, confirm whose lease terms you are applying.
Build a roster for the reconciliation period that identifies each tenant, suite, possession or commencement date, move-out date if applicable, and the lease year used for the true-up. Then pull the provisions that affect recovery and billing.
For each tenant, verify:
- the reconciliation period and statement-delivery deadline;
- the tenant's allocation method and pro-rata share;
- the denominator required by the lease, such as rentable area, occupied area, or gross leasable area;
- recoverable expense categories and any stated exclusions;
- caps, gross-up rules, management-fee treatment, or special allocations;
- monthly estimated CAM payments already invoiced; and
- any notice, review, or audit provisions that affect the tenant package.
> Practical rule: A property-wide spreadsheet convention does not override a tenant-specific lease term. Keep the clause reference next to any assumption that changes the calculation.
If a tenant came online partway through the period, document the proration method before entering the calculation. The same goes for a vacancy, a suite expansion, or a denominator that changes under the lease. These are not clean-up tasks to leave until the statement is ready.
For a deeper explanation of the annual process, see NNN CAM reconciliation and pro-rata shares in multi-tenant NNN property.
1. Tie the Expense File to the Accounting Records
Gather the support for the entire reconciliation period before preparing tenant statements. A useful working file normally includes general-ledger detail, invoices, vendor contracts when relevant, utility records, tax and insurance documentation, credits, and year-end journal entries that affect the period.
Then tie the expense schedule back to the accounting records. The purpose is straightforward: every material charge should be traceable to support, and the total should not include the same cost twice through different accounts or reimbursement streams.
Flag these items for a deliberate review:
- large one-time repairs;
- invoices posted near the beginning or end of the period;
- credits, refunds, and vendor rebates;
- expenses that appear under a new account or vendor name;
- work that may relate to an exclusive-use area rather than a common area; and
- costs that may have been capitalized, reimbursed elsewhere, or excluded by a lease.
You do not need a perfect story for every small invoice before you begin. You do need a process that makes the material or unusual charges easy to investigate before they become a tenant question.
2. Map Every Expense to a Recoverability Decision
The accounting chart of accounts is an accounting tool. A CAM schedule is a lease-administration tool. Those categories often overlap, but they are not automatically the same.
Create a mapping table that assigns each expense line to a CAM category and records the recoverability decision. A simple review table can include the ledger account, vendor, amount, CAM category, lease treatment, support reference, and reviewer note.
| Review question | What to document | | --- | --- | | What is the charge? | Vendor, invoice, service period, and accounting account. | | Why is it in the CAM pool? | The lease category or internal recovery rule that supports inclusion. | | Does it need an adjustment? | Exclusion, cap, allocation change, credit, or timing adjustment. | | Can the decision be explained later? | Invoice or source reference plus a concise note. |
This is especially important when a line is plausible but not automatically recoverable. A repair may be ordinary property maintenance, an owner cost, a tenant-specific cost, or a project that needs a different treatment under the lease. Record the decision instead of relying on memory after the bill is sent.
For a lease-level review of this issue, see CAM caps and exclusions.
3. Review Budget-versus-Actual Variances Before Allocating Costs
Compare the actual expense pool to the budget or CAM estimates used during the year. The purpose is not just to explain why the final balance changed. It is an efficient way to spot source-data issues before allocation.
Sort the variance report by dollar movement and percentage movement. For each material change, identify whether it reflects:
- a real increase or decrease in operations;
- timing between the budget and the vendor billing cycle;
- an accounting classification issue;
- a property-wide charge that needs a tenant-specific adjustment; or
- a one-time item that requires lease review.
For example, a large increase in common-area utilities may be expected if usage or rates changed, but it still needs a traceable source. A landscaping variance may be a new contract, catch-up work, an incorrectly posted invoice, or a cost that belongs to a different period. The reconciliation file should distinguish those possibilities before a tenant has to ask.
4. Check the Allocation and Gross-Up Logic
Once the adjusted expense pool is ready, validate the allocation inputs before calculating tenant shares.
Check the numerator and denominator for every tenant. Confirm that the tenant's square footage, the property denominator, occupancy assumptions, and dates all match the applicable lease treatment. If the property uses a different allocation for taxes, insurance, utilities, or a tenant-specific service, isolate that calculation instead of forcing it through a general CAM percentage.
Where a lease permits gross-up, document the assumption, method, and expense categories to which it was applied. Where it does not, do not import a property-level convention by habit. The question is always what the lease supports for that tenant and expense category.
Before finalizing, perform a control total:
1. Add the tenant allocations. 2. Compare them to the adjusted recoverable pool. 3. Explain any difference as vacancy, an owner share, a nonrecoverable amount, a cap, a special allocation, or rounding.
If the control total does not tell a clear story, the tenant statements are not ready.
5. Reconcile the True-Up Against What Was Already Billed
The final tenant balance is not simply the tenant's share of actual expenses. It is the tenant's permitted share, adjusted under the lease, less the estimates or reimbursements already billed and received for the same period.
For every tenant, compare the final charge or credit against the ledger and invoice history. Verify that monthly estimates were posted to the correct period and that credits, concessions, or manual adjustments are visible in the calculation.
Use an exception review for:
- a large balance due or credit;
- a new expense category;
- a negative allocation or unexpected zero balance;
- a tenant whose cap materially changes the result;
- a tenant with a midyear start, move-out, or suite change; and
- an item that depends on a manual lease interpretation.
This review catches errors that can look like formula mistakes but actually start with source data. A charge assigned to the wrong property, a tax payment covering the wrong period, or a missed credit will not be fixed by changing the percentage formula.
6. Build a Tenant-Readable Reconciliation Package
A good reconciliation statement shows the inputs, not just the amount due.
At a minimum, make it easy for a tenant to see:
- the period covered;
- the allocation basis or pro-rata share used;
- actual expenses by category;
- lease-required adjustments, caps, or exclusions when material;
- estimated payments or credits already applied; and
- the resulting amount due or credit, including the due date and contact for questions.
Keep a supporting schedule behind the statement with the source for material charges and the version of the calculation that generated the bill. The first tenant communication does not have to include every invoice, but the file should make it possible to respond consistently if a tenant requests backup under the lease.
Avoid a bare invoice labeled "CAM true-up." A concise cover note that names the period, balance, due date, and point of contact makes the communication more useful and creates a clearer record of delivery.
7. Preserve the Audit Trail and Close the Loop
Before you send the statement, save a dated snapshot of the calculation, tenant roster, lease references, expense support, allocation schedule, and final statement. If a tenant raises a question later, preserve the original version before revising anything.
After delivery, track open balances, credits, questions, document requests, and final resolutions. Then capture the lessons that should change the next budget or estimate cycle: recurring utility movement, an expense category that needs better coding, a lease clause that requires a clearer abstract, or a tenant whose billing schedule did not match the reconciliation period.
The best CAM true-up process starts before year-end. Clean coding, current lease abstracts, timely review of unusual invoices, and a maintained tenant roster turn reconciliation from a scramble into a documented workflow.
If you want to test an allocation before finalizing a schedule, a CAM calculator can help with planning. The final tenant obligation should always be based on the applicable lease and the records supporting the expense file.
CAM Reconciliation Checklist: Final Pre-Billing Review
Use this short list before tenant statements go out:
- Tenant roster and reconciliation periods are current.
- Lease clauses, caps, exclusions, deadlines, and allocation methods are documented.
- Expense detail ties to accounting records and material invoices are supported.
- Recoverability decisions and adjustments are recorded.
- Budget-versus-actual variances have been reviewed.
- Allocation, gross-up, and control totals have been checked where applicable.
- Estimates already billed are reconciled to the final calculation.
- Tenant statement shows the period, inputs, payments, and amount due or credit.
- Calculation version, source support, and delivery record are retained.
---