This section contains details of the suggested accounting entries that can be set up for the Securities module of Oracle FLEXCUBE. The details of the suggested accounting entries are listed event-wise.
This chapter contains the following sections:
The following is an exhaustive list of events for portfolio type and customer buy/sell type of securities products.
This section contains the following topics:
Event Code | Event Description | Remarks | |||
---|---|---|---|---|---|
SPLP | Sec. Purchase from Long Position | All types | |||
SSLP | Sec. Sale from Long Position | All types | |||
ACRD | Accrual of Sec. Discount Earned | All types | |||
ACRP | Accrual of Sec. Premium Paid | All types | |||
ACRR | Accrual of Redemption Premium Earned | All types | |||
FACR | Sec. Forward Deal P&L Accrual | All types | |||
DVIN | Securities Dividend Initiation | All types | |||
DVCD | Securities Dividend Collection | All types | |||
DVLQ | Securities Dividend Liquidation | All types | |||
BRVL | Securities Revaluation of Positions/Deals | All types | |||
SSKC | Safe Keeping/Custodial Charges | All types | |||
WRLL | Warrants Sec. Tear-Off Processing | All types | |||
WROL | Warrant Detachment from Parent Sec | All types | |||
WELL | Warrants Sec. Exercise Processing | All types | |||
WXLL | Expiry of Un-Exercised Warrants | All types | |||
RGLL | Rights Security Tear-Off Processing | All types | |||
RGOL | Rights Detachment from Parent Sec. | All types | |||
RELL | Exercise of Rights for New Equity | All types | |||
RXLL | Expiry of Un-Exercised Rights | All types | |||
CANG | Corporate Action Notice Generation | All types | |||
IACR | Securities Coupon Interest Accrual | All types | |||
CPCD | Coupon Collection | All types | |||
CPIN | Coupon Initiation | All types | |||
CPLQ | Coupon Liquidation | All types | |||
SCIN | Securities Stock to Cash Initiation | All types | |||
SCCD | Securities Stock to Cash Collection | All types | |||
SCLQ | Securities Stock to Cash LIQD. | All types | |||
YACR | Yield Accruals for deals | All types |
Event Code | Event Description | Remarks | |||
---|---|---|---|---|---|
Book | Booking of Securities Deal | All types | |||
AMND | Amendment of Securities Deal | All types | |||
CANC | Cancellation of Securities Deal | All types | |||
CCON | Counterparty confirmation | All types | |||
DACF | Deliver Versus Payment Confirmation | All types | |||
DFCF | Deliver Free Confirmation | All types | |||
DSTL | Settlement of Securities Deal | All types | |||
EXTN | Extension of Deal Settlement Date | All types | |||
MSTL | Money Settlement of Securities Deal | All types | |||
RACF | Receive Versus Payment Confirmation | All types | |||
RBLK | Release Block of Security Position | All types | |||
REAS | Reassignment of Securities Deal | All types | |||
REVR | Reversal of Securities Deal | All types | |||
RFCF | Receive Free Confirmation | All types |
In the subsequent paragraphs we shall examine the accounting entries and advices for each of the events listed above.
The amount tags listed below are hard-coded in Oracle FLEXCUBE.
Amount Tag | Description | ||
---|---|---|---|
CURR_FV | Current Face Value | ||
SEC_DEAL_AMOUNT | Securities Deal Amount | ||
DEAL_DISCNT_AMT | Securities Deal Discount Amount | ||
DEAL_NOMINALAMT | Securities Deal Nominal Amount | ||
DEAL_PREMIUMAMT | Securities Deal Premium Amount | ||
FWD_DEAL_LOSS | Securities Forward Loss | ||
FWD_DEAL_PROFIT | Securities Forward Profit | ||
SEC_ADJDEAL_AMT | Securities Adjusted Deal Amount | ||
SEC_DEAL_AMOUNT | Securities Deal Amount | ||
TBD_WHT_SELL | T Bill Discount Tax - Sell | ||
ACCRUED_RDPREM | Accrued Redemption Premium Amount | ||
CSH_DVDEND | Cash Dividend Amount | ||
CSH_DVDEND_EDIS | Cash Dividend Expense for DIBR | ||
CSH_DVDEND_EINI | Cash Dividend Expense for INIT | ||
CSH_DVDEND_ELIQ | Cash Dividend Expense for LIQD | ||
CSH_DVDEND_ICOL | Cash Dividend Income for COLL | ||
CSH_DVDEND_IINI | Cash Dividend Income for INIT | ||
CSH_DVDEND_ILIQ | Cash Dividend Income for LIQD | ||
DEAL_DISCNT_AMT | Securities Deal Discount Amount | ||
DEAL_NOMINALAMT | Securities Deal Nominal Amount | ||
DEAL_PREMIUMAMT | Securities Deal Premium Amount | ||
FWD_DEALEXP_ACR | Sec. Forward Deal Expense Accr Amt | ||
FWD_DEALINC_ACR | Sec. Forward Deal Income Accr Amt | ||
FWD_DEAL_LOSS | Securities Forward Deal Loss Amount | ||
FWD_DEAL_PROFIT | Securities Forward Deal Profit Amt | ||
HLDG_LO_MTM_EXP | Sec. Long Holdings MTM Reval Expens | ||
HLDG_LO_MTM_INC | Sec. Long Holdings MTM Reval Income | ||
HLDG_MTM_EXP | Sec. Net Holdings MTM Reval Expense | ||
HLDG_MTM_INC | Sec. Net Holdings MTM Reval Income | ||
HLDG_RL_MTM_EXP | Sec. Long Holdings MTM Realized Reval Expense | ||
HLDG_RL_MTM_INC | Sec. Long Holdings MTM Realized Reval Income | ||
HLDG_RS_MTM_EXP | Sec. Short Holdings MTM Realized Reval Expense | ||
HLDG_RS_MTM_INC | Sec. Short Holdings MTM Realized Reval Income | ||
HLDG_R_MTM_EXP | Sec. Net Holdings MTM Realized Reval Expense | ||
HLDG_R_MTM_INC | Sec. Net Holdings MTM Realized Reval Income | ||
HLDG_SH_MTM_EXP | Sec. Short Holdings MTM Reval Expns | ||
HLDG_SH_MTM_INC | Sec. Short Holdings MTM Reval Incom | ||
LOCOM_REVAL_EXP | Sec. Positions LOCOM Reval Expense | ||
LOCOM_RREVL_EXP | Sec. Positions LOCOM Realized Reval Expense | ||
LOCOM_REVAL_INC | Profit on LOCOM revaluation if LOCOM basis is ‘Acquisition Cost’ | ||
MTM_EXP | Sec. Positions MTM Reval Expense | ||
MTM_INC | Sec. Positions MTM Reval Income | ||
RDMPTN_PREM_AMT | Redemption Premium Amount | ||
REALIZED_LOSS | Securities Realized Trading Loss | ||
REALIZED_PROFIT | Securities Realized Trading Profit | ||
REAL_MTM_EXP | Sec. Positions MTM Realized Reval Expense | ||
REAL_MTM_INC | Sec. Positions MTM Realized Reval Income | ||
RGHT_INTR_VALUE | Rights Intrinsic Value | ||
SEC_ADJDEAL_AMT | Securities Adjusted Deal Amount | ||
SEC_CASH_DIVDND | Securities Cash Dividend Amount | ||
SEC_COST_AMOUNT | Sec. True Asset Cost Amount | ||
SEC_DEAL_AMOUNT | Securities Deal Amount | ||
SEC_DISC_ACCR | Sec. Discount Earned Accrual Amount | ||
SEC_PREM_ACCR | Sec. Premium Paid Accrual Amount | ||
SEC_RDPREM_ACCR | Sec. Redemption Premium Accrual Amt | ||
SEC_REVL_LOSS | Securities Revaluation Loss Amount | ||
SEC_REVL_PROFIT | Securities Revaluation Profit Amt | ||
SEC_RRVL_LOSS | Sec. Revaluation Reversal Loss Amt | ||
SEC_RRVL_PROFIT | Sec. Revaluation Profit Revrsal Amt | ||
STK_TO_CSH | Stock To Cash Amount | ||
STK_TO_CSH_EDIS | Stock To Cash Expense for DIBR | ||
STK_TO_CSH_EINI | Stock To Cash Expense for INIT | ||
STK_TO_CSH_ELIQ | Stock To Cash Expense for LIQD | ||
STK_TO_CSH_ICOL | Stock To Cash Income for COLL | ||
STK_TO_CSH_IINI | Stock To Cash Income for INIT | ||
STK_TO_CSH_ILIQ | Stock To Cash Income for LIQD | ||
TBD_WHT_ACCRA | T Bill Discount Tax - Arrears Accrued | ||
TBD_WHT_ACCRD | T Bill Discount Tax - Advance Accrued | ||
TBD_WHT_ADV | T Bill Discount Tax - Paid in Advance | ||
TBD_WHT_PAY | T Bill Discount Tax - Payable | ||
TBD_WHT_SELL | T Bill Discount Tax - Sell | ||
TBD_WHT_UNACCRB | T Bill Disc. Tax-Unaccrued-Sell Disc > Buy Disc | ||
TBD_WHT_UNACCRS | T Bill Disc. Tax-Unaccrued-Sell Disc <= Buy Disc | ||
UNACCRD_DISCNT | Unaccrued Discount Amount | ||
UNACCRD_PREMIUM | Unaccrued Premium Amount | ||
UNSD_BY_MTM_EXP | Unstld Buy Deals MTM Reval Expense | ||
UNSD_BY_MTM_INC | Unstld Buy Deals MTM Reval Income | ||
UNSD_MTM_EXP | Securities Unutilized Deals MTM Revaluation Expense | ||
UNSD_MTM_INC | Securities Unutilized Deals MTM Revaluation Income | ||
UNSD_R_MTM_EXP | Securities Unutilized Deals MTM Realized Reval Expense | ||
UNSD_R_MTM_INC | Securities Unutilized Deals MTM Realized Reval Income | ||
UNSD_SE_MTM_EXP | Unutilized Sell Deals MTM Revaluation Expense | ||
UNSD_SE_MTM_INC | Unutilized Sell Deals MTM Revaluation Income | ||
UNSR_BY_MTM_EXP | Unutilized Buy Deals MTM Realized Revaluation Expense | ||
UNSR_BY_MTM_INC | Unutilized Buy Deals MTM Realized Revaluation Income | ||
UNSR_SE_MTM_EXP | Unutilized Sell Deals MTM Realized Revaluation Expense | ||
UNSR_SE_MTM_INC | Unutilized Sell Deals MTM Realized Revaluation Income | ||
WARR_INTR_VALUE | Warrants Intrinsic Value | ||
INTCOMP_PUCMA | This Amount tag represents the value of the Bought Interest if any (at the time of Purchase) for the sold securities. If there were more than one purchase, this tag will be a sum of all the bought interest in FIFO order. During sale these tags have value only if the sold units are bought in the current coupon period | ||
TOTALINT_TIAC | This amount tag represents the total interest accrued for the eligible units (total interest - Bought interest). | ||
SEC_PREM_TOTALACCR | This amount tag represents the total Premium accrued for the Sold units | ||
SEC_DISC_TOTALACCR | This amount tag represents the total Discount accrued for the Sold units | ||
SEC_BRIDGE_TFR | This amount tag can be used to move the balance between the bridge-buy and bridge-sell GL’s, (if different GL’s are used for Bridge-buy and bridge-sell). This amount tag will only be populated for the sell leg in the case of BBBS and CBCS kind of deals. | ||
SEC_PREM_ACCR | Premium Paid Accrual Amount | ||
SEC_INTADJ_ACCR | Interest Adjustment Accrual Amount | ||
SEC_DISC_ACCR | Discount Earned Accrual Amount | ||
ACCRUED_INT_ADJ | Accrued Interest Adjustment Amount | ||
BROK_DISC | Brokerage Discount Amount | ||
BROK_PREM | Brokerage Premium Amount | ||
DR_CHG_DISC | Consolidated Debit charges for the deal | ||
CR_CHG_PREM | Consolidated Credit charges for the deal |
Note
When revaluation entries of the previous financial year are being reversed (at BOD on the first working day of the particular financial year) the following Amount Tags are used:
The amount tags have already been explained in the table above except for the fact that they have the PY suffix.
In this section we have provided two separate lists of sample accounting roles. List I contains accounting roles that can be set up for a Portfolio type of product. List II contains samples of accounting roles that are applicable for a Customer buy/sell type of product.
This section contains the following topics:
Accounting Role | Description | ||
---|---|---|---|
SEC DISC TBACRD | Security Deal Discount to be Accrued GL | ||
SEC PREM TBACRD | Security Deal Premium to be Accrued GL | ||
SEC FWDEXP OFST | Security Forward Deal Loss Offset GL | ||
SEC FWDINC OFST | Security Forward Deal Profit Offset GL | ||
SE_FL_INT_RCPY | SE_FL_INT-Receivable/Payable | ||
SE_FL_INT_RAPA | SE_FL_INT- Recd in Adv/Paid in Adv | ||
SEC ASSET GL | Securities Portfolio Asset GL | ||
SEC BRIDGE GL | Securities Bridge GL - Settlement | ||
SEC LIABILTY GL | Securities Portfolio Liability GL | ||
SE_FX_INT_IC | SE_FX_INT - Income – Cum | ||
SE_FX_INT_IX | SE_FX_INT - Income – Ex | ||
SE_FX_INT_AJI | SE_FX_INT-Previous Period Adj Inc | ||
SE_FX_INT_RCPY | SE_FX_INT - Receivable/Payable | ||
SE_FX_INT_RAPA | SE_FX_INT- Recd in Adv/Paid in Adv | ||
SEC RLZD LOSS | Security Trading Realized Loss GL | ||
SEC RLZD PROFIT | Security Trading Realized Profit GL | ||
SEC RDPREM RECV | Security Redemption Premium Receivable | ||
SEC RDPREM ERND | Security Redemption Premium Earned GL | ||
MTM_ASS | Security Positions MTM Reval Asset | ||
MTM_LBY | Security Positions MTM Reval Liability | ||
MTM_EXP | Security Positions MTM Reval Expense | ||
MTM_INC | Security Positions MTM Reval Income | ||
SEC COUPON RECV | Securities Coupon Receivable GL | ||
SEC COUPON PAY | Securities Coupon Payable GL | ||
SEC BRIDGE-S | Securities Bridge - Sale | ||
SEC BRIDGE - PUR | Securities Bridge – Purchase | ||
DEAL_PREMIUM | Deal Premium | ||
DEAL_DISCOUNT | Deal Discount | ||
DEAL INTEREST-BOUGHT | Deal interest bought | ||
ACCRUAL OF PREM EXP – MEMO | Accrual of Premium Expense - Memo | ||
ACCRUAL OF DISCT INC – MEMO | Accrual of Premium Income - Memo | ||
ACCRUAL OF INT. INC - MEMO | Accrual of Interest Income - Memo | ||
INTCOMP_OFF | Purchase Interest Offset GL, created for each interest component to indicate routing of purchase interest. | ||
INTCOMP_PUADJ | Difference between Sold Interest and the Interest Accrued. In the first coupon after purchase, this tag will be equal to Purchase Interest. In subsequent coupons, this tag will have a value of 0, as the Sold Interest would be equal to Interest Accrued | ||
LOCOM_REVAL_INC | Profit on LOCOM revaluation if LOCOM basis is ‘Acquisition Cost’ | ||
LOCOM_REVAL_ASS | Corresponding asset for LOCOM revaluation on ‘Acquisition Cost’ basis | ||
SEC PREM EARNED | Premium Earned | ||
SEC PREM TBACRD | Premium to be Accrued | ||
SEC INT ADJ | EIM Adjustment Receivable for Par deals | ||
SEC BRIDGE GL | EIM Adjustment Income for Par deals | ||
SEC DISC TBACRD | Discount to be Accrued | ||
SEC DISC EARNED | Discount Earned |
Note
You should not use the memo GLs if you accrue premium/discount directly into your income/expense GLs. Similarly, you should not use DEAL_PREMIUM, DEAL_DISCOUNT and DEAL INTEREST-BOUGHT, GLs in a product, which is using SEC DISC TBACRD and SEC PREM TBACRD.
Accounting Role | Description | ||
---|---|---|---|
CS_REG_INC | Chg Class For Cust Sell | ||
CB_REG_INC | Charge Class For Cust Buy | ||
SEC BRIDGE GL | Securities Bridge GL – Settlement | ||
SEC BRIDGE-SELL | Securities Bridge - Sale | ||
SEC BRIDGE - PUR | Securities Bridge – Purchase | ||
SEC BRIDGE BUY | Securities Bridge – Buy | ||
INTCOMP_BOT | Deal interest bought. |
Note
If you are using the Securities Bridge GL (SEC BRIDGE GL) for settlements you should not be associating the Bridge GLs (SEC BRIDGE-S, SEC BRIDGE – PUR) with the product. However, these roles cannot be made applicable on portfolios with Weighted Average as the Costing Method.
The suffixes stand for:
RECV | Receivable | ||
---|---|---|---|
RIA | Received in advance | ||
TBACRD | To be accrued | ||
OFST | Offset GL | ||
RCPY | Receivable/Payable | ||
RAPA | Received in advance/Paid in advance | ||
AJI | Adjustment Income | ||
ERND | Earned | ||
ASS | Asset | ||
LBY | Liability | ||
PAY | Payable | ||
EXP | Expense |
Securities Advices
The list of advices that shall be generated in Securities Module of Oracle FLEXCUBE 3.0 is as shown in the table below:
Advice Code | Advice Description | SWIFT Equivalent. | Sender of Message | Receiver of Message | |||||
---|---|---|---|---|---|---|---|---|---|
TRADE CONF AFFM | Trade Confirmation Affirmation | MT 517 | Trade Instructing Party | Trade Executing Party | |||||
Buyer | Trade Counterparty | ||||||||
MKT TRADE CONF | Market-Side Trade Confirmation | MT 518 | Trade Executing Party | Trade Counterparty | |||||
RECV SEC FREE | Receive Free | MT 520/MT540 | Custody/Portfolio Customer | Custodian | |||||
Custodian | Safekeeping Location | ||||||||
DLVR SEC FREE | Deliver Free | MT 522/MT542 | Custody/Portfolio Customer | Custodian | |||||
Custodian | Safekeeping Location | ||||||||
DLVR SEC APMT | Deliver Against Payment | MT 523/MT543 | Custody/Portfolio Customer | Custodian | |||||
Custodian | Safekeeping Location | ||||||||
RECV SEC APMT | Received against payment | MT 521/ MT 541 | Custody/Portfolio Customer | Custodian | |||||
Custodian | Safekeeping Location | ||||||||
RECV FREE CONF | Receive Free Confirmation | MT 530 | Safekeeping Location | Custodian | |||||
Custodian | Custody/Portfolio Customer | ||||||||
RECV APMT CONF | Receive Against Payment Confirmation | MT 531 | Safekeeping Location | Custodian | |||||
Custodian | Custody/Portfolio Customer | ||||||||
DLVR FREE CONF | Deliver Free Confirmation | MT 532 | Safekeeping Location | Custodian | |||||
Custodian | Custody/Portfolio Customer | ||||||||
DLVR FREE APMT | Deliver Against Payment Confirmation | MT 533 | Safekeeping Location | Custodian | |||||
Custodian | Custody/Portfolio Customer | ||||||||
NOTICE OF RGHTS | Notice of Rights | MT 550 | Custodian | Custody/Portfolio Customer | |||||
NOTICE OF EVENT | Notice of Event | MT 551 | Custodian | Custody/Portfolio Customer | |||||
MONY INCOME ADV | Advice of Money Income | MT 554 | Custodian | Custody/Portfolio Customer | |||||
SEC INCOME ADV | Advice of Income in the Form of Securities | MT 555 | Custodian | Custody/Portfolio Customer | |||||
SEC REDMPTN ADV | Advice of Redemption | MT 556 | Custodian | Custody/Portfolio Customer | |||||
REQST FOR STMT | Request for Statement | MT 570 | Custody/Portfolio Customer | Custodian | |||||
Custodian | Safekeeping Location | ||||||||
SEC HLD STATMNT | Statement of Holdings | MT 571 | Custodian | Portfolio Customer | |||||
Safekeeping Location | Custodian | ||||||||
SEC TXN STATMNT | Statement of Transactions | MT 572 | Custodian | Portfolio Customer | |||||
Safekeeping Location | Custodian | ||||||||
PNDING TXN STMT | Statement of Pending Transactions | MT 573 | Custodian | Portfolio Customer | |||||
Safekeeping Location | Custodian |
In the subsequent sections we have defined suggested accounting entries and advices for each of the events in the life-cycle of an SS deal. Samples of accounting entries, advices, and events have been given for two different types of SS deals. They are:
The preferences set up for a Bank Portfolio type of products are as follows:
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Debit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Credit | |||
SEC ASSET GL | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Credit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Debit | |||
SEC BRIDGE GL | FWD_DEAL_LOSS | Credit | |||
SEC FWDEXP OFST | FWD_DEAL_LOSS | Debit | |||
SEC BRIDGE GL | FWD_DEAL_PROFIT | Debit | |||
SEC FWDINC OFST | FWD_DEAL_PROFIT | Credit | |||
SEC BRIDGE GL | SE_FL_INT_PUCM | Credit | |||
SE_FL_INT_RCPY | SE_FL_INT_PUCM | Debit | |||
SEC BRIDGE GL | SE_FL_INT_PUEX | Debit | |||
SE_FL_INT_RAPA | SE_FL_INT_PUEX | Credit | |||
SEC BRIDGE GL | SE_FX_INT_PUCM | Credit | |||
SE_FX_INT_RCPY | SE_FX_INT_PUCM | Debit | |||
SEC BRIDGE GL | SE_FX_INT_PUEX | Debit | |||
SE_FX_INT_RAPA | SE_FX_INT_PUEX | Credit | |||
SEC PREM TBACRD | BROK_PREM | Debit | |||
SEC BRIDGE GL | BROK_PREM | Credit | |||
SEC BRIDGE GL | DR_CHG_DISC | Debit | |||
SEC DISC TBACRD | DR_CHG_DISC | Credit | |||
SEC PREM TBACRD | CR_CHG_PREM | Debit | |||
SEC BRIDGE GL | CR_CHG_PREM | Credit |
Given below are the sample accounting entries that will be posted if you use the alternative accounting roles for this event:
Accounting Role | Standard/Alternative | Amount Tags | Standard/Alternative | Debit/Credit Indictor | |||||
---|---|---|---|---|---|---|---|---|---|
Sec Asset GL | Standard | DEAL_NOMINALAMT | Standard | Debit | |||||
Sec Bridge - Pur | Alternative | DEAL_NOMINALAMT | Standard | Credit | |||||
Deal Premium | Alternative | DEAL_PREMIUMAMT | Standard | Debit | |||||
Sec Bridge - Pur | Alternative | DEAL_PREMIUMAMT | Standard | Credit | |||||
Sec Bridge - Pur | Alternative | DEAL_DISCNT_AMT | Standard | Debit | |||||
Deal Discount | Alternative | DEAL_DISCNT_AMT | Standard | Credit | |||||
Deal Interest-Bought | Alternative | INTCOMP_PUCM | Standard | Debit | |||||
Sec Bridge - Pur | Alternative | INTCOMP_PUCM | Standard | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | ACCRUED_RDPREM | Debit | |||
SEC RDPREM RECV | ACCRUED_RDPREM | Credit | |||
SEC ASSET GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | FWD_DEAL_LOSS | Credit | |||
SEC FWDEXP OFST | FWD_DEAL_LOSS | Debit | |||
SEC BRIDGE GL | FWD_DEAL_PROFIT | Debit | |||
SEC FWDINC OFST | FWD_DEAL_PROFIT | Credit | |||
SEC BRIDGE GL | REALIZED_LOSS | Credit | |||
SEC RLZD LOSS | REALIZED_LOSS | Debit | |||
SEC BRIDGE GL | REALIZED_PROFIT | Debit | |||
SEC RLZD PROFIT | REALIZED_PROFIT | Credit | |||
SEC ASSET GL | RGHT_INTR_VALUE | Debit | |||
SEC BRIDGE GL | RGHT_INTR_VALUE | Credit | |||
SEC BRIDGE GL | SE_FL_INT_SOCM | Debit | |||
SE_FL_INT_RCPY | SE_FL_INT_SOCM | Credit | |||
SEC BRIDGE GL | SE_FL_INT_SOEX | Credit | |||
SE_FL_INT_RAPA | SE_FL_INT_SOEX | Debit | |||
SEC BRIDGE GL | SE_FX_INT_SOCM | Debit | |||
SE_FX_INT_RCPY | SE_FX_INT_SOCM | Credit | |||
SEC BRIDGE GL | SE_FX_INT_SOEX | Credit | |||
SE_FX_INT_RAPA | SE_FX_INT_SOEX | Debit | |||
SEC BRIDGE GL | UNACCRD_DISCNT | Credit | |||
SEC DISC TBACRD | UNACCRD_DISCNT | Debit | |||
SEC BRIDGE GL | UNACCRD_PREMIUM | Debit | |||
SEC PREM TBACRD | UNACCRD_PREMIUM | Credit | |||
SEC ASSET GL | WARR_INTR_VALUE | Debit | |||
SEC BRIDGE GL | WARR_INTR_VALUE | Credit | |||
SEC BRIDGE GL | ACCRUED_INT_ADJ | Debit | |||
SEC INT ADJ | ACCRUED_INT_ADJ | Credit |
Given below are the sample accounting entries that will be posted if you use the alternative accounting roles for this event:
SSLP (Sale)
Accounting Roles | Standard/ Alternative |
Amount Tags | Standard/ Alternative |
Dr. /Cr. Indicator | ||||||
---|---|---|---|---|---|---|---|---|---|---|
Premium Accrued | Standard | SEC_PREM_TOTALACCR | Alternative | Debit | ||||||
Deal Premium | Alternative | SEC_PREM_TOTALACCR | Alternative | Credit | ||||||
Sec Bridge-S | Alternative | UNACCRD_PREMIUM | Standard | Debit | ||||||
Deal Premium | Alternative | UNACCRD_PREMIUM | Standard | Credit | ||||||
Premium Expense | Standard | SEC_PREM_TOTALACCR | Alternative | Debit | ||||||
Accrual of Prem Exp - Memo | Alternative | SEC_PREM_TOTALACCR | Alternative | Credit | ||||||
Deal Discount | Alternative | SEC_DISC_TOTALACCR | Alternative | Debit | ||||||
Discount Accrued | Standard | SEC_DISC_TOTALACCR | Alternative | Credit | ||||||
Deal Discount | Alternative | UNACCRD_DISCNT | Standard | Debit | ||||||
Sec Bridge-S | Alternative | UNACCRD_DISCNT | Standard | Credit | ||||||
Accrual of Disct Inc - Memo | Alternative | SEC_DISC_TOTALACCR | Alternative | Debit | ||||||
Discount Income | Standard | SEC_DISC_TOTALACCR | Alternative | Credit | ||||||
Sec Bridge-S (SEC-BRIDGE-SEL) | Alternative | INTCOMP_PUCMA | This amount tag represents the value of the Bought Interest if any (at the time of Purchase) for the sold securities | Alternative | Debit | |||||
Deal Interest-Bought (INTCOMP_BOT) | Alternative | INTCOMP_PUCMA | Alternative | Credit | ||||||
Sec Bridge-S (SEC-BRIDGE-SEL) | Alternative | INTCOMP_TIAC | This amount tag represents the interest accrual. | Alternative | Debit | |||||
Accrual of Int. Rec (RCPY) (INTCOMP_RCPY) | Standard | INTCOMP_TIAC | Alternative | Credit | ||||||
Accrual of Int. Inc – Memo (INTCOMP_IMEM) | Alternative | INTCOMP_TIAC | Alternative | Debit | ||||||
Interest Income (INTCOMP_I) | Standard | INTCOMP_TIAC | Alternative | Credit |
Total Sold Interest = INT_ PUCMA + INTCOMP_TIAC)
(INTCOMP_PUCMA will have value only if the security is bought and sold in the same coupon period)
SPLP (Capitalized Bonds)
In addition to the normal accounting entries you will need to specify the entries to move the purchased interest into offset GL (Sale option) or the Bought Interest GL (Sale and coupon).
SSLP (Redemption)
Accounting Roles | Standard/ Alternative |
Amount Tags | Standard/ Alternative |
Dr./Cr. Indicator | |||||
---|---|---|---|---|---|---|---|---|---|
Premium Accrued | Standard | SEC_PREM_TOTALACCR | Alternative | Debit | |||||
Deal Premium | Alternative | SEC_PREM_TOTALACCR | Alternative | Credit | |||||
Premium Expense | Standard | SEC_PREM_TOTALACCR | Alternative | Debit | |||||
Accrual of Prem Exp - Memo | Alternative | SEC_PREM_TOTALACCR | Alternative | Credit | |||||
Deal Discount | Alternative | SEC_DISC_TOTALACCR | Alternative | Debit | |||||
Discount Accrued | Standard | SEC_DISC_TOTALACCR | Alternative | Credit | |||||
Accrual of Disct Inc - Memo | Alternative | SEC_DISC_TOTALACCR | Alternative | Debit | |||||
Discount Income | Standard | SEC_DISC_TOTALACCR | Alternative | Credit |
You will need to maintain the following accounting entry set-up when a securities contract is liquidated with previous year adjustment option.
Accounting Role | Amount Tag | Debit / Credit Indicator | |||
---|---|---|---|---|---|
For Interest | |||||
SEC-BRIDGE-SEL (Security Bridge GL – SALE) | INTCOMP_PUCMA (Purchase Interest) | Debit | |||
INTCOMP_BOT (Deal Purchase Interest) | INTCOMP_PUCMA (Purchase Interest) | Credit | |||
SEC-BRIDGE-SEL (Security Bridge GL – SALE) | INTCOMP_TIAC (Interest Accrued) | Debit | |||
INTCOMP_RCPY (Interest Receivable / Payable) | INTCOMP_TIAC (Interest Accrued) | Credit | |||
INTCOMP_IMEM (Interest Income – Memo) | INTCOMP_TIAC (Interest Accrued) | Debit | |||
INTCOMP_I (Interest Income) | INTCOMP_TIAC (Interest Accrued) | Credit | |||
For Discount | |||||
DEAL_DISCOUNT (Deal Discount GL) | UNACCRD_DISCNT | Debit | |||
SEC BRIDGE GL (Securities Bridge GL – Settlement) | UNACCRD_DISCNT (Unaccrued Discount Amount) | Credit | |||
DEAL_DISCOUNT (Deal Discount GL) | SEC_DISC_TOTACCR (Total Discount Accrued on Sold Units) | Debit | |||
SEC DISC TBACRD (Sec. Deal Discount To Be Accrued GL) | SEC_DISC_TOTACCR (Total Discount Accrued on Sold Units) | Credit | |||
ACCR_DIS_IN_MEM (Accrual of Discount Income-Memo GL) | SEC_DISC_TOTACCR (Total Discount Accrued on Sold Units) | Debit | |||
SEC DISC EARNED (Sec. Discount Earned Income GL) | SEC_DISC_TOTACCR (Total Discount Accrued on Sold Units) | Credit | |||
For Premium | |||||
SEC BRIDGE GL (Securities Bridge GL – Settlement) | UNACCRD_PREMIUM (Unaccrued Premium Amount) | Debit | |||
DEAL_PREMIUM (Deal Premium GL) | UNACCRD_PREMIUM (Unaccrued Premium Amount) | Credit | |||
SEC PREM TBACRD (Sec. Deal Premium To Be Accrued GL) | SEC_PREM_TOTACCR (Total Premium Accrued on Sold Units) | Debit | |||
DEAL_PREMIUM (Deal Premium GL) | SEC_PREM_TOTACCR (Total Premium Accrued on Sold Units) | Credit | |||
SEC PREM PAID (Sec. Premium Paid Expense GL) | SEC_PREM_TOTACCR (Total Premium Accrued on Sold Units) | Debit | |||
ACCR_PRM_XP_MEM (Accrual of Premium Expense-Memo GL) | SEC_PREM_TOTACCR (Total Premium Accrued on Sold Units) | Credit |
Note
If Interest / discount / premium has been accrued during the previous year, the entries will have the amount tags with suffix “_PY” to indicate that they are passed against the Previous Year Adjustment GL. During accounting, for the amount tags with suffix “_PY”, accounting entries are passed against the Previous Year Adjustment GL, maintained in the Chart of Accounts.
Accounting Role | Amount Tag | Debit / Credit Indicator | |||
---|---|---|---|---|---|
For Interest | |||||
SEC-BRIDGE-SEL (Security Bridge GL – SALE) | INTCOMP_PUADJ (This tag should be assigned the difference between Sold Interest and Interest Accrued) | Debit | |||
INTCOMP_OFF (Purchase Interest Offset GL) | INTCOMP_PUADJ (This tag should be assigned the difference between Sold Interest and Interest Accrued). | Credit | |||
INTCOMP_OFF (Purchase Interest Offset GL) | INTCOMP_PUCMA (Purchase Interest) | Debit | |||
INTCOMP_BOT (Deal Purchase Interest) | INTCOMP_PUCMA (Purchase Interest) | Credit | |||
SEC-BRIDGE-SEL (Security Bridge GL – SALE) | INTCOMP_TIAC (Interest Accrued) | Debit | |||
INTCOMP_RCPY (Interest Receivable / Payable) | INTCOMP_TIAC | Credit | |||
INTCOMP_IMEM (Interest Income – Memo GL) | INTCOMP_TIAC_PY (Interest Accrued - Previous Year’s contribution) | Debit | |||
INTCOMP_I (Interest Income) | INTCOMP_TIAC_PY | Credit | |||
INTCOMP_IMEM (Interest Income – Memo GL) | INTCOMP_TIAC_CY (Interest Accrued - Current Year’s contribution) | Debit | |||
INTCOMP_I (Interest Income) | INTCOMP_TIAC_CY | Credit | |||
For Discount | |||||
DEAL_DISCOUNT (Deal Discount GL) | UNACCRD_DISCNT (Unaccrued Discount Amount) | Debit | |||
SEC BRIDGE GL (Securities Bridge GL – Settlement) | UNACCRD_DISCNT (Unaccrued Discount Amount) | Credit | |||
DEAL_DISCOUNT (Deal Discount GL) | SEC_DISC_TOTACCR (Total Discount Accrued on Sold Units) | Debit | |||
SEC DISC TBACRD (Sec. Deal Discount To Be Accrued GL) | SEC_DISC_TOTACCR | Credit | |||
ACCR_DIS_IN_MEM (Accrual of Discount Income-Memo GL) | SEC_DISC_TOTACCR_PY (Total Discount Accrued on Sold Units ( Previous Year’s Contribution ) | Debit | |||
SEC DISC EARNED (Sec. Discount Earned Income GL) | SEC_DISC_TOTACCR_PY (Total Discount Accrued on Sold Units) | Credit | |||
ACCR_DIS_IN_MEM (Accrual of Discount Income-Memo GL) | SEC_DISC_TOTACCR_CY (Total Discount Accrued on Sold Units - Current Year’s Contribution ) | Debit | |||
SEC DISC EARNED (Sec. Discount Earned Income GL) | SEC_DISC_TOTACCR_CY (Total Discount Accrued on Sold Units – Current Years Contribution) | Credit | |||
For Premium | |||||
SEC BRIDGE GL (Securities Bridge GL – Settlement) | UNACCRD_PREMIUM (Unaccrued Premium Amount) | Debit | |||
DEAL_PREMIUM (Deal Premium GL) | UNACCRD_PREMIUM (Unaccrued Premium Amount) | Credit | |||
SEC PREM TBACRD (Sec. Deal Premium To Be Accrued GL) | SEC_PREM_TOTACCR (Total Premium Accrued on Sold Units) | Debit | |||
DEAL_PREMIUM (Deal Premium GL) | SEC_PREM_TOTACCR (Total Premium Accrued on Sold Units) | Credit | |||
SEC PREM PAID (Sec. Premium Paid Expense GL) | SEC_PREM_TOTACCR_PY (Total Premium Accrued on Sold Units - Previous Year’s Contribution) | Debit | |||
ACCR_PRM_XP_MEM (Accrual of Premium Expense-Memo GL) | SEC_PREM_TOTACCR_PY (Total Premium Accrued on Sold Units - Previous Year’s Contribution) | Credit | |||
SEC PREM PAID - Sec. (Premium Paid Expense GL) | SEC_PREM_TOTACCR_CY (Total Premium Accrued on Sold Units - Current Year’s Contribution) | Debit | |||
ACCR_PRM_XP_MEM (Accrual of Premium Expense-Memo GL) | SEC_PREM_TOTACCR_CY (Total Premium Accrued on Sold Units - Current Year’s Contribution) | Credit |
When Wipe Deal Purchase Interest is set to Sale, the accounting entries pertaining to Purchase Interest are as follows:
Accounting Role and Description | Amount Tag and Description | Debit/Credit Indicator | |||
---|---|---|---|---|---|
SEC-BRIDGE-SEL (Security Bridge GL – SALE) | INTCOMP_PUCMA (Sold Interest – Interest Accrued) | Debit | |||
INTCOMP_BOT (Deal Purchase Interest) | INTCOMP_PUCMA (also = Purchased Interest) | Credit | |||
SEC-BRIDGE-SEL (Security Bridge GL – SALE) | INTCOMP_TIAC (Interest Accrued) | Debit | |||
INTCOMP_RCPY (Interest Receivable / Payable) | INTCOMP_TIAC (Interest Accrued) | Credit | |||
INTCOMP_IMEM | INTCOMP_TIAC (Interest Accrued) | Debit | |||
INTCOMP_I | INTCOMP_TIAC - Interest Accrued | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Debit | |||
SEC LIABILTY GL | DEAL_DISCNT_AMT | Credit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Credit | |||
SEC LIABILTY GL | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Credit | |||
SEC LIABILTY GL | DEAL_PREMIUMAMT | Debit | |||
SEC BRIDGE GL | FWD_DEAL_LOSS | Credit | |||
SEC LIABILTY GL | FWD_DEAL_LOSS | Debit | |||
SEC BRIDGE GL | FWD_DEAL_PROFIT | Debit | |||
SEC LIABILTY GL | FWD_DEAL_PROFIT | Credit | |||
SEC RLZD LOSS | REALIZED_LOSS | Debit | |||
SEC BRIDGE GL | REALIZED_PROFIT | Debit | |||
SEC RLZD PROFIT | REALIZED_PROFIT | Credit | |||
SEC BRIDGE GL | RGHT_INTR_VALUE | Debit | |||
SEC LIABILTY GL | RGHT_INTR_VALUE | Credit | |||
SEC BRIDGE GL | SE_FL_INT_PUCM | Credit | |||
SE_FL_INT_RCPY | SE_FL_INT_PUCM | Debit | |||
SEC BRIDGE GL | SE_FL_INT_PUEX | Debit | |||
SE_FL_INT_RAPA | SE_FL_INT_PUEX | Credit | |||
SEC BRIDGE GL | SE_FX_INT_PUCM | Credit | |||
SE_FX_INT_RCPY | SE_FX_INT_PUCM | Debit | |||
SEC BRIDGE GL | SE_FX_INT_PUEX | Debit | |||
SE_FX_INT_RAPA | SE_FX_INT_PUEX | Credit | |||
SEC BRIDGE GL | UNACCRD_DISCNT | Debit | |||
SEC LIABILTY GL | UNACCRD_DISCNT | Credit | |||
SEC BRIDGE GL | UNACCRD_PREMIUM | Credit | |||
SEC LIABILTY GL | UNACCRD_PREMIUM | Debit | |||
SEC BRIDGE GL | WARR_INTR_VALUE | Debit | |||
SEC LIABILTY GL | WARR_INTR_VALUE | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Credit | |||
SEC LIABILTY GL | DEAL_DISCNT_AMT | Debit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Debit | |||
SEC LIABILTY GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Debit | |||
SEC LIABILTY GL | DEAL_PREMIUMAMT | Credit | |||
SEC BRIDGE GL | FWD_DEAL_LOSS | Credit | |||
SEC LIABILTY GL | FWD_DEAL_LOSS | Debit | |||
SEC BRIDGE GL | FWD_DEAL_PROFIT | Debit | |||
SEC LIABILTY GL | FWD_DEAL_PROFIT | Credit | |||
SEC BRIDGE GL | SE_FL_INT_SOCM | Debit | |||
SE_FL_INT_RCPY | SE_FL_INT_SOCM | Credit | |||
SEC BRIDGE GL | SE_FL_INT_SOEX | Credit | |||
SE_FL_INT_RAPA | SE_FL_INT_SOEX | Debit | |||
SEC BRIDGE GL | SE_FX_INT_SOCM | Debit | |||
SE_FX_INT_RCPY | SE_FX_INT_SOCM | Credit | |||
SEC BRIDGE GL | SE_FX_INT_SOEX | Credit | |||
SE_FX_INT_RAPA | SE_FX_INT_SOEX | Debit | |||
SEC DISC TBACRD | BROK_DISC | Debit | |||
SEC BRIDGE GL | BROK_DISC | Credit | |||
SEC BRIDGE GL | DR_CHG_DISC | Debit | |||
SEC PREM TBACRD | DR_CHG_DISC | Credit | |||
SEC DISC TBACRD | CR_CHG_PREM | Debit | |||
SEC BRIDGE GL | CR_CHG_PREM | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC FWD LOSS | FWD_DEALEXP_ACR | Debit | |||
SEC FWDEXP OFST | FWD_DEALEXP_ACR | Credit | |||
SEC FWD PROFIT | FWD_DEALINC_ACR | Credit | |||
SEC FWDINC OFST | FWD_DEALINC_ACR | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC DISC EARNED | SEC_DISC_ACCR | Credit | |||
SEC DISC TBACRD | SEC_DISC_ACCR | Debit |
Given below is the sample accounting entries that will be posted if you use the alternative accounting roles for this event:
Accounting Roles | Standard/ Alternative |
Amount Tags | Standard/ Alternative |
Dr./Cr. Indicator | |||||
---|---|---|---|---|---|---|---|---|---|
* Discount Accrued * (Discount TBACRD can be us |
Standard | SEC_DISC_ACCR | Standard | Debit | |||||
Accrual of Disct Inc – Memo | Alternative | SEC_DISC_ACCR | Standard | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC PREM PAID | SEC_PREM_ACCR | Debit | |||
SEC PREM TBACRD | SEC_PREM_ACCR | Credit |
Given below is the sample accounting entries that will be posted if you use the alternative accounting roles for this event:
Accounting Roles | Standard/ Alternative |
Amount Tags | Standard/ Alternative |
Dr./Cr. Indicator | ||||||
---|---|---|---|---|---|---|---|---|---|---|
Accrual of Prem Exp - Memo | Alternative | SEC_PREM_ACCR | Standard | Debit | ||||||
* Premium Accrued | * (Premium TBACRD can be used) | Standard | SEC_PREM_ACCR | Standard | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC RDPREM ERND | SEC_RDPREM_ACCR | Credit | |||
SEC RDPREM RECV | SEC_RDPREM_ACCR | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC DIVDND PAY | SEC_CASH_DIVDND | Credit | |||
SEC DIVDND RECV | SEC_CASH_DIVDND | Debit |
Advices
Nil
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC DIVDND RECV | SEC_CASH_DIVDND | Credit | |||
SEC SETTLEMENT | SEC_CASH_DIVDND | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC DIVDND PAY | SEC_CASH_DIVDND | Debit | |||
SEC SETTLEMENT | SEC_CASH_DIVDND | Credit |
Advices
Nil.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
RIGHTS ASSET GL | RGHT_INTR_VALUE | Debit | |||
SEC BRIDGE GL | RGHT_INTR_VALUE | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC ASSET GL | RGHT_INTR_VALUE | Credit | |||
SEC BRIDGE GL | RGHT_INTR_VALUE | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | SEC BRIDGE GL | Credit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Debit | |||
RIGHTS ASSET GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Debit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Credit | |||
RES SEC. ASSET | RGHT_INTR_VALUE | Debit | |||
RIGHTS ASSET GL | RGHT_INTR_VALUE | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Debit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Credit | |||
RES SEC. ASSET | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Credit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Credit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Debit | |||
RIGHTS ASSET GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Debit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Credit | |||
RIGHTS ASSET GL | RGHT_INTR_VALUE | Credit | |||
SEC RLZD LOSS | RGHT_INTR_VALUE | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | WARR_INTR_VALUE | Credit | |||
WARRS ASSET GL | WARR_INTR_VALUE | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC ASSET GL | WARR_INTR_VALUE | Credit | |||
SEC BRIDGE GL | WARR_INTR_VALUE | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Credit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Debit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Debit | |||
WARRS ASSET GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Debit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Credit | |||
RES SEC. ASSET | WARR_INTR_VALUE | Debit | |||
WARRS ASSET GL | WARR_INTR_VALUE | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Debit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Credit | |||
RES SEC. ASSET | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Credit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Credit | |||
SEC DISC TBACRD | DEAL_DISCNT_AMT | Debit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Debit | |||
WARRS ASSET GL | DEAL_NOMINALAMT | Credit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Debit | |||
SEC PREM TBACRD | DEAL_PREMIUMAMT | Credit | |||
SEC RLZD LOSS | WARR_INTR_VALUE | Debit | |||
WARRS ASSET GL | WARRS ASSET GL | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SE_FL_INT_IC | SE_FL_INT_IAC | Credit | |||
SE_FL_INT_RCPY | SE_FL_INT_IAC | Debit | |||
SE_FL_INT_IX | SE_FL_INT_IAX | Credit | |||
SE_FL_INT_RAPA | SE_FL_INT_IAX | Debit | |||
SE_FL_INT_AJI | SE_FL_INT_JIA | Credit | |||
SE_FL_INT_RCPY | SE_FL_INT_JIA | Debit | |||
SE_FX_INT_IC | SE_FX_INT_IAC | Credit | |||
SE_FX_INT_RCPY | SE_FX_INT_IAC | Debit | |||
SE_FX_INT_IX | SE_FX_INT_IAX | Credit | |||
SE_FX_INT_RAPA | SE_FX_INT_IAX | Debit | |||
SE_FX_INT_AJI | SE_FX_INT_JIA | Credit | |||
SE_FX_INT_RCPY | SE_FX_INT_JIA | Debit |
Given below is the sample accounting entries that will be posted if you use the alternative accounting roles for this event:
Accounting Roles | Standard/ Alternative |
Amount Tags | Standard/ Alternative |
Dr./Cr. Indicator | |||||
---|---|---|---|---|---|---|---|---|---|
* Accrual of Int. Rec
(RCPY) *(Intcomp_RCPY can be used) |
Standard | INTCOMP_IA | Standard | Debit | |||||
Accrual of Int. Inc - Memo | Alternative | INTCOMP_IA | Standard | Credit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC COUPON PAY | SE_FL_INT_IINI | Credit | |||
SEC COUPON RECV | SE_FL_INT_IINI | Debit | |||
SEC COUPON PAY | SE_FX_INT_IINI | Credit | |||
SEC COUPON RECV | SE_FX_INT_IINI | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC COUPON RECV | SE_FL_INT_ICOL | Credit | |||
SEC SETTLEMENT | SE_FL_INT_ICOL | Debit | |||
SEC COUPON RECV | SE_FX_INT_ICOL | Credit | |||
SEC SETTLEMENT | SE_FX_INT_ICOL | Debit |
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC COUPON PAY | SE_FL_INT_ILIQ | Debit | |||
SE_FL_INT_RCPY | SE_FL_INT_ILIQ | Credit | |||
SEC COUPON PAY | SE_FX_INT_ILIQ | Debit | |||
SE_FX_INT_RCPY | SE_FX_INT_ILIQ | Credit |
Given below is the sample accounting entries that will be posted if you use the alternative accounting roles for this event:
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC COUPON PAY | SE_FX_INT_ILIQ | Debit | |||
SE_FX_INT_RCPY | SE_FX_INT_ILIQ | Credit | |||
SE_FX_INT_IMEM | SE_FX_INT_TIAC | Debit | |||
SE_FX_INT_I | SE_FX_INT_TIAC | Credit | |||
SE_FX_INT_RCPY | SE_FX_INT_PUCMA | Debit | |||
SE_FX_INT_BOT | SE_FX_INT_PUCMA | Credit |
You will need to maintain the following accounting entry set-up when a securities contract is liquidated with previous year adjustment option.
Debit / Credit Indicator | Accounting Role | Amount Tag | |||
---|---|---|---|---|---|
Debit | SEC COUPON PAY - Securities Coupon Payable GL | INTCOMP_PUCMA - Purchase Interest | |||
Credit | INTCOMP_BOT - Deal Purchase Interest | INTCOMP_PUCMA - Purchase Interest | |||
Debit | SEC COUPON PAY - Securities Coupon Payable GL | INTCOMP_TIAC - Interest Accrued | |||
Credit | INTCOMP_RCPY - Interest Receivable / Payable. | INTCOMP_TIAC - Interest Accrued | |||
Debit | INTCOMP_IMEM - Interest Income – Memo | INTCOMP_TIAC - Interest Accrued | |||
Credit | INTCOMP_I - Interest Income | INTCOMP_TIAC - Interest Accrued |
Note
If Interest / discount / premium has been accrued during the previous year, the entries will have the amount tags with suffix “_PY” to indicate that they are passed against the Previous Year Adjustment GL. During accounting, for the amount tags with suffix “_PY”, accounting entries are passed against the Previous Year Adjustment GL, maintained in the Chart of Accounts.
Accounting Role | Amount Tag | Debit / Credit Indicator | |||
---|---|---|---|---|---|
SEC COUPON PAY - Securities Coupon Payable GL | INTCOMP_PUCMA - Coupon Amount – Interest Accrued | Debit | |||
INTCOMP_OFF- Purchase Interest Offset GL | INTCOMP_PUCMA - Coupon Amount – Interest Accrued | Credit | |||
SEC COUPON PAY - Securities Coupon Payable GL | INTCOMP_TIAC - Interest Accrued | Debit | |||
INTCOMP_RCPY - Interest Receivable / Payable | INTCOMP_TIAC - Interest Accrued | Credit | |||
INTCOMP_IMEM - Interest Income – Memo GL | INTCOMP_TIAC_PY - Interest Accrued (Previous Year’s contribution) | Debit | |||
INTCOMP_I - Interest Income | INTCOMP_TIAC_PY - Interest Accrued (Previous Year’s contribution) | Credit | |||
INTCOMP_IMEM - Interest Income – Memo GL | INTCOMP_TIAC_CY - Interest Accrued (Current Year’s contribution) | Debit | |||
INTCOMP_I - Interest Income | INTCOMP_TIAC_CY - Interest Accrued (Current Year’s contribution) | Credit |
When Wipe Deal Purchase Interest is set to Sale, the accounting entries pertaining to Purchase Interest are as follows:
Accounting Role and Description | Amount Tag and Description | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC COUPON PAY - SE Coupon Payable GL | INTCOMP_PUCMA - Purchased Interest | Debit | |||
INTCOMP_BOT - Deal Purchase Interest | INTCOMP_PUCMA | Credit | |||
SEC COUPON PAY - SE Coupon Payable GL | INTCOMP_TIAC - Interest Accrued – Cum | Debit | |||
INTCOMP_RCPY - Interest Receivable / Payable | INTCOMP_TIAC | Credit | |||
INTCOMP_IMEM - Interest Income – Memo | INTCOMP_TIAC - Interest Accrued | Debit | |||
INTCOMP_I - Interest Income | INTCOMP_TIAC | Credit |
Advices
Nil.
(For Realized Revaluation, the amount tags should be replaced with the equivalent tags for Realized Revaluation)
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
LOCOM_REVAL_EXP | LOCOM_REVAL_EXP | Debit | |||
LOCOM_REVAL_LBY | LOCOM_REVAL_EXP | Credit | |||
MTM_EXP | MTM_EXP | Debit | |||
MTM_LBY | MTM_EXP | Credit | |||
MTM_ASS | MTM_INC | Debit | |||
MTM_INC | MTM_INC | Credit |
If you have chosen Deal level revaluation the following entries are passed:
Accounting Role and Description | Amount Tag and Description | Debit/ Credit | |||
---|---|---|---|---|---|
MTM_EXP - Expense GL for Revaluation (MTM Method) | MTM_EXP - Revaluation Expense (MTM Method). | Debit | |||
MTM_LBY - Liability GL for Revaluation (MTM Method). | MTM_EXP - Revaluation Expense (MTM Method). | Credit | |||
MTM_ASS - Asset GL for Revaluation (MTM Method). | MTM_INC - Revaluation Income (MTM Method). | Debit | |||
MTM_INC - Income GL for Revaluation (MTM Method). | MTM_INC - Revaluation Income (MTM Method). | Credit | |||
LOCOM_REVAL_EXP - Expense GL for Revaluation (LOCOM Method). | LOCOM_REVAL_EXP - Revaluation Expense (LOCOM Method). | Debit | |||
LOCOM_REVAL_LBY - Liability GL for Revaluation (LOCOM Method). | LOCOM_REVAL_EXP - Revaluation Expense (LOCOM Method). | Credit |
Advices
No advices allowed for this event.
These entries can be set up for any kind of portfolio costing method and they apply to both deal and position level revaluation.
Accounting Role and Description | Amount Tag and Description | Debit/ Credit | |||
---|---|---|---|---|---|
MTMINCOME | MTM_INC | Debit | |||
SECURITYASSET | MTM_INC | Credit |
These are the entries passed during reversal of revaluation at BOD on the next working day. If the next working day happens to be the first working day of the new financial year the entries passed are:
Accounting Role and Description | Amount Tag and Description | Debit/ Credit | |||
---|---|---|---|---|---|
Prev year adj GL –1 | MTM_INC_PY | Debit | |||
SECURITYASSET | MTM_INC_PY | Credit |
Where Prev year adj GL –1 is the previous year adjustment GL maintained in the Chart of Accounts for the GL head MTM_INC.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC PREM EARNED | SEC_PREM_ACCR | Debit | |||
SEC PREM TBACRD | SEC_PREM_ACCR | Credit | |||
SEC INT ADJ REC | SEC_INTADJ_ACCR | Debit | |||
SEC INT ADJ INC | SEC_INTADJ_ACCR | Credit | |||
SEC DISC TBACRD | SEC_DISC_ACCR | Debit | |||
SEC DISC EARNED | SEC_DISC_ACCR | Credit |
Advices
No advices allowed for this event.
The preferences set for this product are as follows:
Accounting Entries
If brokerage is considered for Assets, the following accounting entries are passed:
Accounting Role | Amount Tag | Dr/Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | BROK_PREM | Debit | |||
BROKPAY | BROK_PREM | Credit |
If brokerage is considered for Liabilities, the following accounting entries are passed:
Accounting Role | Amount Tag | Dr/Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | BROK_DISC | Debit | |||
BROKPAY | BROK_DISC | Credit |
Note
For Brokerage marked as ‘Consider as Discount’ and denominated in a brokerage currency other than the contract currency, the %DISC and %PREM amount tags will be posted into the Bridge Head in the contract currency.
If a particular charge component is considered for discount for Assets, the following accounting entries are passed:
Accounting Role | Amount Tag | Dr/Cr. Indicator | |||
---|---|---|---|---|---|
SEC SETTLEMENT | <Charge Class>_DISC | Debit | |||
SEC BRIDGE GL | <Charge Class>_DISC | Credit | |||
SEC BRIDGE GL | <Charge Class>_PREM | Debit | |||
SEC SETTLEMENT | <Charge Class>_PREM | Credit |
Note
For charge components marked as ‘Consider as Discount’ and denominated in a charge currency other than the contract currency, the %DISC and %PREM amount tags will be posted into the SEC BRIDGE GL head in the contract currency.
Advices
Nil.
Accounting Entries
Nil
Advices
No advices allowed for this product.
Accounting Entries
Nil
Advices
No advices allowed for this product.
Accounting Entries
No accounting entries allowed for this event.
Advices
Nil.
Accounting Entries
No accounting entries allowed for this event.
Advices
Nil.
Accounting Entries
No accounting entries allowed for this event.
Advices
Nil.
Accounting Entries
Nil.
Advices
No advices allowed for this event.
Accounting Entries
Nil.
Advices
No advices allowed for this event.
Accounting Entries
Accounting Role | Amount Tag | Dr./Cr. Indicator | |||
---|---|---|---|---|---|
SEC BRIDGE GL | DEAL_DISCNT_AMT | Debit | |||
SEC SETTLEMENT | DEAL_DISCNT_AMT | Credit | |||
SEC BRIDGE GL | DEAL_NOMINALAMT | Credit | |||
SEC SETTLEMENT | DEAL_NOMINALAMT | Debit | |||
SEC BRIDGE GL | DEAL_PREMIUMAMT | Credit | |||
SEC SETTLEMENT | DEAL_PREMIUMAMT | Debit | |||
SEC BRIDGE GL | FWD_DEAL_LOSS | Credit | |||
SEC SETTLEMENT | FWD_DEAL_LOSS | Debit | |||
SEC BRIDGE GL | FWD_DEAL_PROFIT | Debit | |||
SEC SETTLEMENT | FWD_DEAL_PROFIT | Credit | |||
SEC BRIDGE GL | INT_GS_PUCM | Credit | |||
SEC SETTLEMENT | INT_GS_PUCM | Debit | |||
SEC SETTLEMENT | INT_GS_PUEX | Credit | |||
SEC BRIDGE GL | INT_GS_PUEX | Debit | |||
SEC BRIDGE GL | INT_IC_PUCM | Debit | |||
SEC SETTLEMENT | INT_IC_PUCM | Credit | |||
SEC SETTLEMENT | INT_IC_PUEX | Debit | |||
SEC BRIDGE GL | INT_IC_PUEX | Credit | |||
SEC SETTLEMENT | ISSUR_TAX_PUCM | Debit | |||
SEC BRIDGE GL | ISSUR_TAX_PUCM | Credit | |||
SEC SETTLEMENT | ISSUR_TAX_PUEX | Credit | |||
SEC BRIDGE GL | ISSUR_TAX_PUEX | Debit |
Advices
Nil.
Accounting Entries
No accounting entries are allowed for this event.
Advices
Nil.
Accounting Entries
Nil.
Advices
No advices allowed for this event.
Accounting Entries
No accounting entries allowed for this event.
Advices
No advices allowed for this event.
Accounting Entries
No accounting entries allowed for this event.
Advices
Nil
Accounting Entries
No accounting entries allowed for this event.
Advices
Nil