HomeExpertly
www.homeexpertly.com

Commercial Real Estate CAM Pro-Rata Reconciliation Calculator

Work out a tenant’s pro-rata share percentage and monthly CAM obligation from rentable square feet — with the gross-up, management and admin fees, controllable expense cap and year-end true-up all shown line by line, plus a downloadable PDF.

Pro-rata share = tenant RSF ÷ the denominator your lease specifies. Total GLA and occupied GLA give very different answers, so read the clause before you trust a number. Estimates only, not legal or accounting advice.

Premises & Expenses
1 Premises & Denominator
sq ft
sq ft
%
sq ft
The custom field is only used when “Custom denominator” is selected — use it for a shared-area pool, a pad-site carve-out, or a stated share in the lease.
2 Annual Expense Pool
Landscaping & grounds Ctrl
$
Parking lot & snow Ctrl
$
Common area utilities Var
$
Janitorial & trash Var
$
Security Var
$
Repairs & maintenance Ctrl
$
Property insurance Fixed
$
Real estate taxes Fixed
$
Ctrl = controllable, subject to any cap. Var = controllable and occupancy-variable, so it is what a gross-up clause adjusts. Fixed = normally uncapped and never grossed up.
3 Fees, Gross-Up & Cap
95%
Variable costs are restated as if the property were this full, so a half-empty center does not under-recover. 95% is the market standard.
%
%
%
$
The cap limits this year’s controllable share to the prior year plus the cap percentage. Set the cap or the prior year figure to 0 to switch it off.
4 Base Year & True-Up
$/RSF
$
mo
%
A base year stop of $0 is a triple-net lease, where the tenant pays the full share. Any other figure is a gross or base-year lease, where the tenant pays only the excess over that amount per RSF.
Pro-Rata Share & CAM
Monthly CAM Obligation
Enter the tenant and building square footage to begin
Pro-Rata Share
Annual CAM Payable
True-Up Balance
Recoverable Pool Build-Up
Operating expenses as incurred
Gross-up adjustment
Management fee
Administrative fee
Total recoverable pool
Pro-rata share
TENANT GROSS SHARE
CAM Per RSF
Fees As % Of Pool
New Monthly Estimate
Year-End Reconciliation
Tenant gross share
Controllable cap credit
Base year stop credit
Net CAM payable
Estimates billed
BALANCE
Tenant Share By Expense Category
What this tenant pays into each line, largest first
Expense Schedule — Pool vs Tenant Share
CategoryPoolTenant Share$ / RSFType

Pool figures are after any gross-up. Tenant share is 5.00% of each line across 5,000 RSF. Controllable lines are the ones a cap and an audit clause reach.