This Annexure lists the suggested event-wise accounting entries that can be set up, for the Interest and Charge product applicable for the TD module of Oracle FLEXCUBE.
This chapter contains the following sections:
You need to set up the following events at the IC product for Deposit accounts:
Event Code |
Event Description |
DEBK |
Deposit Booking |
IACR |
Interest Accruals |
ILIQ |
Interest Liquidation |
IMAT |
Interest Maturity |
ROLL |
Discounted Deposit Rollover |
The following amount tags are available:
Amount Tags |
Description |
IACQUIRED |
Acquired Interest Amount |
IACR |
Interest Accrual |
IACR_ADJ |
Interest Accrual Adjustments |
ILIQ |
Interest Liquidation Amount |
ILIQ_ADJ |
Interest Liquidation Adjustments |
IMAT |
Interest Maturity |
PMAT |
Principal Maturity |
TAX |
Tax |
TAX_ADJ |
Tax Adjustment |
TD-PRINC |
Deposit Principal Amount |
TD_INT |
Advance Interest Paid |
Accounting roles are automatically defaulted by Oracle FLEXCUBE based on the IC Rule attached to the particular IC product. An accounting role could be accrual, P/L or tax payment. For creation of role type, standard abbreviations are used across Oracle FLEXCUBE.
The accounting role is created in the following format – ‘TDAA-<accounting role type>-<X>
Where:
If you have maintained more than one formula for a rule, the system will default accounting roles for each of your formulae.
For example, assume that the accounting role is ‘TDAB-ACCR-1’.
This role indicates the following:
Assume that the accounting role is ‘TDAB-PNL-2’
This role indicates the following:
The formula number is ‘2’. (for example debit interest posting against income GL defined for formula 2)
You should select the appropriate accounting role on the ’Role to Head Mapping‘ screen for every product.
‘TDAA-BOOK-X’ represents the settlement account where the amount is credited or debited against P/L account. This role cannot be attached to any GL on the ’Role to Head Mapping’ screen. It is used while maintaining event-wise accounting entries.
Sample accounting role for IC Rule ID like AP01 are given below:
The following list contains details of the advices that are applicable to the TDs you can process at your bank.
This section contains the following topics:
The following advices are sent to customers whenever there is a top-up on existing TDs:
Tag |
Description |
_BRANCH_ |
Code of the branch where TD is held |
_BRANCHNAME_ |
Name of the branch where TD is held |
_BRNADD1_ |
Branch address line 1 |
_BRNADD2_ |
Branch address line 2 |
_BRNADD3_ |
Branch address line 3 |
_TDACCNO_ |
TD Account Number |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address line 1 |
_ADD2_ |
Customer address line 2 |
_ADD2_ |
Customer address line 3 |
_ADD4_ |
Customer address line 4 |
_CCY_ |
Currency of Term Deposit |
_AMT_ |
Term deposit amount |
_VALDATE_ |
Value Date of Top-up |
_TOPAMT_ |
Top-up Amount |
_TOTAMT_ |
Total amount of the deposit = Amount + Top-up amount |
_NEWINTRATE_ |
New Interest Rate after Top-up |
_MATDATE_ |
Maturity Date |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving at Interest Rate |
The advice TD_TOPUP is generated on authorization of top-up.
The TD maturity date change advice, TD_MAT_ADJ, is generated if there is any adhoc change in the holiday calendar.
Tag |
Description |
_BRANCH_ |
Code of the branch where TD is held |
_BRANCHNAME_ |
Name of the branch where TD is held |
_BRNADD1_ |
Branch address line 1 |
_BRNADD2_ |
Branch address line 2 |
_BRNADD3_ |
Branch address line 3 |
_REF_ |
TD Account Number |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address line 1 |
_ADD2_ |
Customer address line 2 |
_ADD2_ |
Customer address line 3 |
_ADD4_ |
Customer address line 4 |
_CCY_ |
Currency of Term Deposit |
_AMT_ |
Term deposit amount |
_DEPTTENOR_ |
Term Deposit Tenor |
_ORGDEPTENOR_ |
Original tenor of deposit before holiday adjustment |
__DEPTTENORADJ_ |
Value ‘Y’ if tenor is adjusted due to holiday, else NULL. |
_MATDATE_ |
Maturity Date |
_ORGMATDATE_ |
Original maturity date of deposit before holiday adjustment |
_MATADJ_ |
Value ‘Y’ if Maturity Date Adjusted due to holiday, else NULL. |
_MATHOL_ |
Value ‘Y’ if maturity date is falling on a holiday, else NULL. |
This redemption advice will be generated only for term deposits with option ‘Redemption Advice Required’ checked at the product level. A message type ‘TD_REDM’ will be used:
Tag |
Description |
_BRANCH_ |
Branch code of the term deposit |
_REF_ |
TD account number |
_BRANCHNAME_ |
Branch name where term deposit is held |
_BRNADD1_ |
Branch address line 1 |
_BRNADD2_ |
Branch address line 2 |
_BRNADD3_ |
Branch address line 3 |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address line 1 |
_ADD2_ |
Customer address line 2 |
_ADD2_ |
Customer address line 3 |
_ADD4_ |
Customer address line 4 |
_CCY_ |
Currency of Term Deposit |
_AMT_ |
Term deposit amount |
_TOTREDMAMT_ |
Total Redemption amount |
_MATDATE_ |
Maturity Date |
_REDMDATE_ |
Redemption date |
_REDMBRANCH_ |
Redemption account branch |
_REDMACCOUNT_ |
Redemption account to |
_REDMNARRATIVE_ |
Redemption narrative |
_PAYOUTTYPE_ |
Pay out Type |
_PAYOUTPERCNT_ |
Payout Percentage |
_PAYOUTREDMAMT_ |
Payout Redemption amount |
_PENALTYDET_ |
Penalty details |
_MAKERID_ |
Teller name |
_TXNDATETIME_ |
Transaction date & time |
_ CERTNO_ |
Certificate numbers getting redeemed |
_ NOCERT_ |
Total number of certificates getting redeemed |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving at Interest Rate |
This rollover advice will be generated only for term deposits during rollover. A message type ‘TD_ROLL’ will be used:
Tag |
Description |
_BRANCHNAME_ |
Branch Name |
_BRNADD1_ |
Branch address line 1 |
_BRNADD2_ |
Branch address line 2 |
_BRNADD3_ |
Branch address line 3 |
_TDATE_ |
Rollover date |
_REF_ |
Advice Reference |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address line 1 |
_ADD2_ |
Customer address line 2 |
_ADD2_ |
Customer address line 3 |
_ADD4_ |
Customer address line 4 |
_TDACNO_ |
Term deposit account number |
_AMT_ |
Rollover amount |
_CCY_ |
Term deposit currency |
_DEPTTENOR_ |
Term deposit tenor |
_MATDATE_ |
Maturity date |
_MATAMT_ |
Maturity amount |
_INTRATE_ |
Interest rate |
_INTAMT_ |
Projected Interest amount |
_TDROLLTYPE_ |
Rollover type |
_BLOCKEDAMT_ |
Blocked/Lien amount |
_TAXAMT_ |
Tax Amount |
_TAXRATE_ |
Tax Rate |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving at Interest Rate |
This advice will be generated for original and duplicate advice for Term Deposit. A message type ‘ICCOD’ will be used. The tag ‘DUPLICATE’ will be displayed only in case of duplicate advice generated:
Tag |
Description |
_BRANCH_ |
Code of the branch where Account is to be held |
_BRNAME_ |
Branch Name |
_BRNADD1_ |
Branch address line 1 |
_BRNADD2_ |
Branch address line 2 |
_BRNADD3_ |
Branch address line 3 |
_ACLASS_ |
Account Class |
_ACLASSDEC_ |
Account class description |
_CUSTID_ |
CIF ID |
_TDATE_ |
Rollover date |
_REF_ |
Advice Reference |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address line 1 |
_ADD2_ |
Customer address line 2 |
_ADD2_ |
Customer address line 3 |
_ADD4_ |
Customer address line 4 |
_TERMDEPAMT_ |
Amount of Term Deposit |
_TDACNO_ |
Term deposit account number |
_VDATE_ |
Opening date |
_AMT_ |
Rollover amount |
_CCY_ |
Term deposit currency |
_XRATE_ |
Applicable Rate |
_INTAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_INTAMTWORD_ |
Interest Amount in words |
_TAXAMT |
Tax Amount |
_TAXCCY |
Tax Amount Currency |
_SPLCCY_ |
Tax collected amount currency |
_TAXAMTWORD |
Tax Amount in words |
_DEPTTENOR_ |
Term deposit tenor |
_MATDATE_ |
Maturity date |
_MATAMT_ |
Maturity amount |
_MATAMTWORDS_ |
Tax Amount in words |
_CCY_ |
Maturity amount currency |
_MDATE_ |
Maturity Date |
_TDATE_ |
TD Booking date |
_INTRATE_ |
Interest rate |
_DUPLICATE_ |
Duplicate Certificate |
_USERNAME_ |
User Name who has generated the advice |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving at Interest Rate |
For denominated certificates the following tags are available for ICCOD advice:
Tag |
Description |
_ CDENOID_ |
Denomination id of the certificate |
_CDENOVAL_ |
Denomination of the certificate |
_CDENOUNIT_ |
The unit of denomination |
_CSTATUS_ |
The current status of the certificate |
This advice will be generated for original and duplicate advice for Term Deposit Simulation.
Advice Tag |
Description |
_BRANCH_ |
Code of the branch where Account is to be held |
_ BRNAME_ |
Name of the branch where Account is to be held |
_ BRADDR1_ |
Branch address line 1 |
_ BRADDR2_ |
Branch address line 2 |
_ BRADDR3_ |
Branch address line 3 |
_ACLASS_ |
Account Class |
_ACLASSDEC |
Account Class Description |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address 1 |
_ADD2_ |
Customer address 2 |
_ADD3_ |
Customer address 3 |
_ADD4_ |
Customer address 4 |
_TERMDEPAMT_ |
Amount of Term Deposit |
_TENORY_ |
Tenor - Term in years |
_TENORM_ |
Tenor - Term in months |
_TENORD_ |
Tenor - Term in days |
_VDATE_ |
Opening date |
_CCY_ |
Currency |
_XRATE_ |
Applicable Rate |
_APY_ |
Annual Percentage yield |
_INTAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_INTAMTWORD_ |
Interest Amount in words |
_TAXAMT |
Tax Amount |
_SPLCCY |
Tax Amount Currency |
_TAXAMTWORD |
Tax Amount in words |
_MATAMT_ |
Maturity Amount |
_MATAMTWORDS_ |
Maturity Amount in words |
_CCY_ |
Maturity Amount currency |
_MDATE_ |
Maturity Date |
_TDATE_ |
TD Booking date |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving at Interest Rate |
This advice will be generated for renewal and simulation of term deposit. A message type ‘TD_REN_SIM’ will be used.
Advice Tag |
Description |
_BRANCH_ |
Code of the branch where Account is to be held |
_BRNAME_ |
Name of the branch where Account is to be held |
_ BRADDR1_ |
Branch address line 1 |
_ BRADDR2_ |
Branch address line 2 |
_ BRADDR3_ |
Branch address line 3 |
_ACLASS_ |
Account Class |
_ ACLASSNAME_ |
Account Class Name |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address 1 |
_ADD2_ |
Customer address 2 |
_ADD3_ |
Customer address 3 |
_ADD4_ |
Customer address 4 |
_TERMDEPAMT_ |
Account Balance |
_TDACNO_ |
Term Deposit Account Number |
_VDATE_ |
Opening date |
_CCY_ |
Currency |
_XRATE_ |
Applicable Rate |
_SPLAMT1_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_SPLAMTWORD1_ |
Interest Amount in words |
_MATAMT_ |
Maturity Amount |
_MATAMTWORDS_ |
Maturity Amount in words |
_CCY_ |
Maturity amount currency |
_MDATE_ |
Maturity Date |
_INTPAIDOUT_ |
Interest paid out as on simulation date |
_SPLCCY |
Interest paid amount currency |
_INTPAIDOUTWORD_ |
Interest paid out amount in words |
_TAXCOLL_ |
Amount of tax collected as till date. |
_SPLCCY |
Tax collected amount currency |
_TAXAMTWORDS_ |
Tax amount in words |
_TDATE_ |
TD Booking date |
_RENTYPE_ |
Type of rollover |
_TENORY_ |
Rollover term in years |
_TENORM_ |
Rollover term in months |
_TENORD_ |
Rollover term in days |
_TERMDEPAMT_ |
Amount of Term Deposit for rollover |
_TERMDEPAMTWORD_ |
Term deposit amount in words |
_MDATE1_ |
Maturity Date |
_XRATE1_ |
Applicable Rate |
_APY_ |
Annual Percentage yield |
_SPLAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_SPLAMTWORD |
Interest amount in words |
_TAXAMT_ |
Tax Amount |
_SPLCCY_ |
Tax Amount currency |
_STAXAMTWORD_ |
Tax Amount in words |
_MATAMT1_ |
Maturity Amount |
_MATAMTWORDS1_ |
Maturity Amount in words |
_CCY_ |
Maturity amount currency |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving the Interest |
This advice will be generated for simulation of TD top up. A message type ‘TD_TOP_SIM’ will be used.
Advice Tag |
Description |
_BRANCH_ |
Code of the branch where Account is to be held |
_ BRNAME_ |
Name of the branch where Account is to be held |
_ BRADDR1_ |
Branch address line 1 |
_ BRADDR2_ |
Branch address line 2 |
_ BRADDR3_ |
Branch address line 3 |
_ACLASS_ |
Account Class |
_ ACLASSNAME_ |
Account Class Name |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address 1 |
_ADD2_ |
Customer address 2 |
_ADD3_ |
Customer address 3 |
_ADD4_ |
Customer address 4 |
_TERMDEPAMT_ |
Amount of Term Deposit |
-TERMDEPAC_ |
Term Deposit Account Number |
_TENORY_ |
Tenor - Term in years |
_TENORM_ |
Tenor - Term in months |
_TENORD_ |
Tenor - Term in days |
_VDATE_ |
Opening date |
_CCY_ |
Currency |
_XRATE_ |
Applicable Rate |
_APY_ |
Annual Percentage yield |
_SPLAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_SPLAMTWORD_ |
Interest Amount in words |
_MATAMT_ |
Maturity Amount |
_MATAMTWORDS_ |
Maturity Amount in words |
_CCY_ |
Maturity amount currency |
_MDATE_ |
Maturity Date |
_INTPAIDOUT_ |
Interest paid out as on simulation date |
_INTPAIDOUTWORD_ |
Interest paid out amount in words |
_TAXCOLL_ |
Amount of tax collected as on top up date |
_SPLCCY_ |
Tax Amount currency |
_TAXAMTWORDS_ |
Tax amount in words |
_TDATE_ |
TD Booking date |
_TOPUPDATE_ |
Date of top up |
_TOPUPAMT_ |
Amount of top up |
_CCY_ |
Top up Currency |
_TOPUPAMTWORD_ |
Top up amount in words |
_BALTERMDEPAMT_ |
Amount of Term Deposit after top up |
_BALTERMDEPAMTWORD_ |
Term deposit amount in words |
_XRATE_ |
Applicable Rate |
_APY_ |
Annual Percentage yield |
_NEWINTAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_NEWINTAMTWORD |
Interest Amount in words |
_TAXAMT |
Tax Amount |
_SPLCCY_ |
Tax Amount Currency |
_TAXAMTWORDS_ |
Tax Amount in words |
_NEWMATAMT_ |
Maturity Amount |
_NEWMATAMTWORDS_ |
Maturity Amount in words |
_CCY_ |
Maturity amount currency |
_INTCUM_ |
Interest Rate Based on Cumulative Amount |
_BASEAMT_ |
Base Amount for Arriving at Interest Rate |
This advice will be generated for simulation of TD redemption. A message type ‘TD_RED_SIM’ will be used.
Advice Tag |
Description |
_BRANCHCODE_ |
Code of the branch where Account is to be held |
_ BRNAME_ |
Name of the branch where Account is to be held |
_ BRADDR1_ |
Branch address line 1 |
_ BRADDR2_ |
Branch address line 2 |
_ BRADDR3_ |
Branch address line 3 |
_ACLASS_ |
Account Class |
_ACLASSNAME_ |
Account Class Name |
_CUSTID_ |
CIF ID |
_CUSTNAME_ |
Customer name |
_ADD1_ |
Customer address 1 |
_ADD2_ |
Customer address 2 |
_ADD3_ |
Customer address 3 |
_ADD4_ |
Customer address 4 |
_TERMDEPAMT_ |
Amount of Term Deposit |
-TERMDEPAC_ |
Term Deposit Account Number |
_TENORY_ |
Tenor - Term in years |
_TENORM_ |
Tenor - Term in months |
_TENORD_ |
Tenor - Term in days |
_VDATE_ |
Opening date |
_CCY_ |
Currency |
_XRATE_ |
Applicable Rate |
_SPLAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
_SPLAMTWORDS_ |
Interest Amount in words |
_MATAMT_ |
Maturity Amount |
_MATAMTWORDS_ |
Maturity Amount in words |
_CCY_ |
Maturity amount currency |
_MDATE_ |
Maturity Date |
_INTPAIDOUT_ |
Interest paid out as on simulation date |
_INTPAIDOUTWORD_ |
Interest paid out amount in words |
_CCY_ |
Currency |
_TAXCOLL_ |
Amount of tax collected as on redemption |
_SPLCCY_ |
Tax Currency |
_TAXAMTWORDS_ |
Tax amount in words |
_TDATE_ |
TD Booking date |
_REDDATE_ |
Date of redemption |
_REDMODE_ |
Mode of redemption |
_REDAMT_ |
Amount of redemption |
_REDMATWORD_ |
Redemption amount in words |
_NEWRATE |
Interest rate applicable for current redemption |
_INTAMT_ |
Amount of interest payable for current redemption |
_SPLCCY_ |
Interest Amount Currency |
_INTAMTWORD |
Interest amount in words |
_PENAMT_ |
Amount of penalty applicable for current redemption |
_CCY_ |
Penalty Amount Currency |
_PENAMTWORD |
Penalty amount in words |
_TAXAMT_ |
Amount of tax applicable for current redemption |
_SPLCCY_ |
Tax Amount Currency |
_TAXAMTWORD_ |
Tax amount in words |
_NETINTAMT |
Net interest amount payable for current redemption |
_SPLCCY_ |
Net Interest amount currency |
_NETINTAMTWORD |
Net interest amount payable in words |
_NET AMT_ |
Net amount payable for current redemption |
_CCY_ |
Net Payable amount currency |
_NET AMTWORD_ |
Net amount payable in words |
_BALTERMDEPAMT_ |
Amount of Term Deposit after redemption |
_CCY_ |
Currency |
_TERMDEPAMTWORD |
Amount of Term Deposit in words |
_NEWXRATE_ |
Applicable Rate |
_APY_ |
Annual Percentage yield |
_NEWINTAMT_ |
Interest Amount |
_SPLCCY_ |
Interest Amount currency |
NEWINTAMTWORD_ |
Interest amount in words |
_TAXAMT1_ |
Tax Amount |
_SPLCCY_ |
Tax Currency |
_TAXAMTWORDS1_ |
Tax Amount in Words |
_NEWMATAMT_ |
Maturity Amount |
_NEWMATAMTWORDS_ |
Maturity Amount in words |
_CCY_ |
Maturity amount currency |
_INTCUM |
Interest Rate Based on Cumulative Amount |
_BASEAMT |
Base Amount for Arriving at Interest Rate |
You can set up various IC products for handling TDs.
This section contains the following topics:
You can set up event-wise accounting entries and advices for the product as suggested below. Accounting roles are for sample rule ID AP01.
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDACCOUNT |
TD-PRINC |
Credit |
TDOFFSET |
TD-PRINC |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
AP01-PNL_ADJ-1 |
IACR_ADJ |
Debit |
AP01-ACR_ADJ-1 |
IACR_ADJ |
Credit |
AP01-PNL-1 |
IACR |
Debit |
AP01-ACCR-1 |
IACR |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
AP01-ACCR-1 |
ILIQ |
Debit |
AP01-PNL_ADJ-2 |
IACQUIRED |
Credit |
AP01-BOOK-2 |
IACQUIRED |
Debit |
AP01-BOOK-1 |
IACQUIRED |
Credit |
AP01-ACQUIRED-1 |
IACQUIRED |
Debit |
AP01-BOOK-1 |
ILIQ |
Credit |
AP01-BOOK-3 |
TAX_ADJ |
Debit |
AP01-TPBL-3 |
TAX |
Credit |
AP01-BOOK-3 |
TAX |
Debit |
AP01-PNL-2 |
ILIQ |
Credit |
AP01-BOOK-2 |
ILIQ |
Debit |
AP01-TPBL_ADJ-3 |
TAX_ADJ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
INT-LIQD |
IMAT |
Debit |
INT-BOOK |
IMAT |
Credit |
PRINC-LIQD |
PMAT |
Debit |
PRINC-BOOK |
PMAT |
Credit |
Note
You need to maintain entries for each of your booking type formulae otherwise the system will not be able to process IC.
Tax entries are mandatory if tax parameters are maintained for your rule. When you don’t maintain tax through the Tax sub-system, but instead you maintain it as a debit type interest component, you should use the common accounting roles and amount tags.
You can set up event-wise accounting entries and advices for the product as suggested below Sample accounting entries for IC Product with Rule ID AP02 are given below.
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDACCOUNT |
TD-PRINC |
Credit |
TDOFFSET |
TD-PRINC |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
AP02-PNL-1 |
IACR |
Debit |
AP02-ACCR-1 |
IACR |
Credit |
AP02-PNL_ADJ-1 |
IACR_ADJ |
Debit |
AP02-ACR_ADJ-1 |
IACR_ADJ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
AP02-ACCR-1 |
ILIQ |
Debit |
AP02-PNL_ADJ-2 |
IACQUIRED |
Credit |
AP02-BOOK-2 |
IACQUIRED |
Debit |
AP02-BOOK-1 |
IACQUIRED |
Credit |
AP02-ACQUIRED-1 |
IACQUIRED |
Debit |
AP02-BOOK-1 |
ILIQ |
Credit |
AP02-BOOK-3 |
TAX_ADJ |
Debit |
AP02-TPBL-3 |
TAX |
Credit |
AP02-BOOK-3 |
TAX |
Debit |
AP02-PNL-2 |
ILIQ |
Credit |
AP02-BOOK-2 |
ILIQ |
Debit |
AP02-TPBL_ADJ-3 |
TAX_ADJ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
INT-LIQD |
IMAT |
Debit |
INT-BOOK |
IMAT |
Credit |
PRINC-LIQD |
PMAT |
Debit |
PRINC-BOOK |
PMAT |
Credit |
You can set up event-wise accounting entries and advices for the product as suggested below. Sample accounting entries for IC Product with Rule ID RC02 are given below.
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDACCOUNT |
TD-PRINC |
Credit |
TDOFFSET |
TD-PRINC |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
RC02-PNL-1 |
IACR |
Debit |
RC02-ACCR-1 |
IACR |
Credit |
RC02-PNL_ADJ-1 |
IACR_ADJ |
Debit |
RC02-ACR_ADJ-1 |
IACR_ADJ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
RC02-BOOK-2 |
ILIQ |
Debit |
RC02-BOOK-1 |
IACQUIRED |
Credit |
RC02-ACQUIRED-1 |
IACQUIRED |
Debit |
RC02-BOOK-2 |
IACQUIRED |
Credit |
RC02-PNL_ADJ-2 |
IACQUIRED |
Debit |
RC02-PNL-2 |
ILIQ |
Credit |
RC02-BOOK-3 |
TAX_ADJ |
Debit |
RC02-BOOK-3 |
TAX |
Credit |
RC02-TPBL_ADJ-3 |
TAX_ADJ |
Debit |
RC02-BOOK-1 |
ILIQ |
Credit |
RC02-ACCR-1 |
ILIQ |
Debit |
RC02-TPBL-3 |
TAX |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
INT-LIQD |
IMAT |
Debit |
INT-BOOK |
IMAT |
Credit |
PRINC-LIQD |
PMAT |
Debit |
PRINC-BOOK |
PMAT |
Credit |
You can set up event-wise accounting entries and advices for the product as suggested below. Sample accounting entries for IC Product with Rule ID TDRD are given below.
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDACCOUNT |
TD-PRINC |
Credit |
TDOFFSET |
TD-PRINC |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDRD-ACR_ADJ-1 |
IACR_ADJ |
Credit |
TDRD-PNL_ADJ-1 |
IACR_ADJ |
Debit |
TDRD-ACCR-1 |
IACR |
Credit |
TDRD-PNL-1 |
IACR |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDRD-BOOK-2 |
ILIQ |
Debit |
TDRD-BOOK-1 |
IACQUIRED |
Credit |
TDRD-ACQUIRED-1 |
IACQUIRED |
Debit |
TDRD-PNL_ADJ-2 |
IACQUIRED |
Credit |
TDRD-BOOK-2 |
IACQUIRED |
Debit |
TDRD-PNL-2 |
ILIQ |
Credit |
TDRD-BOOK-3 |
TAX_ADJ |
Debit |
TDRD-TPBL-3 |
TAX |
Credit |
TDRD-BOOK-3 |
TAX |
Debit |
TDRD-BOOK-1 |
ILIQ |
Credit |
TDRD-ACCR-1 |
ILIQ |
Debit |
TDRD-TPBL_ADJ-3 |
TAX_ADJ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
INT-LIQD |
IMAT |
Debit |
INT-BOOK |
IMAT |
Credit |
PRINC-LIQD |
PMAT |
Debit |
PRINC-BOOK |
PMAT |
Credit |
You can set up event-wise accounting entries and advices for the product as suggested below. Sample accounting entries for IC Product with Rule ID TD01 are given below. The interest is paid upfront at the time of booking.
Note
The IC rule defined for normal interest product should not be linked for discounted product. Separate rule definition is needed for discounted deposits.
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TDACCOUNT |
TD-PRINC |
Credit |
TDOFFSET |
TD-PRINC |
Debit |
TD01-BOOK-1 |
TD-INT |
Credit |
INTPIA |
TD-INT |
Debit |
TD01-BOOK-3 |
TAX |
Debit |
TD01-TPBL-3 |
TAX |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TD01-ACR_ADJ-1 |
IACR_ADJ |
Credit |
TD01-PNL_ADJ-1 |
IACR_ADJ |
Debit |
TD01-ACCR-1 |
IACR |
Credit |
TD01-PNL-1 |
IACR |
Debit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TD01-BOOK-1 |
ILIQ_ADJ |
Debit |
TD01-ACCR-1 |
ILIQ_ADJ |
Credit |
TD01-BOOK-2 |
ILIQ |
Debit |
TD01-PNL-2 |
ILIQ |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
INT-LIQD |
IMAT |
Debit |
INT-BOOK |
IMAT |
Credit |
PRINC-LIQD |
PMAT |
Debit |
PRINC-BOOK |
PMAT |
Credit |
Accounting Entries
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
TD01-BOOK-1 |
TD-INT |
Credit |
INTPIA |
TD-INT |
Debit |
TD01-BOOK-3 |
TAX |
Debit |
TD01-TPBL-3 |
TAX |
Credit |
Accounting entries in Product maintenance
IACR
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
<Rule>-ACCR-1 |
IACR |
Credit |
<Rule>-PNL-1 |
IACR |
Debit |
<Rule>-ACCR-2 |
IACR |
Debit |
<Rule>-PNL-2 |
IACR |
Credit |
ILIQ
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
<Rule>-ACCR-1 |
ILIQ |
Debit |
<Rule>-BOOK-1 |
ILIQ |
Credit |
<Rule>-ACCR-2 |
ILIQ |
Credit |
<Rule>-BOOK-2 |
ILIQ |
Debit |
<Rule>-TPBL-3 |
ILIQ |
Credit |
<Rule>-BOOK-3 |
ILIQ |
Debit |
During redemption of debit interest accounting roles to which accounting entries are passed will be reversed.