6. Viewing Clearing Transactions

This chapter contains the following sections:

6.1 View Clearing Transactions

This section contains the following topic:

6.1.1 Invoking Clearing Transaction Query Screen

You can view clearing transactions in the ‘Clearing Transaction Query’ screen, where you provide the details of the check instruments as well as the clearing details. You can invoke this screen by typing ‘CGDQUERY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

In the Clearing Transaction Input screen, you can view the following:

For more information on Tanked Transaction, refer Branch Parameters chapter under Core Services module.

6.2 Inward Clearing Transaction Query

This section contains the following topic:

6.2.1 Invoking Inward Clearing Transaction Query Screen

You can view inward clearing transactions in the ‘Inward Clearing Transaction Query’ screen, where you provide the details of the check instruments as well as the clearing details. You can invoke this screen by typing ‘CGDIWQRY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

In the Clearing Transaction Input screen, you can view the following:

For more information on Tanked Transaction, refer Branch Parameters chapter under Core Services module.

 

6.3 Query the Clearing Transactions Summary

This section contains the following topics:

6.3.1 Querying the Clearing Transactions Summary

You can view the processed clearing records through the Clearing transaction screen. You can reverse a transaction or input a transaction through this screen. Also, you can query/view the list of transactions with a particular reconciliation status.

You can invoke this screen by typing ‘CGSQUERY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

You can query the clearing transactions based on the following details:

Click ‘Search’ button to view the records based on criteria you have selected. The following details of the record get displayed:

Refer heading ‘Specifying Clearing/Cheque Details’ in the Utility Payments Manual for further details on Clearing Transaction Query screen.

6.3.2 Maintaining Settlement Details

You can maintain settlement details for Inward and Outward Direct Credit transactions.

For details on Inward and Outward Direct Credit transactions, refer to the Retail Teller and Retail Branch user manuals.

Invoke the ‘Settlement Details’ screen from the Application Browser by typing ‘FTDRCST’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

This screen contains fields that explore possible routes of the transfer. Depending on the type of transfer you are initiating and on the number of banks involved in the transfer, you can enter details of the parties involved in the transfer route.

Note

The country information is captured to enable Mantas to analyze the transactions for pos­sible money laundering activities.

For more details on Mantas, refer 'Mantas' interface document.

Route Code

This is an identifier for the transfer route that you are creating. During a retail teller transaction input, you can use this route code to call up the settlement and messaging details that you maintain in this screen.

Intermediary Reimbursement Institution

An ‘Intermediary Reimbursement Institution’ is the financial institution between the Sender’s Correspondent and the Receiver’s Correspondent, through which the reimbursement of the transfer will take place.

Intermediary

The ‘Intermediary’ in a transfer refers to the financial institution, between the ‘Sender’ and the ‘Account With Institution’, through which the transfer must pass.

The Intermediary may be a branch or affiliate of the Sender or the account with Institution, or an entirely different financial institution. This field corresponds to field 56a of S.W.I.F.T.

Here you can enter either the:

Receiver’s Correspondent

The ‘Receiver’s Correspondent’ is the branch of the Receiver or another financial institution at which the funds will be made available to the Receiver. This field corresponds to field 54a of S.W.I.F.T. You can enter one of the following:

Account With Institution

An ‘Account With Institution’ refers to the financial institution, at which the ordering party requests the Beneficiary to be paid. The Account With Institution may be a branch or affiliate of the Receiver, or of the Intermediary, or of the Beneficiary Institution, or an entirely different financial institution.

This field corresponds to Field 57A of S.W.I.F.T. You can enter one of the following:

Sender to Receiver Information

You can include any message that the Sender wishes to pass on to the Receiver as part of the funds transfer.

Receiver Intermediary

The ‘Receiver Intermediary’ in a transfer refers to the financial institution, between the ‘Receiver’ and the ‘Account With Institution’, through which the transfer must pass.

The Intermediary may be a branch or affiliate of the Receiver or the account with Institution, or an entirely different financial institution. This field corresponds to field 56a of S.W.I.F.T.

Here you can enter either the:

