Understanding the bank statement process in SAP

Dmitry Kaglik

February 1, 2016

SAP

11 Comments

Bank statement is the document that bank sends to your company to update you about the balances and transactions on the bank account that the company holds in that bank.

You can receive that statement in various ways. Of course, you need to process these statements in SAP to reflect the bank account transactions. That’s the accounting rule. The way how you process the statement depends on the format you get the statement in. Generally speaking, there are three ways to enter statement in SAP:

  1. Electronic bank statement (EBS). If your bank sends the statement in the format of electronic file, you can import that file using the special tools. Usually you run transaction FF_5 or FF.5 to import such bank statement. There are various bank statement formats available for automatic processing by SAP. There is also a converter tool in transaction DMEE that allows you to convert your bespoke format to a Multicash file acceptable by SAP.
  2. Manual bank statement (MBS). If you get your statement in a paper format or the format that cannot be automatically imported into SAP, you have an option to enter the statement details manually using the SAP transaction FF67.
  3. Manual postings. This means you enter the statement transactions using the non-banking system tools, for example F-53, F-28 or FB01.

If you process the statement using the EBS or MBS processes, you can review the statement using the transaction FEBAN. It gives you an option to see the statements in a tree format where House Bank, House Bank Account and Statement number are the nodes and individual transactions are the end leaves. Once you click the leaf, the right part of the screen shows the details of the transaction. In particular, it gives you an overview of posting status for the statement item.

FEBAN screen
FEBAN screen

What can you see there?

To start with, there are two postings areas. They represent two parts of the banking transactions as you configure them: banking and sub-ledger areas. You can have postings in one or both areas, depending on how you configure your statements. Effectively, you can have different contents in each part of the FEBAN screen.

There are two fields where document numbers can be found in each posting area: Document and Payment on Account

Document number is filled with a proper number if your statement is successfully posted on-line and your transaction is configured to be either without clearing, or with clearing and that clearing was successful. That is valid, for example, when your Bank Statement is properly integrated with the payment process.

Payment on Account field is filled with a document number if you asked system to run a clearing transaction, but clearing was not successful. You can control whether or not “payment on account” is possible by providing the posting key in the “Posting on account” field of the Posting Rule configuration. Additional control is the checkbox “No automatic clearing” in the assignment of bank accounts to transaction types in the EBS configuration.

Other than actual document numbers, the Document number field may contain technical values:

  • Blank value means that the posting area hasn’t been processed yet. You can initiate this process by clicking the “Save” button on the FEBAN screen. This process is called “online post-processing”. If your post-processing is successful, it will update the document number in FEBAN.
  • Dash (“-“) means that the posting area is not relevant to the statement item by the Posting Rule configuration.
  • Asterisk (“*”) means that document generation was not requested when the statement was entered. For example, you could request system to generate a batch input session with posting transactions. You can do it either via a radiobutton on FF_5 selection screen for Electronic Bank Statement, or in Specifications for Manual Bank Statement FF67. This is an off-line post-processing of bank statement.

 

If you have a document number in any of these fields in any Posting Area, you can double-click it and see the document itself.

Unfortunately, there is no option to drill-down to the document number if the statement was posted off-line, even if the document has been actually posted after the statement upload.

You can also read more about EBS configuration in the Free e-book by SAP Expert.

Do you use statement upload functionality in your company?

Related Posts

Automatic period closing in SAP Finance

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailPeriod closing is a process that involves many steps in different SAP modules. Even if we take SAP Finance (FI) alone, period closing activities include various steps in GL, AP, AR, Assets and other submodules. To ensure the period closing is complete and reports are finalized, users maintain a table with periods open […]

Read More

What was your first SAP project?

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailMy dear readers! I believe the majority of you work in SAP world. Some of you have just started, some of you work with SAP all your life. But do you actually remember how your SAP life stared? What was your first project? What was your first task? Let us share the experience, […]

Read More

11 Comments

  • Michael on March 25, 2016

    Dmitry, thank you for the article! It’s a good work and so necessary help for beginners.

  • Barry on December 29, 2017

    btw, i want to know, what is FEBAN? we have known that it’s T-code, but in fact,what is it? is FEBAN an sub-ledger or something else? thank u very much..

    • Dmitry Kaglik on December 29, 2017

      Barry, FEBAN is a transaction in SAP to overview and post-process bank statements.

      • Barry on December 29, 2017

        ooh,, okay Dmitry.. thanks for quick response.. have a nice day. 🙂

  • Barry on December 29, 2017

    Dmitry, could you explain to me, what is difference between “G/L Posted” and “Posted” after post manual bank statement in FF67?

    thanks.. 🙂

    • Dmitry Kaglik on January 4, 2018

      That’s probably the difference between the 1st and 2nd posting areas. I’m not sure as I haven’t dealt with FF67 for quite some time.

  • subhash on January 19, 2018

    nice article

  • shadab on January 30, 2018

    Can you please help me as in my company client is proving ISO file format and we need 2 document posted for a line item.we are using ff_5

    • Dmitry Kaglik on January 31, 2018

      This question is not to be resolved in the comments. You need more help, please contact for the quotation.

Leave a Reply

Your email address will not be published. Required fields are marked *

Search this site

Subscribe!

Polls

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