9. Reports

9.1 Introduction

All activities that are performed in the Nostro Reconciliation module are recorded. The inputs that you have made at different stages are pieced together and can be extracted in the form of meaningful reports as and when you may require them. The various report programs and reporting features available under the Nostro Reconciliation module are explained in this chapter.

You can generate the following reports for the reconciliation sub-system:

This chapter contains the following sections:

9.2 Reconciliation System Unmatched Items Report

The report on unmatched items, as the name suggests, lists all the details of all the unmatched internal and external transactions belonging to a Reconciliation Class + Accounting Entity + Currency combination.

You can choose to generate the report to contain details of all the items that are unmatched as of the current day, or you can specify preferences for the generation of the report.You can invoke the screen to generate this report by typing ‘RERPUNMC’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details.

Reconciliation Class

Select the required reconciliation class for report generation from the adjoining option list.

External Entity

Select the external entity from the adjoining option list.

Account

Select the account number from the adjoining option list.

Start Value Date

Select the start date for validation from the adjoining calendar icon.

Currency

Select the code of the currency from the adjoining option list.

Aging Basis

Indicate whether the report should be generated for booking date or value date.

To generate the report to contain details of all the unmatched items, leave all the fields of the screen blank and click ‘OK’ button. You can however specify the order in which the contents of the report should be sorted.

You also have the option to cull out details of unmatched items based on the following criteria:

You can further indicate the order in which the internal and external entries of the report should be sorted. You can indicate that the internal and external entries should be sorted based on the booking date or value date of the transaction.

After you state your preferences click ‘OK’ button, to generate the report. The contents of the report are determined by the preferences that you state.

9.2.1 Contents of Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the Unmatched Items Report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report

Body of the Report

This report contains details on:

Item Description
Recon Class The reconciliation class that was used to match the entries.
External Entity The external entity to which the external entries that were matched belong.
External Account The external account to which the external entries that were matched belong.
Currency The currency of the external statement

Internal transactions

Item Description
Book Date The date on which the internal transaction was booked.
Value Date The value date of the internal transaction
Debit Amount The debit amount that the internal entry entails.
Credit Amount The credit amount that the internal entry entails.
Transaction Code The transaction code of the internal entry
Internal Reference This is the reference number that the correspondent bank assigned to the transaction. The correspondent bank s internal reference number is your external reference number.
External Reference This is the reference number that you assigned to the transac­tion. Your internal reference number is external to the corre­spondent bank involved in the transaction.
Age Age of the transaction
Entry Sequence Number This is the sequence number of the transaction entry
Supplementary Details This describes the supplementary details.

 

External Transactions

Item Description
Book Date The date on which the internal transaction was booked.
Value Date The value date of the internal transaction.
Debit Amount The debit amount that the internal entry entails.
Credit Amount The credit amount that the internal entry entails.
Transaction Code The transaction code of the internal entry.
Internal Reference This is the reference number that the correspondent bank assigned to the transaction. The correspondent bank s internal reference number is your external reference number.
External Reference This is the reference number that you assigned to the transac­tion. Your internal reference number is external to the corre­spondent bank involved in the transaction.
Age Age of the transaction.
Entry Sequence Number This is the sequence number of the transaction entry.
Supplementary Details This describes the supplementary details.
Statement Year The year to which the statement pertains
Statement Sequence The sequence number assigned to the external statement
Sub Sequence No The sequence number in which the transaction is entered.

 

Summation

The report summary carries the following details for both internal and external entries:

9.3 Matched Items Report

The matched items report gives the details of all the matched entries. The report gives details of all the entries that were matched, the external entity and account to which the entries belong, the reconciliation class used in the matching, whether the entries were matched automatically or manually and the Rule ID that was used to match the entries in the case of the entries that were automatically matched.

9.3.1 Selection Options

You can choose to generate the report to contain details of all the entries that were matched during the current date, or you can generate the report to contain details of the entries that were matched for a specific reconciliation class + external entity + external account + currency combination using a specific reconciliation class.

You can invoke the screen to generate this report by typing ‘RERPMC’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details.

Reconciliation Class

Select the required reconciliation class for report generation from the adjoining option list.

External Entity

Select the external entity from the adjoining option list.

Account

Select the account number from the adjoining option list.

Currency

Select the code of the currency from the adjoining option list.

Automatic/Manual

Select the type of matching for the entries. You can select either of Automatic or Manual.

Match Rule Identification

