22. Annexure B - Accounting Entries

This chapter contains the following sections:

• Section 22.1, "Accounting Entries and Advices for CASA"
• Section 22.2, "Events"
• Section 22.3, "Amount Tags"
• Section 22.4, "Accounting Roles"
• Section 22.5, "Event-wise Accounting Entries for Products"

22.1 Accounting Entries and Advices for CASA

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.

22.2 Events

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

22.3 Amount Tags

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

22.4 Accounting Roles

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

22.5 Event-wise Accounting Entries for Products

You can set up various IC products for handling customer accounts. Some representative products are listed below:

Interest

 

• Interest on Saving and Current Bank Accounts for Retail Customer
• Debit Interest on Current Accounts
• Interest on Current account for Corporate Customer
• Interest Liquidation before month end on Saving and Current Bank Accounts For Retail Customer
• Interest on Saving and Current Bank Accounts for Retail Customer
• Charge on Less Average balance
• Dormancy Charge On Accounts

Charge

 

• Ad-Hoc Statement Charge
• Cheque Book Charges
• Cheques Returned
• Credit Turnover
• Debit Card Blocked
• Debit Card Issued
• Debit Turnover
• Number of Transactions
• No of Account Statements
• Stop Cheque Charges
• Turnover
• YTD-Cr-Turnover
• YTD - Debit Turnover
• Year End Transfer
• Year to date No. of Transactions

22.5.1 Accounting Entries for Interest Products

You can set up accounting entries as given below.

22.5.1.1 Interest on Saving and Current Bank Accounts for Retail Customer

IACR

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

ILIQ

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

 

22.5.1.2 Debit Interest on Current Accounts

IACR

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

ILIQ

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

22.5.1.3 Interest on Current account for Corporate Customer

IACR

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

ILIQ

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

22.5.1.4 Interest Liquidation before month end on Saving and Current Bank Accounts for Retail Customer

IACR

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

ILIQ

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

22.5.1.5 Interest on Saving and Current Bank Accounts for Retail Customer

IACR

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

ILIQ

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

22.5.1.6 Charge on Less Average balance

ILIQ

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

22.5.1.7 Dormancy Charge On Accounts

ILIQ

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

22.5.1.8 Ad-Hoc Statement Charge

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.9 Cheque Book Charges

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.10 Cheques Returned

CIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.11 Credit Turnover

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.12 Debit Card Blocked

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.13 Debit Card Issued

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.14 Debit Turnover

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

 

22.5.1.15 Number of Transactions

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_INCOME	CHARGE	Debit
CHG_BOOK	CHARGE	Credit

22.5.1.16 No of Account Statements

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_INCOME	CHARGE	Debit
CHG_BOOK	CHARGE	Credit

22.5.1.17 Stop Cheque Charges

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_INCOME	CHARGE	Debit
CHG_BOOK	CHARGE	Credit

22.5.1.18 Turnover

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.19 YTD-Cr-Turnover

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

 

22.5.1.20 YTD - Debit Turnover

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.21 Year End Transfer

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.1.22 Year to Date No. of Transactions

CLIQ

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
CHG_BOOK	CHARGE	Debit
CHG_INCOME	CHARGE	Credit

22.5.2 Accounting Entries for Discounted Cheques

22.5.2.1 On Discounting

CDIS

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
Liability a/c*	PD_TAG	Debit
PDC Beneficiary	PD_TAG	Credit

22.5.2.2 On Activation

LIQN

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
Clearing Suspense GL	PD_TAG	Debit
Liability a/c*	PD_TAG	Credit

22.5.2.3 On Rejection

RETN

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
Past Due Account	PD_TAG	Debit
Clearing Suspense GL	PD_TAG	Credit

22.5.2.4 On Re-Presentation

LIQN

Accounting Entries

Accounting Role	Amount Tag	Debit/Credit Indicator
Clearing Suspense GL	PD_TAG	Debit
Past Due Account	PD_TAG	Credit