Reconcilation Reports and Message Error Codes

How the reconciliation report is requested during the day, and how reconciliation data is stored and printed (either for the requested report or the unsolicited report at the end of the day).

Receiving The Reconciliation Report

The user can initiate the reconciliation process by sending a ESTS Reconciliation Report Request to the ESTS centre.

The ESTS Reconciliation Report Response arrives at the RC in a series of messages from the ESTS centre. The last message has a flag indicating that it is the last message.

The RC maintains a reconciliation report sub-account database in parallel with the normal sub-account database. On receipt of a reconciliation report component message (either ISR or IER), the reconciliation sub-account database is updated by the details in the message. Once the reconciliation sub-account database has been updated the report component is routed as dictated by the inbound routing table.

On receipt of the last message in an ESTS reconciliation report, the RC generates an alarm telling the user that the last part of the reconciliation report has been received.

Reconciliation Report for Transaction XXXX-BBBBB IIIIIII Received Where:-· XXXX-BBBBB is the bank/branch code initiating the report request, or the bank / branch code supplied by ESTS Centre on IER is the inquiry number of the report request.

It is important to note that the on-line reconciliation process compares snapshots of the reconciliation data taken at different times. As this is during the business day, transactions may be affecting the data in the time between these snapshots, thus discrepancies do not necessarily indicate accounting problems.

Producing The Reconciliation Report (ESTSREC)

This is an off-line program started using the FWCOM ESTSREC command. The most accurate on-line reconciliation is achieved if the user waits for the ESTS reconciliation report to fully arrive before initiating the ESTSREC process.

Inputs

The program is run by the following command:
FWCOM ESTSREC [BBBB]
Where BBBB is an optional bank code for use in a shared RC. If omitted, the report is produced for all banks on the shared RC.

Processing

The program;

a) First checks whether the operator is permitted to produce the report, as for the EFT Reconciliation Report.

b) If no bank code was specified,displays the date and time at which the report was last run to the user; requests confirmation from the user that the report should be run before continuing;

c) Reads and sorts the reconciliation sub-account database into security identifier within Sub-account type order;

d) Reads the sub-account records from the RC database, and again sorts into security identifier within Sub-account type order;

e) Compares the sorted data and produces a report as detailed below.

Outputs

The report is written to a file

If the RC details match the reconciliation sub-account database details, then only the RC sub-account details are output to the report. If there is a mismatch, then both sets of details are output. If there is no data from ESTS, the appropriate column shows a warning message.