This Annexure lists the suggested event-wise accounting entries that can be set up, for the Interest and Charge product applicable for the Integrated Liquidity Management module of Oracle FLEXCUBE.
This chapter contains the following sections:
You need to set up the following events for a profit product:
Event Code | Event Description | ||
---|---|---|---|
ILIQ | Interest Liquidation | ||
IACR | Interest Accruals | ||
SWBK | Sweep Booking | ||
RVSW | Reverse Sweep |
You can set up various IP products for liquidity management. Some representative products are listed below:
This section contains the following topics:
To define a pool header product, you need to check ‘ILM Product’ check box in preference tab at Product level and select ‘ILM Type’ as ‘Pool Lead’.
Consider the below accounting entries table for Pool Header product ‘PHR1’, which provides details about mapping of the accounting role to amount tag:
Accounting Entries
Accounting Role | Amount Tag | Dr/Cr Indicator | |||
---|---|---|---|---|---|
PHR1-PNL-1 | IACR | Credit | |||
PHR1-ACCR-1 | IACR | Debit | |||
PHR1-PNL_ADJ-1 | IACR_ADJ | Credit | |||
PHR1-ACR_ADJ-1 | IACR_ADJ | Debit | |||
PHR1-PNL-2 | IACR | Debit | |||
PHR1-ACCR-2 | IACR | Credit | |||
PHR1-PNL_ADJ-2 | IACR_ADJ | Debit | |||
PHR1-ACR_ADJ-2 | IACR_ADJ | Credit |
Accounting Entries
Accounting Role | Amount Tag | Dr/Cr Indicator | |||
---|---|---|---|---|---|
PHR1-ACCR-1 | ILIQ | Credit | |||
PHR1-BOOK-1 | ILIQ | Debit | |||
PHR1-ACQUIRED-1 | IACQUIRED | Credit | |||
PHR1-BOOK-1 | IACQUIRED | Debit | |||
PHR1-ACQUIRED-2 | IACQUIRED | Debit | |||
PHR1-BOOK-2 | IACQUIRED | Credit | |||
PHR1-ACCR-2 | ILIQ | Debit | |||
PHR1-BOOK-2 | ILIQ | Credit | |||
PHR1-TPBL-3 | TAX | Credit | |||
PHR1-BOOK-3 | TAX | Debit | |||
PHR1-TPBL_ADJ-3 | TAX_ADJ | Credit | |||
PHR1-BOOK-3 | TAX_ADJ | Debit |
To define a pool reallocation product, you need to check ‘ILM Product’ check box in preference tab at Product level and select ‘ILM Type’ as ‘Pool Reallocation.’ Also, you need to check the ‘Reallocation through Header’ check box.
Consider the below accounting entries table for Pool Reallocation product ‘PLC1’, which provides details about mapping of the accounting role to amount tag
Accounting Entries
Accounting Role | Amount Tag | Dr/Cr Indicator | |||
---|---|---|---|---|---|
PLC1-PNL-1 | IACR | Debit | |||
PLC1-ACCR-1 | IACR | Credit | |||
PLC1-PNL_ADJ-1 | IACR_ADJ | Debit | |||
PLC1-ACR_ADJ-1 | IACR_ADJ | Credit | |||
PLC1-PNL-2 | IACR | Credit | |||
PLC1-ACCR-2 | IACR | Debit | |||
PLC1-PNL_ADJ-2 | IACR_ADJ | Debit | |||
PLC1-ACR_ADJ-2 | IACR_ADJ | Credit |
Accounting Entries
Accounting Role | Amount Tag | Dr/Cr Indicator | |||
---|---|---|---|---|---|
PLC1-ACCR-1 | ILIQ | Credit | |||
PLC1-BOOK-1 | ILIQ | Debit | |||
PLC1-ACQUIRED-1 | IACQUIRED | Credit | |||
PLC1-BOOK-1 | IACQUIRED | Debit | |||
PLC1-ACQUIRED-2 | IACQUIRED | Debit | |||
PLC1-BOOK-2 | IACQUIRED | Credit | |||
PLC1-ACCR-2 | ILIQ | Debit | |||
PLC1-BOOK-2 | ILIQ | Credit | |||
PLC1-TPBL-3 | TAX | Credit | |||
PLC1-BOOK-3 | TAX | Debit | |||
PLC1-TPBL_ADJ-3 | TAX_ADJ | Credit | |||
PLC1-BOOK-3 | TAX_ADJ | Debit |
Accounting Entries
Accounting Role | Amount Tag | Dr/Cr Indicator | |||
---|---|---|---|---|---|
CHILD | CR_CONT | DR | |||
PARENT | CR_CONT | CR | |||
CHILD | DR_CONT | CR | |||
PARENT | DR_CONT | DR |
Accounting Entries:
Accounting Role | Amount Tag | Dr/Cr Indicator | |||
---|---|---|---|---|---|
PARENT | CR_CONT | DR | |||
CHILD | CR_CONT | CR | |||
CHILD | DR_CONT | DR | |||
PARENT | DR_CONT | CR |