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
Period
3
Tenant Roster
4
Invoice Details
5
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

Reconciliation period

Admin fee % and CAM rate are already set per tenant in the roster — this step just sets the time period and applies it.

e.g. 6 for an interim Jan–Jun run, 12 for a full year. This should match the period of the report you uploaded in Step 1.
Each tenant's estimated CAM paid is calculated automatically from their own CAM rate, area and the months/days they occupied in this period. Any amount you type manually in the tenant roster is kept and never overwritten. The period end date (Step 4) follows this number of months.
3

Tenant roster

Enter each tenant's area, CAM rate and admin fee %. The shaded columns set the reconciliation period for each tenant: it starts as the full period from Step 2, and you can type a different From / To date (e.g. a tenant who moved in mid-year) or type the number of days directly. CAM is charged for that tenant's days only.

Area allocation
Drop a tenant roster file here, or click to choose a file (.csv, .xlsx)
Lease Reconciliation period for this tenant
Tenant name Unit ID Area (sq ft) CAM rate $/sf/yr Admin % Start End From To Days Est. CAM paid ($)
Grey italic = filled in automatically. Type over any grey value to set it yourself; clear the field to go back to automatic. Est. CAM paid = CAM rate ÷ 12 × area × months × (tenant days ÷ period days).
4

Invoice details

Used when generating individual tenant CAM recovery invoices.

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

Reconciliation results

Tenant Area Share Days 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.