Beneficiary Institution

Here, you can enter details of the institution in favor of which the payment is made. It is in reality the bank that services the account of the Ultimate Beneficiary. This field corresponds to Field 58A of S.W.I.F.T.

You will be allowed to make entries into this field only for Bank Transfers (when the remitter and beneficiary of the transfer are financial institutions — MT 100 or MT 202). Here you can enter either:

6.3.3 Resolving Customer Credits for Clearing Checks

For processing outward clearing checks, you need to ensure that:

When charges are collected upfront

Step 1

This is the registration event (INIT), for which you can define the following entries:

Debit/Credit Indicator

Accounting Role

Amount Tag

Debit

Nostro with the collecting bank

Check amount

Credit

Clearing Suspense account

Check amount

Debit

Clearing Suspense account

Our charges

Credit

Income -

Our charges

Step 2

This is the liquidation event, for which you can define the following entries:

Debit/Credit Indicator

Accounting Role

Amount Tag

Debit

Clearing Suspense account

Check amount

Credit

Customer

Check amount

Debit

Customer

Our charges

Credit

Clearing Suspense account

Our charges

Debit

Customer

Collecting bank charges

Credit

Collecting Bank charge Account

Collecting bank charges

When clearing charges are collected from the customer after credit

Step 1

This is the registration event. The following entries can defined for this event:

Debit/Credit Indicator

Accounting Role

Amount Tag

Debit

Nostro with the collecting bank

Check amount

Credit

Clearing Suspense account

Check amount

Step 2

This is the liquidation event. The following entries can be defined for this event.

Debit/Credit Indicator

Accounting Role

Amount Tag

Debit

Clearing Suspense account

Check amount

Credit

Customer

Check amount

Debit

Customer

Our charges

Credit

Clearing Suspense account

Our charges

Debit

Customer

Collecting bank charges

Credit

Collecting Bank charge Account (Nostro of collecting bank with your bank)

Collecting bank charges

For the registration product, when the charge is collected upfront, the ARC Maintenance must be as follows:

Txn Account

Offset Account

Charge Account

Charge From Account

Suspense

Nostro

Income

Transaction Account

For the registration product, when clearing charges are collected from the customer after credit, the ARC Maintenance must be as follows:

Txn Account

Offset Account

Charge Account

Charge From Account

Suspense

Nostro

-

-

For the liquidation product, when clearing charges are collected from the customer after credit, the ARC Maintenance must be as follows:

Charge Type

Txn Account

Offset Account

Charge Account

Charge From Account

Our charges

Customer

Suspense

Income

Transaction Account

Collecting Bank charges

Customer

Suspense

Income

Transaction Account

6.3.4 Levying Charges on Dishonored Cheque

You can levy charges on dishonored cheques based on the reason for rejection. Invoke the ‘Clearing Rejection Reason’ screen from the application browser.

You can invoke this screen by typing ‘CGDRJMNT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.‘

In this screen, you have to specify a reject code and give a description of the same. A reject code has to be assigned to every check that you reject.

Reject Code

Specify the reject code.

Description

Specify the description for the specified reject code.

Instrument

Select the instrument type from the drop-down list. The list displays the following values:

Include for Cheque Return Counter

Check this box to include for cheque return counter.

Update Cheque Returns in the Customer Account

Check this box to to identify if entries for Cheque bounce has to be updated at the Customer account based on the reject code.

Charge Preferences

Charge Applicable

Select the appropriate check box to indicate if the charge applicable is for inward returns or outward returns. The list displays the following values:

Inward Return Charge Product

Specify the inward return charge product. Alternatively, you can select inward return charge product from the option list. The list displays all valid inward return charge product maintained in the system.

Outward Return Charge Product

Specify the outward return charge product. Alternatively, you can select outward return charge product from the option list. The list displays all valid outward return charge product maintained in the system.

Charge Reason

The system displays the reason for charge applicable.

Select ‘CHQ’ as the instrument used and check the Charge Applicable box. You can also mention a reason for application of charge.

