10. Reports

10.1 Introduction

This chapter contains the following sections:

To generate any of these reports choose Reports in the Application Browser. Choose TD under it. A list of all the reports in TD module will be displayed. You can choose to view or print the report.

The time and the operator who generated the report will be displayed.

10.2 Customers Fixed Deposit Report

This report lists out all time deposit accounts for a given customer. This report also provides additional information of whether lien is marked or not. You have an option to print and view the report in PDF, HTML, RTF or Excel format.

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

Specify the following details here:

Customer Number

Select the customer number from the adjoining option-list. The list displays all valid customer codes. On failure to provide the value, the report fetches records for all available customers and accounts across the branches.

Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.2.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The following detail block elements are displayed in the report:

Field Name

Field Description

Customer Number

This indicates the customer number whose fixed deposit details are reported

Customer Type

This indicates the customer type of the above customer

Account No.

This indicates the TD account number whose details are gener­ated in the report

Customer Name

This indicates the full name of the customer based on the cus­tomer number

Officer ID

This indicates the unique id of the customer

Currency

This indicates the account currency

Deposit value date

This indicates the value date of the deposit transaction in an account

Maturity date

This indicates the maturity date of a deposit account

Deposit Term in days

This indicates the term (tenor) of the deposit account

Deposit Amount (LCY)

This indicates the deposit amount of the account in local currency

Deposit Amount

This indicates the deposit amount in account currency for an account

Interest Rate

This displays the interest rate of the account

Maturity Amount

This displays the maturity amount as per new calculation

Lien Amount

This indicates the Lien Details (Amount Blocked) of an account

Stock Catalogue Code

This displays Stock Catalogue Code for the TD certificate number

Certificate No

This indicates the certificate number issued for TD account

Duplicate Issue

This indicates Y/N, based on the duplicate certificate issued for TD account

Interest Rate Based on Cumulative Amount

This indicates whether the interest rate for the deposit is arrived using cumulative amount or not.

10.3 TD Full Balance Listing Report

This report gives a complete listing of time deposit accounts opened till the run day. This report gives account class wise grouping of accounts with totals. You have an option to print and view the report in pdf or excel format.

You can invoke ‘TD Full Listing Reports’ screen by typing ‘TDRFULBL’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the following details here:

Branch Code

Select the branch code for which the report needs to be generated, from the adjoining option-list. The list displays all valid branch codes. You have an option to select all the branches or a single branch. If the branch code is not specified, then the TD accounts of all the branches are shown in the report.

Status

Select the account status from the drop-down list. The options available in the drop-down list are as follows:

Click ‘OK’ button to generate the report. For the selected branch, currency-wise deposit amount and number of deposits for the previous month and current month will be displayed along with the cost %.

Process Date

Select the date for processing the report from the adjoining calendar button. The open or close TD accounts till the process date is displayed. If the process date is not specified, then the open or closed TD accounts till current system date are shown.

Click ‘Exit’ to return to the Reports Browser.

10.3.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The following detail block elements are displayed in the report:

Field Name

Field Description

Account Class

This indicates the account class code

Class Name

This indicates the class name

Currency

This indicates the currency of transaction

Status

This indicates the status of the TD account

Account Number

This indicates the TD account number

Customer ID

This indicates the unique id of the customer

Customer Name

This indicates the name of the customer

Open Date

This indicates the date on which the account was opened

Maturity Date

This indicates the maturity date of the deposit account

Deposit Tenor

This indicates the deposit tenor, in days, months, and years.

Interest Rate

This displays the interest rate applicable to TD account

Interest rate based on cumu­lative amount

This indicates Y/N, based on whether the interest rate is based on cumulative rate or not.

Maturity Amount

This displays the maturity amount of the TD

Principal Amount

This indicates the total Principal Amount of the deposit account

Accrued Interest

This indicates the interest accrued for the deposit account

10.4 Large FD Report

This report provides customer-wise details of large time deposits beyond the given amount criteria. You have an option to print and view the report in pdf or excel format.

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

Specify the following details here:

Branch Code

Select the branch code for which the report needs to be generated from the adjoining option-list. The list displays all valid branch code s. You have an option to select all the branches or a single branch.

Currency

