In this article

CAM Reconciliation Process

Use this page to calculate the CAM reconciliation amount.

Process the Reconciliation

To run the CAM reconciliation process, follow these steps: 

  1. In the Header, if needed turn on Include base year and specify the As of date.

    2. The Lease List is updated with all leases that have CAM charges that can be reconciled.

  2. Select Process. All lines in the list are reconciled.
  3. Select Report to review the details of the CAM reconciliation.

After the reconciliation process finishes, the charge for any outstanding amount for the CAM charge is applied to the lease and can be reviewed in the Charge Details for the lease.

Recalculate the Reconciliation Amount

To recalculate the CAM reconciliation amount, follow these steps: 

  1. In the Header, if needed turn on Include base year and specify the As of date.

    2. The Lease List is updated with all leases that have CAM charges that can be recalculated.

  2. Select Recalculate. All lines in the list are recalculated.
  3. Select Report to review the details of the recalculation of the CAM reconciliation.

Header Fields

The following field boxes are available: 

Field Description
Include Base Year

Select whether to include CAM expense pools that use the base year calculation method that are in the specified base year when calculating the CAM expenses.

  • Yes: Includes CAM expense pools that use the base year calculation method and are in the base year. Calculates the CAM expenses for the base year only.
  • No: Includes CAM expense pools that use the base year calculation method, but are not in the base year.
As of Date Specify the date from which you want to show records. Required.
Leases List

Displays a read-only list of all leases with CAM charges. The information in the list includes: 

  • Lease number, currency, and customer account
  • Level numbers
  • CAM charge and the from and to date range for the charge
  • Pro-rata and billed amounts
  • Amount due (calculated: billed amount - prorata amount)
  • Denominator
  • Reconciliation year
  • Recoverable charge

Expenses

This FastTab shows the expense amounts for the selected CAM charge line.

Field Description
Expenses List

Displays a read-only list of the expenses for the lease selected in the Header. The information in the list includes: 

  • Account number and description
  • Expense start and end dates
  • Expense amount
  • Mark-up percentage or amount
  • Gross-up percentage
  • Occupancy rate
  • Calculated amount
CAM Pool No. Displays the expense pool number attached to the CAM charge. Read-only.
Total Amount Displays the total amount of the CAM expense.
Base Year Start/End Date Displays the start and end dates for the base year.
Calculation Method Displays the calculation method for calculating the total CAM expense amount.
Base Year Displays whether the base year is used as the calculation method for the CAM expense.
Pro Rata
Pro-rata Method Displays the pro-rata share method used for dividing the CAM expenses proportionately among all affected tenants.
Denominator

Displays the denominator value, which is calculated as follows: 

(Total tenant area of lowest level / Total tenant area of the property) * 100

Occupancy Rate

This FastTab shows the occupancy rate for the selected CAM charge line. All lines are read-only.

Field Description
Leased Area List

Displays a list of leases and the lowest levels. The information in the list includes: 

  • Lowest level number
  • Start and end dates of the lowest level
  • Area and weighted area
  • Proration factor
Total Leased Area Displays the total leased area of the lowest level.
Total leasable Area Displays the total leaseable of the lowest level.
Occupancy Rate

Displays the occupancy rate, which is calculates as follows: 

Total leased area / Total leasable area

Billing Detail

This FastTab shows the billing details for the selected CAM charge line in the Leases List. All lines are read-only.

Field Description
Charges List

Displays a list of charges. The information in the list includes: 

  • Charge number
  • Start and end dates for the charge
  • Amount for each period and the total billed amount for the year
Billed Amount Displays the billed amount for the CAM charged selected on the Expenses FastTab.

Modifications

This FastTab shows a read-only list of modifications for the CAM reconciliation charges. The information in the list includes: 

  • CAM pool number
  • Lease number
  • Original value and new value
  • Reference number and comment
  • User ID who made the change
  • Date on which the change occurred

Lease List Actions

The following actions are available: 

Action Description
Recalculate Recalculates the CAM reconciliation amount. When the recalculation is processed, any values that were manually edited are overridden with the recalculated values.
Process Processes the records and creates billing lines for the corresponding recoverable charge.
Pro Forma

Prints the report that displays the calculation details of the CAM reconciliation. When running the report, you can specify any of the following filters: 

  • Header filters: 
    • Lease number and customer account
    • CAM pool number
    • Category name and property levels