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:

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.