CPI Calculations Tab

Make the following selections from the eSite menu to display this page:

Rebilling—CPI—CPI Calculations

Use this tab to calculate and adjust tenant charges based on value changes within Consumer Price Indexes. The CPI program produces monthly data on changes in the prices paid by urban consumers for a representative basket of goods and services.

ClosedFields

Select Properties

Click to select properties from the Select Properties tab. The process runs for all selected properties.

CPI Group Code

The group code tells the system which tenant CPI escalations to use for the calculations. CPI group codes are established on the CPI Group Codes Tab.

Preliminary

Select this check box (recommended) to run a preliminary update to review and audit adjusted amounts, tenant charges, and retroactive billings generated as a result of CPI changes before running the final update. Or, clear the check box to run a final update to bill those amounts to tenants and print associated CPI statements.

Report Name

This option is available when the Preliminary option is not selected. The Report Name is a system-generated report name that is created when the final CPI Calculations are run and is saved in the Amsiweb\eSiteweb\Output folder. To avoid overwriting an existing file the next time the process is run, the system gives the report a unique file name that includes the User ID and date.

Description

This option is available when the Preliminary option is not selected. Type a description for the file that is created when the CPI Calculations are run.

Current CPI Index (mm/yyyy)

The period of the current CPI index values to use as a basis for calculating CPI adjustments. For example, if the current CPI index is January 2006, then system pulls the corresponding 01/2006 index value from the table defined on the Tenant Profile tab.

CPI Period for Increase Due From/Thru

The date range used to calculate CPI escalations. Tenants whose anniversary date falls between the From and Thru dates are included in the calculations. When processing CPI calculations, the software uses an anniversary date. This date is calculated as follows:

The software checks the tenant for a Date of Last Calc on the CPI Increases Details tab. If no Date of Last Calc exists, the software uses this Starting Date on the CPI Increases Setup tab. This date is used in conjunction with the Frequency on the on the CPI Increases Setup tab to determine the anniversary date. For example, if a tenant has a Date of Last Calc or Starting Date of 01/01/2004 and a frequency of Annual, the anniversary date will be 01/01/2005.

When generating CPI escalation statements, the software compares the anniversary date to the date range entered here. If the anniversary date falls within this range, the tenant payment amount will be adjusted and the Date of Last Calc field updated. This allows the CPI escalation function to adjust only those tenants requiring a CPI change.

Retroactive Billing

Because the CPI values for a particular time period are normally not available until after the tenant's anniversary period, increases may be calculated retroactively. This retroactive amount may be billed to a tenant using the income code defined in the Tenant Profile.

Select this check box (default) to create tenant billings for the months which have passed since the increase was scheduled to begin. This is to accommodate the time lag in receiving the latest published index rate. Or, clear the check box to indicate retroactive billings or calculations should not be created or run.

Bill Charges Through

The date (mm/dd/yyyy) identifying the end of the tenant's retroactive billing period. This date is used to determine the tenant billing for the number of months which have passed since the increase was scheduled. Typically, this is the system current period. The Calendar Button enables you to select a date.

Retroactive Billing Due

The tenant due date (mm/dd/yyyy) for retroactive billing charges. The Calendar Button enables you to select a date.

Print CPI Statements

Select this check box (default) to print CPI statements after the CPI Calculation Report. Or, clear the check box to indicate CPI statements should not be printed.

Document

Select the CPI statement letter into which the system will merge the tenant CPI billing details.

Message

If desired, add any additional message to be printed on the CPI Escalations Statements.

Cancel

Click to exit the tab without saving changes.

Process

Click to process the request.

See Also

CPI Overview

To Calculate CPI and Print Statements

CPI Frequently Asked Questions

Recurring Charges Tab

Rebilling Overview

Commercial Rebilling

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.