This chapter contains the following sections:
This Annexure lists the suggested event-wise accounting entries that can be set up, for the Interest and Charge product applicable for the CASA module of Oracle FLEXCUBE.
You need to set up the following events for an Interest product:
Event Code |
Event Description |
ILIQ |
Interest Liquidation |
IACR |
Interest Accruals |
UDCH |
UDE Values Change |
CDIS |
Cheque Discount |
You need to set up the following events for a Charge product:
Event Code |
Event Description |
CLIQ |
Charge Liquidation |
The following amount tags are available:
Amount Tags |
Description |
IACR |
Interest Accrued |
CHARGE |
Charge Accrued |
IACQUIRED |
|
IACR_ADJ |
Interest Accrual Adjustment |
ILIQ |
Interest liquidation |
TAX |
Tax Accrual |
TAX_ADJ |
Tax Adjustment |
Accounting roles for CASA are defaulted by FLEXCUBE in a following manner:
‘SAXX’ - ‘accounting role type’ – ‘X’
SAXX represents the IC rule ID you have maintained and attached to the particular IC product. This is based on your own convention. Accounting role type is for example the accrual, P/L, or tax payment. For creation of role type system uses standard abbreviations across FLEXCUBE. ‘X’ is a number which is the number of the formula for which the accounting role is created.
If you have maintained more than one formula at rule level FLEXCUBE will default accounting roles for each of your accounting roles
For Example, SAAB-ACCR-1 = accounting role for accrual pertaining to SAAB product, formula #1. (for example credit interest accrual which was defined in formula 1.) SAAB-PNL-2 = accounting role for income or expense booking pertaining to SAAB product, formula #2. (for example debit interest posting against income GL). You should select the appropriate accounting role on the “Role to head mapping” tab. Note: SAXX-BOOK-X represents the settlement account where the amount is credited or debited against P/L account. This role cannot attached to any GL on “Role to head mapping” screen but it is used while event-wise entries are maintained.
Accounting roles for Sample IC Product with rule ID like CHAV are given below:
The following accounting roles are available:
Accounting Role |
Description |
CHAV-ACQUIRED-1 |
CHAV ACQUIRED INTEREST - FORMULA 1 |
CHAV-PNL_ADJ-1 |
CHAV PNL - ADJ - FORMULA 1 |
CHAV-PNL-1 |
CHAV INCOME/EXPENSE A/C - FORMULA 1 |
CHAV-TPBL_ADJ-2 |
CHAV TAX PAYABLE A/C - FORMULA 2 |
CHAV-TPBL-2 |
CHAV TAX PAYABLE A/C - FORMULA 2 |
CHG_INCOME |
CHARGES INCOME |
DORM-ACQUIRED-1 |
DORM ACQUIRED INTEREST - FORMULA 1 |
DORM-PNL_ADJ-1 |
DORM PNL - ADJ - FORMULA 1 |
DORM-PNL-1 |
DORM INCOME/EXPENSE A/C - FORMULA 1 |
IBSR-ACCR-1 |
IBSR ACCRUAL A/C - FORMULA 1 |
IBSR-ACCR-2 |
IBSR ACCRUAL A/C - FORMULA 2 |
IBSR-ACQUIRED-1 |
IBSR ACQUIRED INTEREST - FORMULA 1 |
IBSR-ACQUIRED-2 |
IBSR ACQUIRED INTEREST - FORMULA 2 |
IBSR-ACR_ADJ-1 |
IBSR ACR - ADJ - FORMULA 1 |
IBSR-ACR_ADJ-2 |
IBSR ACR - ADJ - FORMULA 2 |
IBSR-PNL_ADJ-1 |
IBSR PNL - ADJ - FORMULA 1 |
IBSR-PNL_ADJ-2 |
IBSR PNL - ADJ - FORMULA 2 |
IBSR-PNL-1 |
IBSR INCOME/EXPENSE A/C - FORMULA 1 |
IBSR-PNL-2 |
IBSR INCOME/EXPENSE A/C - FORMULA 2 |
IBSR-TPBL_ADJ-3 |
IBSR TAX PAY ADJ A/C - FORMULA 3 |
IBSR-TPBL-3 |
IBSR TAX PAYABLE A/C - FORMULA 3 |
IOCC-ACCR-1 |
IOCC ACCRUAL A/C - FORMULA 1 |
IOCC-ACCR-2 |
IOCC ACCRUAL A/C - FORMULA 2 |
IOCC-ACQUIRED-1 |
IOCC ACQUIRED INTEREST - FORMULA 1 |
IOCC-ACQUIRED-2 |
IOCC ACQUIRED INTEREST - FORMULA 2 |
IOCC-ACR_ADJ-1 |
IOCC ACR - ADJ - FORMULA 1 |
IOCC-ACR_ADJ-2 |
IOCC ACR - ADJ - FORMULA 2 |
IOCC-PNL_ADJ-1 |
IOCC PNL - ADJ - FORMULA 1 |
IOCC-PNL_ADJ-2 |
IOCC PNL - ADJ - FORMULA 2 |
IOCC-PNL-1 |
IOCC INCOME/EXPENSE A/C - FORMULA 1 |
IOCC-PNL-2 |
IOCC INCOME/EXPENSE A/C - FORMULA 2 |
IOCC-TPBL_ADJ-3 |
IOCC TAX PAY ADJ A/C - FORMULA 3 |
IOCC-TPBL-3 |
IOCC TAX PAYABLE A/C - FORMULA 3 |
IOCM-ACCR-1 |
IOCM ACCRUAL A/C - FORMULA 1 |
IOCM-ACCR-2 |
IOCM ACCRUAL A/C - FORMULA 2 |
IOCM-ACQUIRED-1 |
IOCM ACQUIRED INTEREST - FORMULA 1 |
IOCM-ACQUIRED-2 |
IOCM ACQUIRED INTEREST - FORMULA 2 |
IOCM-ACR_ADJ-1 |
IOCM ACR - ADJ - FORMULA 1 |
IOCM-ACR_ADJ-2 |
IOCM ACR - ADJ - FORMULA 2 |
IOCM-PNL_ADJ-1 |
IOCM PNL - ADJ - FORMULA 1 |
IOCM-PNL_ADJ-2 |
IOCM PNL - ADJ - FORMULA 2 |
IOCM-PNL-1 |
IOCM INCOME/EXPENSE A/C - FORMULA 1 |
IOCM-PNL-2 |
IOCM INCOME/EXPENSE A/C - FORMULA 2 |
IOCP-ACCR-1 |
IOCP ACCRUAL A/C - FORMULA 1 |
IOCP-ACCR-3 |
IOCP ACCRUAL A/C - FORMULA 3 |
IOCP-ACQUIRED-1 |
IOCP ACQUIRED INTEREST - FORMULA 1 |
IOCP-ACQUIRED-3 |
IOCP ACQUIRED INTEREST - FORMULA 3 |
IOCP-ACR_ADJ-1 |
IOCP ACR - ADJ - FORMULA 1 |
IOCP-ACR_ADJ-3 |
IOCP ACR - ADJ - FORMULA 3 |
IOCP-PNL_ADJ-1 |
IOCP PNL - ADJ - FORMULA 1 |
IOCP-PNL_ADJ-3 |
IOCP PNL - ADJ - FORMULA 3 |
IOCP-PNL-1 |
IOCP INCOME/EXPENSE A/C - FORMULA 1 |
IOCP-PNL-3 |
IOCP INCOME/EXPENSE A/C - FORMULA 3 |
IOSR-ACCR-1 |
IOSR ACCRUAL A/C - FORMULA 1 |
IOSR-ACCR-2 |
IOSR ACCRUAL A/C - FORMULA 2 |
IOSR-ACQUIRED-1 |
IOSR ACQUIRED INTEREST - FORMULA 1 |
IOSR-ACQUIRED-2 |
IOSR ACQUIRED INTEREST - FORMULA 2 |
IOSR-ACR_ADJ-1 |
IOSR ACR - ADJ - FORMULA 1 |
IOSR-ACR_ADJ-2 |
IOSR ACR - ADJ - FORMULA 2 |
IOSR-PNL_ADJ-1 |
IOSR PNL - ADJ - FORMULA 1 |
IOSR-PNL_ADJ-2 |
IOSR PNL - ADJ - FORMULA 2 |
IOSR-PNL-1 |
IOSR INCOME/EXPENSE A/C - FORMULA 1 |
IOSR-PNL-2 |
IOSR INCOME/EXPENSE A/C - FORMULA 2 |
IOSR-TPBL_ADJ-3 |
IOSR TAX PAY ADJ A/C - FORMULA 3 |
IOSR-TPBL-3 |
IOSR TAX PAYABLE A/C - FORMULA 3 |
PAST_DUE_ACCOUNT |
Past Due Account |
CLG_BRIDGE_GL |
Clearing Suspense GL |
You can set up various IC products for handling customer accounts. Some representative products are listed below:
Interest
Charge
You can set up accounting entries as given below.
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOSR-PNL-1 |
IACR |
Debit |
IOSR-ACCR-1 |
IACR |
Credit |
IOSR-PNL_ADJ-1 |
IACR_ADJ |
Debit |
IOSR-ACR_ADJ-1 |
IACR_ADJ |
Credit |
IOSR-PNL-2 |
IACR |
Credit |
IOSR-ACCR-2 |
IACR |
Debit |
IOSR-PNL_ADJ-2 |
IACR_ADJ |
Credit |
IOSR-ACR_ADJ-2 |
IACR_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOSR-ACCR-1 |
ILIQ |
Debit |
IOSR-BOOK-1 |
ILIQ |
Credit |
IOSR-ACQUIRED-1 |
IACQUIRED |
Debit |
IOSR-BOOK-1 |
IACQUIRED |
Credit |
IOSR-ACCR-2 |
ILIQ |
Credit |
IOSR-BOOK-2 |
ILIQ |
Debit |
IOSR-ACQUIRED-2 |
IACQUIRED |
Credit |
IOSR-BOOK-2 |
IACQUIRED |
Debit |
IOSR-TPBL-3 |
TAX |
Credit |
IOSR-BOOK-3 |
TAX |
Debit |
IOSR-TPBL_ADJ-3 |
TAX_ADJ |
Credit |
IOSR-BOOK-3 |
TAX_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOCP-PNL-1 |
IACR |
Debit |
IOCP-ACCR-1 |
IACR |
Credit |
IOCP-PNL_ADJ-1 |
IACR_ADJ |
Debit |
IOCP-ACR_ADJ-1 |
IACR_ADJ |
Credit |
IOCP-PNL-3 |
IACR |
Credit |
IOCP-ACCR-3 |
IACR |
Debit |
IOCP-PNL_ADJ-3 |
IACR_ADJ |
Credit |
IOCP-ACR_ADJ-3 |
IACR_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOCP-ACCR-1 |
ILIQ |
Debit |
IOCP-BOOK-1 |
ILIQ |
Credit |
IOCP-ACQUIRED-1 |
IACQUIRED |
Debit |
IOCP-BOOK-1 |
IACQUIRED |
Credit |
IOCP-ACCR-3 |
ILIQ |
Credit |
IOCP-BOOK-3 |
ILIQ |
Debit |
IOCP-ACQUIRED-3 |
IACQUIRED |
Credit |
IOCP-BOOK-3 |
IACQUIRED |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOCC-PNL-1 |
IACR |
Credit |
IOCC-ACCR-1 |
IACR |
Debit |
IOCC-PNL_ADJ-1 |
IACR_ADJ |
Credit |
IOCC-ACR_ADJ-1 |
IACR_ADJ |
Debit |
IOCC-PNL-2 |
IACR |
Debit |
IOCC-ACCR-2 |
IACR |
Credit |
IOCC-PNL_ADJ-2 |
IACR_ADJ |
Debit |
IOCC-ACR_ADJ-2 |
IACR_ADJ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOCC-ACCR-1 |
ILIQ |
Credit |
IOCC-BOOK-1 |
ILIQ |
Debit |
IOCC-ACQUIRED-1 |
IACQUIRED |
Credit |
IOCC-BOOK-1 |
IACQUIRED |
Debit |
IOCC-ACCR-2 |
ILIQ |
Debit |
IOCC-BOOK-2 |
ILIQ |
Credit |
IOCC-ACQUIRED-2 |
IACQUIRED |
Debit |
IOCC-BOOK-2 |
IACQUIRED |
Credit |
IOCC-TPBL-3 |
TAX |
Credit |
IOCC-BOOK-3 |
TAX |
Debit |
IOCC-TPBL_ADJ-3 |
TAX_ADJ |
Credit |
IOCC-BOOK-3 |
TAX_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IBSR-PNL-1 |
IACR |
Debit |
IBSR-ACCR-1 |
IACR |
Credit |
IBSR-PNL_ADJ-1 |
IACR_ADJ |
Debit |
IBSR-ACR_ADJ-1 |
IACR_ADJ |
Credit |
IBSR-PNL-2 |
IACR |
Credit |
IBSR-ACCR-2 |
IACR |
Debit |
IBSR-PNL_ADJ-2 |
IACR_ADJ |
Credit |
IBSR-ACR_ADJ-2 |
IACR_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IBSR-ACCR-1 |
ILIQ |
Debit |
IBSR-BOOK-1 |
ILIQ |
Credit |
IBSR-ACQUIRED-1 |
IACQUIRED |
Debit |
IBSR-BOOK-1 |
IACQUIRED |
Credit |
IBSR-ACCR-2 |
ILIQ |
Credit |
IBSR-BOOK-2 |
ILIQ |
Debit |
IBSR-ACQUIRED-2 |
IACQUIRED |
Credit |
IBSR-BOOK-2 |
IACQUIRED |
Debit |
IBSR-TPBL-3 |
TAX |
Credit |
IBSR-BOOK-3 |
TAX |
Debit |
IBSR-TPBL_ADJ-3 |
TAX_ADJ |
Credit |
IBSR-BOOK-3 |
TAX_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOCM-PNL-1 |
IACR |
Debit |
IOCM-ACCR-1 |
IACR |
Credit |
IOCM-PNL_ADJ-1 |
IACR_ADJ |
Debit |
IOCM-ACR_ADJ-1 |
IACR_ADJ |
Credit |
IOCM-PNL-2 |
IACR |
Credit |
IOCM-ACCR-2 |
IACR |
Debit |
IOCM-PNL_ADJ-2 |
IACR_ADJ |
Credit |
IOCM-ACR_ADJ-2 |
IACR_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
IOCM-ACCR-1 |
ILIQ |
Debit |
IOCM-BOOK-1 |
ILIQ |
Credit |
IOCM-ACQUIRED-1 |
IACQUIRED |
Debit |
IOCM-BOOK-1 |
IACQUIRED |
Credit |
IOCM-ACCR-2 |
ILIQ |
Credit |
IOCM-BOOK-2 |
ILIQ |
Debit |
IOCM-ACQUIRED-2 |
IACQUIRED |
Credit |
IOCM-BOOK-2 |
IACQUIRED |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHAV-TPBL_ADJ-2 |
TAX_ADJ |
Credit |
CHAV-BOOK-1 |
IACQUIRED |
Debit |
CHAV-BOOK-2 |
TAX |
Debit |
CHAV-TPBL-2 |
TAX |
Credit |
CHAV-PNL-1 |
ILIQ |
Credit |
CHAV-BOOK-1 |
ILIQ |
Debit |
CHAV-PNL_ADJ-1 |
IACQUIRED |
Credit |
CHAV-BOOK-2 |
TAX_ADJ |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
DORM-PNL-1 |
ILIQ |
Credit |
DORM-BOOK-1 |
IACQUIRED |
Debit |
DORM-BOOK-1 |
ILIQ |
Debit |
DORM-PNL_ADJ-1 |
IACQUIRED |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_INCOME |
CHARGE |
Debit |
CHG_BOOK |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_INCOME |
CHARGE |
Debit |
CHG_BOOK |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_INCOME |
CHARGE |
Debit |
CHG_BOOK |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
CHG_BOOK |
CHARGE |
Debit |
CHG_INCOME |
CHARGE |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
Liability a/c* |
PD_TAG |
Debit |
PDC Beneficiary |
PD_TAG |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
Clearing Suspense GL |
PD_TAG |
Debit |
Liability a/c* |
PD_TAG |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
Past Due Account |
PD_TAG |
Debit |
Clearing Suspense GL |
PD_TAG |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Debit/Credit Indicator |
Clearing Suspense GL |
PD_TAG |
Debit |
Past Due Account |
PD_TAG |
Credit |