For all reject codes where charge is applicable a charge basis is automatically created by the system. You have to link the charge basis to a charge product in the IC module.

You can check the box ‘Include for Cheque Return Counter’ to indicate that the reject code is considered for incrementing the return counter, when the cheque comes in for clearing.

Refer to the Interest and Charges user manual to find out how to create a charge basis.

If you wish to levy charge for a dishonored check, then, when marking the check as dishonored, specify a reject code that has a charge basis linked to it. You can do this in the Interface Clearing Details screen, which is explained in the next section.

On authorization of dishonored checks, the system will validate if the reject code associated with a dishonored check has a charge basis linked to it and process charges accordingly.

6.3.4.1 Processing of Presenting Bank Charges

During inward return handling, the presenting bank charges maintained using Inward Return Charge Product will be received from the Debtor bank and credited to income GL. The system will directly map Inward return charge products maintained in the ARC maintenance to the Reject codes and the inward return suspense GL maintained in Endpoint maintenance will be used to pass reversal entries for RETN event for Inward returns

The system processes the charges during inward returns handling as follows:

In case a return is received from Inward clearing, the system will automatically trigger the RETN event with the following accounting entries:

Event

Account

Dr/Cr

Amount tag

Transaction Code

Branch Code

RETN

Cus­tomer       

Dr

Cheque Amount

Main Transac­tion code

Account Branch

(Cheque_Retn_ amt+ Charge amount)

RETN

Income GL

Cr

Our_charge

Transaction code from ARC for the specific charge product

Transac­tion Branch

RETN

Inward Return Suspense GL

Cr

Cheque_Retn_ amt

Offset Trans­action code

Transac­tion Branch

If no Charges are applicable, then Cheque return amount will be the Cheque Amount.

If the Original parent transaction is found, then the system will validate if:

Computed Charge amount = Cheque amount –Cheque return amount

Else the system will log an exception for the transaction.

Based on the reason for rejection and if you have selected ‘Charge Applicable’ field as ‘Outward returns’ for the corresponding Reject code in the ‘Clearing Reject Code Maintenance’ screen, the, the presenting bank charges can be levied from the customer account for an outward return based on the charge set up at ARC maintenance.

You can maintain the presenting bank charges using the charge products in ARC setup with ‘Their Charge’ selected as ‘Yes’. The Outward return charge products maintained in the ARC maintenance will be directly mapped to the Reject codes and when the transactions are rejected, depending on the reject codes with which it gets rejected, the corresponding charge amount will be credited to income GL.

The following accounting entries will be triggered during Outward return handling if presenting bank charges are applicable:

Dr/Cr

Account/GL

Amount Tag

Dr

Customer for Presenting

Bk_Chg_Amt at Account branch

Cr

Return Cheque GL for Presenting

Bk_Chg_Amt at Account branch

If presenting bank charges are applicable for an outward return clearing transaction, then ‘Cheque Return Amount’ field will be derived based on the charge maintained for the respective reject code.

To add the accounting entries as part of the REVR event that includes with customer account with charges, the following events and accounting entries will be maintained.

6.3.4.2 Inward Return Handling without the parent match:

During the Inward Return File upload, in case the cheques are returned, when original parent contract cannot be identified, the system will check if the parameter ‘Process_return__without_ParentMatch’ is maintained as ‘Yes’. If Yes, the system will allow the return process as follows:

The system will pass the following Accounting entries:

Event

Account

Dr/Cr

Amount tag

Transaction Code

Branch Code

RETN

Cus­tomer       

Dr

Cheque Amount (( Cheque_Retn_ amt + Charge amount))

Main Transac­tion code

Account Branch

RETN

Income GL

Cr

Our Charge Amount

Offset Transac­tion code

Transaction Branch

RETN

Inward Return Suspense GL

Cr

Cheque_Retn_ amt

Offset Transac­tion code

Transaction Branch

 

6.3.4.3 Amount Tags and Accounting Entries

Amount Tags

As part of cheque return amount and presenting bank charge amount, the following amount tags are passed:

Accounting Entries

As part of the REVR event, the following Accounting entries will be passed:

With Customer Account – With Charges (Insufficient Balance)

Event

Account

Dr/Cr

Amount tag

Transaction Code

Branch Code

REVR

Customer

Dr

Cheque Amount

Main Transac­tion Code

Account Branch

REVR

Inward Suspense GL

Cr

Cheque Amount

Offset Trans­action Code

Transaction Branch

REVR

Return Check GL at  Account   Branch

Dr

Cheque Amount

Offset Trans­action Code

Account Branch

REVR

Customer

Cr

Cheque Amount

Main Transac­tion Code

Account Branch

REVR

Customer

Dr

Charge Amount

Main Transac­tion Code

Account Branch

REVR

Return Cheque GL at  Account   Branch       

Cr

Charge Amount

Offset Trans­action Code

Account Branch

REVR

Outward Return Susp GL             

Dr

Cheque_Retn_ amt

Offset Trans­action Code

Transaction Branch

REVR

Return Cheque GL at  Account   Brn       

Cr

Cheque_Retn_ amt

Offset Trans­action Code

Account Branch

Cheque Return Amount = Cheque Amount – Charge Amount

With Customer Account –Without Charges

Event

Account

Dr/Cr

Amount tag

Transaction Code

Branch Code

REVR

Customer

Dr

Cheque Amount

Main Transac­tion Code

Account Branch

REVR

Inward Sus­pense GL

Cr

Cheque Amount

Offset Transac­tion Code

Transac­tion Branch

REVR

Return Cheque GL at  Account   Branch      

Dr

Cheque Amount

Offset Transac­tion Code

Account Branch

REVR

Customer

Cr

ChequeA­mount

Main Transac­tion Code

Account Branch

REVR

Outward Return Susp GL             

Dr

Cheque_Retn_ amt

Offset Transac­tion Code

Transac­tion Branch

REVR

Return Cheque GL at  Account   Branch       

Cr

Cheque_Retn_ amt

Offset Transac­tion Code

Account Branch

Without Customer Account – Without Charges

Event

Account

Dr/Cr

Amount tag

Transaction Code

Branch Code

REVR

Return Cheque GL at  Clearing Branch       

Dr

Cheque Amount

Offset Trans­action Code

Clearing Branch

REVR

Inward Sus­pense GL

Cr

Cheque Amount

Offset Trans­action Code

Transac­tion Branch

REVR

Outward Return Susp GL             

Dr

Cheque Amount

Offset Trans­action Code

Transac­tion Branch

REVR

Return Check GL at  Clearing Branch

Cr

Cheque Amount

Offset Trans­action Code

Clearing Branch

If the account is not found during the Inward clearing reject and if the ‘Update Cheque return in the Customer Account’ is not selected at the Clearing Reject Code Maintenance. then the system will not trigger the customer level entries. The charge related details will be maintained in the arc set up for the corresponding CG product. The charges related accounting entries will not be triggered if the account is not found during Inward clearing reject.

In case of handling returns for successfully processed Inward clearing transactions, the system will first reverse the entries that is passed as part of Inward clearing transaction and pass the newly introduced reject entries as well as part of this REVR event. This process is performed using ‘Inward Cheque Return’ screen.

The accounting entries that will be triggered as part of REVR event during return of an successfully processed Inward Clearing transaction will be as follows:

Event

Account

Dr/Cr

Amount tag

Transaction Code

Branch Code

REVR

Customer

Dr

(-) Cheque Amount

Main Transac­tion Code

Account Branch

REVR

Inward Sus­pense GL

Cr

(-) Cheque Amount

Offset Trans­action Code

Transac­tion Branch

REVR

Return Cheque GL at  Account   Branch      

Dr

Cheque Amount

Offset Trans­action Code

Account Branch

REVR

Inward Sus­pense GL

Cr

Cheque Amount

Offset Trans­action Code

Transac­tion Branch

REVR

Outward Return Susp GL             

Dr

Cheque_Retn_ amt

Offset Trans­action Code

Transac­tion Branch

REVR

Return Cheque GL at  Account   Branch       

Cr