Select the currency code from the adjoining option-list. The list displays all valid currency codes maintained in the system. By default the value ‘ALL’ will be displayed.

Amount Exceeding

Specify the deposit amount here. The report generated will include only those accounts which exceed the deposit amount specified here.

Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.4.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

Customer with deposit amount total exceeds

This indicates the TD accounts of the customer with deposit amount exceeding specified amount.

Branch Code

Indicates the branch for which report is generated

Branch Name

Indicates the name of the branch

Customer ID

This indicated the unique id of the customer whose TD accounts exceeds specified amount

Customer Short Name

This indicates the short name of the customer

Account Currency

This indicates the currency of the TD account

Account Number

Indicates the TD account of the customer whose current availa­ble balance exceeds the specified limit

Interest rate

This displays the interest rate of the account

Maturity Amount

This displays the maturity amount based on the display at the TD level

Deposit amount

This indicates the deposit amount

Interest Rate Based on Cumulative Amount

This indicates whether the interest rate for the deposit is arrived using cumulative amount or not.

10.5 Deposit Detail Summary by Total Amount Report

This report provides a summary of currency-wise deposit details. You have an option to print and view the report in pdf or excel format.

You can invoke ‘Deposit Detail Summary by Total Amount’ screen by typing ‘TDRDDSUM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the following details here:

Processing Date

Select the date on which the report has to be processed, from the adjoining calendar button.

Branch Code

Select the branch code for which the report needs to be generated, from the adjoining option-list. The list displays all valid branch codes. You have an option to select all the branches or a single branch.

For the selected branch, currency-wise the deposit amount and number of deposits for previous month and current month are displayed along with the cost %.

10.5.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

Currency

This indicates the interest booking account currency

No. of Deposits

Displays the currency-wise number of deposits for a branch for the previous month

Previous month Deposits

This indicates the previous month deposits

Cost (% per.annum)

This indicates the cost percentage per annum

Cost percentage per annum for previous month = (Previous month deposit amount x 100) / (Sum of Deposit Amount) for a specific currency for a branch with start date from first day of the current financial year till date).

No of deposits

This indicates the currency-wise no. of deposits for a branch for the current month

Current month Deposits

This indicates the current month deposits

Cost (% per.annum)

This indicates the cost percentage per annum

Cost percentage per annum for current month = (Current month deposit amount x 100) / (Sum of Deposit Amount) for a specific currency for a branch with start date from first day of the current financial year till date).

10.6 Interest Paid Report

This is a report of term deposits interest paid for the day. In this report accounts are grouped Account class wise and interest type wise. This report is generated at BOD.

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

Branch Code

Specify the branch code. The system will generate the interest paid report for the branch code that you have selected. If the branch code is not specified, then all the branch accounts are shown in the report.

10.6.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information grouped by branch code:

Field Name

Field Description

Branch Code

Indicates the branch for which report is taken.

Account Class Code

This indicates the Account Class Code

Account Class Name

This indicates the name of the account class

Currency

This indicates the account currency

Account Number

This indicates the account number.

Interest rate

This displays the interest rate of the account

Maturity Amount

This displays the maturity amount as per new calculation

Customer Name

Indicates the customer name

Payment Method

Indicates the payment method defined at IC product level for the TD account.

Interest Paid today

Indicates the interest liquidated and due for today. This field will be displayed only on the day the interest is liquidated.

Interest Paid till date

Indicates the total interest liquidated till date

Interest Rate Based on Cumulative Amount

This indicates whether the interest rate for the deposit is arrived using cumulative amount or not.

Following elements will be displayed for Totals:

Field Name

Field Description

Product Wise Total (Interest Paid Today)

This indicates the product wise Account class total for interest paid today (in ACY)

Product Wise Total (Interest Paid To Date)

This indicates the product wise Account class total for interest paid to date (in ACY)

Currency Wise Total (Interest Paid Today)

This indicates the Currency total for Interest paid Today (in ACY)

Currency Wise Total (Interest Paid to Date)

This indicates the Currency total for interest paid To date (in ACY)

Branch Wise Total (Interest Paid Today)

This indicates the Branch total for Interest paid Today (in ACY)

Branch Wise Total (Interest Paid to Date)

