In this article

CAM Reconciliation Process

Modules > Property lease management > Periodic tasks > CAM Reconciliation

Use this page to calculate the CAM reconciliation amount.

Process the Reconciliation

To run the CAM reconciliation process, follow these steps: 

  1. Select whether to Include base year.
  2. Specify the As of date.
  3. Choose Select to specify the criteria for the records you want to process.
    These records appear in the lines list.
  4. Select any records that you do not want to process, and select Remove.
  5. Select Process.
  6. After the process finishes, select Report to review the details of the CAM reconciliation.

Recalculate the Reconciliation Amount

To recalculate the CAM reconciliation amount, follow these steps: 

  1. Select whether to Include base year.
  2. Specify the As of date.
  3. Choose Select to specify the criteria for the records you want to process.
    These records appear in the lines list.
  4. Select any records that you do not want to process, and select Remove.
  5. Select Recalculate.
  6. When you are asked to confirm the action, select Yes.
    Any manual changes to the page are removed.
  7. After the recalculation finishes, select Report to review the details of the CAM reconciliation.

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

List Grid

The following field boxes are available: 

Field Description
Lease number Displays the lease number.
Customer account Displays the customer account for the lease.
Currency Displays the currency for the CAM expense charge.
Level number Displays the level 1, 2, 3 combination for the unit.
CAM charge Displays the CAM charge name.
From/To date Displays the date range for the CAM reconciliation.
Expense amount Displays the CAM expense amount.
Denominator Displays the percent used for the pro-rata share method.
Pro-rata amount Displays the pro-rata share amount.
Billed amount Displays the CAM amount for the billing period.
Amount due Displays the CAM amount due for the billing period.
Reconciliation year Displays year for the CAM reconciliation.

Line Details

The following field boxes are available: 

Button Description
Expenses
Displays the expense amounts for the selected CAM charge line.
Expense pool number Displays the expense pool number attached to the CAM charge.
Total amount Displays the total amount of the CAM expense.
Exchange rate Displays the exchange rate used for the calculations.
Exchange rate date Displays the date on which the exchange rate is used.
Amount in lease currency Displays the expense amount in the currency of the lease.
Base year start date Displays the start date for the base year.
Base year end date Displays the end date 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.
Expense grid Displays a list of the expense.
Occupancy rate
Displays the occupancy rate for the selected CAM charge line.
Total leased area of Level Displays the total leased area of the property.
Total leasable area of Level Displays the total leaseable of the property.
Occupancy rate Displays the occupancy rate, which is calculates as follows: Total leased area / Total leasable area
Leased area of Level grid Displays a list of the leased area for the levels.
Leasable are of Level grid Displays a list of the leasable area for the levels.
Pro rata
Displays the calculated pro-rata amounts for the selected CAM charge line.
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
Billed amount
Billed amount Displays the sum total of the CAM reconciliation amounts that have been billed to the customer for the selected CAM charge line.
Charge grid Displays a list of charges.
Modifications  
Displays a list of modifications fro the CAM reconciliation.

Buttons

This following buttons are available: 

Button 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 report Prints the pro forma report that displays the calculation details of the CAM reconciliation.