Fullscreen Image

Manage CPI Data - Company Administration

The Manage CPI Data page of the System Administrator Dashboard is where system administrators can set firm-level CPI indexes. Additionally, on this page system administrators can view the global-level CPI indexes that are loaded into Lucernex via API.

Many of our customers have leases where payments are CPI-indexed. This means that there are regular escalations to rent payments that are calculated based upon a percentage increase of one of several possible government-maintained Consumer Price Index. Under FASB guidance, CPI increases are variable rent and should not impact ASC 842 schedules. This means that the CPI escalation must be tied to a separate expense schedule that is not tied to an ASC 842 schedule. Under IASB guidance, the CPI increase is incorporated into IFRS 16 schedules more promptly.

See the CPI Indexes in Lucernex page for a list of Frequently Asked Questions about CPI Indexes in Lucernex.

You can upload CPI Index data in bulk. See the Complete the Firm-Level CPI Import Spreadsheet procedures to learn more.

There are three levels of CPI data in Lucernex. The first two are visible on the firm level. However, global-level indexes cannot be edited, as they are maintained by Lucernex.

  1. Global-level: CPI data for four indexes are loaded via API into Lucernex. These indexes are viewable, but not editable, on the Manage CPI Data page. The indexes are:

    • US All Urban Consumers (Current Series) - BLS_CUUR0000SA0,

    • US Urban Wage Earners and Clerical Workers (Current Series) - BLS_CWUR0000SA0,

    • US Producer Price Index - Industry Data BLS_PCUOMFG, and

    • UK Retail Price Index - RPI Series ONS_CHAW MM23.

  2. Firm-Level: System administrators can add their own CPI indexes that can be used across Lucernex to the Manage CPI Data page.

  3. Contract-Level: Users can add one CPI index to a contract using the CPI Index page of that contract.

To navigate to the Manage CPI Data page:

  1. Click Admin in the toolbar in the upper-right corner of the window.

    The System Administrator Dashboard page opens.

  2. Click Manage CPI Data link in the Company Administration column.

    The Manage CPI Data page opens.

  3. Follow a procedure below.

ClosedHow Lucernex Calculates CPI-Indexed Rent

When a CPI adjustment is made, two values are pulled from the associated CPI table:

  • The base CPI index, which is from the month and year of the expense setup if there has been no ASC 842 re-measurement done; or from the month and year of the ASC 842 re-measurement if that's been done.

  • The current CPI index, which is from the month and year of the retro date of the CPI adjustment being made

Then the ratio of the two values is calculated. The CPI increase is calculated from this ratio, based on the base rent as of the retro date and the ratio calculated in the previous step.

This CPI increase will never be below 0, even if the current CPI index is lower than the base CPI index. This way, the total CPI-indexed rent will never be lower than the fixed base rent. However, as the CPI index fluctuates up or down, the amount of the CPI expense above base rent may either increase or decrease.

If there are catch-up payments due, they will be calculated by taking the difference between the new and previous CPI-increase schedule amounts.

ClosedAdd CPI

To add a firm-level CPI index:

  1. Click Add CPI.

    The Add CPI window opens.

  2. Select the CPI Index you want to add a value for from the CPI Index field.

    If you want to load a new CPI index at the firm level, follow the Complete the Firm-Level CPI Import Spreadsheet procedures.

  3. Select the effective year from the Year field.

  4. Select the effective month from the Month field.

  5. Enter the CPI value in the CPI Value field.

  6. Enter the date this CPI index was published in the Published Date field.

    You can also click Calendar A small button with a picture of a calendar on it. to open the Date Picker and select the appropriate date.

    For best practice we recommend that you include the publication date of the CPI index. In rare cases, the government may make changes to CPI index values for a prior month or year. However, as an auditing practice, we take the policy of retaining the old CPI index value in the system. Including the publication date of the CPI index, helps the system select the CPI value to use if there are multiple records in the system for a particular month or year. The most recent value is used in that scenario.

  7. Click Add.

    The window closes. The CPI index appears in the table.

ClosedEdit CPI

The CPI Indexes on this page fall into two categories: read-only CPI indexes that are fetched via API, and user-created CPI indexes. You will not be able to edit CPI indexes that are fetched by the API.

To edit a CPI index at the firm-level:

  1. Click Edit in the Actions column of the record.

    The Edit CPI window opens.

  2. Make your changes.

  3. Click Update.

    The window closes. Your changes are saved.

ClosedDelete CPI

The CPI Indexes on this page fall into two categories: read-only CPI indexes that are fetched via API, and user-created CPI indexes. You will not be able to delete CPI indexes that are fetched by the API.

To delete a CPI index at the firm-level:

  1. Click Delete in the Actions column of the record.

    A dialog opens, asking you to confirm your choice.

  2. Click Yes.

    The dialog box closes. The CPI index is deleted.

Accruent logo in white text.

© Copyright Accruent 2025Privacy PolicyTerms of UseLegal