This indicates the Branch total for Interest Paid To Date (in ACY)

10.7 TD Statement of Accounts Report

This is a report all financial transactions that are customer initiated along with the interest payout and tax deduction if any that has taken place in a time deposit account. There are multiple financial transactions like deposits, interest pay out etc. that takes place in a time deposit account. Some of these will be customer initiated while others may be done by the system for auto renewal, sweep transactions, etc. The customer needs to get a list of such transactions that have taken place in his/her account along with key transaction details like date transacted, description, maturity date of the deposit etc. This report is generated monthly at EOFI.

You can invoke ‘TD Statement of Accounts Report’ screen by typing ‘TDRSOACC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Branch Code

Specify the branch code. The system will generate the interest paid report for the branch code that you have selected. On failure to specify the branch code the system generates the report for the accounts of all branches.

10.7.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the Report

The report will have the following elements:

Field Name

Field Description

Customer No

This indicates the customer number

Customer Name

This indicates the name of the Customer

Address

This indicates the address of the Customer

Account No.

This indicates the customer account number

Current Balance

This indicates the current balance in the account

Transaction Date

This indicates the date of transaction

Formula Number

This indicates the formula number

Goal Reference Number

This indicates the identification number of the goal that has been captured from channels.

Product

This indicates the product code

Accrual Amount

This indicates the accrual amount for each transaction date

Cumulative Accrual Amount

This indicates the cumulative accrual amount by adding up the accruals for each transaction date

Dr/Cr

This indicates the amount credited or debited for interest, penalty or tax

Interest rate

This displays the interest rate of the account

Maturity Amount

This displays the maturity amount based on the tenor of the TD

User ID

This indicates the identification of the user

Auth ID

This indicates the identification of the authorizer

10.8 TD Account Class Summary Report

This summary report provides MIS information like principal amount, interest amount etc. with respect to term deposit accounts of the bank. This is a GL-wise, currency wise Account class summary report for all the branches. This report provides information about Account class Code, Account class Name, Total Accounts, Principal Balance, Interest Accrued. The totals are also provided.

You can invoke ‘TD Account class Summary ‘screen by typing ‘TDRPRSUM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Branch Code

Specify the branch code. The system will generate the TD account class summary report for the branch code that you have selected.

10.8.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

GL Type

This indicates the GL Type

GL Code

This indicates the GL Code

CCY

This indicates the currency for the respective GL

Account Class Code

This indicates the Account Class code

Account Class Name

This indicates the account class name

Total Accounts

This indicates the Total Accounts

Maturity Amount

This displays the maturity amount as per new calculation

Principal Balance

This indicates the Principal Balance in the accounts

Interest Accrued

This indicates the Interest Accrued for the accounts

Following elements will be displayed for Totals:

Field Name

Field Description

Principal Balance

This indicates the total Principal Balance of the accounts

Interest accrued

This indicates the total Interest accrued for the accounts

10.9 Term Deposits Opened for the Period Report

This report list the term deposit accounts which are opened for the given period, and that are currently on open status.

You can generate this report using ‘TD Account Opened Report’ screen by typing ‘TDROPEN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the following details here:

From Date

Enter the TD accounts which are opened from this date. However by default the system displays the current application date.

To Date

Enter the TD accounts which are opened till this date. However by default the system displays the current application date.

Branch

Specify the branch code of the TD account. The adjoining option list displays the list of all the valid TD/RD branch codes maintained in the system. You can choose the appropriate one.

Account Class

Specify the account class of TD account. The adjoining option list displays the list of all the valid TD/RD account classes maintained in the system. You can choose the appropriate one.

Customer

Specify the customer number of the customer. The adjoining option list displays the list of all the valid customer numbers maintained in the system. You can choose the appropriate one.

Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.9.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

Account No

This indicates the account number

Customer No

This indicates the customer number for whom TD is opened

Customer Name

This indicates the Name of the TD account holder

Date of Open

This indicates the TD account opened date

Value Date

This indicates the Value Date of the TD account

Deposit Amount

This indicates the Deposit Amount

Deposit Term

This indicates the TD Tenor in days, months & years

TD Maturity Date

This indicates the Maturity date of the TD account

