7. Reports

7.1 Introduction

The report programs available under the Clearing module are explained in this chapter. All activities that are performed by the Clearing module are recorded. The inputs you have made at different stages are pieced together and can be extracted in the form of meaningful reports as and when you may require them. Every day teller doing the financial transactions, print hard copy of the reports.

This chapter contains the following sections:

7.2 Inward Clearing Extract Report

This section contains the following topics:

7.2.1 Generating Inward Clearing Extract Report

This Report lists the all inward clearing records. It will have all the records irrespective of their status. You can invoke ‘Inward Clearing Extract Report’ screen by typing ‘CGRINCLR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the transaction date.

Click ‘OK’ button to generate the inward clearing extract report, click ‘Exit’ to return to the Reports Browser.

7.2.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the report

The generated report will be ordered by the batch number and currency. The Batch No (4-7 character of Reference Number). The Summation will be for Number of entries, amount.

Field Name

Description

End Point

This indicates the end point.

Clearing Type

This indicates the clearing type.

Remitter Branch

This indicates the remitter branch.

Remitter Account

This indicates the remitter account.

Beneficiary Account

This indicates the beneficiary account.

Cheque Number

This indicates the cheque number.

Entry Number

This indicates the entry number.

Routing Number

This indicates the routing number.

Payee

This indicates the payee.

Instrument Date

This indicates the instrument date.

Currency

This indicates the currency.

Cheque Amount

This indicates the cheque amount.

Status

This indicates the status.

7.3 Inward Clearing Extract – Passed Entries

This section contains the following topics:

7.3.1 Generating Inward Clearing Extract- Passed Entries

After authorization, all the transactions will come to ‘Clearing Log’ (IFSCLGDT) screen. Here some transactions will go as error, because of lack of funds, or other reasons. A report is required containing data of how many entries passed.

You can invoke ‘Inward Clearing Extract - Passed Entries’ screen by typing ‘CGRCLGPS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the transaction date.

Click ‘OK’ button to generate the inward clearing extract report, click ‘Exit’ to return to the Reports Browser.

7.3.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the report

The generated report will be ordered by the batch number and currency. Batch No (4-7 character of Reference Number). The Summation will be for Number of entries, amount.

Field Name

Description

End Point

This indicates the end point.

Clearing Type

This indicates the clearing type.

Remitter Branch

This indicates the remitter branch.

Remitter Account

This indicates the remitter account.

Beneficiary Account

This indicates the beneficiary account.

Cheque Number

This indicates the cheque number.

Entry Number

This indicates the entry number.

Routing Number

This indicates the routing number.

Remarks

This indicates the remarks.

Instrument Date

This indicates the instrument date.

Currency

This indicates the currency.

Amount

This indicates the amount.

7.4 Inward Clearing Extract - Failed Entries

This section contains the following topics:

7.4.1 Generating Inward Cleating Extract - Failed Entries

This Report lists the failed inward clearing records. You can invoke ‘Inward Clearing Extract - Failed Entries’ screen by typing ‘CGRCLREF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Transaction Date

Specify the transaction date.

Click ‘OK’ button to generate the inward clearing extract report, click ‘Exit’ to return to the Reports Browser.

7.4.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the report

The generated report will be ordered by the batch number and currency. The Batch No (4-7 character of Reference Number). The Summation will be for Number of entries, amount.

Field Name

Description

End Point

This indicates the end point.

Clearing Type

This indicates the clearing type.

Remitter Branch

This indicates the remitter branch.

Remitter Account

This indicates the remitter account.

Beneficiary Account

This indicates the beneficiary account.

Cheque Number

This indicates the cheque number.

Entry Number

This indicates the entry number.

Routing Number

This indicates the routing number.

Failed Reason

This indicates the failed reason.

Remarks

This indicates the remarks.

Instrument Date

This indicates the instrument date.

Currency

This indicates the currency.

Amount

This indicates the amount.

7.5 Inward Clearing Extract – Rejected Entries

This section contains the following topics:

7.5.1 Generating Inward Clearing Extract - Rejected Entries

This Report lists the reject inward clearing records. The bank may wish to reverse some of the passed cheques. A report is required of how many cheques reversed with details.

