16. Annexure A - Accounting Entries

This Annexure contains details of the suggested accounting entries that can be set up, for the Islamic Letters of Credit (Islamic LC) module of Oracle FLEXCUBE. The annexure lists details of the following suggested accounting entries, event-wise.

16.1 Islamic LC Events

The following is an exhaustive list of events that can take place during the lifecycle of an Islamic LC. In the subsequent paragraphs we shall examine the accounting entries for each of the events listed below.

Event Code

Event Description

Remarks

ACCR

Accrual (Of Commission)

All Types

AMND

Amendment

All Types

AOCF

Amendment from open to open and confirm

Import only

AATC

Amendment from Advice to Confirm

Export Only

APAC

Amend - Pre-advice to Adv & confirm

Export Only

APAD

Amendment from Pre-advice to advice

Export Only

AVAL

Availment

Only For Islamic LCs

BADV

Booking Of An Islamic LC With Opera­tion Advise

Export Islamic LC Only

BANC

Booking Of An Islamic LC With Opera­tion Advise And Confirm

Export Islamic LC Only

BCFM

Booking Of An Islamic LC With Opera­tion Confirm

Export Islamic LC Only

BISS

Booking Of An Islamic LC Or Guaran­tee Issue (Open or Open & Confirm)

Only For Import Islamic LC, Standby Islamic LC, Clean Islamic LC, Shipping Guarantee And Guarantee

BPRE

Booking Of An Islamic LC With Opera­tion Pre-Advise

Export Islamic LC Only

CALC

Periodic commission calculation

All types

CANC

Cancellation of an Islamic LC

All Types

CLIQ

Commission Liquidation

All Types

CLOS

Closure Of An Islamic LC Or Guarantee

All Types

GCLM

Guarantee Claim

 

RASN

Re-assign an Islamic LC contract

All types

RAVL

Reversal of Availment

All types

REIN

Reinstating An Islamic LC

Revolving Islamic LCs

ROPN

Reopening Of An Islamic LC

All Types

REVR

Reversal of an Islamic LC Contract

All types

REVE

Reversal of an Islamic LC Event

All Types

REIS

Reissue of Guarantee

Guarantee only

MLIQ

Manual Liquidation of Islamic LC com­mission

 

WAIV

Waiver of components during manual liquidation

 

GCLP

Guarantee Claim Settlement

Guarantees/ SBLCs

GCLM

Guarantee Claim Lodgement

Guarantees/ SBLCs

AASC

Amendment of Advice to Silent Confir­mation

Export LC

Whenever a conversion of currency is involved, the conversion rate used is as follows:

16.2 Amount Tags

Amount Tag

Description

AVAIL_SET_AMT

Availment amount paid

AVAIL_SET_AMTEQ

Availment amount received

COLL_AMNDAMT

Collateral amend amount Dr.

COLL_AMNDAMT_EQ

Collateral amend amount Cr.

COLLAMT_OS

Outstanding Collateral amount

COLLAMT_OS_EQ

Outstanding Collateral amount

LC_AMND_AMT

Islamic LC Amendment Amount

LC_OS_AMT

Outstanding Islamic LC amount

LC_REIN_AMT

Outstanding Reinstatement Amount

LIAB_AMND_AMT

Liability Amendment Amount

ADV_LIAB_AMND_AMT

Liability Amendment Amount for advised Islamic LCs

CNF_LIAB_AMND_AMT

Liability Amendment Amount for confirmed Islamic LCs

LIAB_AMT

Liability Amount

LIAB_AVAIL_AMT

Availment Liability Amount

ADV_LIAB_AVAIL_AMT

Availment Liability Amount for advised Islamic LCs

CNF_LIAB_AVAIL_AMT

Availment Liability Amount for confirmed Islamic LCs

LIAB_OS_AMT

Outstanding liability amount

ADV_LIAB_OS_AMT

Outstanding liability amount for advised Islamic LCs

CNF_LIAB_OS_AMT

Outstanding liability amount for confirmed Islamic LCs

LIAB_REIN_AMT

Reinstatement Amount

ADV_LIAB_REIN_AMT

Reinstatement Amount for advised Islamic LCs

