- Interest and Charges User Guide
- Interest and Charges Maintenance
- Product Maintenance
- Create Product Maintenance
1.2.1 Create Product Maintenance
This topic describes the systematic instructions to configure the interest and charges product maintenance.
- On Home screen, click Interest and Charges. Under Interest and Charges, click Product Maintenance.
- Under Product Maintenance, click Create Product Maintenance.The Create Product Maintenance screen displays.
- Specify the fields on Create Product Maintenance screen.
Note:
The fields marked as Required are mandatory.For more information on fields, refer to the field description table.
Table 1-6 Create Product Maintenance - Field Description
Field Description Product Code Displays the code of the product to define the preferences. Product Description Specify the appropriate description for the defined Product Code. Rule Code Click Search icon and select the rule created in the IC Rule Maintenance screen. Product Start - End Date Specify the date range when the product can be used. The start and end dates should be kept handy while defining a product for a scheme which is open for a specific period. The user cannot use a product beyond the specified expiry date. If the user have attached the expired product at the account level, on save, the system displays the override message as, The product has expired.
Accrual While building a formula (for the rule to link the product), the interest amount will be accrued for all the accounts linked to the product if the interest is indicated as the result of the formula. While defining the preferences for this product, the user can choose to pass the accrual entries in the following manner:- Pass an accrual entry for each account
- Consolidate the interest to be accrued (for individual accounts) and track it against the product.
If the user choose the latter option, the cumulative value of all the accruals (for accounts linked to the product) will be passed as a single accounting entry.
Product Level Select this toggle to accrue interest at the ‘Product Level’, the accrued interest for all the accounts linked to the product will be consolidated and a single entry posted for the product. If the user choose to accrue the interest for each account linked to the product, an accrual entry will be posted for each account individually. The account for which the accrual entry is passed will be shown when the user retrieve information about an entry. The details of accruals for each account will be available in the Accrual Control Journal, a report generated whenever accruals are performed as part of end-of-cycle processing. Accrual day Specify the day of the month on which the accruals have to be carried out for a non-daily accrual frequency. For example, If the Accrual Day is specified as 25, the automatic accrual will be on the 25th day of the months, as per the frequency. Frequency Select the frequency with which the interest accured for the defined account classes. The available options are:- Daily
- Monthly
- Quarterly
- Semi Annual
- Annual
- On liquidation (accrues only when the interest liquidates)
Let us recall the operations relating to accruals that the user have performed so far. When the user build an interest rule, the user defines whether the result of a formula is to be accrued. While defining the product (to which the rule linked), the user would:- Identify the GL/SL to which the interest accrued is posted (Product Accounting Role Definition screen), and
- Specify the event ‘accrual’ occurs to post the entry to the identified GL/SL (Events Definition screen).
Cycle Specify the accrual cycle in the months. If the frequency is selected as- Quarterly
- Semi Annual
- Annual
For example, a quarterly cycle may be March, June, September and December, indicating that the accrual should take place in these months. For a half-yearly cycle, the user would specify June and December.
Start from Account Opening Select the toggle to liquidate the interest periodically for accounts according to a frequency determined in the Account Opening Date. Instead of giving a First Liquidation Date and bringing all the accounts linked to the product to the same liquidation cycle. The periodic liquidations can also be fixed to begin on a particular date (First Liquidation Date) and happen at a definite frequency.
Liquidation at Month End Select the toggle to liquidate the interest at the last working day of the month. For a liquidation frequency in months or multiples of a month (for example: quarterly, half yearly, every two months, etc.,), the user can select that liquidation has to be carried out as of the last working day of the month. In this case, the user should specify the Liquidation Start Date as the last date of the month from which you would begin liquidation.
Liquidation before Month End Select the toggle to liquidate the interest before the month end for all the accounts linked to the product. If the user set the interest liquidation frequency as Monthly, Yearly and Quarterly cycle in the IC Product Preferences, the user can choose to liquidate interest a specified number of days before the month end for all accounts linked to the product. The user have to specify the number of days before which interest should be liquidated. The system arrives at the interest liquidation date based on the specified number of days.
Defer Liquidation Select the toggle to defer the calculation and liquidation of periodic interest on an account for a few days beyond the end date of each interest period. This deferment will allow the inclusion of interest adjustments due to back-valued entries posted into the account after the period end date. In order to avail of this facility, the user need to enable the Defer Liquidation toggle and specify the defer liquidation days.
Days, Months and Year Specify the liquidation frequency for the Interest product. The user can specify the liquidation frequency in - Days - Example: If the user wants to liquidate interest every 15 days, enter ‘15’.
- Months - Example: If the user wants to liquidate interest every quarter, enter ‘03’.
- Years - Example: If the user wants to liquidate interest every year, enter ‘01’
Defer Liquidation Days Specify the number of calendar days by which the interest liquidation has to be deferred. Back Value Recalculation Select the interest recalculation required for all the accounts associated with this product. The available options are: - Not Required
- Non-capitalized
- Capitalized
If a back dated accounting entry is passed within the current liquidation cycle, the next accrual will consider the revised principal effective the back date. If a back dated entry is passed for a date in the previous liquidation cycle, then the difference in interest adjusted during the next liquidation as an interest adjustment entry. If this box is not selected, then neither interest adjustment nor accrual adjustment will be triggered for any back dated transaction. Thus, the revised principal will be considered effective the booking date of the transaction.
First Liquidation On Select the First Liquidation Date once the liquidation frequency has been defined. The frequency and the date will be used to arrive at the first and subsequent dates of liquidation for the accounts linked to the product. For example, the quarterly liquidation cycle may be March, June, September and December, and the liquidation is on the month-end. For such a cycle, the user should indicate 31 March as the date of first liquidation during the year. The subsequent dates will be automatically fixed by the system based on the frequency and the first liquidation date. - Click Save to save the details.The user can view the configured interest and charges product maintenance using View Product Maintenance screen.
Parent topic: Product Maintenance