CAM reconciliation template: step-by-step guide with example
A practical CAM reconciliation template for commercial leases, with the columns to include, a worked true-up example, and the lease clauses that change the math.
Pro Pixel Agency
A CAM reconciliation compares what a commercial tenant paid in estimated common area maintenance (CAM) charges during the year with its share of what the property actually spent. The difference is billed to the tenant or refunded. A good CAM reconciliation template makes the calculation repeatable, transparent and easy for tenants to check.
Below you will find the columns a template should include, a worked example, and the lease terms that most often change the result. Lease language always controls, so treat this as a framework and check each tenant's lease.
The short answer
A CAM reconciliation template lists each operating expense, removes items the lease excludes, applies any gross-up and caps, multiplies the recoverable total by the tenant's pro rata share, and subtracts the estimated payments the tenant already made. The result is the amount owed or refunded. Build the template from each lease's definitions of share, exclusions, caps and base year.
How CAM reconciliation works
- During the year: the tenant pays monthly estimated CAM based on the landlord's budget.
- After year-end: the landlord totals actual operating expenses for the property.
- Adjust: remove non-recoverable costs, apply gross-up and caps as the lease allows.
- Allocate: multiply recoverable costs by each tenant's pro rata share.
- True-up: compare each tenant's share with what it paid, then invoice or credit the difference.
- Reset: set new monthly estimates for the coming year.
Lease terms to pull before you start
Abstract these from each lease first. They are where most disputes start.
- Pro rata share: usually the tenant's rentable area divided by the building's total rentable or leasable area. Check whether the denominator is total area or occupied area; it makes a big difference in a partly vacant building.
- Inclusions and exclusions: many leases exclude items such as capital improvements, leasing commissions, landlord's financing costs and costs recovered from insurance.
- Caps: limits on how much controllable expenses may rise year to year, cumulative or non-cumulative.
- Gross-up: lets variable expenses be adjusted to a stated occupancy level so tenants do not underpay in a partly empty building. It should apply to costs that genuinely vary with occupancy, such as janitorial.
- Base year or expense stop: some leases make the tenant pay only increases over a base year amount.
- Administrative fee: some leases allow a management or admin fee on top of CAM; check the rate and what it applies to.
- Statement deadline and audit rights: when the landlord must deliver the reconciliation and how long the tenant has to review or audit it.
The CAM reconciliation template
Set up one sheet for property-wide expenses and one row per tenant for the allocation. The property sheet should include:
| Column | What it holds |
|---|---|
| Expense category | Landscaping, snow removal, janitorial, security, common utilities, repairs, insurance, property tax, management fee |
| Budgeted amount | The estimate used to set monthly payments |
| Actual amount | Year-end total from the general ledger |
| Excluded amount | Portion the lease does not allow to be recovered |
| Recoverable amount | Actual minus excluded |
| Gross-up adjustment | Adjustment for variable costs where the lease permits |
| Capped amount | Recoverable controllable expenses after applying caps |
| Notes and invoice references | Supporting documents for each line |
The tenant allocation sheet then includes: tenant name, suite, square footage, pro rata share, share of recoverable costs, admin fee if any, estimated payments received, and balance due or credit.
Worked example
A tenant leases 5,000 square feet in a 50,000-square-foot center, a 10% pro rata share. The figures below are illustrative.
| Line | Amount |
|---|---|
| Total actual operating expenses | $130,000 |
| Less excluded items (for example, a capital roof project) | −$10,000 |
| Recoverable expenses | $120,000 |
| Tenant share (10%) | $12,000 |
| Estimated payments made ($875 × 12) | $10,500 |
| Balance due from tenant | $1,500 |
If the tenant had paid $13,000 in estimates, the landlord would owe a $1,000 credit instead. If the tenant moved in mid-year, its share would be prorated for the months it occupied the space.
How a cap changes the result
Suppose the lease caps increases in controllable expenses at a fixed percentage over the prior year. If controllable costs such as landscaping and janitorial jumped well above that limit, the tenant pays only up to the capped amount and the landlord absorbs the rest. Uncontrollable items such as property taxes, insurance and utilities are often excluded from caps, so the template should keep controllable and uncontrollable expenses in separate subtotals. Whether a cap is cumulative (unused increases carry forward) or non-cumulative also changes the math, so note the cap type on each tenant's row.
Tips for a clean reconciliation
- Keep source documents with every line. Invoices and ledger extracts make tenant queries quick to answer.
- Verify square footage. Use measured areas, and keep the denominator consistent with each lease.
- Track mid-year changes. Expansions, contractions and move-outs need prorating by period, not year-end figures.
- Explain variances. A short note on why snow removal or utilities rose prevents most disputes.
- Deliver on time. Late statements may limit recovery under some leases.
For owners with growing portfolios, reconciliations take real accounting time. Our guide to what an accountant costs for a business and our overview of back-office outsourcing explain options for handling the workload. For anything involving lease interpretation or tax treatment, consult a qualified accountant or real estate attorney.
Using property data for leasing
Reconciliation season is also a good time to look at the property as a prospective tenant would. Rising vacancy pushes more cost onto fewer tenants and makes leasing harder. Clear marketing helps fill space faster: strong photography, accurate floor plans and, for vacant or unfinished units, renderings that show a fitted-out space. Our guide to architectural visualization explains how renderings are used in leasing, and a 3D visualization and rendering service can show a suite as a café, clinic or office before any fit-out is built.
Frequently asked questions
When is CAM reconciliation done?
Usually once a year after the property's fiscal year closes, within the deadline set in the lease. Some landlords also run mid-year reviews to adjust estimates if costs are moving sharply.
Can tenants audit CAM charges?
Many commercial leases give tenants the right to review or audit the landlord's records within a set period after receiving the statement. The scope, timing and who pays for the audit depend on the lease.
What costs are usually excluded from CAM?
Common exclusions include capital improvements (or their non-amortized portion), leasing commissions, costs of financing, repairs covered by insurance or warranties, and costs specific to other tenants. Each lease defines its own list.
What is a gross-up in CAM?
A gross-up adjusts variable expenses to what they would have been at a stated occupancy level, so the cost burden on occupied tenants stays fair and consistent when the building is partly vacant.
Need to lease vacant suites faster? Pro Pixel creates photorealistic interior and exterior renderings from your plans. Start a free 3D rendering trial for one of your spaces.
More useful paths
Use these paths to continue with the closest practical topic, service, or decision guide.
Spotted something wrong? Report an error on this page. We correct on the page and say what changed.
