CAM reconciliation

Plaza 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).

Should match the report period from Step 1. Estimated CAM paid below updates automatically whenever this or any tenant's rate/area/months changes.
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.