7. Annexure A - Accounting Entries and Advices

This chapter contains the following sections:

• Section 7.1, "Accounting Entries for XP"

7.1 Accounting Entries for XP

This section contains the following topics:

• Section 7.1.1, "XP Events"
• Section 7.1.2, "Amount Tags"
• Section 7.1.3, "Accounting Roles"
• Section 7.1.4, "Event-wise Accounting Entries"
• Section 7.1.5, "Advices"

This section contains details of the suggested accounting entries that can be set up, for the Expense processing module of Oracle FLEXCUBE. The details of the suggested accounting entries are listed event-wise.

7.1.1 XP Events

Sl No.	Event Code	Event Description
1.	XAMD	Booking of Expense
2.	XBOK	Booking of Expense
3.	XPMT	Liquidation of Expense
4.	XPRV	Reversal of Payment
5.	XREV	Reversal of Expense
6.	XWRF	Write Off of Expense
7	XRFD	Refund

7.1.2 Amount Tags

The amount tags listed below are hard-coded in Oracle FLEXCUBE.

Amount Tag	Description
XP_ADV_LIQD	XP Advance Liquidated in Contract CCY
XP_ADV_PAID	XP Advance Paid in Contract CCY
XP_AMT_INCRDECR	XP Amount Increased/Decreased in Contract CCY
XP_AMT_PAID	XP Amount Paid in Contract CCY
XP_CHG_COLL	XP Charges Collected in Contract CCY
XP_CONT_AMT	XP Contract Amount in Contract CCY
XP_DISC_AMT	XP Discount Amount in Contract CCY
XP_INT_AMT	XP Interest Amount Paid in Contract CCY
XP_OS_ADV	XP Outstanding Advance Amount
XP_OS_AMT	XP Contract Outstanding Amt in Contract CCY
XP_OS_RET	XP Outstanding Retention Amount
XP_RET_COLL	XP Retention Money Collected in Contract CCY
XP_RET_PAY	XP Retention Money Paid in Contract CCY
XP_AMT_REFUND	Refunded amount

In addition to these you can define amount tags as per your requirement for the ICCF and tax components that are attached to a product.

7.1.3 Accounting Roles

The following list contains the accounting roles that are applicable to XP transactions that you can process at your bank.

Accounting Role	Description
XPCHGEXP	Charges collected
XPDISCINC	Discounts Received
XPEXPPROV	Provision
XPPENEXP	Penalty Interest Paid
XPPREPAY	Advance (Prepaid)
XPRETPAY	Retention Money
XPVENEXP	Expense Booking
XPWRITEOFF	Write Off Account
XPVENPAY	Vendor
XPVENEXP	Expense GL

7.1.4 Event-wise 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 XP transaction.

Note

Some of the Amount Tags linked to the Accounting Roles are user defined.

7.1.4.1 Event - XAMD

Accounting Role	Amount Tag	Dr./Cr. Indicator
XPVENEXP	XP_AMT_INCRDECR	DEBIT
XPEXPPROV	XP_AMT_INCRDECR	CREDIT

7.1.4.2 Event - XBOK

Accounting Role	Amount Tag	Dr./Cr. Indicator
XPCHGEXP	XP_CHG_COLL	CREDIT
XPVENPAY	XP_CHG_COLL	DEBIT
XPVENEXP	XP_CONT_AMT	DEBIT
XPEXPPROV	XP_CONT_AMT	CREDIT

7.1.4.3 Event - XPMT

Accounting Role	Amount Tag	Dr./Cr. Indicator
XPVENEXP	XP_ADV_LIQD	DEBIT
XPPREPAY	XP_ADV_LIQD	CREDIT
XPPREPAY	XP_ADV_PAID	DEBIT
XPVENPAY	XP_ADV_PAID	CREDIT
XPEXPPROV	XP_AMT_PAID	DEBIT
XPVENPAY	XP_AMT_PAID	CREDIT
XPDISCINC	XP_DISC_AMT	CREDIT
XPVENPAY	XP_DISC_AMT	DEBIT
XPPENEXP	XP_INT_AMT	DEBIT
XPVENPAY	XP_INT_AMT	CREDIT

7.1.4.4 Event - XWRF

Accounting Role	Amount Tag	Dr./Cr. Indicator
XPWRITEOFF	XP_OS_ADV	DEBIT
XPPREPAY	XP_OS_ADV	CREDIT
XPEXPPROV	XP_OS_AMT	DEBIT
XPVENEXP	XP_OS_AMT	CREDIT
XPVENEXP	XP_OS_RET	DEBIT
XPRETPAY	XP_OS_RET	CREDIT

7.1.4.5 Event - XFRD

The XRFD (Refund) event will be triggered when you process a refund in the system. The following accounting entries have to be set up for this event:

Accounting Role	Amount Tag	Dr / Cr Indicator
XPVENPAY	XP_AMT_REFUND	DEBIT
XPVENEXP	XP_AMT_REFUND	CREDIT

7.1.5 Advices

NIL