32. Annexure A - Accounting Entries and Advices

32.1 Accounting Entries for Securities Module

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:

32.2 Securities Events

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:

32.2.1 Portfolio Type of Products

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

32.2.2 Customer Buy/Sell Type of Products

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.

32.3 Amount Tags

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 ‘Acquisi­tion 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 secu­rities. 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.

32.4 Accounting Roles

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:

32.4.1 List I – Acct Roles for a Portfolio Type of Product

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 compo­nent 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 Pur­chase 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 in­come/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.

32.4.2 List 2 – Acct Roles for a Customer Buy/Sell Type of Product

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 prod­uct. 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 Confir­mation Affir­mation

MT 517

Trade Instructing Party

Trade Executing Party

 

 

 

Buyer

Trade Counter­party

MKT TRADE CONF

Market-Side Trade Confir­mation

MT 518

Trade Executing Party

Trade Counter­party

RECV SEC FREE

Receive Free

MT 520/MT540

Custody/Portfolio Customer

Custodian

 

 

 

Custodian

Safekeeping Loca­tion

DLVR SEC FREE

Deliver Free

MT 522/MT542

Custody/Portfolio Customer

Custodian

 

 

 

Custodian

Safekeeping Loca­tion

DLVR SEC APMT

Deliver Against Pay­ment

MT 523/MT543

Custody/Portfolio Customer

Custodian

 

 

 

Custodian

Safekeeping Loca­tion

RECV SEC APMT

Received against pay­ment

MT 521/ MT 541

Custody/Portfolio Customer

Custodian

 

 

 

Custodian

Safekeeping Loca­tion

RECV FREE CONF

Receive Free Confirmation

MT 530

Safekeeping Loca­tion

Custodian

 

 

 

Custodian

Custody/Portfolio Customer

RECV APMT CONF

Receive Against Pay­ment Confir­mation

MT 531

Safekeeping Loca­tion

Custodian

 

 

 

Custodian

Custody/Portfolio Customer

DLVR FREE CONF

Deliver Free Confirmation

MT 532

Safekeeping Loca­tion

Custodian

 

 

 

Custodian

Custody/Portfolio Customer

DLVR FREE APMT

Deliver Against Pay­ment Confir­mation

MT 533

Safekeeping Loca­tion

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 RED­MPTN ADV

Advice of Redemption

MT 556

Custodian

Custody/Portfolio Customer

REQST FOR STMT

Request for Statement

MT 570

Custody/Portfolio Customer

Custodian

 

 

 

Custodian

Safekeeping Loca­tion

SEC HLD STATMNT

Statement of Holdings

MT 571

Custodian

Portfolio Customer

 

 

 

Safekeeping Loca­tion

Custodian

SEC TXN STATMNT

Statement of Transactions

MT 572

Custodian

Portfolio Customer

 

 

 

Safekeeping Loca­tion

Custodian

PNDING TXN STMT

Statement of Pending Transactions

MT 573

Custodian

Portfolio Customer

 

 

 

Safekeeping Loca­tion

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:

32.4.3 SS Deal with a Portfolio Type Of Product: Bank Portfolio

The preferences set up for a Bank Portfolio type of products are as follows:

32.4.3.1 SPLP: Security Purchase from Long Position

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.

32.4.3.2 SSLP: Security Sale from Long Position

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 secu­rities

Alternative

Debit

Deal Interest-Bought (INT­COMP_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) (INT­COMP_RCPY)

Standard

INTCOMP_TIAC

Alternative

Credit

Accrual of Int. Inc – Memo (INTCOMP_I­MEM)

Alternative

INTCOMP_TIAC

Alternative

Debit

Interest Income (INT­COMP_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_TOTA­LACCR

Alternative

Debit

Deal Pre­mium

Alternative

SEC_PREM_TOTA­LACCR

Alternative

Credit

Premium Expense

Standard

SEC_PREM_TOTA­LACCR

Alternative

Debit

Accrual of Prem Exp - Memo

Alternative

SEC_PREM_TOTA­LACCR

Alternative

Credit

Deal Dis­count

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 Inter­est)

Debit

INTCOMP_BOT (Deal Pur­chase Interest)

INTCOMP_PUCMA (Purchase Inter­est)

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 Dis­count Accrued on Sold Units)

Debit

SEC DISC TBACRD (Sec. Deal Discount To Be Accrued GL)

SEC_DISC_TOTACCR (Total Dis­count Accrued on Sold Units)

Credit

ACCR_DIS_IN_MEM (Accrual of Discount Income-Memo GL)

SEC_DISC_TOTACCR (Total Dis­count Accrued on Sold Units)

Debit

SEC DISC EARNED (Sec. Discount Earned Income GL)

