Three methods to import bank statement in SAP

Dmitry Kaglik

September 4, 2017



Bank account statement is the document that tells the bank account holder the information related to the bank account. If your company runs SAP, once the bank statement received for the company bank accounts, it should be entered into SAP. Like with entering invoices and entering payments, SAP supports several methods for entering bank statement too. The method of entering depends on arrangements with the bank and the format of bank statement delivery.

Manual bank statement

The most classical way of entering the bank statement supports the paper statements or electronic formats not directly uploadable into SAP.

Transaction FF67 is the user interface for entering the bank statement details.

FF67 user interface
FF67 user interface

Once user enters or selects the bank account, he needs to enter the initial and closing balance of the statement. The next screen gives the opportunity to enter individual transactions from the statement.

When the statement is entered, it can be posted on-line or via a separate batch input session, depending on user preference.

Electronic bank statement (EBS)

The more advanced way to receive bank statement from the bank is via electronic files. There are multiple file formats. Some of them are worldwide standards (e.g. SWIFT MT940, Multicash), other are country- or bank-specific (e.g. BAI2 or Royal Bank of Scotland).

SAP supports multiple formats, and you can configure transactions FF.5 and FF_5 to call one or several of them with the pre-defined variants.

The layout of the transaction in this case will depend on the assigned program and variant. You can pre-populate certain fields on the screen to allow bank statement import with less manual steps.

Once the file is imported, SAP can do some automatic checks, depending on the file format. For example, SAP automatically checks the incoming and outgoing balances of consecutive MT940 statements and throws an error if they don’t match. This check does not work for BAI2 statements because their numbers are not assigned by the bank.

Like with the manual bank statement, SAP can attempt an automatic posting of EBS at the moment of entry, or create a batch-input for processing later.


The most advanced way to import bank statement into SAP is via IDOCs. You can ask your bank to send you IDOCs in FINSTA format. In order to enable that way of communication with the bank you need to configure partner profile for the bank in transaction WE20 and add FINSTA IDOC to the profile.

When IDOC is received into SAP, it will automatically create bank statement records in the system. However, the standard SAP program will not attempt automatic posting of these statements. If you need to post them automatically, you need to schedule program RFEBKA30 to run periodically and pick up any unprocessed items.

What is next?

Depending on the way how the statement is entered in SAP and some user-specific settings, SAP will or will not automatically post the bank statement items. In some cases, you will need to process them separately either via batch input or via program RFEBKA30. However, this will not ensure all bank statement items are fully posted.

There are several configuration steps allowed for the bank statement. They are subject to a separate conversation.

You need to check the statement status and, in some cases, you need to post-process the statement items. You can read about that process in a separate article of SAP Expert. There is also a SAP BSM functionality to check the overall status of the bank statements in a separate monitor.

If you have additional questions about the way to import bank statement into SAP, why not ask SAP Expert?

Related Posts

Top SAP Expert posts from 2021

Dmitry Kaglik

January 10, 2022


No Comment

The year 2021 is behind us. There were many articles published on SAP Expert blog that year, as well as during previous years. Let’s see what were the most read posts from 2021. Search Strings: Powerhorse of Electronic Bank Statement More Free SAP Training Do you need help with SAP Job interviews? As for the […]

Read More

Merry Christmas and Happy New Year 2022 from SAP Expert

Dmitry Kaglik

December 25, 2021


No Comment

My dear readers! It is holiday season again upon us! Another year has gone. 2021 comes to the end. The year of surprises, struggle, success and wins. Christmas is today, and New Year is just around the corner. Let’s celebrate these! Let’s make new and better plans for future year. SAP Expert had its ups […]

Read More


  • Emile Van den Hoogen on September 4, 2018

    Nice article. For the section, what is next?, I am looking at processing the bank statements via web services calls (SOAP wsdl). There are a couple of BAPIs BAPI_ACCSTMT** that probably can be converted into webservices. After importing the bank statements, postprocessing can be handled via a triggered batch job.
    Also I saw that there is an SAP solution called Financial Network Services that can handle electronic bank statements. May be it would be nice to add some thoughts / information about these recent developments as well, since SOAP webservices is more standard than idocs based.

  • […] is very likely that PVT will be the first time when you see the Bank Statement reflecting your payments made the new way. This means that some changes in the EBS configuration […]

  • […] published multiple articles about the bank statement process in SAP. We looked at the ways to import the statement, the ways to process the end-of-day and intra-day […]

Leave a Reply

Your email address will not be published.

Search this site


You can subscribe to our regular updates here.


Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...
Disclaimer and privacy policy