Commercial Lease Operating Expense Reconciliation: Step-by-Step Guide
The annual reconciliation cycle — from closing your books to collecting true-up payments — for NNN, modified gross, and gross leases.
Quick Answer
Operating expense reconciliation in a commercial lease is the process of comparing actual annual expenses to the estimated amounts collected from tenants, generating either a true-up invoice (tenant owes more) or a credit (tenant overpaid). It applies to all lease structures where tenants share operating costs — NNN, modified gross, and full-service leases with expense stops or base years.
How Lease Structure Affects Reconciliation
| Lease Type | What Tenant Pays | Reconciliation Scope | Key Complexity |
|---|---|---|---|
| Triple Net (NNN) | All operating expenses: taxes, insurance, CAM | Full recoverable expense pool vs. estimated payments | Gross-up, capital exclusions, CAM caps |
| Modified Gross | Selected expense categories (e.g., utilities only, or taxes only) | Only the expense categories specified in the lease | Identifying which categories apply per each lease |
| Full Gross / Full Service | Fixed gross rent; landlord absorbs all operating costs | Expenses above base year or expense stop only | Establishing the base year expense level accurately |
The Annual Reconciliation Timeline
Close fiscal year books
Post all operating expense invoices for the prior year. Book accruals for expenses incurred but not yet invoiced — utilities, insurance premium adjustments, property tax refunds. Do not leave the books open past this date or the GL export will be incomplete.
Run GL export and classify expenses
Export the full GL for the reconciliation period. Classify each line item as recoverable or non-recoverable per each tenant's lease exclusion schedule. Flag capital expenditures, owner-specific costs, and management fees exceeding the lease cap. This classification step is where most reconciliation errors originate.
Apply gross-up and calculate pro-rata shares
For leases with gross-up provisions, normalize variable expenses to the occupancy threshold defined in each lease. Calculate each tenant's pro-rata share using the denominator in their specific lease. Apply CAM caps where applicable. Verify that the prior year base is correct before calculating any cap ceiling.
Send reconciliation statements
Send a complete reconciliation package to each tenant: the expense pool detail, their pro-rata share calculation, prior estimated payments, and the resulting true-up balance. Check each lease for the specific deadline — many leases require delivery within 90 or 120 days of fiscal year end. Missing this deadline can waive your right to collect.
Collect true-up payments and update estimates
Collect outstanding true-up invoices. Issue credits to tenants who overpaid. Update each tenant's monthly estimated CAM payment for the current year based on the reconciled prior year actuals, typically increasing by 3–7% as a forward estimate.
Key Data Sources for Reconciliation
General Ledger (GL) Export
The primary data source. Export from Yardi, MRI, or your accounting system filtered by property and expense account codes. Confirm the export covers the full fiscal year — partial-year exports are a common source of errors.
Tenant Lease Abstracts
Each lease defines the recoverable expense categories, exclusion carve-outs, denominator SF, gross-up threshold, and CAM cap terms. Abstracts must be current — mid-lease amendments frequently change these terms.
Prior Year Reconciliation Statements
Required to establish the base year expense level for leases with base year OE structures, and to calculate the prior year CAM figure for cap ceiling calculations.
Rent Roll and Estimated Payment History
Confirms each tenant's leased square footage and the total estimated CAM payments collected during the year. Discrepancies between the rent roll SF and the lease abstract SF must be resolved before calculating pro-rata shares.
Separating Base Year Expenses from Current Year Actuals
For full-service and modified gross leases with expense stop or base year structures, reconciliation requires calculating two figures:
The base year figure must be fixed at the level established when the lease was executed. A common error is recalculating or adjusting the base year — once locked in a lease, the base year amount cannot be changed without a lease amendment.
What Can Go Wrong
Missing lease-specific exclusions in GL classification
Applying a single exclusion list to all tenants when different leases have different carve-outs. Tenant A's lease may exclude management fees; Tenant B's may not. Running a single reconciliation template without lease-specific filtering is the most common source of overbilling and the first thing an auditor checks.
Sending reconciliation statements past the lease deadline
Many leases specify that if the landlord does not deliver a reconciliation statement within 120 or 180 days of year end, the tenant's obligation to pay the true-up is waived for that year. At $15,000 per tenant × 20 tenants, missing the deadline costs $300,000 in permanent, unrecoverable leakage.
Not separating base year expenses from current year in expense-stop leases
Billing the full operating expense pool instead of only the excess above the base year on full-service or modified gross leases. Tenants in these leases are only responsible for increases above their contractual base — billing the full pool without the base year offset results in overbilling, often by 80–90% of what was invoiced.
Frequently Asked Questions
What is operating expense reconciliation in a commercial lease?
Operating expense reconciliation compares actual annual expenses to estimated tenant payments, generating a true-up invoice or credit. It applies to all lease structures where tenants share operating costs — NNN, modified gross, and full-service leases with expense stops.
How does NNN reconciliation differ from gross lease reconciliation?
NNN tenants pay their pro-rata share of all operating expenses. Reconciliation compares actual expenses to monthly estimates for the full recoverable pool. In a gross or modified gross lease, reconciliation applies only to expenses above the base year or expense stop — not the entire pool.
What happens if the landlord misses the reconciliation deadline?
Many leases include a strict deadline (typically 90–180 days after fiscal year end) with a waiver provision if missed. Missing the deadline may permanently waive the landlord's right to collect the true-up for that year.
What data sources are needed for operating expense reconciliation?
You need: (1) the GL export for the reconciliation period; (2) each tenant's lease abstract with exclusion carve-outs and pro-rata denominator; (3) prior year reconciliation statements for base year and cap calculations; and (4) the rent roll and estimated payment history.
Related Resources
CAM Reconciliation Explained
Overview of CAM reconciliation mechanics
CAM Reconciliation Process
Detailed workflow from GL to true-up
What Are CAM Charges?
Foundational guide to CAM charges
CAM Gross-Up Calculator
Model gross-up adjustments at multiple occupancy thresholds
CAM Reconciliation Software
Automate the full reconciliation cycle from GL export to statements
Run Your Reconciliation in Hours, Not Weeks
CapVeri processes your GL export, applies each tenant's lease exclusions, and generates reconciliation statements — no manual classification required.
Get Started Free