Show TOC

FI-BL, Import and Postprocessing of Electronic Bank Statement Locate this document in the navigation structure

 

Technical Data

Technical Name of Business Function

FIN_BL_EB_1

Type of Business Function

Enterprise business function

Available As Of

SAP enhancement package 6 for SAP ERP 6.0

Technical Usage

Central Applications

Application Component

Electronic bank statement (FI-BL-PT-BS-EL)

Accounts receivable accounting (FI-AR)

Accounts payable accounting (FI-AP)

Prerequisite Business Function

Financials Extension (EA-FIN)

With this business function, you can automatically import and forward electronic bank statements to the SAP system, and quickly and comprehensively postprocess bank statement items that have not been posted direct in the system. In addition, a bank statement overview is available. Improved integration of the electronic bank statement with other SAP areas, such as SAP Dispute Management or Accounting Interaction Center (AIC), enables you to optimize the process of updating payments in the system.

You import and forward electronic bank statements automatically using a report. You can control the specific formats in the report using Customizing settings. By specifying various source paths, you can import, rename, forward, and following successful processing, store several bank statement files in a directory at the same time. Other functions, such as background processing or job scheduling, support automatic processing using the Schedule Manager.

The postprocessing of bank statement items provides you with a more efficient means of processing payments. Postprocessing is done in a single screen transaction that fully supports you in the daily processing of open bank statement items. Numerous functions within this transaction speed up the search for open items and their subsequent posting in the system. These functions include the rapid assignment of open items, change to the note to payee, the scanning of a changed note to payee again, the search for payment advices (for example), or additional import of further items by using search parameters such as customer, document number, or the item amount.

You can display important information about the current bank statements in the bank statement overview using the SAP NetWeaver Business Client (NWBC). You can check the completeness of the imported bank statements and that the balances are correct, or display information about the directories used. From the overview, you can trigger the automatic import and switch direct to the postprocessing of the bank statement items.

Integration

You can use this business function in the Edit Bank Statement Item transaction to create and display dispute cases for accounts receivable accounting. On the Dispute Case tab page, you can call up the displayed dispute cases and navigate directly to the Dispute Case Processing transaction.

To use this function, you must be using SAP Dispute Management. This application component is part of the software component FINBASIS. Depending on the function required, the following minimum requirements must be met:

Function

Software Component

Business Function

Create dispute cases for residual items

FINBASIS 300

Create dispute cases for customer-disputed objects

FINBASIS 602

FSCM Functions (FIN_FSCM_CCD) in the SAP Dispute Management system

Note Note

For more information, see Creating Dispute Cases during Processing of Account Statements.

End of the note.

In postprocessing of bank statement items, you can submit inquiries to the Accounting Interaction Center (AIC) by choosing   Help   Service Request  . You can use custom templates to enter service requests. To use this function, you must be using the interaction center of SAP Customer Relationship (SAP CRM). This application component is part of the software component BBPCRM. The following minimum requirements must be met:

Function

Software Component

Business Function

Create service requests

BBPCRM 701

FI, Enablement for Financial Shared Services (FIN_SSC_AIC_1) in the financial accounting system

Note Note

For more information, see SAP Library for SAP CRM under   Interaction Center   Interaction Center WebClient   Shared Services Framework   Integration with SAP ERP   Accounting Interaction Center   Launching Service Requests from Back-End Systems  .

End of the note.

Prerequisites

  • You have installed the following components as of the specified version (or higher):

    Type of Component

    Component

    Only Needed for the Following Functions

    Software component

    SAP_APPL 606

    EA-APPL 606

    SAP NetWeaver

    SAP NetWeaver Business Client (NWBC)

    Bank statement overview

  • For you to be able to use the business function, the following prerequisites must also be met:

    • You have activated the Financials (EA-FIN) Enterprise Extension.

    • You have configured the following application components:

      • Electronic bank statement (FI-BL-PT-BS-EL)

      • Accounts receivable accounting (FI-AR)

    • In addition to this business function, you have activated the Financials Extension (EA-FIN) business function.

    • You have made the necessary settings in Customizing for the electronic bank statement. For more information, see the release note FIN_BL_EB_1: Import and Postprocessing of Electronic Bank Statement (New) for this business function.

