In this article

Sales Based Reconciliation

Modules > Property lease management > Periodic tasks > Sales based reconciliation

Use this page to determine how much to bill for the reconciliation period, based on the sales reporting amounts and a calculation using the type of rent charge. This amount is added to the charge details for the reconciliation period for the recoverable charge.

Run Sales Based Reconciliation

To run the sales based reconciliation, follow these steps: 

  1. Ensure that all sales reporting amounts have been entered for the leases in either the Sales Reporting or Mass Sales Reporting pages.
  2. Open theSales Based Reconciliationpage.
  3. In the Parameters FastTab:
    1. Select the Reconciliation option you want to use for running the reconciliation. Depending on the option you select, also specify the date range or year.
    2. Select whether to Prorate the breakpoint.
      This option is used for the following recoverable type methods: monthly breakpoint reached, graduated leasing, and cumulative graduated leasing.
  4. Select Select to specify the filter criteria for the lines you want to process.
    The Lines FastTab are automatically updated with the records that satisfy the filter criteria.
  5. Select any records that you do not want to process, and select Remove.
  6. Review the Line Details FastTab as needed by selecting a line the Lines FastTab.

    7. If you want to preview the reconciliation before processing, select Print to preview the report.

  7. Select OK.

After the reconciliation is run, a billing line is created for each line that is processed. You can view the billing line on the Billing Lines page.

Parameters FastTab

This FastTab contains the following fields: 

Field Description
Reconciliation Option

Select the range of records for reconciliation: 

  • By reconciliation frequency: Runs the next period based on the reconciliation frequency set within the Sales rate tab of the sales based charge.
  • Date Range: Runs the reconciliation for the specified From/To date range.
  • Year end: Runs the year-end reconciliation for the specified Year.
Prorate breakpoint

Indicates whether proation is used for the breakpoint when the first and last periods are partial periods.

This option is used for the following recoverable type methods: monthly breakpoint reached, graduated leasing, and cumulative graduated leasing.

  • Yes: Uses the sales amount and the annual breakpoint for the full year, and then prorates them to the actual time frame.
  • No: Uses the sales amount and the annual breakpoint for the full year. No proration is used.
From/To date

Available when Reconciliation Option is Date Range.

Specify the date range in which you want to run the reconciliation.

Reconciliation year

Available when Reconciliation Option is Year.

Specify the year in which you want to run the reconciliation.

Lines FastTab

This FastTab displays the lines that match the filter criteria that you select. These lines have a sales reporting status of Reported and are available for the sales based reconciliation process. The information in the list includes standard lease information in addition to sales reporting information: 

  • Lease number, levels, property, and customer account
  • Billing period from and to dates
  • Charge number, recoverable charge type
  • Total sales amount, recoverable amount, and currency

Line Details FastTab

This FastTab contains the following fields: 

Line Details Fast Tab Table
Field Description
Sales amounts tab
Sales reporting number Displays the sales reporting number for the sales based charge.
Totals sales amount Displays the total sales amount for the sales reconciliation report. The totals sales is based on the reconciliation option selected.
Sales amount lines

Displays the sales amount for the periods included in the report. The lines show the following information: 

  • Year
  • Period
  • From/To date
  • Amount
Reconciled details tab
Total bill amount

Displays the total amount that has already been billed (or reconciled). The calculated amount is based on the reconciliation calculation method selected.

For example, for the natrual breakpoint reconciliation method is used, the regular billing amounts and the reconciled amounts appear. For all other reconciliation methods, only the reconciled amounts appear.

Lines

Displays the billing information. The lines shows the following information: 

  • Start/End date
  • Description
  • Amount
  • Billed
Rent tab

Displays the billing information for lines that use the natural breakpoint recoverable type. The lines shows the following information: 

  • Start/End date
  • Description
  • Amount
  • Billed
Sales rate tab

Depending on the recoverable types for the lines being processed for the reconciliation, this tab shows the percentage for the reconciliation type. These values are from the Sales Based page.

  • Natural Breakpoint: Breakpoint percentage
  • Sales Percentage: Breakpoint percentage
  • Monthly Breakpoint Reached: Annual breakpoint amount and the Breakpoint percentage
  • Non-Natural Breakpoint: Annual breakpoint amount and the Breakpoint percentage
  • Graduated Leasing: Breakpoint start amount and Percent
  • Accumulated Graduated Leasing: Breakpoint start amount and Percent
Totals tab
Displays the totals for lines that are being reconciled. The total values that appear depend on the recoverable types for the lines being processed.

Buttons

This page contains the following buttons: 

Button Description
OK

Processes the sales based reconciliation for the lines in the Lines FastTab.