6. Annexure A - Accounting Entries

6.1 Accounting Entries for ILM

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:

6.2 Events

You need to set up the following events for an Interest product:

Event Code Event Description
ILIQ Interest Liquidation
IACR Interest Accruals

6.3 Amount Tags

The following amount tags are available:

6.4 Accounting Roles

The following accounting roles are available:

6.5 Event-wise Accounting Entries for Products

This section contains the following topics

You can set up various IC products for liquidity management. Some representative products are listed below:

6.5.1 Pool Header

You can set up event-wise accounting entries and advices for the product as suggested below:

6.5.1.1 IACR: Interest Accrual

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

6.5.1.2 ILIQ: Interest Liquidation

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

6.5.2 Pool Reallocation

6.5.2.1 IACR: Interest Accrual

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

 

6.5.2.2 ILIQ: Interest Liquidation

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

 

6.5.3 Normal Debit and Credit Interest

You can set up event-wise accounting entries and advices for the product as suggested below:

6.5.3.1 IACR: Interest Accrual

Accounting Entries

Accounting Role Amount Tag Dr/Cr Indicator
NINT-PNL-1 IACR Debit
NINT-ACCR-1 IACR Credit
NINT-PNL_ADJ-1 IACR_ADJ Debit
NINT-ACR_ADJ-1 IACR_ADJ Credit
NINT-PNL-2 IACR Credit
NINT-ACCR-2 IACR Debit
NINT-PNL_ADJ-2 IACR_ADJ Debit
NINT-ACR_ADJ-2 IACR_ADJ Credit

6.5.3.2 ILIQ: Interest Liquidation

Accounting Entries

Accounting Role Amount Tag Dr/Cr Indicator
NINT-ACCR-1 ILIQ Credit
NINT-BOOK-1 ILIQ Debit
NINT-ACQUIRED-1 IACQUIRED Credit
NINT-BOOK-1 IACQUIRED Debit
NINT-ACQUIRED-2 IACQUIRED Debit
NINT-BOOK-2 IACQUIRED Credit
NINT-ACCR-2 ILIQ Debit
NINT-BOOK-2 ILIQ Credit