Total Interest Payable

This indicates the Interest Amount

(This will show interest amount on the maturity date.)

Maturity Amount

This displays the maturity amount as per new calculation

Product Code

This indicates the Account Class code of the TD account

Deposit Currency

This indicates the currency under which TD is opened

Goal Reference Num­ber

This indicates the identification number of the goal that provided by external channels.

Currency Total

This indicates the Currency-wise total for deposit amount, Inter­est Payable and Maturity Amount

Close on Maturity

This will show whether TD will be closed on maturity

Auto Rollover

This will show whether TD will be automatically rolled over

Interest Rate

This displays the interest rate of the account

Stock Catalog Cd

This displays Stock Catalog Code for the TD certificate number

Certificate No

This indicates the certificate number

Duplicate Issue

This indicates/N based on the duplicate certificate issued for TD account.

Interest Rate Based on Cumulative Amount

This indicates whether the interest rate for the deposit is arrived using cumulative amount or not.

10.10 Term Deposits Closed for the Period Report

This report list the term deposit accounts which are closed for the given period, and that are currently on open status.

You can generate this report using ‘TD Account Closed Report’ screen by typing ‘TDRCLOSE’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the following details here:

Branch Code

Specify the branch code of the TD account. The adjoining option list displays the list of all the valid TD/RD branch codes maintained in the system. You can choose the appropriate one.

Based on the branch code, the system displays the branch name.

Customer

Specify the customer number of the customer. The adjoining option list displays the list of all the valid customer numbers maintained in the system. You can choose the appropriate one.

Based on the customer code, the system displays the name of the customer.

Account Class

Specify the account class of TD account. The adjoining option list displays the list of all the valid TD/RD account classes maintained in the system. You can choose the appropriate one.

The system displays the description of the account class.

From Date

Enter the TD accounts which are closed from this date. However by default the system displays the current application date.

To Date

Enter the TD accounts which are closed till this date. However by default the system displays the current application date.

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:

Choose the appropriate one.

Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.10.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

Account No./Deposit No.

This indicates the TD account Number

Customer Name

This indicates the Name of the TD account holder

Closure Date

This indicates the TD account closed date

Amount of deposit

This indicates the Deposit Amount

Maturity Date

This indicates the Maturity date of the TD account

Proceeds credit to

This will show the Payment Mode of the TD account

Interest Rate

This displays the interest rate of the account

Goal Reference Number

This indicates the identification number of the goal received from external channels.

Interest Amount

This indicates the Interest Amount, accrued and liquidated for the closed TD account

(This will show the actual interest amount which has been paid to the customer)

Maturity Amount

This displays the maturity amount as per new calculation

Branch

This indicates the Branch Name

Product Code

This indicates the Account Class code of the TD account

Deposit Currency

This indicates the deposit currency

Stock Catalogue Code

This displays Stock Catalog Code for the TD certificate num­ber

Certificate Number

This indicates the certificate number

Duplicate Issue

This indicates duplicate issue

10.11 Term Deposits Account Renewed Report

This report lists the term deposit accounts which are renewed for the given period. You can generate this report using ‘TD Account Renewed Report’ screen by typing ‘TDRRENEW’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the following details here:

From Date

Enter the TD accounts which are renewed from this date. However by default the system displays the current application date.

To Date

Enter the TD accounts which are renewed till this date. However by default the system displays the current application date.

Branch Code

Specify the branch code of the TD account. The adjoining option list displays the list of all the valid TD/RD branch codes maintained in the system. You can choose the appropriate one.

Account Class

Specify the account class of TD account. The adjoining option list displays the list of all the valid TD/RD account classes maintained in the system. You can choose the appropriate one.

Customer

Specify the customer number of the customer. The adjoining option list displays the list of all the valid customer numbers maintained in the system. You can choose the appropriate one.

Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.11.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the report contains the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

Product Code

This indicates the product code and list TD accounts renewed under it

Product Title

This indicates the product title

Account Number

This indicates the TD account Number

Customer Name

This indicates the name of the customer

Customer Number

This indicates the customer number of the renewed TD

Deposit Currency

This indicates the currency of the deposited amount

TD Opened Date

This indicates the term deposit opened date

Value Date

