1. Interest and Charges User Guide
  2. Interest and Charges Maintenance
  3. Interest Rule Maintenance
  4. Create Interest Rule Maintenance

1.12.1 Create Interest Rule Maintenance

This topic describes the systematic instructions to configure the interest rule maintenance details.

  1. On Home screen, click Interest and Charges. Under Interest and Charges, click Interest Rule Maintenance.
  2. Under Interest Rule Maintenance, click Create Interest Rule Maintenance.
    The Create Interest Rule Maintenance screen displays.

    Figure 1-21 Create Interest Rule Maintenance


    Description of Figure 1-21 follows
    Description of "Figure 1-21 Create Interest Rule Maintenance"

  3. Specify the fields on Create Interest Rule Maintenance screen.

    Note:

    The fields, which are marked with an asterisk, are mandatory.

    For more information on fields, refer to the field description table.

    Table 1-22 Create Interest Rule Maintenance - Field Description

    Field Description
    Rule ID Specify the unique code for each Rule ID to represent the type of interest.

    When the user wants to link a product to a rule, it is possible to identify the rule with the assigned code only.
    Rule Description Specify the short description of the rule to indicate the type of interest.

    This will be used by the system for all the display and printing purposes. Enter atleast three characters for the Rule description.
    Apply Interest By default, the interest will always be applied from the day when an account is opened till the day before it is closed.
    However, the user have the option of excluding the month in which the account is opened or closed from being considered for the interest application.
    • On Account Closure Month
    • On Account Opening Month

      The user have the option to specify a date till when the interest has to be liquidated.

User Element Window and System Element Window:

In the same way, the user picks up the SDEs applicable for the defined rule. The user should identify the UDEs which the user would be using in the rule. The types of UDEs are as follows:
  • Rate
  • Amount
  • Number
The interest that you charge on a debit balance is an example of a debit rate. The interest that you pay on a credit balance is an example of a credit rate. A User Data Element will be an amount under the following circumstances:
  • In the case of a tier structure, the upper and lower limit of a tier or a tier amount.
  • In the case of a charge, when it is indicated as a flat amount.
  • Any amount that can be used in the definition of formula.

A UDE as a number is typically used for a Rule where interest is defined based on the number of transactions. A UDE under this category can also be used to store a numerical value that may be used in a formula. For example, in the formula you would like to multiply an intermediate result with a certain number before arriving at the final result. The ‘certain number’ in the formula can be a UDE.

The user can enter the actual values of the UDEs (like the interest rate, the upper limit for the tier, etc.) in the IC User Data Element Maintenance screen. This is because you can specify 3-6 different values for each data element. A rule can, therefore, be applied on different accounts since it just represents a method of interest calculation. The following example illustrates this.

  1. Click System Element Window to update the system element details.
    The System Element Window displays.

    Figure 1-22 Create Interest Rule Maintenance - System Element Window


    Description of Figure 1-22 follows
    Description of "Figure 1-22 Create Interest Rule Maintenance - System Element Window"

    For more information on fields, refer to the field description table.

    Table 1-23 System Element Window - Field Description

    Field Description
    System Element Name Click Search icon and select the system element name from the drop-down list.

    The user have to specify the method for calculating interest in the form of formulae.

Formula Window:

Using the SDEs and the UDEs specified for a Rule, the user can calculate interest. The user have to specify the method for calculating interest in the form of formulae. Using the SDEs and the UDEs, the user can create any number of formulae for a rule.

  1. Click Formula Window button to invoke the formula section.
    The Formula Window displays.

    Figure 1-23 Create Interest Rule Maintenance - Formula Window


    Description of Figure 1-23 follows
    Description of "Figure 1-23 Create Interest Rule Maintenance - Formula Window"

    For more information on fields, refer to the field description table.

    Table 1-24 Formula Window - Field Description

    Field Description
    Formula Type Select the formula type from the drop-down list.

    You have to specify the method for calculating interest in the form of formulae.
    Formula No Specify the formula number.

    Formula Number Using the SDEs and the UDEs that you have specified for a Rule, you can calculate interest. Using the SDEs and the UDEs you can create any number of formulae for a Rule.
    Accruals Required Select the toggle to enable the interest accruals.
    Rounding Required Select the toggle to enable the interest rounding.
    Book Flag The Booking Flag of a formula denotes whether the result of a formula should be:
    • Booked (that is, if the resulting amount should be posted to the customer account).
    • Non-booked (that is, the result of the formula is to be used in another formula and not to be posted to the customer account).
    • Tax (that is, the formula is used to calculate tax. The tax can be borne either by the customer or the bank).
    Days In A Month The method in which the N of the formula for interest calculation, PNR/100, has to be picked up is specified for a formula. This is done through two fields:
    • Days in a month
    • Days in a year

    The number of interest days for an account can be arrived at in three ways.

    One, by considering:
    • one by considering the actual number of days in a month
    • two, the US method of considering 360 days in a year 3-8
    • three, the Euro method of considering 360 days in a year
    Periodicity The Periodicity of a rule application denotes whether the formula you are defining has to be:
    • applied for each change during the interest period (or daily).
    • only for the last day of interest period (periodic).
    Days In A Year The interest rate is always taken to be quoted per annum. You must therefore indicate the denominator value (the total number of days in the year) based on which interest has to be applied. You can specify the days in a year as
    • Actual number of days (leap year will be 366, non-leap year will be 365)
    • 360 days
    • 365 days (leap and non-leap will be 365)

Expression Window

  1. Click Expression Window button to invoke Add Expression table grid.
    The Expression Window displays.

    Figure 1-24 Create Interest Rule Maintenance - Expression Window


    Description of Figure 1-24 follows
    Description of "Figure 1-24 Create Interest Rule Maintenance - Expression Window"

    For more information on fields, refer to the field description table.

    Table 1-25 Expression Window - Field Description

    Field Description
    Formula No Specify the formula number.
    Expression Specify the expression.
    Condition Specify the condition.
    Result Specify the result.

    Debit / Credit

    The result of a formula will be an amount that has to be either debited from the customer account or credited to it. For example, the debit interest that the user charge on an overdraft would be debited from the customer account; while the credit interest that the user pay would be credited to the customer account. In this screen, you indicate this. Often, when calculating interest for an account, the user would want to debit interest under certain conditions and, under certain other conditions, credit interest. In such a case, the user can build formulae to suit both conditions. The formula that is used to calculate interest for the account would depend on the condition that is fulfilled.

  2. Click Save to save the details.
    The user can view the configured interest rule maintenance using View Interest Rule Maintenance screen.

Parent topic: Interest Rule Maintenance