How to Build a Defensible Reconciliation Package

By Angel Campa, Founder, CapVeri

What Makes a Reconciliation Package Defensible

A defensible package is one that answers an auditor's questions before they ask them. It does not mean burying the tenant in paper. It means providing enough structured information that a competent reviewer can verify the math, understand the methodology, and identify any areas they want to examine further — all without a single phone call.

Tenant auditors bill $150–$350/hour. Every hour they spend requesting basic information that should have been in the package is an hour you pay for (if the lease shifts audit costs to the landlord above a threshold) or an hour that extends the dispute timeline. A well-structured package reduces audit duration by 30–50% compared to a bare-bones statement that forces the auditor to reconstruct your methodology from scratch.


The Three Layers of Documentation

Think of the reconciliation package as three concentric layers. Every tenant gets Layer 1. Layer 2 goes to tenants who ask questions. Layer 3 is produced only during a formal audit.

Layer 1: The Reconciliation Statement Package (Proactive)

This is what every tenant receives with their annual reconciliation statement. It should contain four documents:

1. Cover Letter (1 page)

The cover letter is not a formality. It is your first line of defense against disputes. A good cover letter answers three questions: what changed, why it changed, and what the tenant owes.

Structure:

  • Opening paragraph: State the reconciliation period, the total CAM charge for the period, the estimates collected, and the net true-up or credit amount.
  • Year-over-year summary: Two to three sentences on the largest changes. "Property insurance increased 14% ($38,000) due to carrier market conditions. Property tax increased 6% ($22,000) following the county's 2025 reassessment. All other categories were within 3% of prior year."
  • Payment instructions: How to pay the true-up (or how the credit will be applied), and the due date.
  • Contact information: Name and direct number for questions. Not a generic property management email.

What not to include in the cover letter:

  • Apologies for increases. The expenses are what they are.
  • Predictions about next year. You do not know yet.
  • Legal disclaimers. The lease governs; the cover letter is communication.

2. Reconciliation Statement (1–2 pages)

The statement itself is the calculation. It must show:

Line ItemWhat It Shows
Expense categoriesTotal actual expense per category (CAM, Tax, Insurance — or however the lease defines pools)
Gross-up adjustmentIf applicable, the adjusted amount for variable expenses at target occupancy
Total recoverable expensesSum of all categories after exclusions and adjustments
Tenant's pro-rata share %The tenant's SF divided by the denominator, expressed as a percentage
Denominator usedThe total rentable or leasable SF used in the calculation
Tenant's allocated shareRecoverable expenses x pro-rata %
Cap adjustmentIf applicable, the capped amount and the cap calculation
Base year adjustmentIf applicable, the base year amount and the excess calculation
Admin/management feeIf applicable, the fee amount and calculation basis
Total tenant obligationThe bottom line for the period
Estimates collectedTotal of monthly estimates paid during the year
Net true-up (or credit)Total obligation minus estimates collected

Show the Denominator

The single most questioned number on any reconciliation statement is the pro-rata share percentage. Always show the numerator (tenant SF), the denominator (building SF), and the resulting percentage. A statement that says "Your pro-rata share is 4.82%" without showing 9,640 SF / 200,000 SF invites a question. A statement that shows all three numbers does not.

3. Expense Category Summary (1 page)

A one-page table showing each expense category with current year actual, prior year actual, and dollar/percentage variance:

CategoryPrior YearCurrent Year$ Change% Change
Janitorial$142,000$147,300+$5,300+3.7%
R&M$98,500$103,200+$4,700+4.8%
Landscaping$62,000$64,800+$2,800+4.5%
Utilities$285,000$308,000+$23,000+8.1%
Insurance$272,000$310,100+$38,100+14.0%
Property Tax$365,000$387,000+$22,000+6.0%
Management Fee$85,000$87,500+$2,500+2.9%
Total$1,309,500$1,407,900+$98,400+7.5%

This summary tells the tenant exactly where the increase came from. Insurance and utilities account for $61,100 of the $98,400 increase. Everything else is within normal range. A tenant who sees this table understands the true-up without needing to request GL detail.

