Configuring Interest Keys

Objective

After completing this lesson, you will be able to configure interest keys and calculation rules

Interest Key

Flowchart explaining interest key determination involving inputs like Dunning Level, Contract Account, and Items leading to functions for calculating and posting interest. Other elements include Reference Interest Rates and a Calculation Rule.

The interest key controls the item interest calculation.

The interest key can be entered in the contract account.

If it was calculated in the dunning run, the interest key is stored in the dunning level.

The interest key entered in the item (manually or automatically) has the highest priority.

The interest posting creates an interest document which contains an interest supplement.

The interest supplement contains the items for which interest was calculated, as well as the relevant amounts, intervals, and the interest key. This allows you to identify which factors were used for interest calculation and posting.

A graphic illustrating the components of an interest key with a key icon, period control, tolerance days, transfer days, interest frequency, and calculation rule. Arrows connect the period control to the other elements.

The interest key consists of all control parameters for interest calculation and posting:

  • Parameters for item selection

  • Reference to a calculation rule

The tolerance days (grace period) is the minimum number of days that must have passed since the due date for net payment of a receivable before interest can be calculated. If the receivable is cleared within the tolerance period, no interest calculation or interest posting can take place.

The tolerance period is not taken into account for interest calculations in the future (such as installment plan interest).

The calculation frequency determines the earliest point at which interest is calculated for an item if interest has already been calculated.

The transfer days refer to the period that it takes a bank to clear a payment and provide the clearing information. This ensures that interest calculation does not take place on a receivable for which payment is delayed by the bank.

The baseline date for interest calculation is Due Date + Grace Period + Transfer Days.

A flowchart depicting the interest calculation rule, with sections for rounding unit/rule, time-dependent, and minimum amounts feeding into details about method (360/365), interest interval, and monthly calculation, and referencing rate, surcharge, and minimum/maximum. The details section is highlighted with a yellow oval.

The interest calculation rule contains the parameters for interest calculation:

  • Dynamic interest rate

  • Static interest rate

The interest rate depends on:

  • The reference interest

  • The analysis period

The interest rates are stored per currency and debit/credit indicator according to the date. They can also be based on a reference interest rate, such as the federal funds rate.

The interest calculation can be carried out on a monthly basis (for example, 2% per month).

The interest calculation method dictates how interest is to be calculated. Most users use the act/365 method, with which the system calculates interest based on a 365-day period.

The Scale Type indicator is used if the interest rate used is based on amounts. For example, you may wish to charge an interest rate of 5% on the first 1000 balance and then 6% for any balance above 1000.

The interest interval can be set to a day, week, month, or year. In most countries, this indicator is set to Year. However, some countries with high inflation rates use Day or Week.

A display screen shows settings and parameters for a dunning procedure, including dunning level, selection parameters, charges, interest, history and printout options, limit percentage, and immediate new document dunning.

You can select the Calculate Interest indicator when a dunning level is reached.

You can select the Update Key indicator to control the interest processing:

  • _ – Interest is only calculated, not posted

    An organization can send a letter to a customer informing them that they could have charged interest, but opted not to.

  • 1 – Interest is calculated and posted statistically

    You do not expect to complete the transaction or collect the interest.

  • 2 – Interest is calculated and posted

    The general ledger is updated as a result.

Configure an Interest Key

Business Example

You want to configure an interest key for interest calculation.

Note

In this exercise, the value ## should be replaced with your group number

Note

In this exercise, the value # should be replaced with the corresponding letter.

Task 1: Configure an Interest Key

Steps

  1. Go to the SAP S/4HANA system.

  2. Configure an interest key using the following data:

    Header Data

    FieldValue
    Interest KeyX# (such as XA, XB, and so on)
    NameInterest Key ##
    Tolerances Number1
    Tolerances UnitWeeks (2)
    Transfer Days Number2
    Transfer Days UnitDays (1)
    Frequency Number1
    Frequency UnitMonths (3)
    Calculation RuleYN01 Interests 5% fix
    1. Call transaction FICAIMG to access the FI-CA implementation guide.

    2. Choose Business TransactionsInterest CalculationItem Interest CalculationDefine Interest Key.

    3. In the Interest Key overview, choose New Entries.

    4. Enter the values from the Header Data table.

    5. Choose Save.

    6. Choose Back three times.

  3. Assign the interest key X# to the contract account ac240-##f (transaction CAA2).

    1. Call transaction CAA2 Contract Account Change.

    2. On the initial screen, enter contract account ac240-##f.

    3. Select Enter.

    4. In the Information dialog box, choose Continue.

    5. Go to the General Data tab.

    6. In the Interest Key field, choose X#.

    7. Choose Save.

    8. Choose Back.

Log in to track your progress & complete quizzes