The following are the reports that you can generate for the Deposits module:
In the Application Browser these reports are available under the option Reports for the Deposits module.
This chapter contains the following sections:
This section contains the following topics:
The maturity report gives information about the details of a contract that is:
To invoke the screen, choose ‘Report’ from the Application Browser. Thereafter, choose ‘Corporate Deposits’ and ‘Maturity’ under it. You can also invoke this screen by typing ‘LDRPMATR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The report will be generated for all contracts maturing during the period you specify. However to generate a report that includes contracts satisfying certain parameters only, you can specify the following:
Product type
You can generate the Maturity report for a specific product type or for all product types. You can choose to generate the report either for loans, commitments, deposits, or for a combination of any two or for all of them.
Product
You can generate a product-wise report. For instance you can generate a report on a short term Fixed Deposit having a 90 day tenor.
Currency
Under specific Product type(s) and product(s), you can choose to generate reports in specific currency(s).
Customer
You can generate this report for specific customer(s).
Specifying the period
While generating the report you can specify the period (i.e., the From and To dates) for which the report has to be generated.
Maturity type
You can generate the report only for a particular Maturity Type. The Maturity type of a deposit can be:
For instance if you generate the report only for call deposits or notice deposits the due date column will display call or notice depending on the maturity type that you have specified. Only for deposits with a fixed maturity date will the due date be displayed.
Specifying the schedule date for reporting
You can generate the report based on the schedule date for which payment is due.
Liquidation Mode
Components of a deposit can be liquidated automatically or manually. In auto liquidation a schedule will be automatically liquidated on the day it falls due. In manual liquidation a schedule amount has to be liquidated manually.
You can generate the report based on the liquidation mode that you have specified. The report can be generated only for deposits with auto liquidation or you can generate the report for deposits that have to be manually liquidated.
Interim Schedules
You can generate the report for only those deposits with interim schedules for the specified period. When the maturity date and the due date of the contract are not the same it is an interim schedule. When the maturity date and the due date of the contract are the same then the report generated is for maturity schedule.
For each schedule, the due date and maturity date will be different. However if it is the last schedule then the due date and the maturity date have to be the same.
The report options that you selected while generating the report are printed at the beginning of the report.
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
The report is sorted on the Due Date in the ascending order.
Due Date
The Due date is reported when a schedule is being reported. When the maturity of a deposit is being reported, the Due Date will indicate the Maturity Date. For a call contract this will be Call. Similarly for a notice contract this will be Notice.
Customer
This is the CIF ID of the customer involved in the deposit.
Contract reference number
This is the reference number of the deposit being reported.
Maturity Date
When the maturity date and the due date of the deposit are not the same it is an interim schedule and not the maturity schedule.
Component
This is the component of the deposit against which the payment due is being reported. If more than one component falls due on the same day they will be reported one by one.
Currency
This is the SWIFT code of the contract currency.
Due Amount
This is the amount that falls due on the Due Date for the component, as per the schedule defined in the contract. This amount does not consider the unpaid amounts that belong to earlier schedules.
EURO Eqv.
This is the EURO equivalent of the due amount.
Outstanding Amount
This is the total outstanding amount that the customer has to repay. This amount includes amounts belonging to earlier schedules that are still due. In case the customer has made pre-payments the outstanding amount can be less than the due amount.
EURO Eqv.
This is the EURO equivalent of the outstanding amount.
This section contains the following topics:
A forward contract is a deposit with a future value date. The value date is the date on which the deposit takes effect. The tenor of the deposit will begin on this date. All accounting entries for the deposit, all calculations for interest and all the other components based on the tenor will be made from this date onwards.
The forward contract report gives details of all the deposits with a future value date. Only contracts that take effect on a date later than or same as the specified date are included in the report.
You can select the following options based on which the report can be generated.
To invoke the screen, choose ‘Report’ from the Application Browser. Thereafter, choose ‘Corporate Deposits’ and ‘Corporate Deposits Forward Contracts Report’ under it. You can also invoke this screen by typing ‘LDRPFRWD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Specifying the period
While generating the report you can specify the period (i.e., the From and To dates) for which the report has to be generated.
Product type
You can generate the Forward contracts report for a specific product type or of all product types. For instance you can specify the type of product whose details the report should contain. It could be either for loans, commitments or deposits.
The report options that you selected while generating this report are printed at the beginning of the report.
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
The report can be sorted on the Value Date or the Contract Reference Number in the ascending order.
Product Type
This is the type of product for which the report is being generated.
Contract Reference Number
This is the reference number of the deposit being reported.
Counterparty Number
This is the CIF ID of the customer involved in the deposit.
Counterparty Name
This is the name of the customer involved in the deposit.
Amount
This is the principal amount involved in the deposit.
Euro Eqv.
This is the amount converted into EURO
Value Date
This is the date on which the deposit takes effect.
Maturity Type
This is the maturity type of the deposit. It could be fixed, call or notice.
Maturity Date
This is the date on which the deposit matures. The maturity date is generated in the report only in case of fixed maturity deposits.
Notice Days
The number of days of notice will be generated in the report if it is a notice deposit.
Apart from these details, the body of the report displays the following charge and interest details also.
Charge Details
The charge details are:
Interest Details
The interest details are:
This section contains the following topics:
Value Dated Amendments, are changes to the terms of a deposit which affect its financial details. The changes to the terms of a deposit take effect on a particular date, called the Value date. You can make changes to the various components of a deposit, like increase in the principal, change in interest rate, etc.
The Value Dated Amendments report gives details on any changes made to the terms of a deposit that come into effect on a future Value Date.
The options for which you can generate the report are as follows:
To invoke the screen, choose Report from the Application Browser. Thereafter, choose Corporate Deposits and Corporate Deposits Forward Changes Report - Options under it. You can also invoke this screen by typing ‘LDRPFWCH’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Specifying the period
While generating the report you can specify the period (i.e. the ‘From’ and ‘To’ dates) for which the report has to be generated. All the amendments that have been input and are due to come into effect during this period will be generated in the report.
Product type
You can generate the Value Dated Amendments report for a specific product type or for all product types. You can generate the report either for loans, commitments, deposits, or for a combination of any two or all of them.
The report options that you selected while generating this report are printed at the beginning of the report.
The contents of the Corporate Deposits Forward Changes Report - Options have been discussed under the following heads:
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
The report can be sorted on the Contract Reference number or the Value Date of the change, in the ascending order.
Contract reference number
This is the reference number of the deposit being reported.
Counter party
This is the CIF ID of the customer involved in the deposit.
Counter party name
This is the name of the customer involved in the deposit.
Maturity date
This is the date on which the deposit matures. The maturity date is reported only in case of fixed maturity deposits.
Value date
This is the date on which the changes specific to the deposit are to take effect.
Amount
This is the original principal amount involved in the deposit.
Currency
This indicates the contract currency.
Transaction Date
This is the date on which the deposit was disbursed.
Amendment date
This is the date, on which the changes that are defined are to take effect (value date of the amendment).
New maturity date
If the amendment being reported is for changing the maturity date of the deposit, the new maturity date will be reported.
Differential amount
This is the amount by which the total principal amount is increased.
Revolving flag
This is reported only for commitments. It reports whether the commitment is revolving or non-revolving.
Component name
This is the name given to the interest component.
New rate
If the amendment being reported is for changing the maturity date of the deposit, the new rate of the interest component is reported.
Old rate
This is the old rate of the main interest.
New rate code
If the deposit has floating interest and the amendment being reported is for a change in the rate code, the new floating rate code defined for the interest is reported.
Old rate code
This is the old floating rate code of the deposit.
New spread
If the deposit has a floating interest and the amendment being reported is for a change in the spread the new spread is reported.
Old spread
This is the old spread for the floating interest deposit
New amount
This is the new principal amount specified for the deposit.
Old amount
This is the original principal amount of the deposit
This section contains the following topics:
Contract events are events that have taken place during the tenor of a deposit.
Contract Events report gives a list of all the events that have taken place during the tenor of a deposit. The events are listed by their Value Date.
You can generate the report for the following options:
Specifying the period
While generating the report you can specify the period (i.e., the from and to dates), for which the report has to be generated. All the events that have taken place on the deposit during this period will be reported.
Reference number
You can generate the report based on the contract reference number. All the events that have taken place on the particular contract, for the specified period will be reported in the report.
To invoke the screen, go to ‘Report’ on the Application Browser. Click ‘Corporate Deposits’ and select ‘Contract Event’ under it. Otherwise, use the code ‘LDRPEVNT’ on the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
The contents of the Contract Event Details Report have been discussed under the following heads:
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
The report can be sorted on the Reference Number of the contract:
Product Code
This is the code of the product for which the details are being reported.
Reference Number
This is the reference number of the deposit being reported.
Counterparty
This is the CIF ID of the customer involved in the deposit.
Currency
This is the SWIFT code of the contract currency.
Event Code
This is the code of the event for which details are being reported.
Event Description
This is the description of the event.
Sequence No
This is the sequence number of the event.
Event Date
This indicates the date on which the event took place.
ICCF Event Date
This indicates the date on which the ICCF event took place.
Item Name
This indicates the name of the item.
Item Value
This indicates the value of the item.
The list of events for which the report will be generated is as follows:
Event Code | Event Description | ||
---|---|---|---|
BOOK | Booking | ||
INIT | Initiation | ||
CONF | Confirmation | ||
DELT | Deletion | ||
REVC | Reversal of Contract | ||
REVP | Reversal of Payment | ||
CAMD | Contract Amendment | ||
VAMB | Booking Value dated amendment | ||
VAMI | Initiating Value dated amendment | ||
IRRN | Rate Revision | ||
ACCR | ICCF Accrual | ||
LIQD | Liquidation | ||
ROLL | Rollover | ||
NOTC | Notice | ||
REAS | Reassign User | ||
STCH | Status Change | ||
SCDT | Schedule Date |
This section contains the following topics:
The Contract Retrieval report gives you comprehensive information about a deposit. Information about deposits that are active, liquidated and reversed can be retrieved through this report. You can generate the report for a variety of reasons.
You can generate the report for the following options:
Product type
You can generate the Contract Retrieval report for a specific product type or for all product types. You can choose to retrieve information only about loans, commitments, deposits, or for a combination of any two or for all of them.
Product
You can generate a product-wise report. For instance you can generate a report on a short term Fixed deposit having a 90 day tenor.
Currency
Under specific Product type(s) and product(s), you can choose to generate the report for deposits in a specific currency(s).
Customer
You can generate this report for specific customer(s).
Specifying the period
While generating the report you can specify the period (i.e. the ‘From’ and ‘To’ dates) for which the report has to be generated. The details of all the deposit made during the specified period will be generated in the report.
Maturity type
You can generate the report only for a particular Maturity Type. The Maturity type of a deposit can be:
You can generate the report either for fixed maturity deposit, call deposits or notice deposits, for a combination of one or more of them.
Specifying the maturity dates
If you have advanced or post-phoned the maturity date of the deposit, while generating the report you have to specify the original maturity date along with the new maturity date. You can do this by way of specifying the ‘From’ and ‘To’ maturity dates.
Contract status
You can generate the report based on the status of the deposit. For example, the status of the deposit could be active or liquidating. All the deposits with the specified status for the specific period will be reported. You can also generate the report for a combination of status codes.
Auth status
You can generate the report for deposits either with an authorized or unauthorized status.
To invoke the screen, choose ‘Report’ from the Application Browser. Thereafter, choose ‘Corporate Deposits’ and ‘Contract Retrieval’ under it. You can also invoke this screen by typing ‘LDRPRETR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The contents of the Contract Retrieval report have been discussed under the following heads:
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Product
This is the product for which the report is generated.
Description
This is the description of the product for which details are being reported.
Product type
This is the product type to which the generated report belongs.
Payment method
This is the method in which the payments are being made.
Contract reference number
This is the reference number of the deposit being reported.
Contract status
This is the current status of the deposit.
Outstanding amount
This is the total outstanding amount that the customer has to repay. This amount includes amounts, belonging to earlier schedules that are still due. In case the customer has made pre-payments, the outstanding amount may be less than the due amount.
EURO Equivalent
This is the EURO equivalent of the outstanding amount.
User Ref. No
This is the user reference number.
Customer
This is the name of the customer.
Related Ref No
This is the related reference number.
Contract Currency
This is the currency in which the contract is defined.
Contract Amount
This is the contract amount.
Original Start Date
This is the original start date of the contract.
Booking Date
This is the booking date of the contract.
Value Date
This is the value date of the contract.
Maturity Type
This is the type of maturity of the contract.
Maturity Date
This is the maturity date of the contract.
Notice Days
This is the notice days.
Tenor
This is the tenor of the contract
User Defined Status
This is the user defined status of the contract.
Auth Status
This is the authorization status of the contract.
Broker
This is the broker code of the contract
Cluster ID
This is the cluster ID.
Cluster Size
This is the size of the cluster.
Credit Line
This is the credit line of the contract.
Tax Scheme
This is tax scheme of the contract
Commitment Type
This is the type of commitment.
Schedule Type
This is the type of schedule.
Amortization Type
This is the type of amortization
Liquidation Mode
This is the mode of liquidation of the contract.
Rollover Allowed
This indicates if rollover is allowed for the contract.
Rollover Mode
This is the mode of rollover.
Rollover Count
This is the rollover count.
Status Control
This is the status control of the contract.
Template Status
This is the template status of the contract.
Component
This is the component of the deposit against which, the payment due is being reported. If more than one component falls due on the same day, then they will be reported one at a time.
Currency
This is the SWIFT code of the contract currency.
Rate type
This is the interest rate type of the deposit. It could be fixed, floating or special.
Code Usage
If the interest rate type is set to floating, then this indicates whether the rate usage is automatic or periodic.
Interest basis
This is the basis on which interest is calculated.
Rate code
If the interest rate type is set to floating, then the rate code defined for the deposit is reported.
Current rate (%)
This is the interest rate applicable for the component, as of the date of report generation.
Current spread
If the interest rate type is floating the current spread, applicable over the rate maintained, is reported as of today.
Flat amount
When the interest rate type is special the flat amount applicable is reported.
This section contains the following topics:
The Memo Accrual Function will give you the latest accrual amounts for all components of a contract for which accruals are applicable, without actually passing the accrual entries. Through this function you can generate the Memo Accrual Control journal.
You can generate the report for the following options:
Product
You can generate the report for specific products or all.
Accrual Processing Date
You can generate the report to get the accrual figures as of a specific date.
Apart from the header the following information is provided for each contract:
Accrual processing date
This is the date, as of which the accrual entries for the deposit were passed.
Contract reference number
This is the reference number of the deposit being reported.
Status
This is the current status of the deposit being reported.
Component
This is the component of the deposit against which accrual entries are being reported.
Currency
This is the SWIFT code of the contract currency.
Current accrual
This is the amount for which accruals are projected for the current month.
Outstanding accrual
This is the total amount that is due for the deposit, which is yet to be liquidated.
This section contains the following topics:
The accrual control journal gives the details of accruals done on deposits, as of a specific date. For Non Accrual Basis (NAB) contracts, the interest, commission, fees, penalty interest and penalty commission are calculated but no accrual entries are passed.
You can generate the report for the following options:
Accrual Processing Date
You can generate the report by way of specifying the dates on which the accrual entries will be passed.
To invoke the screen, go to ‘Report’ on the Application Browser. Click ‘Corporate Deposits’ and select ‘Accrual Control’ under it. Otherwise, use the code ‘LDRPACCR’ on the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
The contents of the Accrual Control Report have been discussed under the following heads:
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated, the page number of the report and accrual processing date.
Contract reference number
This is the reference number of the deposit being reported.
Status
This is the current status of the deposit being reported.
Component
This is the component of the deposit against which accrual entries are passed.
Currency
This is the SWIFT code of the contract currency.
Accrual
If there is accrual or not.
Current accrual
This is the amount for which accrual entries are passed for the current month.
Outstanding accrual
This is the total amount that has been accrued till date, for the deposit.
This section contains the following topics:
The Accrual Control List Summary report summarizes the details of accruals done for particular contracts.
The contents of the Accrual Control List Summary have been discussed under the following heads:
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated, the page number of the report and accrual processing date.
This is the product for which the report is being reported.
Component
This is the component of the deposit against which accrual entries are passed.
Currency
This is the SWIFT code of the contract currency.
Status
This is the current status of the deposit being reported.
Accrual
If there is accrual or not.
Cumulative current accrual
This is the amount for which accrual entries are passed, for the current month.
Cumulative outstanding accrual
This is the total amount that has been accrued so far, for the deposit.
Accrual reference number
This is the reference number of the accrual being reported.
This section contains the following topics:
The interest accrual analysis report will give you the interest accrual details. You can generate this report by using ‘Accrual Analysis Report’ screen.
To invoke the screen, type ‘LDRPCALC’ in the field at the top right corner of the Application tool bar and click the adjoining arrow button.
You can generate the report for the following option:
Contract Selection Type
Indicate the type of contract for which you want to generate report. The following are the options available:
Date Range
Specify the date range to generate the report.
Contract Selection
If you have selected the ‘Single Contract’ option, then select a single contract to generate the report. However, if you selected ‘Multiple Contract’ option, then select the multiple contracts under the ‘Multiple Contracts’ section.
The contents of interest accrual analysis report have been discussed under the following heads:
The ‘Header’ carries the title of the report, branch code, branch date, user ID, module, date and time at which the report has been generated and the page number of the report.
Reference No
This is the contract reference number.
Counterparty
This is the counterparty ID and name.
Value Date
This is the value date of the contract.
Maturity Date
This is the maturity date of the contract.
Component
This is component of the contract.
Int. Method
This is the interest calculation method.
Start Date
This is the start date of the contract.
End Date
This is the end date of the contract.
Basic Amount
This is the basic amount of the contract.
Rate
This is the rate of interest.
No. of Days
This is the number of days.
Interest Amount
This is the interest amount.
This section contains the following topics:
The periodic rate revision report will give you the details of the periodic rate revisions. You can generate this report by using ‘Rate Revision’ screen.
To invoke the screen, type ‘LDRPREVN’ in the field at the top right corner of the Application tool bar and click the adjoining arrow button.
You can generate the report for the following option:
Product Type
Indicate the type of product from the adjacent drop-down list.
Value Date
Specify the value date.
Product Code
Specify the product.
Maturity Type
Indicate the type of maturity from the drop-down list.
Contract Currency
Specify the contract currency.
Revision Date
Specify the date of rate revision.
Customer
Specify the customer.
The contents of periodic rate revision report have been discussed under the following heads:
The ‘Header’ carries the title of the report, branch code, branch date, user ID, module, date and time at which the report has been generated and the page number of the report.
Revn Date
This is the date of the rate revision.
Rate Code
This is the rate code.
Customer
This is the customer for whom the rate has been revised.
Contract Ref. Number
This is the contract reference number.
Ccy
This is the currency of the contract.
Contract Amount
This is the contract amount.
Component
This is the deposit component.
Ccy
This is the currency
Current Rate
This is the current rate of interest.
Current Spread
This section contains the following topics:
Repayment schedules can be defined for various components of a product such as principal, interest, commission and fees. These schedules will apply to all the deposits involving the product, unless redefined at the time of processing the deposit.
The Overdue Schedules report gives details of all repayment schedules of a deposit that are overdue (i.e., are not paid even when they are beyond, their scheduled repayment dates).
You can generate the report for the following options:
Product type
You can generate the report for a specific product type or for all product types. You can generate the report for loans, commitments, deposits, for a combination of any two or for all of them.
Product
You can generate a product-wise report for schedules that are overdue. For instance, you can generate the report about overdue schedules of a long term deposit product, having a tenor of 15 years.
Currency
Under specific Product type(s), you can choose to generate reports in a specific currency(s).
Customer
You can generate this report for specific customer(s).
Specifying the period
While generating the report you can specify the period (i.e., the from and to dates) for which the report has to be generated.
Specifying the schedules
You can generate the report for specific schedules involving the product. Schedules that have not been defined or liquidated are examples for such schedules.
To invoke the screen, go to ‘Report’ on the Application Browser. Click ‘Corporate Deposits’ and select ‘Overdue Schedules’ under it. Otherwise, use the code ‘LDRPOSCH’ on the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
The contents of the Overdue Schedule Report have been discussed under the following heads:
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Due Date
The Schedule Due Date is reported when a schedule is being reported. When the maturity of a deposit is being reported, the Due Date will be the Maturity Date. For a call contract this will be Call. Similarly for a notice contract this will be Notice.
Overdue days
This indicates the number of days for which the payment is overdue.
Customer
This is the CIF ID of the customer involved in the deposit.
Contract reference number
This is the reference number of the deposit being reported.
Status
This is the current status of the contract being reported.
Component
This is the component of the deposit against which the payment due is being reported. If more than one component falls due on the same day they will be reported one after another.
Currency
This is the SWIFT code of the component currency.
Overdue amount
This is the total amount that is overdue for the component, as per the schedule defined in the contract. This amount takes into consideration, all amounts belonging to earlier schedules that are still due.
EURO Eqv.
This is the EURO equivalent of the overdue amount.
This section contains the following topics:
The Overdue Schedules Summary report summarizes the details of each contract:
Apart from the header the following information is provided for each contract:
Due Date
The Due Date is reported when a schedule is being reported. When the maturity of a deposit is being reported, the Due Date will indicate the Maturity Date. For a call contract this will be Call. Similarly for a notice contract this will be notice.
Overdue days
This indicates the number of days for which the schedule payment is overdue.
Product
This is the product for which the report is being generated.
Component
This is the component of the deposit, against which the payment due is being reported. If more than one component falls due on the same day they will be reported one after another.
Currency
This is the SWIFT code of the contract currency.
Status
This is the current status of the contract being reported.
Cumulative overdue amount
This is the total amount that is overdue for the component(s), as of the date of report generation.