This indicates the Value date of TD account

Interest rate

This displays the interest rate of the account

Deposit Amount

This indicates the Deposit Amount

Period of Deposit

This indicates the TD renewal Period

Due Date

This indicates the Maturity date or renewal of the TD account

Total Interest Pay

This indicates the Interest Amount

(This will show interest amount on the maturity date)

Maturity Value

This displays the maturity amount as per new calculation

Interest Rate Based on Cumulative Amount

This indicates whether the interest rate for the deposit is arrived using cumulative amount or not.

10.12 Term Deposits Account Maturity Report

This report lists the term deposits that will be matured for the given period. You can generate this report using ‘TD Account Maturity Report’ screen.

To invoke this screen, type ‘TDRMATR’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details here:

From Date

Enter the From date. This should be greater than the current application date

To Date

Enter the To date. This should be greater than the current application date

Branch Code

Specify the branch code of the TD account. The adjoining option list displays the list of all the valid TD/RD branch codes maintained in the system. You can choose the appropriate one.

Account Class

Specify the account class of TD account. The adjoining option list displays the list of all the valid TD/RD account classes maintained in the system. You can choose the appropriate one.

Customer

Specify the customer number of the customer. The adjoining option list displays the list of all the valid customer numbers maintained in the system. You can choose the appropriate one.

Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.12.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the generated report will have the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the report

The generated report will have the following information:

Field Name

Field Description

Account Number/Deposit Number

This indicates the TD account Number

Customer Name

This indicates the Name of the TD account holder

Date of Open

This indicates the TD account opened date

Value Date

This indicates the Value Date of the TD account

Deposit Amount

This indicates the Deposit Amount

Maturity Date

This indicates the Maturity date of the TD account

Deposit Term

This indicates the TD Tenor (Maturity Date – Interest Start Date)

Total Interest Payable

This indicates the Interest Amount

(This will show interest amount on the maturity date)

Goal Reference Num­ber

This indicates the identification number of the goal provided by the external channels.

Interest rate

This displays the interest rate applicable for the account

Maturity Amount

This displays the maturity amount for the tenor of TD

Branch

This indicates the Branch Name

Product Code

This indicates the product code of the TD account

Product Currency

This indicates the Currency of the TD account class

Currency Total

This indicates the Currency-wise total for deposit amount, Interest Payable and Maturity Amount

Auto Rollover

Will indicate whether the TD is Auto Rollover or not

Stock Catalogue Code

This displays Stock Catalogue Code for the TD certificate num­ber

Certificate Number

This indicates the certificate number

Duplicate issue

This indicates Y/N based on the duplicate certificate genera­tion for TD account

Interest Rate Based on Cumulative Amount

This indicates whether the interest rate for the deposit is arrived using cumulative amount or not.

10.13 Term Deposit Account Maturity Date Change Report

You can generate the TD account maturity date change report for term deposits that have the maturity date adjusted due to adhoc holiday change. You can generate this report using the ‘Term Deposit Maturity Date Changed Due to Change in Holiday Calendar’ screen.

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

Specify the following details here:

From Date

Specify the date from which the report for TD account maturity date change should be generated. By default, system displays the current Application date.

To Date

Specify the date till which the report for TD account maturity date change should be generated. By default, system displays the current Application date.

Branch Code

Specify the branch code of the TD account. The adjoining option list displays all valid TD branch codes maintained in the system. You can choose the appropriate one.

Deposit Account Number

Specify the account number of the term deposit. The adjoining option list displays tall valid deposit account numbers maintained in the system. You can choose the appropriate one.

Customer

Specify the customer number here. The adjoining option list displays all the valid customer numbers maintained in the system. You can choose the appropriate one.

Report Format

Select the format in which you want to report to be generated from the options provided in the drop-down list. This list displays the following values:

Report Output

Select the output for the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select the location where you want the report to be generated from the options provided in the adjoining drop-down list. This list displays the following values:

Printer

Specify the name of the printer or select it from the option list provided. The adjoining option list displays all the configured printers.

This is applicable only if you have specified the output as 'Print'.

Click the ‘Ok’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.13.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the generated report will have the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

User ID

Operator generating the Report

Report From Date

Date from which the report is generated

