This chapter contains the following sections:
This section contains the following topics:
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.
| 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 |
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.
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 |
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.
| Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
|---|---|---|---|---|---|
| XPVENEXP | XP_AMT_INCRDECR | DEBIT | |||
| XPEXPPROV | XP_AMT_INCRDECR | CREDIT |
| 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 |
| 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 |
| 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 |
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 |
NIL