You can invoke ‘Inward Clearing Extract - Rejected Entries’ screen by typing ‘CGRCHREV’ 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 parameters here:

Transaction Date

Specify date of transaction of inward clearing extract for which you wish to generate report, from the adjoining calendar.

Reject Code

Specify reject code of the inward clearing extract for which you wish to generate report, from the adjoining option list.

Reject Reason

Reason for the rejection of the inward clearing extract is defaulted here based the specified reject code.

Click ‘OK’ button to generate the inward clearing extract report, click ‘Exit’ to return to the Reports Browser.

7.5.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated, the module of the report and reject code.

Body of the report

The generated report will be ordered by the batch number and currency. The Batch No (4-7 character of Reference Number). The Summation will be for Number of entries, amount.

Field Name

Field Description

Transaction Branch

This indicates the transaction branch.

Remitter Account

This indicates the remitter account.

Beneficiary Account Number

This indicates the beneficiary account.

Customer Name

This indicates the customer name.

Cheque Number

This indicates the cheque number.

Batch Number

This indicates the batch number

Currency

This indicates the currency of the transaction

Total Amount

This indicates the total amount

Total Number of Records

This indicates the total number of records

Value Date

This indicates the value date.

Reject Reason

This indicates the reject reason.

Currency

This indicates the currency.

Amount

This indicates the amount.

7.6 Inward Clearing Extract – Forcefully Passed Entries

This section contains the following topics:

7.6.1 Generating Inward Clearing Extract - Forcefully Passed Entries

The bank will forcefully pass some of the entries which had failed earlier. A report is required of how many passed forcefully with details. You can invoke ‘Inward Clearing Extract – Forcefully passed Entries’ screen by typing ‘CGRCLFPS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the transaction date.

Click ‘OK’ button to generate the inward clearing extract report, click ‘Exit’ to return to the Reports Browser.

7.6.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the report

The generated report will be ordered by the batch number and currency. The Batch No (4-7 character of Reference Number). The Summation will be for Number of entries, amount.

Field Name

Field Description

End Point

This indicates the end point.

Clearing Type

This indicates the clearing type.

Remitter Branch

This indicates the remitter branch.

Remitter Account

This indicates the remitter account.

Beneficiary Account

This indicates the beneficiary account.

Cheque Number

This indicates the cheque number.

Entry Number

This indicates the entry number.

Routing Number

This indicates the routing number.

Previous Status

This indicates the previous status.

Current Status

This indicates the current status.

Payee

This indicates the payee.

Instrument Date

This indicates the instrument date.

Currency

This indicates the currency.

Amount

This indicates the amount.

7.7 Inward Clearing Summary Report

This section contains the following topics:

7.7.1 Generating Inward Clearing Summary Report

Cheques are processed in various Inward Clearing types, Currencies, and Batches throughout the day. These Inward Clearing Cheques are either processed successfully or rejected, based on the accounts fund position, status, etc.

You can generate ‘Inward Clearing Summary Report’ to help the branches in balancing inward clearing transactions. This report lists all the inward clearing transactions processed on that day. The transactions are grouped by batches. You can invoke ‘Inward Clearing Summary Report’ screen by typing ‘CGRINCLG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.CGRINCLG__CVS_MAIN

You can specify the following parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

Date

Specify the date for which you wish to generate the report from the adjoining calendar.

End Point

Specify cheque number which you wish to maintain as an end point to generate the report, from the adjoining option list.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.7.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Inward Clearing Summary Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

End Point

Indicates End Point

Clearing House Name

Indicates Clearing House Name

Clearing House

Indicates Clearing house

Currency

Indicates Currency

Batch Number

Indicates Batch Number

Debit Amount

Indicates Sum of Cheque Amount of the batch

Rejected Amount

Indicates Sum of amount of the rejected cheques of the batch

Passed Amount

Indicates Sum of amount of the passed cheques of the batch

7.8 Outward Clearing Failed Transactions Report

This section contains the following topics:

7.8.1 Generating Outward Clearing Failed Transaction Report

Outward clearing cheques are settled by forwarding them to clearing houses. On the due date of settlement, credits are received from the other banks, through the clearing house. Subject to the returns, the funds are credited to the customer accounts. If an outward clearing transaction fails, then you can generate ‘Outward Clearing Failed Transactions Report’ to list transactions which failed on that day. This report groups all failed transactions based on the instrument and clearing type of the transaction.