CNF_LIAB_REIN_AMT

Reinstatement Amount for confirmed Islamic LCs

R

Receivable Charge

E

Receivable Commission

COLL_AMT_OBP

Initial Collateral amount

COLL_AMTEQ_OBP

Initial Collateral amount

COLL_AMNDAMT_OBP

Collateral amend amt Dr.

COLL_AMNDAMTE­Q_OBP

Collateral amend amt Cr.

COLL_AMT_DECR_OBP

Decreased Collateral amount

COLL_AMT_DE­CREQ_OBP

Decreased Collateral amount equivalent

COLL_REFUND_OBP

Collateral Refund to Customer

COLLAMT_OS_OBP

Outstanding Collateral amount

COLLAMT_OSEQ_OBP

Outstanding Collateral amount

SCF_LIAB_OS_AMT

Silent confirmation liability outstanding amount

SCF_LIAB_AMND_AMT

Silent confirmation liability amend amount

SCF_LIAB_AVAL_AMT

Silent confirmation liability availment amount

16.3 Accounting Roles

The following is an exhaustive list that contains details of the Accounting Roles that are applicable to the Islamic LCs you can process at your bank.

Accounting Role

Description

Role Type

IL_OCU

Outstanding Credit Unutilized

Contingent Liability

IL_OCU_OFFSET

Unutilized Credit Offset

Contingent Asset

IL_CNF

Confirmation of Islamic LC

Real GL

IL_CNF_OFF

Confirmation of Islamic LC Offset

Real GL

IL_COLL_ACCT

Islamic LC Collateral account

Liability

AVL_DEBIT_ACCT

Availment Debit account

Real / Type ‘X’

AVL_CREDIT_ACCT

Availment Credit account

Real / Type ‘X’

CHG_CUST_ACC

Customer Accounts

Real/Type ‘X’

COMM_CUST_ACC

Customer Accounts

Real/Type ‘X’

COLL_CUST_ACC

Customer Accounts

Real/Type ‘X’

TAX_CUST_ACC

Customer Accounts

Real/Type ‘X’

COMM_INC

Commission Income

Income

COMM_REC

Commission earned not collected

Asset

COMM_PAY

Commission collected in advance

Liability

CHG_INC

Charge Income

Income

CHG_REC

Charge receivable

Asset

CHG_EXP

Charge expense

Expense

CHG_PAY

Charge payable

Liability

TAX_PAY

Tax payable

Liability

TAX_EXP

Tax expense

Expense

COL_OBP_ACC

Obligor Account

Real/Type “X”

LI_SCF

Silent Confirmation of LI

Real GL

LI_SCF_OFF

Silent Confirmation of LI Offset

Real GL

16.4 Event-Accounting Entries

In this section, we will discuss the suggested accounting entries that should be generated for each event in the life cycle of an Islamic LC.

This section contains the following topics:

16.4.1 BISS: Booking of an import Islamic LC

16.4.1.1 Liability

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_AMT

Dr

IL_OCU_OFFSET

LIAB_AMT

Cr

16.4.1.2 Collateral

Booking (From Customer Account)

Role

Amount Tag

Debit / Credit

COLL_CUST_ACC

COLL_AMT_OS

Dr

LC_COLL_ACC

COLL_AMT_OSEQ

Cr

COL_DEPOSIT_ACC

COLL_AVLAMTEQ

Dr

LCCOLL_INT_ACCT

COLL_AVLAMT

Cr

Booking (From Customer and Obligor Account)

Role

Amount Tag

Debit/Credit

COL_CUST_ACC

COLL_AMT

Dr

LCCOLL_INT_ACCT

COLL_AMTEQ

Cr

COL_OBP_ACC

COLL_AMT_OBP

Dr

LCCOLL_INT_ACCT

COLL_AMTEQ_OBP

Cr

Here, the transfer of the collateral from the customer onto the collateral deposit account/GL is assumed to be done before the booking of the Islamic LC.

16.4.1.3 Charges

Booking (From Customer Account)

Role

Amount Tag

Debit / Credit

CHG_CUST_ACC

CHARGES

Dr

CHG_INC

CHARGES

Cr

 

