15. Reports

15.1 Introduction

The report programs available under the Funds Transfer (FT) module are explained in this chapter. All activities that are performed by the FT module are recorded. The inputs you have made at different stages of the contract are pieced together and can be extracted in the form of meaningful reports as and when you may require them.

The reports that can be generated for the FT Module are as follows:

Note

Some of the reports you do not have to make any specifications. For such reports, there is no Report Options screen.

This chapter contains the following sections:

15.2 FT Daily Activity Journal

Every day Teller doing the financial transactions, prints hard copy of the three reports: 1. Cash Position, 2.Teller Transaction Report, 3. Batch Journal Report for reconciliation with the vouchers and cheques for onward submission. These reports are required to be developed in Oracle FLEXCUBE.

The Daily Activity Journal reports all the FT contracts of your branch, for which some event has taken place during the day. These details are printed and sorted on the basis of event and product code.

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

The report details all activities that were performed on FT contracts as of a given day. All contracts that were initiated either manually, or by the Autobook program together with those processed by the FT Update Function will be listed in this report. The relevant details of a Transfer, including the contract status such as reversed, reconciled etc., will be reported.

This report also indicates the overrides that were encountered during the day, while contracts were processed. However the actual overrides can be viewed in the contract detailed view.

Click ‘OK’ button to generate the Daily Activity report, click ‘Exit’ to return to the Reports Browser.

The Daily Activity Journal is provided with two options:

The Summary Option briefly highlights the basic aspects of a contract like the account numbers of the remitter and beneficiary, the currencies used in the contract etc. The Detailed Option on the other hand gives you a comprehensive report of the contract.

If you choose to generate this report as a part of the end-of-day processes, all the activities performed during the day will be reported. You have the option to spool, print or view the report.

15.2.1 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

Field Name Field Description
Contract Indicates the contract.
Override Indicates Override.
Spread Indicates Spread.
Remitter Currency This is the detail regarding the currency of the remitter.
Beneficiary Currency This is the detail regarding the currency of the beneficiary.
Payment Details This is the detail regarding the payment in the bank.
Product Description This is the description of the respective product.
Contract Status This is the current status of the FT Contract.
Remitter Amount It gives the sum of remitter amount.
Beneficiary Amount It gives the sum of beneficiary amount.
Exchange This is the rate at which the exchange of currency is done.
Input The Login ID of the user that created the reconciliation class record.
Remitter Branch & Account This is the description of the branch and the account of the remit­ter.
Beneficiary Branch & Account This is the description of the branch and the account of the bene­ficiary.
Ordering Party Indicates ordering party.
Authorized The Login ID of the user that has authorized the record.
Debit Value Date Debit value date of the entries contained in the external state­ment.
Credit Value Date Credit value date of the entries contained in the external state­ment.
Check Number This is the details regarding the check number.
Remitter A/C And Description This is the description of the remitter’s account.
Beneficiary A/C And Description This is the description of the beneficiary’s account.
Ultimate Beneficiary A/C This is the details regarding the ultimate beneficiary account.
Manager Check Number This is the details regarding the manager’s check.

 

15.3 FT Contract Report

The FT Contract reports all the FT contracts of your branch, for which some event has taken place during the day. These details are printed and sorted on the basis of event and product code.

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

Click ‘OK’ button to generate the FT Contract report, click ‘Exit’ to return to the Reports Browser.

This section contains the following topics:

15.3.1 Selection Options

The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Start Date

Select the start date of the contract from the option list.

End Date

Select the end date of the contract from the option list provided.

Currency

You need to specify the currency type. You have the following options:

Based on the currency type, you can select the currency from the option list provided.

Customer

You need to specify the customer type. You have the following options:

Based on the customer type, you can select the customer from the option list provided.

Account

You need to specify the account type. You have the following options:

Based on the account type, you can select the account from the option list provided.

Branch

You need to specify the branch type. You have the following options:

Based on the branch type, you can select the branch from the option list provided.

Amount

You need to specify the amount type. You have the following options:

Based on the amount type, you can select the required amount from the option list provided.

15.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 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

Field Name Field Description
Contract Indicates the contract
Remitter Currency This is the detail regarding the currency of the remitter.
Beneficiary Currency This is the detail regarding the currency of the benefi­ciary.
Payment Details This is the detail regarding the payment in the bank.
Receiver Correspondent This field captures Receiver Correspondent.
Spread Code This is the description of the spread code.
Contract Status This is the current status of the FT Contract.
Remitter Amount It gives the sum of remitter amount.
Exchange Rate This is the rate at which the exchange of currency is done.
Beneficiary Amount It gives the sum of beneficiary amount.
Remitter Branch & Account This is the description of the branch and the account of the remitter.
Beneficiary Branch & Account This is the description of the branch and the account of the beneficiary.
Account with Institution This is the details regarding the institution’s account.
Ordering Party Indicates ordering party.
Input By This field gives description regarding Input By.
Authorized By The Login ID of the user that has authorized the record.
Debit Value Date Debit value date of the entries contained in the external statement.
Credit Value Date Credit value date of the entries contained in the external statement.
Check Number This is the details regarding the check number.
Remitter A/C And Descrip­tion This is the description of the remitter’s account.
Beneficiary A/C And Description This is the description of the beneficiary’s account.
Ultimate Beneficiary A/C This is the details regarding the ultimate beneficiary account.
Product Description This is the description of the respective product.
Manager Check Number This is the details regarding the manager’s check.

15.4 Remittance Received Report

The Remittance Received Report gives details on remittance received.

You can invoke this screen by typing ‘FTRPREMR’ 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 preferences for the report:

Branch Code

Specify the branch code from the adjoining drop down list.

Report Date

Select the date from the option list.

15.4.1 Contents of the Report

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

Header

The following details are displayed in the header section:

Sr. No. Field Name Field Description
1 Branch Indicates Branch name
2 Branch Date Indicates Branch code
3 User ID Indicates User ID
4 Module Indicates Module name
5 Run Date Indicates Date on which report is generated

 

Body of the Report

Field Name Field Description
Contract Reference Number Indicates the contract reference number.
Dr Reference Num­ber Indicates the dr reference number.
Amount Indicates amount.
Currency Indicates currency.
Value Date Indicates value date.
Correspondent Bank Indicates correspondent bank.
Beneficiary Details Indicates beneficiary details.
Beneficiary Account No Indicates beneficiary account no.
Beneficiary Title Indicates beneficiary title.
Remitter Detail Indicates remitter detail.
Remitter Bank Indicates remitter bank.
Remitter Account Number Indicates remitter account number.
Remitter Name Indicates remitter name.