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.
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.
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 generated in the report |
Customer Name |
This indicates the full name of the customer based on the customer 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. |
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.
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 cumulative 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 |
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.
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 available 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. |
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 %.
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). |
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.
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) |
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.
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 |
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.
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 |
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.
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 Number |
This indicates the identification number of the goal that provided by external channels. |
Currency Total |
This indicates the Currency-wise total for deposit amount, Interest 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. |
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.
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 number |
Certificate Number |
This indicates the certificate number |
Duplicate Issue |
This indicates duplicate issue |
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.
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. |
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.
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 Number |
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 number |
Certificate Number |
This indicates the certificate number |
Duplicate issue |
This indicates Y/N based on the duplicate certificate generation 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. |
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.
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 number |
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 |
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.
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 number |
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. |
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.
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 number |
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.
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.
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 |
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.
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 |
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.
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 |
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.
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 |
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.
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.
You can process the ad-hoc combined statement by doing the following:
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:
You can generate Combined Statement Report using ‘Combined Statement Report’ screen. You can invoke this screen by typing ‘CSRCSTAD’ 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.
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.
You can generate a report that shows the details of all Term Deposits where the rate is modified by the user in the pay-out or pay-in grid. So all Term Deposits where Original and Applied Exchange Rate are different they are displayed in this Report. You can invoke this screen by typing ‘TDRRTMOD’ in the field at the top right corner of the application tool bar and clicking on the adjoining arrow button.
Enter the following details:
Branch Code
Select branch code of the account number from the list of values.
Branch Description
The description of the branch based on the branch code you select.
Customer
Select the customer from the list of values. The list displays all the valid customer numbers maintained in the system.
Customer Name
The customer's name based on the account number you select.
Deposit Account Number
Select the customer's account number from the list of values.
From Date
Select the start date using the calendar.
To Date
Select the end date using the calendar.
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
Enter 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.
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 ID |
The customer ID for whom the TD is opened |
Account Branch |
The account branch |
Deposit Account Number |
The TD account number for which the rate is modified. |
Report from Date |
The start date for generating the report |
Report to Date |
The end date of the report |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch |
The TD account branch. |
Customer ID |
The ID of the customer for whom the rates are modified. |
Customer Name |
The name of the customer for whom the rates are modified. |
Deposit Account Number |
The TD Deposit account number |
Account Description |
The description of the TD Deposit account |
Deposit Account Currency |
The currency of the TD account. |
Pay IN (I)/OUT (O) |
The mode used for the user defined rates. |
Offset Account |
The offset account number. |
Offset Currency |
The cuurency of the offset account |
Offset Amount |
The amount paid for the TD account, in the offset account currency. |
Original Exchange Rate |
The FX rate picked up by the system. |
Applied Excahnge Rate |
The FX rate entered by the user. |
Variance |
The difference between the Original and Applied Exchange rates. |
Transaction Date |
The date of transaction. |
Maturity Date |
The date of the TD maturity. |