SEC_DISC_TOTACCR (Total Dis­count Accrued on Sold Units)

Credit

For Premium

 

 

SEC BRIDGE GL (Securities Bridge GL – Settlement)

UNACCRD_PREMIUM (Unaccrued Premium Amount)

Debit

DEAL_PREMIUM (Deal Pre­mium GL)

UNACCRD_PREMIUM (Unaccrued Premium Amount)

Credit

SEC PREM TBACRD (Sec. Deal Premium To Be Accrued GL)

SEC_PREM_TOTACCR (Total Pre­mium Accrued on Sold Units)

Debit

DEAL_PREMIUM (Deal Pre­mium GL)

SEC_PREM_TOTACCR (Total Pre­mium Accrued on Sold Units)

Credit

SEC PREM PAID (Sec. Pre­mium Paid Expense GL)

SEC_PREM_TOTACCR (Total Pre­mium Accrued on Sold Units)

Debit

ACCR_PRM_XP_MEM (Accrual of Premium Expense-Memo GL)

SEC_PREM_TOTACCR (Total Pre­mium 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 Previ­ous Year Adjustment GL. During accounting, for the amount tags with suffix “_PY”, ac­counting 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 (Pur­chase Interest Offset GL)

INTCOMP_PUADJ (This tag should be assigned the difference between Sold Interest and Interest Accrued).

Credit

INTCOMP_OFF (Pur­chase 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 - Pre­vious Year’s contribution)

Debit

INTCOMP_I (Interest Income)

INTCOMP_TIAC_PY

Credit

INTCOMP_IMEM (Interest Income – Memo GL)

INTCOMP_TIAC_CY (Interest Accrued - Cur­rent 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 Con­tribution )

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 Con­tribution )

Debit

SEC DISC EARNED (Sec. Discount Earned Income GL)

SEC_DISC_TOTACCR_CY (Total Discount Accrued on Sold Units – Current Years Con­tribution)

Credit

For Premium

 

 

SEC BRIDGE GL (Securities Bridge GL – Settlement)

UNACCRD_PREMIUM (Unaccrued Pre­mium Amount)

Debit

DEAL_PREMIUM (Deal Premium GL)

UNACCRD_PREMIUM (Unaccrued Pre­mium 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 Con­tribution)

Debit

ACCR_PRM_X­P_MEM (Accrual of Premium Expense-Memo GL)

SEC_PREM_TOTACCR_PY (Total Premium Accrued on Sold Units - Previous Year’s Con­tribution)

Credit

SEC PREM PAID - Sec. (Premium Paid Expense GL)

SEC_PREM_TOTACCR_CY (Total Premium Accrued on Sold Units - Current Year’s Con­tribution)

Debit

ACCR_PRM_X­P_MEM (Accrual of Premium Expense-Memo GL)

SEC_PREM_TOTACCR_CY (Total Premium Accrued on Sold Units - Current Year’s Con­tribution)

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 Pur­chase Interest)

INTCOMP_PUCMA (also = Pur­chased 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.

32.4.3.3 SPSP: Security Purchase from Short Position

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.

32.4.3.4 SSSP: Security Sale from Short Position

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.

32.4.3.5 FACR: Security Forward Deal P & L Accrual

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.

32.4.3.6 ACRD: Accrual of Security Discount Earned

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_DIS­C_ACCR

Standard

Debit

Accrual of Disct Inc – Memo

Alternative

SEC_DIS­C_ACCR

Standard

Credit

Advices

No advices allowed for this event.

32.4.3.7 ACRP: Accrual of Security Premium Paid

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.

32.4.3.8 ACRR: Accrual of Redemption Premium Earned

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.

32.4.3.9 DVIN: Securities Dividend Initiation

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

32.4.3.10 DVCD: Securities Dividend Collection

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.

32.4.3.11 DVLQ: Securities Dividend Liquidation

Accounting Entries

Accounting Role

Amount Tag

Dr./Cr. Indicator

SEC DIVDND PAY

SEC_CASH_DIVDND

Debit

SEC SETTLEMENT

SEC_CASH_DIVDND

Credit

Advices

Nil.

32.4.3.12 RGLL: Rights Security Tear-Off Processing

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.

32.4.3.13 RGOL: Rights Detachment from Parent Security

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.

32.4.3.14 RELL: Exercise of Rights for New Equity

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.

32.4.3.15 RENL: Rights Security Exercise Processing

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.

32.4.3.16 RXLL: Expiry of Un-Exercised Rights

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.

32.4.3.17 WRLL: Warrants Security Tear-Off Processing

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.

32.4.3.18 WROL: Warrant Detachment from Parent Security

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.

32.4.3.19 WELL: Warrants Security Exercise Processing

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.

32.4.3.20 WENL: Exercise of Warrants for New Equity

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.

32.4.3.21 WXLL: Expiry of Un-Exercised Warrants

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.

32.4.3.22 IACR: Securities Coupon Interest Accrual

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

INT­COMP_IA

Standard

Debit

Accrual of Int. Inc - Memo

Alternative

INT­COMP_IA

Standard

Credit

Advices

No advices allowed for this event.

32.4.3.23 CPIN: Coupon Init

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.

32.4.3.24 CPCD: Coupon Init

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.

32.4.3.25 CPLQ: Coupon Liquidation

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 Cou­pon Payable GL

INTCOMP_PUCMA - Pur­chase Interest

Credit

INTCOMP_BOT - Deal Purchase Interest

INTCOMP_PUCMA - Pur­chase Interest

Debit

SEC COUPON PAY - Securities Cou­pon Payable GL

INTCOMP_TIAC - Interest Accrued

Credit

INTCOMP_RCPY - Interest Receiva­ble / 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 Previ­ous Year Adjustment GL. During accounting, for the amount tags with suffix “_PY”, ac­counting 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 Inter­est 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 contri­bution)