You can invoke ‘Outward Clearing Failed Transactions Report’ screen by typing ‘CGROCFTN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

End Point

Specify cheque number which you wish to maintain as an end point to generate the report, from the adjoining option list.

Process Date

Specify the date when the outward clearing transaction was processed from the adjoining Calendar.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.8.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Outward Clearing Failed Transactions Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

End Point

Indicates the end point

Transaction Date

Indicates the date of transaction

Instrument Type

Indicates the instrument type

Instrument No

Indicates Instrument Number

XREF

Indicates External Reference Number

Acc Branch

Indicates Payee Account Branch

Beneficiary Account Number

Indicates the beneficiary account number

Instrument CCY

Indicates the instrument currency

SC CCY

Indicates the charge currency

Transaction Status

Indicates the transaction status

Reference Number

Indicates FCC Reference Number

Routing No

Indicates Clearing Routing Number

Remitter Account

Indicates Payee Account Number

Beneficiary Account Description

Indicates the Beneficiary Account Description

Instrument Amount

Indicates Instrument Amount

SC Amount

Indicates Service Charge Amount

Reject Reason

Indicates Cheque Reject Remarks

7.9 Cheques Due for Realization Report

This section contains the following topics:

7.9.1 Generating Cheques Due for Realization Report

Instruments that need to be credited to the customer’s account are lodged in clearing. On the clearing due date, the cheques are realized and the accounts are credited, subject to the returns. Simultaneously branches open various clearing sessions based on the requirements and lodge cheques.

You can generate ‘Cheques Due for Realization Report’ to list cheques that are due for realization for that day. This report lists cheques which were already due for credit to the accounts value date. You can invoke ‘Cheques Due for Realization Report’ screen by typing ‘CGRCDTOD’ 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 parameters here:

Clearing Type

Specify clearing type for which you wish to generate the report, form the adjoining option list.

Value Date

Specify clearing value date of the outward clearing transaction from the adjoining calendar.

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

End Point

Specify cheque number which you wish to maintain as an end point to generate the report, from the adjoining option list.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.9.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Cheques Due for Realization Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

End Point

Indicates Clearing End Point

Origination Branch

Indicates the origination branch

Clearing type and description

Indicates the clearing type and description

Instrument type

Indicates the instrument type

Currency

Indicates the currency of the transaction

Account Number

Indicates Account Number

Name

Indicates Account Holder Name

Bank Code

Indicates Bank Code

Instrument No

Indicates Instrument Number

Amount in TCY

Indicates the Amount in TCY

Transaction Seq NO

Indicates the transaction sequence number

Deposit Date

Indicates Cheque Deposited Date

Product Code

Indicates the product code

Value Date

Indicates value date

Transaction Ltrl

Indicates Transaction ltrl

7.10 Inward Clearing Cheque Reject Report

This section contains the following topics:

7.10.1 Generating Inward Clearing Cheque Reject Report

Cheques which were presented in inward clearing are cleared after verifying the following:

If the presented cheque fails in any of the above validations, then the Drawee Bank rejects the cheque. Subsequently, these cheques are returned to clearing house, with reasons for not honoring it.

You can generate ‘Inward Clearing Cheque Reject Report’ with details of cheques which were rejected during inward clearing process for a given period. This report groups cheques, based on the end point, branch code, and totals provided for instrument amount.

You can invoke ‘Inward Clearing Cheque Reject Report’ screen by typing ‘CGRICLRS’ 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 parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

From Date

Specify the date from when you wish to generate the report from the adjoining calendar.

To Date

Specify the date till when you wish to generate the report from the adjoining calendar.

End Point

Specify cheque number which you wish to maintain as an end point to generate the report, from the adjoining option list.

Account Number

Specify account number to which the rejected inward clearing cheque was submitted, from the adjoining option list.

Reject Reason

Specify rejection code for rejection of the cheque from the adjoining option list.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.10.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Inward Clearing Cheque Reject Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

RM ID

Relationship manager ID

Account No

Indicates Remitter Account Number

Account Desc

Indicates Account Description