In automatic matching, select the rule id for matching of entries.

Match Date

Specify the date as of which matching entries to be retrieved.

Match Status

Select the match status from the adjoining drop-down list. The drop-down list displays:

You can further specify the following options with which the report can be generated. You can generate the report to contain details of the following:

Exception

Check against the field marked exception to obtain a list of the entries that were matched using rules where match is reported as exception.

For example, the preferences stated in the screen that is displayed above would indicate that the report should contain details of the items that are open and authorized, that were automatically matched using NRRULE7 for the reconciliation class + external entity + external account + currency combination stated.

To generate the report to contain details of all the entries that were matched, leave all the fields of the screen blank and click ‘OK’ button. You can however specify the order in which the contents of the report should be sorted.

You also have the option to cull out details of specific entries that were matched items based on the following criteria:

After you specify your preferences, click ‘OK’ to generate the report. The contents of the report are determined by the preferences that you state.

9.3.2 Contents of the Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the Matched Items Report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of the Report

This report contains details of:

Item Description
Recon Class The ID of the reference number that was used to match the external statement.
External Entity The code assigned to the external entity.
External A/C The external account involved in the entry that was matched.
Currency The currency of the external account.
Match Reference The unique reference number assigned by Oracle FLEXCUBE to the entries that were matched.
Match Date The date on which the entries were matched.
Auto / Manual Indicates whether the statement was matched automatically or manu­ally.
Match Rule ID Indicates the ID of the rule which when applied resulted in the match­ing of the entries.
Match Status This indicates the matching status of the entries.
Exception This provides the information about the exception.
Auth Status This indicates the authorization status.

Internal transaction(s)

Item Description
Book Date The date on which the internal transaction was booked.
Value Date The value date of the internal transaction.
Debit Amount The Debit Amount of the internal transaction.
Credit Amount The Credit Amount of the internal transaction.
Transaction Code The transaction code assigned to the internal entry.
Internal Reference Number The reference number that the correspondent bank assigned to the transaction. The correspondent bank s internal reference number is your external reference number.
External Reference Number The reference number that you assigned to the transaction. Your internal reference number is external to the correspondent bank involved in the transaction.
Supplementary Details This describes the supplementary details.
Entry Sequence Number The sequence number in which the transaction is entered.

 

Summation

The report summary carries the following details:

9.4 Upload Exception Report

The Upload Exception report lists details of the statements for which exceptions occurred while the statements were being uploaded into the Reconciliation module of Oracle FLEXCUBE. The report also describes the nature of the exception that occurred when the statement was uploaded.

9.4.1 Selection Options

You can choose to generate the report to contain details of all the statements that were uploaded during a given date or you can indicate the upload sequence number for which you want details.

You can invoke the screen to generate this report by typing code ‘RERPUPEX’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details.

Upload Date

Specify the upload date or select the upload date from the adjoining calendar.

Upload Sequence Number

Specify the upload sequence number from the adjoining option list. The option list displays the sequence number maintained in the system.

To indicate that the report should contain details of all the exceptions that occurred during upload for a given date, you need to enter only the date for which you want to retrieve details, and click ‘OK’ button.

If you want to generate the report to contain details of the exceptions that occurred during a specific upload session, click the adjoining option list and select an Upload sequence number from the option-list that is displayed. After you have specified your preferences click ‘OK’ button. The contents of the report are determined by the preferences that you state.

9.4.2 Contents of the Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the Upload exception report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of the Report

This report contains details of:

Item Description
Upload Sequence Number Sequence number that Oracle FLEXCUBE automatically assigns to each upload session.
Initiation Date Date on which the statement upload was initiated.
Termination Date This is the date on which the statement upload was terminated.
Termination Status Status of the upload sequence. It could read success or failure indicating that the upload was a success or a failure.

Options

Item Description
Recon Class Reconciliation class for which you need to upload details.
External Entity External entity to which the uploaded statement belongs.
External Account Account to which the uploaded statement belongs.
Currency Currency of the external statement.
Year Year to which the statement pertains.
Statement Sequence Number Sequence number that you assigned to the statement when it was uploaded.
Sub Sequence Number Sub- sequence number that you assigned to the statement when it was uploaded.
Upload Source Source from which the statement was uploaded.
Upload Date Date on which the statement was uploaded.
Exception Exception that occurred when the statement was uploaded.
Upload Source This is the upload source.
Initiation Date The date on which the exception occurred.
Upload Reference Number The reference number of the uploaded statement.
Exceptions The exceptions

 

