> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tangoanalytics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CAM and expense reconciliations

> Understand how expense reconciliations work and how to complete them in Tango.

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

<Steps>
  <Step title="Navigate to Reconcile Expenses">
    Go to **Lease Financials → Reconcile Expenses**. Select the year from the **Select Year** dropdown.
  </Step>

  <Step title="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
  </Step>

  <Step title="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
  </Step>

  <Step title="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.
  </Step>

  <Step title="Review the summary">
    Scroll up to the **Reconciliation Summary** section. Review the calculated **Amount Due** or **Credit Due**.
  </Step>

  <Step title="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.
  </Step>

  <Step title="Review the payment">
    Navigate to **Lease Financials → Lease Payments** (or Receivables) to find and review the generated lump sum payment.
  </Step>
</Steps>

<Info>Internal comments are visible to all system users. External comments are visible if the reconciliation is shared outside the system.</Info>

## Date calculations

| Field | Formula |
| - | - |
| Bill Due Date | Effective To + Landlord Days to Bill |
| Recon Due Date | Bill Received Date + Tenant Days to Complete |
| Occupancy % | Days Occupied ÷ Days in Period |