4. Methodology Notes (half page)

If your reconciliation involves gross-up adjustments, multiple expense pools, or non-standard allocation methods, include a brief methodology note. This is not a legal brief — it is a plain-language explanation:

"Building occupancy averaged 82% during the reconciliation period. Variable expenses (janitorial, utilities, R&M) have been grossed up to 95% occupancy per Section 8.4 of your lease. Fixed expenses (property tax, insurance) are not grossed up. The gross-up increased the total recoverable CAM pool by $47,200."


Layer 2: First-Level Backup (On Request)

When a tenant or their representative requests additional detail, provide:

GL Summary by Account. A report showing every GL account that feeds into the CAM pool, with account number, description, and annual total. This is the bridge between the category-level summary in Layer 1 and the individual transactions in Layer 3.

Example:

GL AccountDescriptionAnnual Total
6110Day Janitorial - Contract$98,000
6115Day Janitorial - Supplies$12,400
6120Night Janitorial - Contract$31,200
6125Window Cleaning$5,700
Janitorial Total$147,300
6210HVAC Maintenance$38,500
6220Plumbing Repairs$12,800
6230Electrical Repairs$18,400
6240General Building Repairs$33,500
R&M Total$103,200

Rent Roll Extract. The list of tenants in the building during the reconciliation period, with their suite, square footage, lease start/end dates, and months of occupancy. This lets the auditor verify the denominator and confirm that the occupancy data matches the gross-up calculation.

Cap Calculation Worksheet. If the tenant has a CAM cap, show the prior year's capped allowable, the cap percentage, the current year ceiling, the actual amount, and which number was used. This is the calculation most frequently challenged in audits (see /resources/cam-expense-caps).


Layer 3: Full Audit Package (Formal Audit Only)

This is produced only when a tenant exercises formal audit rights under their lease. It includes:

  • Complete GL transaction detail for every account in the CAM pool. Every invoice, journal entry, and adjustment.
  • Vendor invoices for any transaction the auditor requests. Have these organized by GL account and sorted by date.
  • Service contracts for recurring vendors (janitorial, landscaping, elevator, security).
  • Property tax bills and assessment notices.
  • Insurance policy declarations pages showing premiums by coverage type.
  • Management agreement showing the fee calculation methodology.
  • Lease abstract for the auditing tenant, showing all CAM-related provisions.

Do Not Provide Layer 3 Proactively

Providing full GL detail and vendor invoices with the initial reconciliation statement does not reduce disputes — it increases them. An auditor reviewing 2,000 line items will find questions about individual transactions that they never would have identified from a category summary. Provide what the lease requires proactively (Layer 1), and respond to specific requests with targeted information (Layers 2 and 3). This is not about hiding information. It is about providing the right level of detail at the right time.


Common Documentation Failures That Auditors Exploit

1. No Prior-Year Comparison

A reconciliation statement that shows only the current year forces the auditor to request prior-year data separately, then build the comparison themselves. This adds time and creates an adversarial dynamic from the start. Including the prior-year comparison (Layer 1, document 3) eliminates this.

2. Unexplained Gross-Up

A tenant sees their CAM bill is based on $1,407,900 of expenses, but the GL total is $1,360,700. The $47,200 difference is the gross-up adjustment. Without the methodology note explaining this, the tenant's first assumption is that $47,200 was added without justification.

3. Missing Denominator Documentation

The statement says pro-rata share is 4.82%. The tenant's lease says they have 9,640 SF. They divide 9,640 by 4.82% and get a denominator of 200,000 SF. But the building's marketing materials say 205,000 SF. The 5,000 SF difference is the ground-floor common area excluded from the rentable area calculation. Without showing the denominator and its derivation, this becomes a dispute.

4. Inconsistent Expense Categories Year Over Year

Last year's statement had a line item called "Common Area Maintenance." This year it is split into "Janitorial," "Landscaping," and "R&M." The totals may be identical, but the tenant cannot verify that because the categories changed. If you restructure your statement format, include a bridge showing how last year's categories map to this year's.