9.5 Capture Exception Report

The capture exception report contains details of all the exceptions that occurred while the entries that were posted to the internal accounts and GLs were being captured.

9.5.1 Selection Options

You can generate the report to contain details of all the capture exceptions that occurred as of a given date or you can generated the report details of the exceptions that occurred during specific capture sequence.

You can invoke the screen to generate this report by typing ‘RERPCPEX’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details.

Capture Date

Specify the capture date or select the date from the adjoining calendar.

Capture Sequence Number

Specify the capture sequence number from the adjoining option list. The option list displays the sequence number maintained in the system.

To indicate that the report should contain details of all the exceptions that occurred during upload for a given date, you need to enter only the date for which you want to retrieve details, and click ‘OK’ button.

If you want to generate the report to contain details of the exceptions that occurred during a specific match session, click the adjoining option list and select a capture Sequence Number from the option list that is displayed. Thereafter, you should also specify the date on which the entries were captured.

After you have specified your preferences, click ‘OK’ button. The contents of the report are determined by the preferences that you state.

9.5.2 Contents of the Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the Matched Items Report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of Report

Item Description
Capture Sequence Number Sequence number that Oracle FLEXCUBE assigns to each internal capture session.
Initiation Date Date on which the internal capture was initiated.
Termination Date Date on which the internal capture was terminated.
Termination Status Status of the capture sequence. It could read success or failure indicating that the capture was a success or a failure.

 

Options

Item Description
Recon Class Reconciliation class that you specified while specifying selection options.
External Entity External entity that you specified while specifying selection options.
External Account External account that you specified while specifying selection options.
Capture End Date Date upto, which the details of the internal entries were captured.

 

Exceptions

Item Description
Recon Class Reconciliation class that you specified while specifying selection options.
External Entity External entity that you specified while specifying selection options.
External Account External account that you specified while specifying selection options.
Account/GL This shows the account number of GL code.
Entry Serial Number This shows the account entry serial number.

 

Summation

The summary of the report lists all the exceptions that occurred during the internal capture.

9.6 Match Exception Report

The match exception report lists details of all the exceptions that occurred while internal and external statements were being matched. The report also contains a description of the exception that occurred while the entries were being matched.

9.6.1 Selection Options

You can generate the report to contain details of all the match exceptions that occurred as of a given date or you can indicate a specific match sequence number for which you want to retrieve details.

You can invoke the screen to generate this report by typing ‘RERPMCEX’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details.

Match Date

Specify the upload date or select the upload date from the adjoining calendar.

Auto Match Sequence Number

Specify the match sequence number from the adjoining option list. The option list displays the sequence number maintained in the system.

To indicate that the report should contain details of all the exceptions that occurred during upload for a given date, you need to enter only the date for which you want to retrieve details, and click ‘OK’ button.

If you want to generate the report to contain details of the exceptions that occurred during a specific match session, click the adjoining option list and select an Auto Match Sequence Number from the option-list that is displayed. After you have specified your preferences, click ‘OK’ button. The contents of the report are determined by the preferences that you state.

9.6.2 Contents of the Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the Match exception report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of the Report

This report contains details of:

Item Description
Match Sequence Number Match sequence number assigned by Oracle FLEXCUBE to the matching session.
Initiation Date Date on which the matching session was initiated.
Termination status Termination status of matching session.
Termination Date Date on which the matching session was terminated.
Recon Class Reconciliation class for which the match was executed.
External Entity External entity for which the match was executed.
External Account External account for which the match was executed.
Currency Currency for which the match was executed.
Exception Exception that occurred during the match session.

9.7 RE External Statement Report

The RE External Statement Report details the fields in the generated reports.

You can invoke the screen to generate this report by typing ‘RERSTMIN’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details:

Reconciliation Class

Select the required reconciliation class for report generation from the adjoining option list.

External Entity

Select the external entity from the adjoining option list.

External Account

Select the account number from the adjoining option list.

Currency

Select the code of the currency from the adjoining option list.

Year

Specify the year.

Sequence Number

Specify the sequence number of the statement.

Sub Sequence Number

Specify the sub sequence number of the statement.

9.7.1 Contents of Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the RE External Statement Report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of the Report

This report contains details of:

Item Description
Recon Class This is the reconciliation class.
Class Description This is the description of the reconciliation class.
External Entity This is the external entity.
External Account This is the external account number.
Currency The currency in which the amount is mentioned.
Year The year in which external account created.
Sequence Number This is the sequence number.
Sub Sequence Number This is the sub sequence number
Media The media is swift for the uploaded external statements. It is null for the manually maintained External Statements.
Closing Book Balance This is the balance amount at the time of closing a balance book.
Date This is the date on which balance book is closed.
Opening Book Balance This is balance amount while opening the book.
Date This is the date in which balanced book is opened.
Internal Remarks This shows the internal remarks.
Available Balance This is the total balance available after the book is opened.
Transaction Reference Number This is the reference number of transaction.
Entry Sequence Number This is the sequence number of transaction entry.
Current Number This is the current number.
Funds This indicates the funds.
Booking Date This is the booking date.
Value Date This is the date on which the transaction is validated.
Debit This is the amount debited.
Credit This is the amount credited.
Internal Reference Number This is the internal reference number of fund.
External Reference Number This is the external reference number of fund.
Transaction code This is the transaction number of the fund.
Supplementary Details This describes the supplementary details.

9.8 Manual Matching Report

The matched items report gives the details of all the matched entries. The report gives details of all the entries that were matched, the external entity and account to which the entries belong, the reconciliation class used in the matching, whether the entries were matched automatically or manually and the Rule ID that was used to match the entries in the case of the entries that were automatically matched.

You can invoke the screen to generate this report by typing ‘RERMANMC’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details.

Match Reference Number

Select the reference number from the adjoining option list. The option list displays the numbers maintained in the list.

Click ‘OK’ to generate the report.

9.8.1 Contents of Report

The selection options that you specified while generating the report are printed at the beginning of the report.

The contents of the Matched Items Report are discussed under the following heads:

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of the Report

This report contains details of:

Item Description
Recon Class This is the ID of the reference number that was used to match the external statement.
External Entity This is the code assigned to the external entity.
External Account This is the external account involved in the entry that was matched.
Currency This is the currency of the external account.
Match Date This is the date on which the entries were matched.
Auto / Manual This indicates whether the statement was matched automatically or manually.
Match Rule ID This indicates the ID of the rule which when applied resulted in the matching of the entries.
Match Status This indicates the matching status of the entries.
Exception This provides the information about the exception.
Auth Status This indicates the authorization status.

Internal Transaction(S)

Item Description
Book Date This is the date on which the internal transaction was booked.
Value Date This is the value date of the internal transaction.
Debit Amount This is the Debit Amount of the internal transaction.
Credit Amount This is the Credit Amount of the internal transaction.
Transaction Code This is the transaction code assigned to the internal entry.
Internal Reference This is the reference number that the correspondent bank assigned to the transaction. The correspondent bank s internal reference number is your external reference number.
External Ref No This is the reference number that you assigned to the transaction. Your internal reference number is external to the correspondent bank involved in the transaction.
Supplementary Details This describes the supplementary details.
Entry Sequence Number This is the sequence number in which the transaction is entered.

 

External Transactions

Item Description
Book Date This is the booking date of the external transaction
Value Date This is the value date of the external transaction
Statement Year This is the year to which the statement pertains
Debit Amount This is the debit amount as contained in the external statement
Credit Amount This is the credit amount as contained in the external statement
Statement Sequence This is the sequence number assigned to the external statement
Sub Sequence Number This is the sub sequence number assigned to the external state­ment
Transaction Code This is the transaction code assigned to the transaction by the cor­respondent bank
Internal Reference This is the reference number that the correspondent bank assigned to the transaction. The correspondent bank s internal reference number is your external reference number.
External Reference This is the reference number that you assigned to the transaction. Your internal reference number is external to the correspondent bank involved in the transaction.
Supplementary Details This describes the supplementary details.
Entry Sequence Number This is the sequence number in which the transaction is entered.

Summation

The report summary carries the following details:

 

9.9 Exception Report

You can invoke the screen to generate this report by typing ‘SVROV’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Specify the following details:

Module

Specify the module from the adjoining option list.

Description

Give a brief description.

9.9.1 Contents of Report

The selection options that you specified while generating the report are printed at the beginning of the report.

Header

The Header carries the title of the Report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.

Body of the Report

This report contains details of:

Item Description
Module Indicates the module of the transaction
Contract Reference Indicates the contract reference
Event Sequence Number Indicates the sequence number of the event
Instrument Code Indicates the instrument code
User ID Indicates the User ID
Auth ID Indicates the authorization ID
Exception Indicates the exception