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:

• Section 6.2, "Events"
• Section 6.3, "Amount Tags"
• Section 6.4, "Accounting Roles"
• Section 6.5, "Event-wise Accounting Entries for Products"

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:

• IACR
• IACR_ADJ
• ILIQ
• IACQUIRED
• TAX
• TAX_ADJ

6.4 Accounting Roles

The following accounting roles are available:

• PHR1-ACCR-1
• PHR1-ACCR-2
• PHR1-ACQUIRED-1
• PHR1-ACQUIRED-2
• PHR1-ACR_ADJ-1
• PHR1-ACR_ADJ-2
• PHR1-PNL-1
• PHR1-PNL-2
• PHR1-PNL_ADJ-1
• PHR1-PNL_ADJ-2
• PHR1-TPBL-3
• PHR1-BOOK-1
• PHR1-BOOK-2
• PHR1-BOOK-3
• PHR1-TPBL_ADJ-3
• PLC1-ACCR-1
• PLC1-ACCR-2
• PLC1-ACQUIRED-1
• PLC1-ACQUIRED-2
• PLC1-ACR_ADJ-1
• PLC1-ACR_ADJ-2
• PLC1-PNL-1
• PLC1-PNL-2
• PLC1-PNL_ADJ-1
• PLC1-PNL_ADJ-2
• PLC1-BOOK-1
• PLC1-BOOK-2
• PLC1-BOOK-3
• PLC1-TPBL-3
• PLC1-TPBL_ADJ-3
• NINT-PNL-1
• NINT-ACCR-1
• NINT-PNL_ADJ-1
• NINT-ACR_ADJ-1
• NINT-ACQUIRED-1
• NINT-ACQUIRED-2
• NINT-PNL-2
• NINT-ACCR-2
• NINT-PNL_ADJ-2
• NINT-ACR_ADJ-2
• NINT-BOOK-1
• NINT-BOOK-2

6.5 Event-wise Accounting Entries for Products

This section contains the following topics

• Section 6.5.1, "Pool Header"
• Section 6.5.2, "Pool Reallocation"
• Section 6.5.3, "Normal Debit and Credit Interest"

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

• Pool Header
• Pool Reallocation
• Normal Debit and Credit Interest

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