Booking (From Receivable Account)

Role

Amount Tag

Debit / Credit

CHG_REC

CHARGES

Dr

CHG_INC

CHARGES

Cr

 

On Receipt (For booking Under Receivable Account)

Role

Amount Tag

Debit / Credit

CHG_CUST_ACC

CHARGES

Dr

CHG_REC

CHARGES

Cr

 

16.4.1.4 Commission

In Advance (Non - Accrual - On Booking)

Role

Amount Tag

Debit / Credit

COMM_CUST_ACC

COMMSN

Dr

COMM_INC

COMMSN

Cr

 

In Advance (Accrual - On Booking)

Role

Amount Tag

Debit / Credit

COMM_CUST_ACC

COMMSN

Dr

COMM_PAY

COMMSN

Cr

 

In Advance (Month-End Accrual)

Role

Amount Tag

Debit / Credit

COMM_PAY

COMMSN

Dr

COMM_INC

COMMSN

Cr

 

In Arrears (Non - Accrual - On Booking)

No Entries For Booking

In Arrears (Non - Accrual - On Receipt)

Role

Amount Tag

Debit / Credit

COMM_CUST_ACC

COMMSN

Dr

COMM_INC

COMMSN

Cr

 

In Arrears (Accrual - On Booking)

No Entries For Booking

In Arrears (Month - End Accrual)

Role

Amount Tag

Debit / Credit

COMM_REC

ACCR_COMMSN

Dr

COMM_INC

ACCR_COMMSN

Cr

 

In Arrears (On Receipt of Commission)

Role

Amount Tag

Debit / Credit

COMM_CUST_ACC

COMMSN

Dr

COMM_REC

COMMSN

Cr

 

16.4.2 Accounting Roles for Transfer of Charge & Commission Components from Islamic LC to BC

Here, Islamic LC_COMM component and Islamic LC_CHG component are defined in the Islamic LC product where the Collect Islamic LC Commission in Bills option is checked.

Accounting Role

Description

LC_CHG_RECV

Islamic LC Charges Receivable

LC_COM­M_RECV

Islamic LC Commission Receiva­ble

 

16.4.3 Accounting Entries for Transfer of Charge & Commission Components from Islamic LC to BC

Dr/Cr

Accounting role

Amount tag propagated from Islamic LC

Dr

LC_COM­M_RECV

LC_COMM_LIQD

Cr

LC_COMM_INC

LC_COMM_LIQD

Dr

LC_CHG_RECV

LC_CHG_LIQD

Cr

LC_CHG_INC

LC_CHG_LIQD

In case of Islamic LC products you have to set up accounting to liquidate commission and charges onto the income GL from receivable GL.

If the accounting role for the DR leg of the accounting entries is setup as customer role, the same is recovered from the customer and gets tracked for transfer to Bills. If realization of income is not expected to happen on CLIQ, you need not setup any accounting entries in the CLIQ event and the income entries can be setup from Bills. The system allows Islamic LC products to be saved without any accounting entries defined in the CLIQ event if the options ‘Collect Islamic LC commission in Bills’ and ‘Collect Islamic LC charges in Bills’ for all the associated Charge and commission components are checked.

16.4.4 Collateral Bridge Accounting Role

Accounting role

Description

LC_BC_COL­L_BRIDGE

Collateral bridge between Islamic LC and Bills

This accounting role is used to transfer the collaterals from the Islamic LC onto the Bill. This role maps onto the GL/Account maintained as a part of the Islamic LC product preference.

16.4.5 AVAL: Availment under Islamic LC

Liability

Role

Amount Tag

Dr/ Cr

IL_OCU

AVAIL_SET_AMT

Cr

IL_OCU_OFFSET

AVAIL_SET_AMTEQ

Dr

IL_OCU

ADV_LIAB_AVAIL_AMT

Cr

IL_OCU_OFFSET

ADV_LIAB_AVAIL_AMT

Dr

IL_CNF_OFF

CNF_LIAB_AVAIL_AMT

Dr

IL_CNF

CNF_LIAB_AVAIL_AMT

Cr

 

Collateral (If Any)

Role

Amount Tag

Debit / Credit