Cheque_Retn_ amt

Offset Trans­action Code

Account Branch

Note

During this scenario, the system should not trigger the Customer cheque bounce entries even if ‘Update Cheque return in the Customer Account’ is specified at the Clearing Reject Code Maintenance.

6.4 Query Clearing (Repair) Upload Summary

This section contains the following topics:

6.4.1 Querying Clearing (Repair) Upload Summary

You can modify the details for multiple clearing transactions using ‘Query Clearing Upload’ screen. You can use this screen for both inward clearing as well as outgoing clearing transactions and you can also authorize, reject clearing transactions in bulk.

You can invoke this screen by typing ‘CGDCLGDT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

You can query the multiple clearing transactions based on:

External Reference No

Specify the external reference of the transaction you are querying. This adjoining option list displays all valid external reference numbers maintained in the system. You can choose the appropriate one.

The system displays the following details corresponding to the specified External Reference No. However, you can modify them, if the default status is not ‘Success’.

End Point

Specify the end point/clearing house of the transaction you are querying. This adjoining option list displays all valid end points maintained in the system. You can choose the appropriate one.

Remitter Account No

Specify the remitter account number of the transaction you are querying. This adjoining option list displays all valid external remitter account numbers maintained in the system. You can choose the appropriate one.

Product

Specify the clearing product of the transaction you are querying. This adjoining option list displays all valid clearing product codes maintained in the system. You can choose the appropriate one.

Beneficiary Account

Specify the beneficiary account you are querying. This adjoining option list displays all valid beneficiary account numbers maintained in the system. You can choose the appropriate one.

Transaction Date

Enter the transaction date you are querying.

User Id

Specify user Id who input the transaction you are querying. This adjoining option list displays all valid user Ids maintained in the system. You can choose the appropriate one.

Status

Select the status of the transaction you are querying from the drop-down list:

Currency

Specify currency of the instrument you are querying. This adjoining option list displays all valid currencies maintained in the system. You can choose the appropriate one.

Remitter Branch

Specify remitter branch you are querying. This adjoining option list displays all valid remitter branches maintained in the system. You can choose the appropriate one.

Remitter Account Currency

Specify remitter account currency you are querying. This adjoining option list displays all valid remitter account currencies maintained in the system. You can choose the appropriate one.

Instrument No

Specify instrument number you are querying.

Amount

Specify the instrument amount you are querying.

Authorization Status

Select the authorization status of the transaction you are querying from the drop-down list:

Direction

Select the direction of the transaction you are querying from the drop-down list:

Rejected Code

Specify reject reason code for querying. This adjoining option list displays all valid reject codes maintained in the system. You can choose the appropriate one.

te one.

Batch Number

Specify the batch number for the transaction you want to query.

Click ‘Search’ button to view the records based on criteria you have selected. The following details of the record get displayed:

Clearing Details:

The system displays the following details:

Instrument Date

Specify the instrument date.

6.4.2 Inward Clearing of Instruments

You can process the failed inward clearing transactions of instruments using ‘Query Clearing Upload’ screen. You can invoke this screen by typing ‘CGDCLGDT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

To process the failed inward clearing transactions of instruments,

  1. Specify the instrument type from the adjoining option list.
  2. Select the status as ‘Error’ from the drop-down list.
  3. Click the ‘Query’ button to view all the failed transactions.
  4. Change the status as ‘Unprocessed’, to process the transactions failed due to expired instrument.

Note

    • You need to revalidate the instrument before processing them from the clearing repair screen. If not, system will display the error message and the status will be updated as ‘ERRR’.
    • The cheque cannot be rejected after the return marking cut off time, however will be postponed to the next working day.

6.4.3 Validating Returned Outward Clearing Transaction

If the outward clearing transaction is returned from ‘Clearing Repair Screen’ (CGDCLGDT); ‘Cheque Return Screen’ (6560); ‘Clearing Log Screen’ (IFDCLGDT), on save, the following validation will be done

Note

Return cut-off time would be validated only for the outward clearing returns of cheques.

6.5 Inward Query Clearing Upload

