CAM reconciliation

720 Polaris Parkway CAM reconciliation tool

Follow the steps below to upload expenses, set your rules, confirm the tenant roster, and calculate each tenant's true-up.

1
Expenses
2
Tenant Roster
3
Invoice Details
4
Calculate
1

Operating expenses

Upload a CSV or Excel file with two columns: category and annual amount. Or add lines manually.

Drop your 12-month opex report here, or click to choose a file (.csv, .xlsx)
Category Annual amount Admin fee base
Upload a report or add expense lines manually to continue.
2

Tenant roster

Enter leased area, each tenant's admin fee %, and CAM rate — estimated CAM paid recalculates automatically as you type. If a tenant moved in or out partway through the period, enter their actual months (and extra days) occupied — leave blank to assume the full period. Or upload a roster file (columns: tenant, area, admin fee %, estimated paid, CAM rate, unit ID, lease start, lease end, occupancy start, occupancy end, months occupied, days occupied).

Leave blank to auto-sum tenant areas. Set this explicitly if two tenants share one suite at different times (a mid-year turnover), so the space isn't counted twice.
Area allocation
Drop a tenant roster file here, or click to choose a file (.csv, .xlsx)
Tenant name Unit ID Area (sq ft) CAM rate ($/sqft/yr) Admin % Est. CAM paid ($) Months occupied + Days Lease start Lease end
3

Invoice details

Used when generating individual tenant CAM recovery invoices.

Each tenant's invoice increments from this number in table order.
4

Reconciliation results

Tenant Area Share Occupancy Admin % CAM due Est. paid True-up

True-up shown as amber = additional amount due from tenant. Green = credit owed to tenant. Figures assume expense lines tagged "excluded" (taxes/insurance) are kept out of the admin fee base but still included in the CAM pool billed to tenants.