Instrument type

Indicates Instrument type

Instrument No

Indicates Instrument No

Instrument CCY

Indicates Instrument Currency

Instrument Amount

Indicates Instrument Amount

Cheque Return date

Indicates Transaction date

Routing No

Indicates Clearing routing no

Clearing Ref No

Indicates FCC Contract reference no

TXN No

Indicates Xref

Telephone No

Indicates Contact No

Reject reason

Indicates Reject reason

Auth ID

Indicates Authorizer Id

Auth ID date

Indicates Authorizer date and time

7.11 Outward Clearing Cheque Reject Report

This section contains the following topics:

7.11.1 Generating Outward Clearing Cheque Reject Report

You can generate a report of outward clearing cheque rejections using ‘Outward Clearing Reject Report’ screen. This screen gives the details of the cheques those were bounced during a given period. You can invoke ‘Outward Clearing Cheque Reject Report’ screen by typing ‘CGROCLRS’ 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 parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

From Date

Specify the date from when you wish to generate the report from the adjoining calendar.

To Date

Specify the date till when you wish to generate the report from the adjoining calendar.

End Point

Specify cheque number which you wish to maintain as an end point to generate the report, from the adjoining option list.

Account Number

Specify account number to which the rejected inward clearing cheque was submitted, from the adjoining option list.

Reject Reason

Specify rejection code for rejection of the cheque from the adjoining option list.

Include Subordinates

The relationship managers can generate the reports for the customers who are associated with their subordinate RMs. Choose one of the following options:

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.11.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Inward Clearing Cheque Reject Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Rm ID

Relationship Manager ID

Transaction Branch

Transaction Branch

End Point

End Point

Remittance Account

Remittance Account

Account Description

Account Description

Instrument type

Instrument type

Instrument No

Instrument Number

Instrument CCY

Instrument Currency

Instrument Amt

Instrument Amount

Cheque Return Date

Cheque Return Date

Routing No

Routing No

Reference No

Reference No

Transaction No

Transaction No

Contact No

Contact No

Auth ID

Auth ID

Auth Time

Auth Time

Reject Reason

Reject Reason

7.12 Outward Clearing Summary Report

This section contains the following topics:

7.12.1 Generating Outward Clearing Summary Report

When a customer submits instruments of various other banks to credit their accounts, they are lodged into outward clearing and are moved to clearing settlement. You can generate ‘Outward Clearing Summary Report’ to provide list of the transactions processed successful or rejected while processing outward clearing. The results are grouped based on the endpoint, clearing type, and transaction currency.

You can invoke ‘Outward Clearing Summary Report’ screen by typing ‘CGROCSAR’ 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 parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

Transaction Status

Select status of the transaction from the adjoining drop-down list. This list displays the following values:

Transaction Date

You can generate this report for the transactions having a specific transaction date. Select the transaction date using the adjoining calendar button.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.12.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Outward Clearing Summary Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

No of Txns

Indicates No of Transactions

Product

Indicates the product

Transaction Ccy

Indicates the transaction currency

Transaction Date

Indicates the transaction date

Amount credited

Indicates Credit amount for outward transactions

Amount Return

Indicates Return amount for outward transactions

Net amount in TCY

Indicates Total net amount for outward cheque transactions

Net amount in LCY

Indicates Total net amount for outward LCY transactions

7.13 Clearing Balance Summary Report

This section contains the following topics:

7.13.1 Generating Clearing Balance Summary Report

Clearing houses are conducted region-wise and a pool of branches of each bank participates in each clearing house to settle the funds. You can generate ‘Clearing Balance Summary Report’ to get region-wise summary details of clearing house details, clearing, and amount cleared for that day. The details are grouped based on the clearing house and branch. You can invoke ‘Clearing Balance Summary Report’ screen by typing ‘CGRBLSUM’ 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 parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

Region Code

Specify a valid region code of the clearing house for which you wish to generate clearing balance summary, from the adjoining option list.

Transaction Date

Specify the transaction date. In the report, the system will include all the transactions entered on the date specified here.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.13.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Clearing Balance Summary Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Status

Indicates the status of the clearing balance

Clearing House

Indicates Clearing house description

Clearing Branch.

Indicates Clearing branch code