Report To Date

Date till which the report is generated

Body of the report

The generated report will have the following information:

Field Name

Field Description

Customer ID

This indicates the customer ID

Customer Name

This indicates the customer name

Deposit Account Number

This indicates the deposit account num­ber

Account Description

This indicates the account description

Account Branch

This indicates the account branch

Account Currency

This indicates the account currency

Deposit Amount

This indicates the deposit amount

Deposit Tenor

This indicates the deposit tenor

Deposit Maturity Date

This indicates the deposit maturity date

Maturity Date Adjusted Due to Holiday

This indicates the maturity date adjusted due to a holiday

Account Open Date

This indicates the account opening date

Account Class

This indicates the account class

10.14 TD Account Maturity Date Falling on a Holiday Report

You can generate this report using the ‘Term Deposit Maturity Date Falling on a Holiday due to an Adhoc change in Holiday Calendar’ screen.

This report displays the list of Term deposit for which the maturity date falls on a holiday due to Adhoc holiday change.

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

Specify the following details here:

From Date

Specify the date from which the report for TD account maturity date change should be generated. By default, system displays the current Application date.

To Date

Specify the date till which the report for TD account maturity date change should be generated. By default, system displays the current Application date.

Branch Code

Specify the branch code of the TD account. The adjoining option list displays all valid TD branch codes maintained in the system. You can choose the appropriate one.

Deposit Account Number

Specify the account number of the term deposit. The adjoining option list displays tall valid deposit account numbers maintained in the system. You can choose the appropriate one.

Customer

Specify the customer number here. The adjoining option list displays all the valid customer numbers maintained in the system. You can choose the appropriate one.

Report Format

Select the format in which you want to report to be generated from the options provided in the drop-down list. This list displays the following values:

Report Output

Select the output for the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select the location where you want the report to be generated from the options provided in the adjoining drop-down list. This list displays the following values:

Printer

Specify the name of the printer or select it from the option list provided. The adjoining option list displays all the configured printers.

This is applicable only if you have specified the output as 'Print'.

Click the ‘Ok’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.14.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the generated report will have the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

User ID

Operator generating the Report

Report From Date

Date from which the report is generated

Report To Date

Date till which the report is generated

Body of the report

The generated report will have the following information:

Field Name

Field Description

Customer ID

This indicates the customer ID

Customer Name

This indicates the customer name

Deposit Account Number

This indicates the deposit account num­ber

Account Description

This indicates the account description

Account Branch

This indicates the account branch

Account Currency

This indicates the account currency

Deposit Amount

This indicates the deposit amount

Deposit Tenor

This indicates the deposit tenor

Deposit Maturity Date

This indicates the deposit maturity date

Account Open Date

This indicates the account opening date

Account Class

This indicates the account class

Generate Advice

Indicates whether the advice should be generated or not.

10.15 TD Account Maturity Date not Adjusted Report

This report displays the list of term deposit for which the maturity date is not adjusted and falls on a holiday due to the following reasons:

You can generate this report using the ‘Term Deposit Maturity Date Not Adjusted’ screen. You can invoke this screen by typing ‘TDRMNADJ’ in the field at the top-right corner of the Application tool bar and clicking the adjoining arrow button.

Specify the following details here:

From Date

Specify the date from which the report for TD account maturity date change should be generated. By default, system displays the current Application date.

To Date

Specify the date till which the report for TD account maturity date change should be generated. By default, system displays the current Application date.

Branch Code

Specify the branch code of the TD account. The adjoining option list displays all valid TD branch codes maintained in the system. You can choose the appropriate one.

Deposit Account Number

Specify the account number of the term deposit. The adjoining option list displays tall valid deposit account numbers maintained in the system. You can choose the appropriate one.

Customer

Specify the customer number here. The adjoining option list displays all the valid customer numbers maintained in the system. You can choose the appropriate one.

Report Format

Select the format in which you want to report to be generated from the options provided in the drop-down list. This list displays the following values:

Report Output

Select the output for the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select the location where you want the report to be generated from the options provided in the adjoining drop-down list. This list displays the following values:

Printer

Specify the name of the printer or select it from the option list provided. The adjoining option list displays all the configured printers.