This section contains the following topic:

6.5.1 Invoking Inward Query Clearing Upload

You can invoke this screen by typing ‘CGDIWCGD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

You can query the multiple clearing transactions based on:

External Reference No

Specify the external reference of the transaction you are querying. This adjoining option list displays all valid external reference numbers maintained in the system. You can choose the appropriate one.

The system displays the following details corresponding to the specified External Reference No. However, you can modify them, if the default status is not ‘Success’.

End Point

Specify the end point/clearing house of the transaction you are querying. This adjoining option list displays all valid end points maintained in the system. You can choose the appropriate one.

Remitter Account No

Specify the remitter account number of the transaction you are querying. This adjoining option list displays all valid external remitter account numbers maintained in the system. You can choose the appropriate one.

Product

Specify the clearing product of the transaction you are querying. This adjoining option list displays all valid clearing product codes maintained in the system. You can choose the appropriate one.

Beneficiary Account

Specify the beneficiary account you are querying. This adjoining option list displays all valid beneficiary account numbers maintained in the system. You can choose the appropriate one.

Transaction Date

Enter the transaction date you are querying.

User Id

Specify user Id who input the transaction you are querying. This adjoining option list displays all valid user Ids maintained in the system. You can choose the appropriate one.

Status

Select the status of the transaction you are querying from the drop-down list:

Currency

Specify currency of the instrument you are querying. This adjoining option list displays all valid currencies maintained in the system. You can choose the appropriate one.

Remitter Branch

Specify remitter branch you are querying. This adjoining option list displays all valid remitter branches maintained in the system. You can choose the appropriate one.

Remitter Account Currency

Specify remitter account currency you are querying. This adjoining option list displays all valid remitter account currencies maintained in the system. You can choose the appropriate one.

Instrument No

Specify instrument number you are querying.

Amount

Specify the instrument amount you are querying.

Authorization Status

Select the authorization status of the transaction you are querying from the drop-down list:

Direction

Select the direction of the transaction you are querying from the drop-down list:

Rejected Code

Specify reject reason code for querying. This adjoining option list displays all valid reject codes maintained in the system. You can choose the appropriate one.

Batch Number

Specify the batch number for the transaction you want to query.

Click ‘Search’ button to view the records based on criteria you have selected. The following details of the record get displayed:

Clearing Details:

The system displays the following details:

Instrument Date

Specify the instrument date.

 

6.6 Intra-day Clearing Batch Process

This section contains the following topic:

6.6.1 Processing Intra-day Clearing Batch Process

The system runs Intra-day clearing batch process (CGFNDCHK) before the CGUPLOAD batch while the clearing upload records are still in the unprocessed state. This batch can also be triggered manually.This validates the Cheque amount and check the Drawer’s account balances for the unprocessed clearing records.

The system generates a report to give the details of the accounts with possible insufficient balances to pass the inward clearing cheques at the time of generation

The processing of this batch is as follows:

6.7 Clearing Auto Reject Mapping Maintenance

This section contains the following topic:

6.7.1 Invoking Clearing Auto Reject Mapping Maintenance Screen

You can map Oracle FLEXCUBE error codes to the corresponding Reject codes that will result in the auto reject of the incoming clearing transaction using ‘Clearing Auto Reject Mapping Maintenance’ screen. You can invoke this screen by typing ‘CGDERRCD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

You can specify the following details:

Error Code

Specify the error code encountered due to the an exception resulting in the failure of an inward clearing transaction. Alternatively, you can select error code from the option list. The list displays all valid error codes maintained in the system.

Error Description

Specify the error description for the selected error code.

Reject Code

Specify the reject code maintained in the system specifically for auto rejection of Inward clearing transactions. Alternatively, you can select reject code from the option list. The list displays all valid reject codes maintained in the system.

Reject Reason

Specify the reject reason for the selected reject code.

If there corresponding set of exceptions mapped to the Reject codes that are marked for auto rejection, then the system will perform the following steps to automatically reject the incoming transactions

6.8 Clearing Batch Process (CGUPLOAD)

This section contains the following topic:

