Bank transactions import

Bank statement import overview

You must complete the setup process before importing bank statements, reviewing and processing matches, and generating payments through validation.  

See Bank statement setup overview. The setup involves technical settings that should be done very carefully. If you are not certain, contact your administrator or business partner.

This is an overview of the bank statement import and matching process. See the relevant function help for specifics regarding each step.

The process varies based on the flow type selected in the Bank import settings function (BSIIMPPAR).

Standard: Importing, matching, and generating payments takes place within the full bank statement import workflow, including the Process bank transaction function (GESBSIMTC).

Reconciliation only: Importing takes place within the bank statement import workflow. Matching and generating payments takes place in the Bank statement reconciliation function (RAPBAN).

1. Import transactions

This function imports bank transactions in various electronic formats from one or several bank statement files. These files have been obtained directly from your bank or exported from an online banking tool and saved to your workstation or server. The bank transaction import function (BSIIMPORT) imports these files from their saved location for matching and processing.

This step applies to Standard and Reconciliation only flow types.

See Bank transaction import

2. Managing imports and matching

Next, you need to manage how you import and match transactions.

An imported statement can have one of the following statuses:

• Not matched: Initial status after import, no matching has been performed.
• Matched: Matching or partial matching has been performed for the statement.
• Validated: Payments have been generated and the statement is read-only.
• Reconcile: The bank statement was imported with Reconciliation only as the flow type. The transaction data has been copied to the Bank statement reconciliation function (RAPBAN). The statement here is read-only.

Standard flow type:
Match transactions to open items or accounts using the Bank transaction management function (BSIIMP). You can perform an automatic match from this screen, but you cannot review or modify results and you cannot generate payments.

Reconciliation only flow type:
The transaction data for the statement has been copied to the Bank statement reconciliation function (RAPBAN) where you can perform a standard manual bank reconciliation. Import data is display-only. For each statement, you directly access the transaction data from the Action icon menu at the beginning of each line. You cannot process the statement through the Process bank transactions screen.

See Bank transaction management

3. Matching transactions to open items or accounts

This step only applies to the Standard flow type.

The imported transactions need to be reviewed and matched to open items or other accounts such as a G/L account, BP account, or a suspense account. This is done in the Process bank transactions screen. You can match items automatically or manually.

• Automatic matching: From the Bank transaction management screen, click Start matching to run the process on all unmatched statements in the grid.
• Manual matching: From the Action icon menu at the beginning of a line, select Process bank transactions. This opens a new screen where you can review and edit results from automatic matching, perform manual matching and selection, and manual entry.

Processing transactions

This step only applies to the Standard flow type.

When you select Process bank transactions, you can view details for all transactions in that statement. Transactions can have one of four initial matching levels:

A: An exact match to one or several open items (or a G/L account) was found.

AS: The transaction was automatically assigned to a G/L account or a BP according to search terms defined in the search term list function.

B: Some information was found, but not an exact match. Possible matching open items are displayed.

C: No matches were found and there are no possible matches displayed.

See Process bank transactions

4. Validating a statement

This step only applies to the Standard flow type.

Validating is the final step in the bank import process and generates the payment. Before validating, you must distribute the complete transaction amount as paid, plus overpayment if applicable. You can distribute transactions in a statement to multiple open items or accounts. Once you have generated the payment, you can no longer modify the transaction. The validation is always performed for the entire current statement and depends on the matching status:

A/AM/AS: Payments are created for the matched open items or G/L accounts. Payment lines for discounts are created as needed.

B/C: Payments are created for the suspense account unless you have selected to Suppress intermediate posting. In that case, you need to manually generate payments and journal entries for those transactions. This option and suspense account settings are defined in the Bank import settings.

See Process bank transactions

5. Manually completing a transaction

This step only applies to the Standard flow type.

In certain cases, open items associated with a bank statement transaction might have been settled outside the bank statement import process. In other words, a payment transaction included in the bank statement already exists as a payment.

Complete transaction is active when the transaction status is Not validated but has already been matched or when the transaction status is Partially validated.
This option is inactive when the transaction status is Not validated but has not yet been matched, or when the transaction status is Validated or Manually completed.

Note: Use this action with care. Completing a transaction cannot be undone.