This is applicable only if you have specified the output as 'Print'.

Click the ‘Ok’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.15.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The contents of the report are discussed under the following heads:

Header of the report

The header of the generated report will have the following information:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

User ID

Operator generating the Report

Report From Date

Date from which the report is generated

Report To Date

Date till which the report is generated

Body of the report

The generated report will have the following information:

Field Name

Field Description

Customer ID

This indicates the customer ID

Customer Name

This indicates the customer name

Deposit Account Number

This indicates the deposit account num­ber

Account Description

This indicates the account description

Account Branch

This indicates the account branch

Account Currency

This indicates the account currency

Deposit Amount

This indicates the deposit amount

Deposit Tenor

This indicates the deposit tenor

Deposit Maturity Date

This indicates the deposit maturity date

Account Open Date

This indicates the account opening date

Reason for not adjusting

This indicates one of the following reason for not adjusting the maturity date:

  • Block exists
  • Breach of minimum tenor
  • Breach of maximum tenor

Note

You should manually take appropriate action If maturity date is not adjusted due to a block.

10.16 Customer-wise Tax Deduction Report

You can generate term deposit tax deduction EOD reports for specific customers. This report provides the details of the tax deducted at source for a customer for the term deposits. The system generates this report during beginning of day operations.

This report can be generated for a specific branch, as of the date of tax deduction.

10.16.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The report contains the following details:

Header

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body

Field Name

Field Description

Customer ID

Customer number

Account Title

Account class description

Account No

TD account number

Account Currency

TD account currency

Tax Type

IC rule description

TDS Date

Tax deduction date

Interest in Account Currency

Interest in account currency

Tax Deduced in Account Currency

Tax deducted in account currency

Interest in Local Currency

Interest in local currency

Tax in Local Currency

Tax in local currency

 

10.17 Term Deposits Exceeding Lien Limits Report

You can generate a report of term deposits exceeding the lien reports using ‘Term Deposits Exceeding Lien Limit’ screen. To invoke the screen, type ‘STRLELMT’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.

Specify the following details:

Branch Code

Specify the branch code for which you are generating the report. The option list displays all valid branch codes available in the system. Choose the appropriate one.

Based on the branch code selected, the system displays the name of the branch.

Customer

Specify the CIF of the customer for whom the report is being generated. The option list displays all valid customer numbers that are applicable. Choose the appropriate one.

Based on the customer number, the system displays the name of the customer.

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:

Choose the appropriate one.

Once you have specified the details, click ‘OK’. The system generates the report based on the parameters specified.

10.17.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The term deposit exceeding lien limit report contains the following details:

Header Elements

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body Elements

Field Name

Field Description

RM Id

Relationship Manager ID

Customer No

CIF Number

Customer Name

Customer Name

Deposit Amount

Deposit Amount

Deposit Term

Deposit Term in Days, Months and Years

Account Number

Account Number

Td Maturity Date

Maturity date of the TD

Total Interest Payable

Total Interest Payable

Maturity Amount

Maturity Amount

Lien Limit %

Lien Limit % at bank level

Lien %

Lien percentage utilized

Lien Amount

Lien Amount

Total Interest Payable

Total Interest Payable

Maturity Amount

Maturity Amount

 

10.18 Unclaimed Deposits Transferred for a Day

You can generate a report for the unclaimed deposits transferred during a day. If you do the required maintenances and batch set up, you can generate the ‘Unclaimed Deposits Transferred for a Day’ report as part of EOD operations.

For further details on report parameter and batch maintenances, refer to the Reports User Manual.

10.18.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 report is as follows:

Header

The following details are displayed in the header section:

Field Name

Field Description

Branch

Current Branch Code and branch Name

Branch Date

Current Branch Date

Run Date & Time

Current Run Date and Time

User ID

Operator generating the Report

Module

Module of the Report

Page No

Page No. of the Report

Body of the Report

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

Field Name

Field Description

Product Code

Indicates the product code

Product Title

Indicates the product title

Currency

Indicates the currency of the transaction

Account Number

Indicates the account number

Customer Name

Indicates the name of the customer

Deposit/Renewal Date

Indicates the deposit renewal date

Maturity Date

Indicates the maturity date

Grace Days

