This chapter contains the following sections:
This section contains the following topic:
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.
This section contains the following topic:
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.
This section contains the following topics:
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.
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 possible 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:
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 |
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 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.
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 | Customer | Dr | Cheque Amount | Main Transaction code | Account Branch | ||||||
(Cheque_Retn_ amt+ Charge amount) | |||||||||||
RETN | Income GL | Cr | Our_charge | Transaction code from ARC for the specific charge product | Transaction Branch | ||||||
RETN | Inward Return Suspense GL | Cr | Cheque_Retn_ amt | Offset Transaction code | Transaction 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.
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 | Customer | Dr | Cheque Amount (( Cheque_Retn_ amt + Charge amount)) | Main Transaction code | Account Branch | ||||||
RETN | Income GL | Cr | Our Charge Amount | Offset Transaction code | Transaction Branch | ||||||
RETN | Inward Return Suspense GL | Cr | Cheque_Retn_ amt | Offset Transaction code | Transaction Branch |
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:
Event | Account | Dr/Cr | Amount tag | Transaction Code | Branch Code | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
REVR | Customer | Dr | Cheque Amount | Main Transaction Code | Account Branch | ||||||
REVR | Inward Suspense GL | Cr | Cheque Amount | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Check GL at Account Branch | Dr | Cheque Amount | Offset Transaction Code | Account Branch | ||||||
REVR | Customer | Cr | Cheque Amount | Main Transaction Code | Account Branch | ||||||
REVR | Customer | Dr | Charge Amount | Main Transaction Code | Account Branch | ||||||
REVR | Return Cheque GL at Account Branch | Cr | Charge Amount | Offset Transaction Code | Account Branch | ||||||
REVR | Outward Return Susp GL | Dr | Cheque_Retn_ amt | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Cheque GL at Account Brn | Cr | Cheque_Retn_ amt | Offset Transaction Code | Account Branch |
Cheque Return Amount = Cheque Amount – Charge Amount
Event | Account | Dr/Cr | Amount tag | Transaction Code | Branch Code | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
REVR | Customer | Dr | Cheque Amount | Main Transaction Code | Account Branch | ||||||
REVR | Inward Suspense GL | Cr | Cheque Amount | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Cheque GL at Account Branch | Dr | Cheque Amount | Offset Transaction Code | Account Branch | ||||||
REVR | Customer | Cr | ChequeAmount | Main Transaction Code | Account Branch | ||||||
REVR | Outward Return Susp GL | Dr | Cheque_Retn_ amt | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Cheque GL at Account Branch | Cr | Cheque_Retn_ amt | Offset Transaction Code | Account Branch |
Event | Account | Dr/Cr | Amount tag | Transaction Code | Branch Code | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
REVR | Return Cheque GL at Clearing Branch | Dr | Cheque Amount | Offset Transaction Code | Clearing Branch | ||||||
REVR | Inward Suspense GL | Cr | Cheque Amount | Offset Transaction Code | Transaction Branch | ||||||
REVR | Outward Return Susp GL | Dr | Cheque Amount | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Check GL at Clearing Branch | Cr | Cheque Amount | Offset Transaction 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 Transaction Code | Account Branch | ||||||
REVR | Inward Suspense GL | Cr | (-) Cheque Amount | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Cheque GL at Account Branch | Dr | Cheque Amount | Offset Transaction Code | Account Branch | ||||||
REVR | Inward Suspense GL | Cr | Cheque Amount | Offset Transaction Code | Transaction Branch | ||||||
REVR | Outward Return Susp GL | Dr | Cheque_Retn_ amt | Offset Transaction Code | Transaction Branch | ||||||
REVR | Return Cheque GL at Account Branch | Cr | Cheque_Retn_ amt | Offset Transaction 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.
This section contains the following topics:
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.
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,
Note
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.
This section contains the following topic:
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.
This section contains the following topic:
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:
This section contains the following topic:
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
This section contains the following topic:
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.
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 |
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
The system will upload inward clearing file and pass consolidated entry for the total cheque amount at branch level as follows:
Cr/Dr Indicator | Account/GL | Amount Tag | |||
---|---|---|---|---|---|
Dr | Inward Suspense GL | FILE_AMT | |||
Cr | Clearing Nostro/Central Bank Account | FILE_AMT |
Cr/Dr Indicator | Account/GL | Amount Tag | |||
---|---|---|---|---|---|
Dr | Inward Suspense GL | FILE_AMT | |||
Cr | Clearing Nostro Account/GL | FILE_AMT |
The system will upload inward return clearing file and pass consolidated entry for the total cheque amount at branch level as follows:
Cr/Dr Indicator | Account/GL | Amount Tag | |||
---|---|---|---|---|---|
Dr | Inward Return Suspense GL | FILE_AMT | |||
Cr | Clearing Nostro/ Central Bank Account | FILE_AMT |
Cr/Dr Indicator | Account/GL | Amount Tag | |||
---|---|---|---|---|---|
Dr | Inward Return Suspense GL | FILE_AMT | |||
Cr | Clearing Nostro Account/ GL | FILE_AMT |