Bank transactions management

Use this function to view all imported bank statements and their status. By default only nonvalidated statements display.

The tasks you can perform for each statement vary depending on the flow type setting: Standard or Reconciliation only.

Standard flow type:

• Start the automatic matching for all unmatched statements.
• Undo the matching or delete an imported statement if necessary.
• Open a statement to review the transactions and to start the matching for this single statement. You can also do manual matches.

Reconciliation only flow type:

• Access transactions in the Bank statement reconciliation function (RAPBAN) for matching and generating payments.
• Display imported bank transactions.

These statements are imported using the Bank transactions import function (BSIIMPORT) or you can click Start import from the Action panel to access the this function.

After importing bank transactions, you need to match the transactions to open items or payments and validate to generate the payment.  For matches to payments, a new payment is not generated when you validate the statement. 

Matching transactions

Applies to Standard flow type only.

Click Start matching from the Actions panel. This runs the automatic matching process for all unmatched statements and searches for open items and posted payments based on search criteria in Bank import settings (BSIIMPPAR).

One bank statement transaction can only be matched to either an open item(s) or a payment(s). A transaction cannot be matched to both an open item and a payment.

Matching priority depends on the sign of the payment transaction:

• Revenue: Open items are matched first.
• Expense: Payments are matched first.

Note: You can start the matching for a single statement from the Process bank transactions option on the Actions icon menu on each line.

Processing transactions

Applies to Standard flow type only.

For each statement (line), the next step is to select Process the bank transactions from the Actions icon menu.

Bank statement reconciliation

Applies to Reconciliation only flow type only.

For each statement (line), click Bank statement reconciliation from the Actions icon menu at the beginning of a line to access that function.

(missing or bad snippet)

 

Prerequisites

Screen management

Grid

By default, only nonvalidated statements are shown, but you can change the display using options available from the Menu bar. The fields in this grid are read-only.

Possible status of a statement:

Not matched: initial status after import (Standard flow type)Matched: matching for some or all transactions performed (Standard flow type)

Validated: payments generated, read-only (Standard flow type)

Reconcile: statements imported with the Reconciliation only flow type to be processed through the Bank statements reconciliation function (RAPBAN)

Action icon

Delete

This actions deletes the current statement. You can only delete statements that have not been validated. Matched statements must be unmatched before you can delete them. Statements with a Reconcile Matching status cannot be deleted.

Undo matching

This action unmatches the current bank statement. This does not apply to statements with a Reconcile Matching status.

Process bank transactions

Use this function to review and manage matching results and to generate payments through validation. This only applies to Standard flow type imports. You can perform the following actions: Check and edit automatic matching results Undo and redo matching Manual matching Manual selections (search for open items) Manual entries Start the validation and generate the payment See the documentation for Process bank transaction.

Bank statement reconciliation

For statements with a Reconcile Matching status only, click this option to go directly to the Bank statement reconciliation function to match items and generate payments.

Action panel

Start import

This action opens the Bank transactions import function where you can import bank transactions. This applies to both flow types: Standard and Reconciliation only.

Start matching

This action starts the automatic matching process for all unmatched statements at once. The matching searches for possible open items to match against imported statements.

Use these actions to filter import results in the grid.

No filter

Select this action to undo previous filters by new statements or validated statements.

New statements

Select this action to display only new statements.

Validated statements

Select this action to display only validated statements.

Error messages

• Generic messages

The only error messages are the generic ones.

Tables used

The following tables are implemented by the function:

Table	Table description
BSIIMP [BSIIMP]	Bank statement import