Region code

Indicates Region code

Region name

Indicates Region name

Inward Txn date

Indicates the inward transaction date

Outward Txn Date

Indicates the outward transaction date

No. Of Inward Cheques

Indicates the number of inward cheques

Inward Amount (LCY)

Indicates the inward amount in local currency

No. of Outward cheques

Indicates Cheque count

Outward amount (LCY)

Indicates the outward amount in local currency

Amount Brought (LCY).

Indicates Sum of all instruments amount

7.14 Liquidated Instrument Report

This section contains the following topics:

7.14.1 Generating Liquidated Instrument Report

When a bank issues instruments to its customers and non-customers, they can be issued against CASA, Cash or GL Account. You can generate ‘Liquidated Instrument Report’ with complete details of instruments and the corresponding beneficiary. The details are grouped based on the instrument type.

You can invoke ‘Liquidated Instrument Report’ screen by typing ‘CGRLQINT’ 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 parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated from the adjoining option list.

Liquidation Date

Specify the liquidation date when the instrument was liquidated from the adjoining calendar.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.14.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Liquidated Instrument Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Reference No

Indicates Reference no

Instrument Type

Indicates Instrument Type

Instrument Number

Indicates Instrument No

Issued Date

Indicates Instrument Date

Currency

Indicates Instrument currency

Instrument Amount

Indicates Instrument Amount

Beneficiary Name.

Indicates Customer Name

Total count & Amount

Indicates Transaction count and amount

7.15 Instrument Issued Today Report

This section contains the following topics:

7.15.1 Generating Instrument Issued Today Report

Banks issue various types of instruments like DD/BC/TCs etc to their customers. You can generate ‘Instrument Issued Today’ report with the details of the customers and the issued instruments, for the run date. As per regulatory requirements, PAN no. is also maintained for instruments issued with higher amounts.

The instrument details are grouped based on the instrument type and currency wise. You can invoke ‘Instruments Issued Report’ screen by typing ‘CGRINSTR’ 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 parameters here:

Branch Code

Specify a valid code of the Branch in which report is being generated, from the adjoining option list.

Instrument Type

Specify instrument type for which you need to generate the report from the adjoining option list.

Teller ID

Specify a valid ID of the teller for which you need to generate the report from the adjoining option list.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.15.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Instrument Issued Today Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Teller ID

Indicates the teller ID

Instrument Currency

Indicates Instrument currency

Instrument type

Indicates Instrument type

Issuer Short Name

Indicates Account description

Instrument Date

Indicates Instrument Date

Instrument Number

Indicates the instrument number

Payable bank

Indicates Payable bank code

Contract Ref no

Indicates Contract reference no

Xref

Indicates Reference no

Instrument Amount

Indicates Instrument Amount

Instrument No

Indicates Instrument No

Account Currency

Indicates Account Currency

Account Currency Amount

Indicates Account amount

Charge Ccy

Indicates Charge Currency

Charge Amt

Indicates Charge Amount

Payable Branch

Indicates the payable branch

Identifier Name

Indicates the name of the identifier

Pan Card Number

Indicates the PAN card number

No of Instruments of this type

Indicates Total no of instruments

Total Amount for this type

Indicates Total amount for each instrument type

Total amount for this currency

Indicates Total amount for each instrument currency

7.16 Outward Clearing Handoff Report

This section contains the following topics:

7.16.1 Generating Outward Clearing Handoff Report

Outward clearing instruments received from the customers are lodged and sent to end point clearing for crediting the customer accounts. On the clearing value date, the funds are made available to the customers. You can generate ‘Outward Clearing Handoff Report’ to list complete details of outward clearing transaction handoff.

You can invoke ‘Outward Clearing Handoff Report’ screen by typing ‘CGROCGHR’ 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 parameters here:

From Date

Specify the date from when you wish to generate the report from the adjoining calendar.

To Date

Specify the date till when you wish to generate the report from the adjoining calendar.

Currency

Specify a valid currency in which the outward clearing transaction was handed-off, from the adjoining option list.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.16.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Outward Clearing Handoff Report is as follows:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Account Branch

Indicates Originating branch

Clearing Branch

Indicates Transaction branch

Remitter Account

Indicates Payee Account

