Skip to main content
Expense reconciliations (also called CAM reconciliations) compare what a tenant paid in estimates throughout the year against the landlord’s actual expense statement. The result is either an additional payment owed or a credit due to the tenant.

​
When to reconcile

Reconciliations are typically done annually after the landlord provides the year-end statement. The frequency (annual, semi-annual, etc.) is configured during reconciliation setup.

​
Entering reconciliation data

1

Navigate to Reconcile Expenses

Go to Lease Financials → Reconcile Expenses. Select the year from the Select Year dropdown.
2

Create a reconciliation detail record

In the Reconciliation Details section, click New. The page has four sections:
  1. Reconciliation Summary — a read-only year-over-year summary
  2. Reconciliation Details — the overall reconciliation for the period
  3. Controllable Line Items — expenses the tenant can partially influence
  4. Non-Controllable Line Items — expenses outside the tenant’s control
3

Fill in the reconciliation details

  • Effective From / To — the period being reconciled
  • Billed Area (tenant and center) and Billed Prorata — from the landlord statement
  • Bill Received Date — used to calculate the recon due date
  • Status — for example, In Process
  • Escrow (billed) values — total and by expense category from the landlord statement
  • Cap and base values — if applicable; defaults pull from the Base Year and Cap Setup tab
  • Tax rate from the landlord statement
4

Fill in line items

After saving, the template applies and line items appear. For each line:
  • Landlord columns — enter exactly what the landlord statement shows
  • Tenant calculation columns — enter your audited values
Add or remove lines using the Add and Delete buttons.
5

Review the summary

Scroll up to the Reconciliation Summary section. Review the calculated Amount Due or Credit Due.
6

Generate the payment or credit

Click Generate Lump Sum. Enter the effective date and due date, confirm the payment type and vendor, then click OK.The reconciliation status changes to Processed and becomes read-only.
7

Review the payment

Navigate to Lease Financials → Lease Payments (or Receivables) to find and review the generated lump sum payment.
Internal comments are visible to all system users. External comments are visible if the reconciliation is shared outside the system.

​
Date calculations