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:
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.
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:
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.
New FEBAN is another transaction for the bank statement process. You can read more about it here.
Do you use statement upload functionality in your company?