20. Annexure B - Accounting Entries

This chapter contains the following sections:

• Section 20.1, "Accounting Entries and Advices for CASA"
• Section 20.2, "Events"
• Section 20.3, "Amount Tags"
• Section 20.4, "Accounting Roles"
• Section 20.5, "Event-wise Accounting Entries for Products"

20.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.

20.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

20.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

20.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

20.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

20.5.1 Accounting Entries for Interest Products

You can set up accounting entries as given below.

20.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

 

20.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

20.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

20.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

20.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

20.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

20.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

20.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

20.5.1.9 Cheque Book Charges

CLIQ

Accounting Entries

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

20.5.1.10 Cheques Returned

CIQ

Accounting Entries

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

20.5.1.11 Credit Turnover

CLIQ

Accounting Entries

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

20.5.1.12 Debit Card Blocked

CLIQ

Accounting Entries

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

20.5.1.13 Debit Card Issued

CLIQ

Accounting Entries

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

20.5.1.14 Debit Turnover

CLIQ

Accounting Entries

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

 

20.5.1.15 Number of Transactions

CLIQ

Accounting Entries

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

20.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

20.5.1.17 Stop Cheque Charges

CLIQ

Accounting Entries

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

20.5.1.18 Turnover

CLIQ

Accounting Entries

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

20.5.1.19 YTD-Cr-Turnover

CLIQ

Accounting Entries

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

 

20.5.1.20 YTD - Debit Turnover

CLIQ

Accounting Entries

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

20.5.1.21 Year End Transfer

CLIQ

Accounting Entries

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

20.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

20.5.2 Accounting Entries for Discounted Cheques

20.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

20.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

20.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

20.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