6. Manually Entering an External Statement

6.1 Introduction

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:

• Section 6.2, "Reconciliation External Statement Input Screen"
• Section 6.3, "Features of the External Statement Input Screen"
• Section 6.4, "The Statement Details Screen"
• Section 6.5, "Viewing the Overrides that were Encountered"
• Section 6.6, "Viewing Fields"

6.2 Reconciliation External Statement Input Screen

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.

6.3 Features of the External Statement Input Screen

The External Account Input screen is designed to contain two tabs, which correspond to the:

• Statement details screen
• Entry details screen

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.

6.4 The Statement Details Screen

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:

• The reconciliation class
• The external entity and account to which the statement belongs
• The currency of the statement

Entering Details of the External Statement

While entering the details of an external statement, you should also specify the following details:

• The year to which the statement pertains
• The sequence number of the statement
• The sub-sequence number of the statement (if required)
• The reference number that is quoted on the external statement
• The media through which you received the statement

Upload Details

If the details of the external statement have been automatically uploaded from an external source, the following upload details are displayed:

• Source: The code that identifies the source from which external statement was uploaded in to Oracle FLEXCUBE.
• Date: The date on which the external statement was uploaded onto Oracle FLEXCUBE.
• Source Ref No: The reference number assigned to code from which the statement was uploaded.

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
• The opening balance date

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
• The closing balance date

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.

6.5 Viewing the Overrides that were Encountered

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.

6.6 Viewing Fields

Click ‘Fields’ button to view the ‘User Defined Fields’. You should input values in the fields corresponding to Field Names displayed.