Features

The business function has the following features:

Importing and Forwarding Bank Statements Automatically

You import electronic bank statements using the report Import and Forward (Automatically) (FEB_FILE_HANDLING), which you can control using the Customizing settings and which provides the following options:

  • Import any number of bank statement files (mass import)

    By entering a source path, you can import any number of bank statement files at the same time.

  • Support of standard formats SWIFT MT940/MT942 and BAI

    You can use the report Import and Forward (Automatically) for the formats SWIFT MT940/MT942 and BAI. To import other formats, you can use Business Add-Ins.

  • Variable entry of source path and storage path for the import files

  • Specification of directories for files that are incorrect or cannot be processed

  • Option of forwarding bank statements to other systems

  • Import log with error analysis

  • Background processing and job scheduling

    If necessary, you can configure the import to run in the background or schedule it as a job using the Schedule Manager (CA).

For more information, see Importing Bank Statements.

Postprocessing Bank Statements

The improved transaction for postprocessing bank statement items provides you with information and functions that you require in your day-to-day work to be able to post the open bank statement items in the system.

  • Single screen transaction with high functionality

    You remain on one screen during the entire process. Even when displaying information for individual items, you remain in the transaction and within the context.

  • Worklist

    A clear worklist of open bank statement items is available to you for postprocessing, with quick navigation and the option for presetting, new selection, and creation of variants. You can also save the processing status of your worklist without posting, so that you process it later.

  • Detail area for bank statement items

    The detail area offers an overview of the most important data for a bank statement item, such as note to payee, transaction, business partner, customer, currency, posting date, and other fields. You can edit the following fields, for example:

    • You can change the note to payee text. You can then let the system scan the changed note to payee again. When searching for payment advice notes (based on the transaction selected), you can insert the full payment advice content into the note to payee.

    • For payments in a currency different to the system currency, you can translate the foreign currency in the detail area.

    • When you select the transaction, you specify the business criteria based on which the system scans the note to payee. Depending on the transaction, you start a search for documents, open items, payment advice notes, data mediums, or checks.

  • Assignment, document entry, and payment usage

    After the selected bank statement items have been scanned, a results list of the open items found is displayed.

    • You see an overview of the amounts already assigned and of the payment amount still open. You can post the residual amounts as residual items or partial payments according to the difference posting type you selected.

    • If the scan of the note to payee does not find all of the open items, you can import more items that are added to the results list. Relevant search parameters are customer, vendor, and item amount, for example.

    • After the open amount has been assigned or distributed successfully, the simulation (optional) and posting to the system is carried out and the posting document created. You can also view the cleared documents in the payment usage.

    • The logging and display of the application log takes place within the transaction on a separate tab page.

    • Depending on the transaction you select, additional functions are available to you within postprocessing:

      • Creation of on account postings

      • Account assignments to G/L accounts (optionally with account assignment template)

      • Creation and display of dispute cases

      • Insertion of attachments and notes

  • Creation of service requests to the Accounting Interaction Center (AIC)

For more information, see Postprocessing Bank Statements.

Bank Statement Overview

The bank statement overview is available to you through the extended role Process Bank Statement in the NWBC and offers the following functions:

  • Overview of the directories used for the import

  • Overview of the bank statements imported (postprocessing worklist)

  • Overview of the bank statements forwarded

  • Call of transaction Edit Bank Statement Item

  • Start of report Import and Forward (Automatically)

To display the bank statement overview, your user has to be assigned to the Process Bank Statement (SAP_FI_BL_BANK_STATEMENT_EXT) role. For information about the role, see Processing Bank Statements in the SAP NetWeaver Business Client.

For more information about functions, see Bank Statement Overview.

More Information

  • For more information about NWBC, see SAP Library for SAP NetWeaver under   SAP NetWeaver by Key Capability   Application Platform by Key Capability   ABAP Technology   UI Technology   SAP NetWeaver Business Client  .

  • For information about the features of the electronic bank statement, see the application documentation under Electronic Bank Statement (FI-BL).