TXN Seq No

Indicates FCC Contract reference no

Instr No

Indicates Instrument No

Instr Date

Indicates Cheque Issue date

Routing No

Indicates Routing No

Beneficiary Account

Indicates Drawee account

Acc Ccy

Indicates Beneficiary Account currency

Amount

Indicates Instrument Amount

Clg type

Indicates Clearing product code

End Point

Indicates Outward clearing branch

7.17 Float Extension Report

This section contains the following topics:

7.17.1 Generating Float Extension Report

You can generate a float extension report to view the list of cheque transactions processed in float extension batch.

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

Specify the following here:

Branch Code

Select the transaction branch of the float extension from the adjoining option list.

From Date

Indicate the date from which transactions are extended. The system defaults current date. From Date should be lesser than or equal to ‘To Date’.

To Date

Indicate the date to which the transactions are extended. The system defaults current date. To Date should be lesser than or greater to ‘From Date’

7.17.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

The selection criteria used for the generation of the report is displayed below the header.

Body of the Report

Field Name

Field Description

Float Extension Reference Number

Indicates the Float Extension Reference Number generated by the system.

Execution Date

Indicate the Date of Execution

Branch Code

Indicates Branch Code

Remitter Account

Indicates the Remitter Account Number

Beneficiary Account

Indicates the Beneficiary Account Number.

Float Days Extended

Indicates the number of Float Days extended.

Status

Indicates the Status of execution.

Old Value Date

Indicates Value Date before float extension.

New Value Date

Indicates Value Date after float extension.

Clearing Type

Indicates the Clearing product code.

Sector Code

Indicates the Sector Code

Clearing Bank Code

Indicates the clearing bank code

Clearing Branch Code

Indicates the clearing branch code

Instrument Number

Indicates the Instrument Number of Cheque/DD/BC

Currency

Indicates the Currency of the Instrument

Instrument Amount

Indicates the Amount of the Instrument

Entry Number

Indicates Entry Sequence Number of Float Extension.

Instrument Date

Indicates the Date of the Instrument

7.18 On Us Transaction Report

This section contains the following topics:

7.18.1 Generating On Us Transaction Report

You can invoke ‘On Us Transaction Report’ screen by typing ‘CGRPOUTN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

7.18.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report.

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Account Number

Indicates the account number

Customer Name

Indicates the name of the customer

Debit/Credit Indicator

Indicates whether the transaction is credit or debit

Currency

Indicates the currency of the account

Amount

Indicates the amount

Instrument Number

Indicates the instrument number

Description

Gives brief on the transaction

Value Date

Indicates value date

Input Branch

Indicates the input branch

Maker ID

Indicates the identification of the maker of the record

Input Date

Indicates the date of input

Reference Number

Indicates the reference number

7.19 Funds Availability Simulation Report

This section contains the following topics:

7.19.1 Generating Funds Availability Simulation Report

Funds Availability Simulation Report is used to generate details of the accounts with possible insufficient balances.

You can invoke ‘Funds Availability Simulation Report’ screen by typing ‘CGRINSIM’ 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 parameters here:

Transaction Date

Select the transaction date from the adjoining calendar.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

7.19.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report.

Header

The Header carries the Branch of the report, information on the branch and date, the ID of the user who generated the report, currency of the instrument the date and time at which it was generated and the module of the report.

Field Name

Description

Transaction Date

Indicates the transaction Date

Transaction Branch

Indicates the transaction Branch

User ID

ID of the user who generated the report,

Date and time

Date and time of the report generation

Module

Module of the Report

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Description

Account Number

Indicates the Account of the remitter

Name

Indicates the customer name.

Available Balance

This would be Remitter Account's available Balance without adding uncollected funds or cover account/limits funds

Uncollected Funds

This field will include uncollected funds excluding the withdrawable uncollected funds

Available Balance Including Limits/Cover account

This field will hold the available balance including limits/cover account+ withrawable uncollected funds

Total Check Amount

Sum of all check amount for the account

Difference

This will have difference of (Available Bal Including Limits/Cover + withdraw able Uncollected fund)- Total Check Amount

OD Type

DAUD/DAIF

Check Number

This indicates the cheque number

Check Amount

This indicates the cheque amount