Indicates the grace days

Outstanding Principal

Indicates the outstanding principal

Outstanding Interest

Indicates the outstanding interest

10.19 Term Deposits Topped-up During the Period

You can generate the Term Deposit Top-up report for TD accounts for which the top-up is made. This report can be generated for all branches or for specific branch for account.To invoke the screen, type ‘TDRTOPUP’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.

Specify the following:

Branch Code

Select the current branch code from the adjoining option list.

Branch Name

The branch name of the selected branch code is displayed here.

Account Number

Select the account number from the adjoining option list.

Customer Number

Select the customer number from the adjoining option list.

Customer Name

The customer name of the selected customer is displayed here.

From Date

Specify the date from which the report for topped-up TD account should be generated.

To Date

Specify the date till which the report for topped-up TD account should be generated.

Report Format

Select the format in which you want to report to be generated from the options provided in the drop-down list. This list displays the following values:

Report Output

Select the output for the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select the location where you want the report to be generated from the options provided in the adjoining drop-down list. This list displays the following values:

Printer

Specify the name of the printer or select it from the option list provided. The adjoining option list displays all the configured printers.

This is applicable only if you have specified the output as 'Print'.

Click the ‘Ok’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.

10.19.1 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. The report contains the following details:

Header

The following details are displayed in the header section:

Field Name

Field Description

Customer Number

Customer for whom the TD is opened

Branch Code

Current Branch Code

Account Number

TD Account number for which top-up is made

Report from Date

The start date for generating the Report

Report to Date

The end date for generating the Report

Body of the Report

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

Field Name

Field Description

Deposit Account Number

Indicates the TD Deposit account number

Account Description

Indicates the description of the TD Deposit account

Customer Number

Indicates the customer number

Account Open Date

Indicates the account opening date

Top-up Date

Indicates the top-up date of the account

Top-up Value Date

Indicates the value date of the TD top-up

Top-up Amount

Indicates the account opening date

Total Deposit Amount

Indicates the total deposit amount

Interest Rate

Indicates the rate of interest

Maturity Date

Indicates the date of TD maturity

Maturity Amount

Indicates the TD amount on deposit maturity

10.20 Ad-Hoc Combined Statement

You can generate ad-hoc combined statement through ‘Ad-Hoc Combined Statement’ screen.You can invoke this screen by typing ‘STDCDSMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Customer No

Select the customer number from the adjoining option list.

Customer Name

The system displays the customer name.

Statement ID

Select the statement ID from the adjoining option list.

Balance

You can select the balance to view based on the book date or value date.

Based on Date Range

From Date

Specify the from date for the combined statement generation.

To Date

Specify the to date for combined statement generation.

Print Options

You can print, view or spool the statement.

Apply Online Charges

Check this box to indicate that the charges needs to be applied to generate the ad-hoc account statement.

Send to Customer

Check this box to send the statement to the customer.

Processing Ad-Hoc Combined Statement

You can process the ad-hoc combined statement by doing the following:

10.20.1 Charge Details

You can view, waive or modify the online charges computed for the generation of the combined statement through the Charges screen. You can invoke this screen by typing ‘CSCONLEVT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button or click ‘Charges’ on the ‘Ad-Hoc Combined Statement’ screen.

The system displays the following details in the charges screen:

Note

The following maintenances are necessary for the online charge calculation:

10.20.2 Combined Statement Generation Report

You can generate Combined Statement Report using ‘Combined Statement Report’ screen. You can invoke this screen by typing ‘RPRCNDLG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Customer No

The system displays the customer number.

Statement ID

The system displays the statement ID.

Contents of the Report

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

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Branch Date

Indicates the date of Branch in which report is taken

Page No

Displays Page No out of total No of pages in report

Module

Indicates the Module of the Report

Report Run Date

Indicates Current System Date

Report Run Time

Indicates Current System Time

Customer Name

Indicates the name of the customer

Customer Address

Indicates the address of the customer

Account Summary Details

Indicates the summary details for CASA, TD and CL

Body of the Report

The body of the report displays:

For further details on combined statement refer section ‘Maintaining Combined Statements’ section in ‘Generating Account Statements’ chapter of ‘CASA’ user manual.