Intacct Real Estate

Creating a CPI Template

CPI Templates let you save reusable CPI escalation settings and apply consistent rules to recurring charges without entering the same configuration each time.

You can select an existing CPI Template from the CPI settings for a lease recurring charge. Selecting a template pre-fills the CPI configuration, which you can review before applying.


Accessing CPI Templates

To open CPI Templates:

  • Go to Setup.

  • Open Templates.

  • Select CPI Templates.

Select Create to create a new CPI Template.


CPI Template Settings

Template Name

Enter a unique name for the template.

The name is required.

Retroactive Method

Select how SIRE handles increases that should have been applied to an earlier period:

  • No retroactive: Does not create a separate charge for the earlier period.

  • Create a charge: Creates a retroactive charge for the difference.

Retroactive Charge Item ID

Select the Intacct Order Entry item used for retroactive CPI charges.

This field is required when Create a charge is selected and is disabled when No retroactive is selected.

Adjustment Frequency (Months)

Enter the number of months between CPI adjustments.

The value must be at least one month.

Next Adjustment Date

Enter the date on which the next CPI adjustment should be calculated.

Terminate Date

Optionally enter a date after which future CPI adjustments should stop.


Calculation Method

Use the Calculation Method section to define how SIRE compares CPI index values.

Calculation Method 1

Select one of the available methods:

  • Current year against last year: Compares the current CPI value with a previous CPI value.

  • Current year against base year: Compares the current CPI value with a defined base-year CPI value.

Index 1

Select the primary CPI index used in the calculation.

Area 1

Select the geographic area for the primary CPI index.

The available indexes and areas depend on the CPI data supported by SIRE, including United States and Canadian options.

Previous Index Date

For Current year against last year, select the month used as the previous comparison date.

Previous Index

For Current year against last year, select the CPI index used for the previous comparison.

Previous Index Area

For Current year against last year, select the geographic area for the previous CPI index.


Base Year Controls

Base Year Controls are used when Current year against base year is selected.

Base Year Index

Select the CPI index used as the base-year reference.

Base Year Index Date

Select the month used for the base-year CPI reference.

Base Year Index Value

Optionally enter a base-year index value.

Base Year Description

Optionally enter a description for the base year.

Base Year Basis

Optionally enter the basis used for the base-year calculation.


Using A Second Index

A second index is optional and can be used when the lease requires two CPI calculations.

When a second calculation method is selected, complete:

  • Calculation Method 2

  • Index 2

  • Area 2

When both calculation methods are configured, select how SIRE should use the results:

  • Greater: Uses the higher calculated result.

  • Lesser: Uses the lower calculated result.


Calculation Components

Use Calculation Components to limit, adjust, or establish minimum CPI increases.

Stop Percentage

Enter the maximum CPI increase allowed by the template.

Lease Factor

Enter the lease-specific percentage used to adjust the CPI result.

Floor Percent

Enter the minimum CPI increase to apply.

If the calculated increase is below the floor, SIRE uses the Floor Percent instead.

Cap Percent

Enter the maximum CPI increase allowed after applying the other CPI calculations.

The percentage fields are optional and should only be completed when the lease requires the corresponding limitation or adjustment.


Saving A CPI Template

Before saving:

  • Confirm that the Template Name is unique.

  • Confirm that the required fields for the selected calculation method are complete.

  • Confirm that the selected indexes and areas match the applicable CPI data source.

  • Confirm that the dates correspond to the intended CPI cycle.

  • Confirm that a Retroactive Charge Item ID is selected when Create a charge is used.

Select Save to create the template.


Applying A CPI Template

CPI Templates can be applied from the CPI settings for a lease recurring charge.

To use an existing template:

  • Open the CPI settings for the recurring charge.

  • Select Existing Template.

  • Select the CPI Template.

  • Review the pre-filled settings.

  • Confirm the configuration.

Selecting a template copies its settings into the recurring charge configuration. The template can then be reviewed before the recurring charge is saved.


Editing, Viewing, And Deleting Templates

From the CPI Templates list, use the action menu for a template to:

  • Edit the template.

  • View the template in read-only mode.

  • Delete the template.

Users with viewing access can view templates but cannot modify them.


Frequently Asked Questions

Where Do I Access CPI Templates?

Go to Setup > Templates > CPI Templates.

Which Calculation Method Should I Select?

Select Current year against last year when the calculation compares the current index with a previous index. Select Current year against base year when the calculation uses a defined base-year reference.

When Are Previous Index Fields Required?

Previous Index Date, Previous Index, and Previous Index Area are required when Current year against last year is selected.

When Are Base Year Fields Required?

Base Year Index and Base Year Index Date are required when Current year against base year is selected.

When Is The Retroactive Charge Item ID Required?

It is required when Create a charge is selected as the Retroactive Method.

Can I Use Two CPI Indexes?

Yes. Configure Calculation Method 2, Index 2, and Area 2. Then select whether SIRE should use the Greater or Lesser result.

Can I Apply A CPI Template To A Recurring Charge?

Yes. Select Existing Template in the recurring charge CPI settings to pre-fill the configuration.

Can Viewers Edit CPI Templates?

No. Viewers can open templates in read-only mode. Creating, editing, and deleting require the appropriate setup permissions.