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:
- Unmatched Items Report
- Matched Items Report
- Manual Matching Report
- Reconciliation Class Definition Report
- External Account Definition Report
- Matching Rule Definition Report
- Rule Definition Report
- Statement Input Report
- Upload Exception Report
- Capture Exception Report
- Match Exception Report
This chapter contains the following sections:
- Section 9.2, "Reconciliation System Unmatched Items Report"
- Section 9.3, "Matched Items Report"
- Section 9.4, "Upload Exception Report"
- Section 9.5, "Capture Exception Report"
- Section 9.6, "Match Exception Report"
- Section 9.7, "RE External Statement Report"
- Section 9.8, "Manual Matching Report"
- Section 9.9, "Exception Report"
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.
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:
- The reconciliation class
- The external entity and account to which the statement belongs
- The currency of the external statement
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 transaction. Your internal reference number is external to the correspondent 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 transaction. Your internal reference number is external to the correspondent 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:
- The internal and external balance
- The unmatched internal and external debit amount
- The unmatched internal and external credit amount
- The amount that could be matched
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:
- Open
- Closed
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:
- Entries that were automatically matched
- Entries that were manually matched
- Entries that were matched on a specific date
- For entries that were automatically matched you can specify the rule by which the match was obtained
- Matched items that based on their status (including Suggested Match status)
- Open, closed, authorized or unauthorized
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:
- The external entity
- The external account to which the entries belong
- The currency of the account
- The reconciliation class that was used in the matching
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 manually. |
Match Rule ID |
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 |
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:
- The total internal credit and debit that was matched
- The total external credit and debit that was matched
Item
Description
Internal Debit Sum
This is the sum of the internal debit. This is to be matched with external credit sum.
External Debit Sum
This is the sum of the external debit. This is to be matched with internal credit sum.
Internal Credit Sum
This is the sum of the internal credit.
External Credit Sum
This is the sum of the external credit.
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 statement |
Transaction Code |
This is the transaction code assigned to the transaction by the correspondent 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:
- The total internal credit and debit that was matched
- The total external credit and debit that was matched
Item
Description
Internal Debit Sum
This is the sum of the internal debit. This is to be matched with external credit sum.
External Debit Sum
This is the sum of the external debit. This is to be matched with internal credit sum.
Internal Credit Sum
This is the sum of the internal credit.
External Credit Sum
This is the sum of the external credit.
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 |