5. Late Delivery Without Explanation

A statement that arrives 150 days after fiscal year-end, when the lease specifies 120 days, may not start the audit clock. Some leases treat late delivery as a waiver of the right to collect the true-up. At minimum, late delivery signals to tenants that the landlord's process is disorganized, which encourages them to audit.


Statement Format Checklist

Before sending any reconciliation statement, verify it includes:

  • Tenant name, suite number, and lease reference
  • Reconciliation period dates
  • Expense total by category
  • Gross-up adjustment (if applicable) with occupancy percentage stated
  • Exclusions (CapEx, landlord-only costs) explicitly listed or noted
  • Pro-rata share: numerator, denominator, and percentage
  • Cap calculation (if applicable): base, cap %, ceiling, actual, billed
  • Base year excess (if applicable): base year amount, current year amount, excess
  • Admin/management fee calculation
  • Total tenant obligation
  • Estimates collected (itemized by month or as annual total)
  • Net true-up or credit
  • Prior-year comparison by category
  • Cover letter with top 2–3 expense drivers
  • Payment instructions and due date

California SB 1103 Documentation Requirements

For commercial properties over 50,000 SF in California, SB 1103 imposes specific documentation obligations that go beyond what most leases require. Landlords must:

  • Provide an itemized statement of actual CAM expenses with the reconciliation.
  • Respond to tenant requests for supporting documentation within 30 days.
  • Make records available for inspection during normal business hours.

Failure to comply does not void the CAM charges, but it gives tenants procedural grounds to delay payment and extend dispute timelines. See the full SB 1103 compliance guide at /resources/sb-1103-compliance.


How CapVeri Supports Defensible Documentation

CapVeri generates all three layers from a single GL import. The reconciliation statement, category summary, prior-year comparison, and GL detail are all derived from the same dataset, which means the numbers are internally consistent by construction. Every calculation links back to the source GL entry, so when an auditor asks "why is R&M $103,200?" the answer is one click away, not a two-day forensic exercise through filing cabinets.

For a step-by-step guide to preparing for tenant audits, see /resources/tenant-audit-defense-playbook. For the pre-send checklist to run before delivering statements, see /resources/cam-presend-checklist.

Start Free Audit

Upload your GL export and CapVeri produces audit-ready reconciliation statements with built-in prior-year comparison, gross-up documentation, and category-level detail. Every number traces back to the source.

Start Free Audit

Frequently Asked Questions

What should be included in a CAM reconciliation statement?

A complete reconciliation statement includes: the total expense by category, the tenant's pro-rata share percentage and the denominator used to calculate it, the tenant's allocated share per category, any cap or base-year adjustments, the total amount owed, estimates already collected during the year, and the net true-up or credit. Supporting documentation should include a GL summary by category and the methodology for any gross-up or allocation adjustments.

How much backup documentation should a landlord provide with the reconciliation statement?

Provide enough to answer the first round of questions without a phone call: the statement itself, a one-page cover letter explaining major year-over-year changes, and a category-level expense summary with prior-year comparison. Do not proactively attach full GL detail, individual invoices, or vendor contracts. Reserve those for the formal audit process if the tenant exercises audit rights.

What triggers a tenant to audit a CAM reconciliation?

The three most common triggers are: a true-up exceeding 15% of annual estimates, a category-level increase that is not explained in the cover letter, and a reconciliation statement that arrives late or looks different from prior years. Tenants also audit when they are considering lease renewal and want to validate historical charges, or when a new CFO reviews vendor payments and questions the CAM line item.

Can a landlord be penalized for providing insufficient reconciliation documentation?

Some leases specify that an incomplete reconciliation statement does not start the tenant's audit clock. If the lease requires specific supporting documentation and the landlord does not provide it, the tenant may argue the statement was never properly delivered, keeping the audit window open indefinitely. California SB 1103 imposes specific documentation obligations for commercial properties over 50,000 SF.