Enter the property’s CAM costs and one tenant’s lease terms. You’ll see their pro-rata share, any cap, and whether they owe you money or you owe them a credit, with every step of the math shown. Then add every tenant to the roster to see the property’s totals and print each tenant’s statement.
Free, no signup
Runs in your browser; nothing you type is sent to TenantPoint
Download a CSV or print the result
This tenant's reconciliation
Calculate one tenant's CAM true-up
Three short steps, then save the tenant to build the whole property's roster. The result updates as you type.
You're looking at a worked example. Replace any number with your own.
Credit due to the tenant
$2,430
They paid $14,400 in estimates, but their share of this year’s CAM is only $11,970 after the cap. Refund the difference or credit it against upcoming charges, as the lease directs.
An estimate for one tenant. It skips exclusions, gross-ups, base years, admin-fee limits, and expense pools, and caps the whole share rather than only controllable costs. The lease controls.
How we got this number
Pro-rata share3,000 sq ft ÷ 45,000 sq ft6.67%
Share before any cap$180,000 total CAM × 6.67%$12,000
Cap limit$11,400 last year × (1 + 5%)$11,970
Share this tenant paysThe lower of $12,000 and $11,970, so the cap applies$11,970
Less estimates already paidTheir monthly CAM payments, added up− $14,400
Reconciliation of Northline Dental's share of this year’s common area maintenance costs
Total CAM expenses for the year
$180,000
Pro-rata share3,000 sq ft ÷ 45,000 sq ft
6.6667%
Share before any cap
$12,000
Cap on this year’s shareLast year’s $11,400 + 5%
$11,970
Share allocated to the tenant
$11,970
Less estimates paid during the year
− $14,400
Credit due to the tenant
$2,430
Prepared from the figures entered in TenantPoint’s free CAM reconciliation calculator (tenantpoint.co/tools/cam-reconciliation-calculator). It applies a pro-rata share by rentable area and, where shown, a year-over-year cap on the whole share. The lease controls.
Free template
Get the CAM reconciliation worksheet
The spreadsheet version: recoverable pool, each tenant's share, caps, proration, admin fee and the true-up balance. Comes with the reconciliation and audit checklists.
CAM reconciliation worksheetSpreadsheet template
CAM Reconciliation ChecklistPrintable checklist
CAM Audit Checklist for Landlords and TenantsPrintable checklist
How to use the CAM reconciliation calculator
1
Enter the property's numbers
The year's total CAM costs and the property's rentable square footage, from your operating statement and the lease. A property name and year are optional; they appear on the roster and each statement.
2
Add this tenant's lease terms
Their square footage and, if the lease has one, the cap on yearly CAM increases.
3
Compare with what they paid
Enter the estimates they paid during the year. The result shows the true-up and how it was calculated, and you can print a statement for this tenant.
4
Save the tenant and add the next
Give them a name and suite, save them to the roster, and repeat. Add every tenant to see the property's totals, the checks to make before you send statements, and the landlord's share of vacancy.
What this calculator covers, and what it doesn’t.
Included
The core true-up, for one tenant or the roster
A pro-rata share by square footage, an optional year-over-year cap on last year's actual CAM, and the balance against estimates already paid. Every dollar figure is rounded to whole dollars before the balance is worked out. Save each tenant to the roster and the property's totals, occupancy, cap absorption, vacancy share, and recovery are added up from those same figures.
Not included
Lease-specific adjustments
Exclusions, gross-ups for partial occupancy, base years or expense stops, admin-fee limits, controllable-only caps, and separate expense pools for different tenant groups. The checks under the roster flag a likely gross-up and any cap that binds, but apply neither; the rest you check against each lease yourself.
Best use
Check the statements before you send them
Sanity-check one tenant's number, answer a tenant's question about how their share was worked out, or run the whole property to see what the statements add up to and what the landlord carries.
Allocation = total CAM expenses × pro-rata share, rounded to whole dollars.
If a cap is on: cap limit = last year’s allocation × (1 + cap %), and the allocation is the lower of the two.
Balance = allocation − estimates already paid. Positive means the tenant owes; negative means a credit.
Property roster: leased area = the tenants’ square feet added up; occupancy = leased ÷ rentable. Allocated, estimates paid and the net balance are each tenant’s rounded figures added up.
Absorbed by caps = (share before the cap − allocation), added up over the tenants whose cap binds.
Landlord’s vacancy share = total CAM × (rentable − leased) ÷ rentable, never below zero. Recovery = allocated ÷ total CAM.
What it leaves out
Exclusions and expense pools.
Gross-ups and base years: a roster check reminds you to gross up when occupancy is under 95%, but nothing is grossed up and base years are never applied.
Administrative-fee limits.
Capping only controllable costs: it caps the whole share.
Vacant suites as rows: the roster lists tenants, and vacancy is whatever area they don’t cover.
Method checked October 4, 2026. General information for commercial property owners, not legal, tax, or accounting advice. The signed lease controls.
CAM reconciliation questions, answered.
What is a CAM reconciliation?
In most commercial leases, tenants pay monthly estimates of their share of common area maintenance (CAM) costs during the year. After the year ends, the landlord compares each tenant's share of the actual costs with the estimates they paid. If the share is higher, the tenant owes the difference; if it is lower, the tenant is due a refund or credit. That year-end true-up is the CAM reconciliation.
Usually by dividing the tenant's rentable square footage by the property's total rentable square footage: a 3,000 sq ft space in a 45,000 sq ft center has a 6.67% share. Leases differ on the denominator. Some divide by leased or occupied area instead of total rentable area, which raises every tenant's share when the property isn't full, and some leave out anchor tenants that pay their own costs. Use the exact definition in the lease.
How does a cap on CAM increases work?
A cap limits how much a tenant's CAM can grow from one year to the next, usually by a stated percentage such as 3% to 5%. Most caps apply only to controllable expenses like landscaping, janitorial, and repairs; taxes, insurance, utilities, and snow removal are commonly carved out and pass through in full. This calculator applies a simple year-over-year cap: this year's share can't exceed the tenant's actual CAM last year times (1 + the cap percentage). It caps the whole share you enter, so if the lease caps only controllable expenses, run those costs separately.
What's the difference between a cumulative and a non-cumulative cap?
Leases and guides use these labels inconsistently, so go by how the lease defines the cap rather than the name. Caps come in two basic structures. In one, the cap grows from a fixed starting amount every year whether or not costs actually rose, so unused room carries forward and a cheap year can be followed by a bigger catch-up. In the other, each year's increase is measured against the prior year's actual costs, so a cheap year lowers the base for every year after it. This calculator uses the second, simpler structure. If your lease works the other way, enter last year's capped limit instead of last year's actual charge.
Which expenses are usually excluded from CAM?
Common exclusions include capital expenditures such as a roof or parking lot replacement (or all but an amortized portion each year), leasing commissions and tenant-improvement costs, the landlord's financing costs and income taxes, costs reimbursed by insurance or by another tenant, and costs caused by the landlord's own negligence. Many leases also limit the management or administrative fee to a stated percentage. Remove excluded items before entering the property's total CAM.
What is a gross-up, and does this calculator apply one?
A gross-up clause adjusts variable expenses, such as janitorial or common-area utilities, to what they would have been at a stated occupancy (often 95% or 100%). It keeps tenants in a partly vacant building paying a consistent share and lets the landlord recover costs that rise with occupancy. This calculator doesn't gross up. If the lease has a gross-up clause, adjust the variable expenses first and enter the adjusted total.
How do base years and expense stops change the math?
In a base-year lease, common in office buildings, the tenant pays its share only of the increase in expenses above a base year, not its full share. An expense stop works the same way with a fixed dollar amount instead of a year. This calculator assumes a net lease where the tenant pays its full pro-rata share, so for a base-year or expense-stop lease, subtract the tenant's share of the base amount from the result.
Can I reconcile the whole property, not just one tenant?
Yes. Work out one tenant, then use step 4 to save them to the property roster and clear the tenant fields for the next one. The property's total CAM and square feet stay put. Once the roster has a tenant, a table under the calculator shows every tenant's share, allocation, estimates paid, and balance, with totals for leased area, occupancy, the net amount owed or credited, what the caps absorb, the landlord's vacancy share, and the percentage of CAM recovered. A short list of checks follows it, for example a reminder to gross up when occupancy is under 95%. The roster is saved only in your browser, so you can come back to it; nothing you type is sent to TenantPoint.
Can I print a statement for the tenant?
Yes. With a tenant's figures in the form, use "Print statement for this tenant" in the result panel. It prints a one-page statement with the property name, the year, the tenant and suite, and the lines of the calculation: total CAM, pro-rata share, share before the cap, the cap, the allocated share, estimates paid, and the balance, with a note that the lease controls. To print a statement for a tenant already on the roster, use Edit on their row to load them back into the form first. "Print / save as PDF" still prints the whole page, including the roster.
When is a reconciliation due, and what if a tenant disputes it?
Many leases require the landlord to deliver the annual statement within a set period after the year ends, commonly 90 to 180 days, and give tenants a window to review or audit the records. Under some leases a late statement can limit what you're able to collect, so check yours. If a tenant disputes the statement, pin down exactly what is being questioned, check the lease's audit-rights language, and answer with the invoices, the square footage, and the calculation behind that specific item.
TenantPoint keeps each lease's share, caps, and CAM charges in one workspace for owner-operators, and reconciles every tenant from them. It does not calculate gross-ups, base years or admin fees today. Start a 21-day trial; no credit card required.