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