Debit

INTCOMP_I - Interest Income

INTCOMP_TIAC_PY - Interest Accrued (Previous Year’s contri­bution)

Credit

INTCOMP_IMEM - Interest Income – Memo GL

INTCOMP_TIAC_CY - Interest Accrued (Current Year’s contribu­tion)

Debit

INTCOMP_I - Interest Income

INTCOMP_TIAC_CY - Interest Accrued (Current Year’s contribu­tion)

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 - Pur­chased 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 Receiv­able / Payable

INTCOMP_TIAC

Credit

INTCOMP_IMEM - Interest Income – Memo

INTCOMP_TIAC - Interest Accrued

Debit

INTCOMP_I - Interest Income

INTCOMP_TIAC

Credit

Advices

Nil.

32.4.3.26 BRVL: Securities Revaluation of Positions/Deals

(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 Revalua­tion (MTM Method)

MTM_EXP - Revaluation Expense (MTM Method).

Debit

MTM_LBY - Liability GL for Revalua­tion (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 Revalua­tion (MTM Method).

MTM_INC - Revaluation Income (MTM Method).

Credit

LOCOM_REVAL_EXP - Expense GL for Revaluation (LOCOM Method).

LOCOM_REVAL_EXP - Revalua­tion Expense (LOCOM Method).

Debit

LOCOM_REVAL_LBY - Liability GL for Revaluation (LOCOM Method).

LOCOM_REVAL_EXP - Revalua­tion Expense (LOCOM Method).

Credit

Advices

No advices allowed for this event.

32.4.3.27 RRVL: Reversal of Position and Deal level Revaluation

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.

32.4.3.28 YACR: Yield Accruals for all deals

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.

32.4.4 SS deal with a Customer Buy/Sell type of product

The preferences set for this product are as follows:

32.4.4.1 BOOK: Booking of securities deal

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 curren­cy 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.

32.4.4.2 AMND: Amendment of securities deal

Accounting Entries

Nil

Advices

No advices allowed for this product.

32.4.4.3 CANC: Cancellation of securities deal

Accounting Entries

Nil

Advices

No advices allowed for this product.

32.4.4.4 CCON: Counterparty confirmation

Accounting Entries

No accounting entries allowed for this event.

Advices

Nil.

32.4.4.5 DACF: Deliver Versus Payment Confirmation

Accounting Entries

No accounting entries allowed for this event.

Advices

Nil.

32.4.4.6 DFCF: Deliver Free Confirmation

Accounting Entries

No accounting entries allowed for this event.

Advices

Nil.

32.4.4.7 DSTL: Settlement of Securities Deal

Accounting Entries

Nil.

Advices

No advices allowed for this event.

32.4.4.8 EXTN: Extension of Deal Settlement Date

Accounting Entries

Nil.

Advices

No advices allowed for this event.

32.4.4.9 MSTL: Money Settlement of Securities Deal

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.

32.4.4.10 RACF: Receive Versus Payment Confirmation

Accounting Entries

No accounting entries are allowed for this event.

Advices

Nil.

32.4.4.11 RBLK: Release Block of Security Positions

Accounting Entries

Nil.

Advices

No advices allowed for this event.

32.4.4.12 REAS: Reassignment of Securities Deal

Accounting Entries

No accounting entries allowed for this event.

Advices

No advices allowed for this event.

32.4.4.13 REVR: Reversal of Securities Deal

Accounting Entries

No accounting entries allowed for this event.

Advices

Nil

32.4.4.14 RFCF: Receive Free Confirmation

Accounting Entries

No accounting entries allowed for this event.

Advices

Nil