6. Annexure A – Accounting Entries and Advices

6.1 Introduction

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

This chapter contains the following sections:

• Section 6.2, "Events"
• Section 6.3, "Accounting Roles"
• Section 6.4, "Amount Tags"
• Section 6.5, "Accounting Entries and Advices"
• Section 6.6, "Advice Format"

6.2 Events

You can link the following events to an Intermediary product.

Event Code	Event Description
INLQ	Intermediary Liquidation
INHL	Intermediary Hierarchy Liquidation
IMST	Intermediary Statement

6.3 Accounting Roles

The following accounting roles are available in the module.

Accounting Role	Role Description
EXPENSE	Expense GL
REC_INTER	Receiving Intermediary
PAY_INTER	Paying Intermediary
INCOME	Income GL

6.4 Amount Tags

The following amount tags are available in the module.

Amount Tag	Tag Description
<RULEID>_INTERPAY_AMT	Amount paid to the Intermediary
INTERHIE_AMT	Amount for hierarchy-wise settlement

6.5 Accounting Entries and Advices

You can set up accounting entries for the following types of products:

• Payment
• Collection

This section contains the following topics:

• Section 6.5.1, "Payment"
• Section 6.5.2, "Collection"

6.5.1 Payment

For a product linked to payment type of rule, you can maintain the following accounting entries.

6.5.1.1 Accounting Entries

INLQ – Intermediary Liquidation

Dr/Cr	Accounting Role	Amount Tag
Dr	EXPENSE	<RULEID>_INTERPAY_AMT
Cr	REC_INTER	<RULEID>_INTERPAY_AMT

 

6.5.1.2 Advices

You can link the following advices to the events.

Event	Message Name	Description
INLQ	IN_INTER_CR	Credit Advice
INLQ	IN_INTER_DR	Debit Advice
IMST	IN_INTER_STMT	Intermediary Statement

The advices will address the primary intermediary.

6.5.2 Collection

For a product linked to collection type of rule, you can maintain the following accounting entries.

6.5.2.1 Accounting Entries

INLQ – Intermediary Liquidation

Dr/Cr Indicator	Accounting Role	Amount Tag
Dr	PAY_INTER	<RULEID>_INTERPAY_AMT
Cr	INCOME	<RULEID>_INTERPAY_AMT
Cr	REC_INTER	<RULEID>_INTERPAY_AMT
Dr	EXPENSE	<RULEID>_INTERPAY_AMT

 

INHL – Intermediary Hierarchy Liquidation

Dr/Cr Indicator	Accounting Role	Amount Tag
Dr	PAY_INTER	INTERHIE_AMT
Cr	REC_INTER	INTERHIE_AMT

 

Rule ID will be replaced with actual Rule ID while processing the entries.

6.5.2.2 Advices

You can link the following advices to the events.

Event	Message Name	Description
INLQ	IN_INTER_CR	Credit Advice
INLQ	IN_INTER_DR	Debit Advice
IMST	IN_INTER_STMT	Intermediary Statement

The advices will address the primary intermediary.

If settlement mode for intermediary is CASA for both debit and credit, the settlement details will be picked up from the settlement account maintenance for the intermediary.

If settlement mode for intermediary is ‘External Account’, the credits will be handled using the external account by triggering a PC transaction. Debits to intermediary will be handled using the settlement account details maintained for the intermediary.

6.6 Advice Format

You can maintain the following advice formats using the ‘Advice Format’ screen:

• INTER_CR_ADV (for credit advice)
• INTER_DR_ADV (for debit advice)
• INTER_STMT (for intermediary statement)

This section contains the following topics:

• Section 6.6.1, "INTER_CR_ADV "
• Section 6.6.2, "INTER_DR_ADV "
• Section 6.6.3, "INTER_STMT "

6.6.1 INTER_CR_ADV

You can capture the following details in this format:

• Date
• Intermediary Code
• Intermediary Name
• Address
• Intermediary Customer Id
• Value Date
• Amount
• Currency
• Credit Account

6.6.2 INTER_DR_ADV

You can capture the following details in this format:

• Date
• Intermediary Code
• Intermediary Name
• Address
• Intermediary Customer Id
• Value Date
• Amount
• Currency
• Debit Account

6.6.3 INTER_STMT

You can capture the following details in this format:

• Date
• Statement Period
• Intermediary Code
• Intermediary Name
• Address
• Intermediary Customer id
• Transaction Date
• Transaction Details
• Amount
• Currency
• Debit/Credit
• Settlement account