6.8.1 Processing Clearing Batch

CGUPLOAD batch can be configured as intra-day batch to process the uploaded clearing data. This will process the clearing upload data which are in unprocessed status and creates the clearing transaction based on the instrument type, instrument product.

6.8.2 Provision for populating Clearing Upload

The excel upload process exposed by the system can be utilized to upload the clearing data into the clearing log data store.

The following are the fields which are mandatory for both Inward and Outward Clearing:

Field

Description

Data Type

INSTRNO

Instrument number

Number

PROD

Product code (inward clearing product)

String

INSTRCCY

Instrument currency

String

INSTRAMT

Instrument amount

Number

ROUTINGNO

Routing Number

String

The following are the fields which are mandatory for Inward Clearing:

Field

Description

Data Type

REMACCOUNT

Remitter account

Number

ENDPOINT

End point

String

The following are the fields which are mandatory for Outward Clearing:Clearing Intra-day Batch ProcessThis section contains the following topic:

Field

Description

Data Type

BENACCOUNT

Beneficiary account

Number

INSTRDATE

Instrument date

Date

6.8.3 Processing Clearing Intra-day Batch Process

The clearing intra-day batch (CGOUTBAT) will read the outward and outward LOCH clearing cheques for the current date and pass a consolidated entry at the branch level for the total number of cheque amount.

The clearing intra-day batch (CGINBAT) will read the inward and inward LOCH clearing cheques for the current date and pass a consolidated entry at the branch level for the total number of cheque amount in the file.

The clearing intra-day batch (CGOUTRBT) will read the outward return and outward LOCH return clearing cheques for the current date and pass a consolidated entry at the branch level for the total number of cheque amount in the file.

The clearing intra-day batch (CGINRBAT) will read the inward return and inward LOCH return clearing cheques for the current date and pass a consolidated entry at the branch level for the total number of cheque amount.

You can trigger the consolidated entry for the total cheque amount in the Outward Clearing file. using CGOUTBAT batch. This batch will consider all the Outward clearing contracts with clearing date as current system date and based on the end point, product code and consolidation status combination and pass a consolidated entry for the total cheque amount for the branch as follows and update the consolidation status field:

Cr/Dr Indicator

Account/GL

Amount Tag

Dr

Clearing Nostro/Central Bank Account

FILE_AMT

Cr

Outward Suspense GL

FILE_AMT

This batch job will trigger the consolidated entry for both Normal Outward and In-house clearing contracts.

The system will check if consolidation batch is executed prior to clearing upload batch. The system will update consolidated reference number against the individual cheques which were part of the consolidation amount.

If the CGINBAT is run prior to the clearing upload batch, the system will consider all the Return/reject of Inward clearing contracts based on the clearing type ‘IC’, file reference number or batch number and status as REJE and pass the consolidated batch entry for the Outward Return as follows:

Cr/Dr Indicator

Account/GL

Amount Tag

Dr

Clearing Nostro/Central Bank Account

FILE_AMT

Cr

Outward Return Suspence GL

FILE_AMT

The CGOUTRBT batch will trigger to pass the above mentioned consolidated entries for outward return and below mentioned outward LOCH return clearing contracts. The following batch entry will be triggered for LOCH process. The Internal Susp GL and Internal Return Susp GL will be fetched from the End point GL maintenance.

Outward LOCH Process:

Cr/Dr Indicator

Account/GL

Amount Tag

Dr    

Clearing Nostro Account/GL

FILE_AMT

Cr     

Outward Suspence GL

FILE_AMT

Outward Return LOCH:

Cr/Dr Indicator

Account/GL

Amount Tag

Dr    

Clearing Nostro Account/GL

FILE_AMT

Cr     

Outward Return Suspence GL

FILE_AMT

Note

6.8.3.1 Uploading Inward Clearing File

The system will upload inward clearing file and pass consolidated entry for the total cheque amount at branch level as follows:

 

 

 

 

 

Uploading Inward Return Clearing File

The system will upload inward return clearing file and pass consolidated entry for the total cheque amount at branch level as follows: