An external statement can be entered into Oracle FLEXCUBE either manually or can be uploaded automatically. The details of an external account can come in through the media types set up for your bank. External statements that have come in through SWIFT can be automatically uploaded. The details of an uploaded statement will be automatically displayed in the relevant fields of this screen.
The statements that come in through media types other than SWIFT should be manually entered into Oracle FLEXCUBE through the External Account Definition screen.
This chapter contains the following sections:
You can invoke the ‘Reconciliation External statement Input’ screen by typing ‘REDXSTIN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
If you are maintaining the details of a new statement, click the new button on the Application toolbar. The ‘Reconciliation External statement Input’ screen is displayed without any details. If you are calling an External Statement Input record that has already been defined, double-click a class record of your choice from the summary screen.
The External Account Input screen is designed to contain two tabs, which correspond to the:
In the statement details screen you can enter details that pertain to the external statement as a whole. Whereas in the entry details screen, you can enter details that pertain to the individual entries contained in the statement.
Specifying Details of an External Account
Most of the details that you are required to enter are contained in the external statement that you have received. You are required to enter the following statement details:
Entering Details of the External Statement
While entering the details of an external statement, you should also specify the following details:
Upload Details
If the details of the external statement have been automatically uploaded from an external source, the following upload details are displayed:
If you manually enter the details of an external statement, these fields will be grayed and will not contain any information.
Specifying Opening Balance Details
You are also required to enter the details of the following as contained in the external statement:
The opening book balance refers to the amount that was in the external account as of the opening balance date. The opening balance date indicates the start date of the period for which the statement was sent.
Note
Please note that the opening book balance should be equal to the previous closing book balance for the reconciliation class + external account + external entity combination.
Specifying Closing Balance Details
You should also enter details of the following as contained in the external statement:
The closing book balance refers to the amount that was in the external account as of the closing balance date. The closing balance date indicates the end date of the period for which the statement was sent.
The available balance refers to the amount that is currently available in the account for which the statement was sent.
Note
The closing book balance should be equal to the sum of the opening book balance and the transactions contained in the external statement.
Click ‘Override’ button to view the overrides that were encountered while the external statement was uploaded. The overrides screen with a list of all the overrides that were encountered during the entry of the current statement is displayed.
Click ‘Fields’ button to view the ‘User Defined Fields’. You should input values in the fields corresponding to Field Names displayed.