Contents

1. Preface

  • 1.1 Introduction
  • 1.2 Audience
  • 1.3 Documentation Accessibility
  • 1.4 Organization
  • 1.5 Related Documents
  • 1.6 Glossary of Icons
  • 2. An Overview of Interest and Charges Module

  • 2.1 Introduction
  • 2.2 Interest Rule Definition
  • 2.3 Product Definition
  • 2.4 Conditions Definition
  • 2.5 Usage of Prevailing Market Rates
  • 2.6 Combine Accounts
  • 2.7 Calculation of Charges
  • 2.8 Other Features
  • 2.9 Information Retrieval
  • 3. Maintenance Required for Processing Interest and Charges

  • 3.1 Rules
  • 3.2 Branch Parameters
  • 3.2.1 Maintaining Branch Parameters
  • 3.3 Rules for Interest and Charges
  • 3.3.1 Invoking Interest and Charges Rule Maintenance
  • 3.3.2 System Elements (SDEs)
  • 3.3.3 User Elements (UDEs)
  • 3.3.4 Formulas Button
  • 3.3.5 Applying Prepayment Penalties on Deposits
  • 3.3.6 Maintenance for Prepayment Penalties
  • 3.3.7 Maintaining Rule for Calculating Commission on HDB
  • 4. Maintaining System Data Elements

  • 4.1 System Data Elements Maintenance
  • 4.1.1 Invoking System Data Elements Maintenance
  • 4.1.2 Maintaining SDE for Interest Calculation on Daily Average Balance
  • 4.1.3 Maintaining SDE to Compute Average Balance of Two Consecutive Months
  • 4.1.4 Maintaining SDE for ELCM related Values
  • 4.1.5 Maintaining SDE for Tax Exemption
  • 4.1.6 Maintaining SDEs for Computing TDS
  • 4.1.7 Maintaining SDEs for Computing Advance Interest
  • 4.1.8 Maintaining SDEs for Computing Overdraft Interest
  • 4.1.9 Maintaining SDE for Computing commission on Highest Debit Balance
  • 4.1.10 Maintaining SDE for FATCA
  • 4.1.11 Maintaining SDE for Virtual Accounts
  • 4.2 Customer TDS Details
  • 4.2.1 Invoking Customer TDS Details Screen
  • 4.2.2 Maintaining SDEs for Deducting Charges on Dormant Accounts
  • 4.2.3 Implications of Working with User Defined Fields
  • 5. Giving UDE Values for Condition

  • 5.1 Interest and Charges UDE Maintenance
  • 5.1.1 Invoking the Interest and Charges UDE Maintenance Screen
  • 5.1.2 Printing UDE Values
  • 5.1.3 Maintaining Rate Codes
  • 5.1.4 Defining Effective Date for Rate Code
  • 5.1.5 Closing Rate for Date
  • 5.2 Interest Rate Association for Account Class
  • 5.2.1 Associating Interest Rate to Account Class
  • 5.3 UDE Values for Select Customer Accounts
  • 5.3.1 Modifying UDE Values for Select Customer Accounts
  • 6. Building Formulae

  • 6.1 Formula Wizard Screen
  • 6.2 Building Blocks of Formulae
  • 6.3 Building Formulae
  • 7. Defining Interest and Charge Products

  • 7.1 Interest and Charges Product Maintenance
  • 7.1.1 Invoking Interest and Charges Product Maintenance
  • 7.1.2 Preference Button
  • 7.1.3 Specifying Preferences for Charges Product
  • 7.1.4 Charge Basis in Oracle FLEXCUBE
  • 7.1.5 Status Maintenance Button
  • 7.1.6 Accounting Roles Button
  • 7.1.7 Events Button
  • 7.1.8 Branch Button
  • 7.1.9 Customer Button
  • 7.1.10 UDE Limits Button
  • 7.1.11 Preferences for Consolidated Charges Products
  • 7.1.12 Charge Product Application on an Account
  • 7.1.13 General Condition
  • 7.1.14 Special Condition
  • 7.2 Transaction Codes for Processing External Charges
  • 7.2.1 Processing Transaction Code for External Charges
  • 7.3 Booking of External Charges
  • 7.3.1 Booking of External Charges
  • 8. Floating Rate Codes for IC Module

  • 8.1 Interest and Charges Branch Availability Maintenance
  • 8.1.1 Invoking Interest and Charges Branch Availability Maintenance
  • 8.1.2 Branch Restrictions
  • 8.2 Floating Rates for IC Rate Codes
  • 8.2.1 Invoking IC Rate Input Screen
  • 8.2.2 Closing Rate for Date
  • 8.2.3 Uploading IC Rates
  • 9. Applying Interest Product on Account

  • 9.1 Defining General Condition
  • 9.1.1 Waiving General Condition for Specific Account
  • 9.1.2 Repopulate at Liquidation
  • 9.1.3 Closing General Condition
  • 9.1.4 Maintaining Rate Codes
  • 9.1.5 Defining Effective Date for Rate Code
  • 9.1.6 Closing Rate for Date
  • 9.1.7 Giving UDE Values for General Condition
  • 9.1.8 Identifying and Specifying Values for UDEs
  • 9.2 Special Condition Definition
  • 9.2.1 Invoking IC Special Conditions Maintenance Screen
  • 9.2.2 Defining UDE Values for the Account
  • 9.2.3 Specifying Effective Date for UDE Value Pickup
  • 9.2.4 Closing Values Applicable for Effective Date
  • 9.2.5 Recalculation of Interest for Back-valued UDE Value Changes
  • 9.3 Associating Customer Account with another Account
  • 9.3.1 Application of Interest and Charges – A note
  • 9.3.2 Details for Deposit types of Account
  • 10. Checking for Consistency in Data

  • 10.1 Consistency Check
  • 10.1.1 Maintenance Consistency Check
  • 10.1.2 Unauthorized Accounts
  • 10.1.3 Unauthorized Account Classes
  • 10.1.4 Unauthorized Currency Details
  • 10.1.5 Details of Invalid Products or Rules
  • 10.1.6 Unauthorized General Conditions
  • 11. Daily Processing of Interest and Charges

  • 11.1 Maintenance Consistency Checks
  • 11.2 IC Intra-day Batch
  • 11.3 Liquidating Interest Automatically
  • 11.4 Automatic Accruals
  • 11.5 Reversing Accrual Entries
  • 11.6 Charges Applicable for Creditor or Debtor Agreements
  • 11.7 Consolidated Charges Processing
  • 11.8 End of Day processing for Debiting Receivable GLs
  • 11.8.1 Liquidating Debit Interest and Charges
  • 11.8.2 Auto Liquidation
  • 11.8.3 Manual Liquidation
  • 11.8.4 Processing Write-off for the new Status
  • 11.8.5 Processing Recovery of OD Account
  • 12. Liquidating Interest Online

  • 12.1 Processing Online Liquidation
  • 12.2 Online Liquidation for Multiple Accounts
  • 12.2.1 Invoking Interest and Charges Multiple Account Online Liquidation Screen
  • 12.2.2 Product Code Tab
  • 12.2.3 Account Number Tab
  • 12.2.4 Authorize Button
  • 12.2.5 Viewing Interest and Charges Multiple Account
  • 12.3 Online Liquidation for Single Account
  • 12.3.1 Invoking Interest and Charges Single Account Online Liquidation
  • 12.3.2 Authorizing Online Liquidation for Single Account
  • 12.3.3 Viewing Interest and Charges Single Account
  • 12.4 Calculating Interest Applicable for Account
  • 12.5 Online Calculation for Multiple Accounts
  • 12.5.1 Processing Online Calculation for Multiple Accounts
  • 12.6 Online Calculation for Single Account
  • 12.6.1 Processing Online Calculation for Single Account
  • 12.7 Capitalization of OD Interest
  • 13. Maintaining Interest Statement Details

  • 13.1 Interest Statements
  • 13.1.1 Maintaining Interest Statements
  • 13.2 Printed Value Identification
  • 13.3 Interest Statement Generation
  • 14. Annexure A - Accounting Entries and Advices

  • 14.1 Accounting Entries for Interest and Charges
  • 14.2 Event-wise Accounting Entries and Advices
  • 14.2.1 Charge Basis: ADHOC-STMT
  • 14.2.2 Charge Basis: NUM-CHQ-ISS
  • 14.2.3 Charge Basis: NUM-CHQ-RET
  • 14.2.4 Charge Basis: NUM-STOP-PAY
  • 14.2.5 Charge Basis: NUM-ACCT-STMTS
  • 14.2.6 Charge Basis: ITEM-COUNT
  • 14.2.7 Charge Basis: TURNOVER
  • 14.2.8 Accounting Entries and Advices for Interest
  • 14.2.9 Accounting Entries for Write-off Process
  • 14.2.10 Accounting Entries for Income Recognition
  • 14.2.11 Accounting Entries for FATCA
  • 15. Queries and Reports

  • 15.1 Online Queries
  • 15.1.1 Accessing Online Queries
  • 15.1.2 The Interest Applicable on an Account
  • 15.1.3 Single account
  • 15.1.4 Multiple Accounts
  • 15.2 Interest Calculation - Projected
  • 15.2.1 Generating Interest Calculation - Projected Report
  • 15.2.2 Contents of the Report
  • 15.3 Liquidation Control List
  • 15.3.1 Generating Liquidation Control List Report
  • 15.3.2 Contents of the Report
  • 15.4 The Accrual Control List
  • 15.4.1 Generating the Accrual Control List
  • 15.4.2 Contents of the Report
  • 15.5 The Maintenance for Interest Statements Report
  • 15.5.1 Generating Interest Statement Report
  • 15.5.2 Contents of the Report
  • 15.6 The SDE Details Report
  • 15.6.1 Generating the SDE Details Report
  • 15.6.2 Contents of the Report
  • 15.7 The Product Details Report
  • 15.7.1 Generating the Product Details Report
  • 15.7.2 Contents of the Report
  • 15.8 Report on Interest Calculation Details
  • 15.8.1 Generating Interest Calculation Details Report
  • 15.8.2 Contents of the Report
  • 15.9 Savings YTD Interest Report
  • 15.9.1 Generating the Saving YTD Interest Report
  • 15.9.2 Contents of the Report
  • 15.10 Report of TD linked to Overdraft Account
  • 15.10.1 Generating TD linked to Overdraft Account Report
  • 15.10.2 Contents of the Report
  • 15.11 Accrual Control List Report
  • 15.11.1 Generating Accrual Control List Report
  • 15.11.2 Contents of the Report
  • 16. Function ID Glossary