COLL_CUST_ACC

COLL_AMNDAMT

Cr

LC_COLL_ACCT

COLL_AMNDAMTEQ

Dr

LCCOLL_INT_ACCT

COLL_AVLAMT

Dr

LC_BC_COLL_BRIDGE

COLL_AVLAMTEQ

Cr

 

16.4.6 CLOS: Closure of an Islamic LC / Guarantee

Liability

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_OS_AMT

Cr

IL_OCU_OFFSET

LIAB_OS_AMT

Dr

IL_OCU

ADV_LIAB_OS_AMT

Cr

IL_OCU_OFFSET

ADV_LIAB_OS_AMT

Dr

IL_CNF

CNF_LIAB_OS_AMT

Cr

IL_CNF_OFFSET

CNF_LIAB_OS_AMT

Dr

 

Collateral

Booking (From Customer Account

Role

Amount Tag

Debit / Credit

COLL_CUST_ACC

COLLAMT_OS

Cr

LC_COLL_ACCT

COLLAMT_OSEQ

Dr

LCCOLL_INT_ACCT

COLLAMT_OS

Dr

COL_DEPOSIT_ACC

COLLAMT_OSEQ

Cr

Booking (From Customer and OBP account)

Role

Amount Tag

Dr/Cr

LCCOLL_INT_ACCT

COLLAMT_OS

Dr

COLL_CUST_ACC

COLLAMT_OSEQ

Cr

LCCOLL_INT_ACCT

COLLAMT_OS_OBP

Dr

COLL_OBP_ACC

COLLAMT_OSEQ_OBP

Cr

 

16.4.7 REIN: Reinstatement of an Islamic LC / Guarantee

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_REIN_AMT

Dr

IL_OCU_OFFSET

LIAB_REIN_AMT

Cr

IL_OCU

ADV_LIAB_REIN_AMT

Dr

IL_OCU_OFFSET

ADV_LIAB_REIN_AMT

Cr

IL_CNF

CNF_ LIAB_REIN_AMT

Dr

IL_CNF_OFF

CNF_ LIAB_REIN_AMT

Cr

16.4.8 BADV: Advising an Islamic LC

Booking Islamic LC Advice

Role

Amount Tag

Debit / Credit

IL_OCU

ADV_LIAB_OS_AMT

Dr

IL_OCU_OFFSET

ADV_LIAB_OS_AMT

Cr

 

Charges

As given in event BISS.

Commission

As given in event BISS.

16.4.9 BCFM: Confirming an Islamic LC

Liability

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_AMT

Dr

IL_OCU_OFFSET

LIAB_AMT

Cr

 

Collateral (If Any)

Role

Amount Tag

Debit / Credit

COLL_CUST_ACC

COLL_AMT_OS

Cr

LC_COLL_ACCT

COLL_AMT_OSEQ

Dr

Charges

As given in event BISS.

Commission

As given in event BISS.

16.4.10 BPRE: Pre-advising an Islamic LC

None

16.4.11 BANC: Advising and Confirming an Islamic LC

Role

Amount Tag

Debit / Credit

IL_CNF

CNF_LIAB_OS_AMT

Dr

IL_CNF_OFFSET

CNF_LIAB_OS_AMT

Cr

16.4.12 AMND: Amendment

Liability

Reverse all the previous entries for booking. Re-book entries based on BISS or BADV or BPRE or BANC.

Role

Amount Tag

Debit / Credit

IL_OCU

ADV_LIAB_OS_AMT

Dr

IL_OCU_OFFSET

ADV_LIAB_OS_AMT

Cr

IL_CNF

CNF_LIAB_OS_AMT

Dr

IL_CNF_OFFSET

CNF_LIAB_OS_AMT

Cr

 

Collateral

From Customer and OBP account

Role

Amount Tag

Debit / Credit

COL_DEPOSIT_ACC

COLL_AMNDAMTEQ

Dr

LCCOLL_INT_ACCT

COLL_AMNDAMT

Cr

COL_CUST_ACC

COLL_AMNDAMT

Dr

LCCOLL_INT_ACCT

COLL_AMNDAMTEQ

Cr

COL_OBP_ACC

COLL_AMNDAMT_OBP

Dr

LCCOLL_INT_ACCT

COLL_AMNDAMTE­Q_OBP

Cr

LCCOLL_INT_ACCT

COLL_AMT_DECR

Dr

COLL_CUST_ACC

COLL_AMT_DECREQ

Cr

LCCOLL_INT_ACCT

COLL_AMT_DE­CR_OBP

Dr

COLL_OBP_ACC

COLL_AMT_DE­CREQ_OBP

Cr

 

In case of decrease of collateral amount upon amendment, the system attributes the amount tags with negative amounts.

16.4.13 AOCF: Amendment from Open to Open and Confirm

None

16.4.14 APAD: Amendment from Pre-advice to Advice

None

16.4.15 APAC: Amendment from Pre-advice to Advice and Confirm

Same as For BISS

16.4.16 REVR: Reversal of an Islamic LC Contract

Reverse out all the accounting entries booked for the contract till date.

16.4.17 REVE: Reversal of an Islamic LC Event

Reverse the accounting entries of the last version creating event.

16.4.18 ACCR: Accrual of Commission

See Commissions under event BISS.

16.4.19 CALC: Periodic Commission Calculation Date

No entries due to commission calculation.

16.4.20 CLIQ: Liquidation of Commission

See Commissions under event BISS.

16.4.21 ROPN: Reopening of an Islamic LC

Liability

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_OS_AMT

Dr

IL_OCU_OFFSET

LIAB_OS_AMT

Cr

IL_OCU

ADV_LIAB_OS_AMT

Dr

IL_OCU_OFFSET

ADV_LIAB_OS_AMT

Cr

IL_CNF

CNF_LIAB_OS_AMT

Dr

IL_CNF_OFFSET

CNF_LIAB_OS_AMT

Cr

 

Collateral

Booking (From Customer Account)

Role

Amount Tag

Debit / Credit

COLL_CUST_ACC

COLLAMT_OS

Dr

LC_COLL_ACCT

COLLAMT_OS_EQ

Cr

Booking (From Customer and Obligor Account)

Role

Amount Tag

Dr/Cr

COL_CUST_ACC

COLLAMT_OS

Dr

LCCOLL_INT_ACCT

COLLAMT_OSEQ

Cr

COL_OBP_ACC

COLLAMT_OS_OBP

Dr

LCCOLL_INT_ACCT

COLLAMT_OSEQ_OBP

Cr

 

16.4.22 CANC: Cancellation of an Islamic LC

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_OS_AMT

Cr

IL_OCU_OFFSET

LIAB_OS_AMT

Dr

IL_OCU

ADV_LIAB_OS_AMT

Cr

IL_OCU_OFFSET

ADV_LIAB_OS_AMT

Dr

IL_CNF

CNF_LIAB_OS_AMT

Cr

IL_CNF_OFFSET

CNF_LIAB_OS_AMT

Dr

Collateral

From Customer and Obligor account

Role

Amount Tag

Debit / Credit

LCCOLL_INT_ACCT

COLLAMT_OS

Dr

COLL_CUST_ACC

COLLAMT_OSEQ

Cr

LCCOLL_INT_ACCT

COLLAMT_OS_OBP

Dr

COLL_OBP_ACC

COLLAMT_OSEQ_OBP

Cr

 

16.4.23 TRGN: Generation of Tracers

None

16.4.24 AATC: Amendment from Advice to Confirm

Role

Amount Tag

Debit / Credit

IL_OCU

LIAB_OS_AMT

Cr

IL_OCU_OFFSET

LIAB_OS_AMT

Dr

IL_OCU

ADV_LIAB_OS_AMT

Cr

IL_OCU_OFFSET

ADV_LIAB_OS_AMT

Dr

IL_CNF

CNF_LIAB_OS_AMT

Dr

IL_CNF_OFFSET

CNF_LIAB_OS_AMT

Cr

16.4.25 RASN: Reassign an Islamic LC

None

16.4.26 RAVL: Reversal of Availment

Fetch entries for last availment event and reverse them.

16.4.27 MLIQ: Manual Liquidation of Islamic LC commission

Role

Amount Tag propagated from Islamic LC

Dr / Cr

COMM_CUST_ACC

LC_COMM_LIQD

Dr

LC_COMM_RECV

LC_COMM_LIQD

Cr

CHG_CUST_ACC

LC_CHG_LIQD

Dr

LC_CHG_RECV

LC_CHG_LIQD

Cr

These Accounting entries are maintained when there is an Accounting entry maintained in CLIQ for transferring into Receivable. If the accounting entry is not maintained in CLIQ then the Cr Leg will be Income GL.

16.4.28 WAIV: Waiver of Components during Manual Liquidation

The amount tags for the WAI event are created upon creation of the charge and commission components. Consider Islamic LC_CHG and Islamic LC_COMM as charge and commission components defined in the system. The corresponding amount tags will be as follows:

Amount Tag

Description

LC_CHG_WAIV

LC Charge being waived

LC_COMM_WAIV

LC Commission being waived

Accounting Entries for the Waiver event

Dr/Cr

Accounting role

Amount tag propagated from Islamic LC

Dr

LC_COM­M_RECV

LC_COMM_WAIV

Cr

LC_COMM_INC

LC_COMM_WAIV

Dr

LC_CHG_RECV

LC_CHG_WAIV

Cr

LC_CHG_INC

LC_CHG_WAIV

 

These accounting entries are maintained if receivable accounting entries have been maintained on the CLIQ event of the Islamic LC. The amounts for waiver will be displayed as negative amounts. Partial waivers are not allowed.

16.4.29 GCLP: Guarantee Claim Settlement

The following accounting entries are maintained for GCLP event:

Accounting Role

Amount Tag

Dr/Cr

CLAIM_DEBIT_ACCT

CLAIM_CUST_AMT

Dr

CLAIM_SUSPENSE

CLAIM_CUST_AMT

Cr

CLAIM_CREDIT_ACCT

CLAIM_SETTLE_AMT

Cr

CLAIM_SUSPENSE

CLAIM_SETTLE_AMT

Dr

LC_OCU

CLAIM_SETTLE_AMT

Cr

LC_OCU_OFFSET

CLAIM_SETTLE_AMT

Dr

CLAIM_SUSPENSE

COLL_AVALAMT

Cr

LCCOLL_INT_ACCT

COLL_AVALAMT

Dr

COL_CUST_ACC

COLL_REFUND

Cr

LCCOLL_INT_ACCT

COLL_REFUND

Dr

COL_OBP_ACC

COLL_REFUND_OBP

Cr

LCCOLL_INT_ACCT

COLL_REFUND_OBP

Dr

16.4.30 AASC: Amendment of Advice to Silent Confirmation

Accounting entry of AASC event with contingent entries with new amount tags and the reversal entry of ADV

Accounting Role

Amount Tag

Dr/Cr

LI_OCU_OFFSET

ADV_LIAB_OS_AMT

Dr

LI_OCU

ADV_LIAB_OS_AMT

Cr

LI_SCF

SCF_LIAB_OS_AMT

Dr

LI_SCF_OFF

SCF_LIAB_OS_AMT

Cr

Accounting entry of AMND event with operation code as SCF

Accounting Role

Amount Tag

Dr/Cr

LI_SCF

SCF_LIAB_AMND_AMT

Dr

LI_SCF_OFF

SCF_LIAB_AMND_AMT

 

Cr

Accounting entry of AVAL event with operation code as SCF

Accounting Role

Amount Tag

Dr/Cr

LI_SCF_OFF

SCF_LIAB_AVAIL_AMT

Dr

LI_SCF

SCF_LIAB_AVAIL_AMT

Cr

Accounting entry of CLOS/CANC event with operation code as SCF

Accounting Role

Amount Tag

Dr/Cr

LI_SCF_OFF

SCF_LIAB_OS_AMT

Dr

LI_SCF

SCF_LIAB_OS_AMT

Cr

Accounting entry of ROPN event with operation code as SCF

Accounting Role

Amount Tag

Dr/Cr

LI_SCF

SCF_LIAB_OS_AMT

Dr

LI_SCF_OFF

SCF_LIAB_OS_AMT

Cr