Understanding the bank statement process in SAP

Dmitry Kaglik

February 1, 2016

SAP

2 Comments

Share the knowledge:Share on FacebookTweet about this on TwitterShare on LinkedInShare on Google+Share on RedditShare on VKShare on StumbleUponEmail this to someone

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?

Share the knowledge:Share on FacebookTweet about this on TwitterShare on LinkedInShare on Google+Share on RedditShare on VKShare on StumbleUponEmail this to someone

Related Posts

Introduction to SAP BSM

Dmitry Kaglik

October 2, 2017

SAP

No Comment

Share the knowledge:Bank statement is the document that tells the bank account holder the status of the bank account balance along with the list of incoming and outgoing payment transactions. When the statement is received, it should be entered into SAP system to reconcile bank accounting and general ledger, mark payments as processed, invoices as […]

Read More

Three methods to import bank statement in SAP

Dmitry Kaglik

September 4, 2017

SAP

No Comment

Share the knowledge: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 […]

Read More

2 Comments

  • Michael on March 25, 2016

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

Leave a Reply

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

Search this site

Subscribe!

Enter your email address:

Polls

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

View Results

Loading ... Loading ...