Introduction to SAP BSM

Dmitry Kaglik

October 2, 2017

SAP

No Comment

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 paid and so on. There are multiple ways how the bank statement can be entered into SAP system.

Receiving a bank statement is one task, and another one is to monitor that all bank statements for all bank accounts were received and processed in time. Is there a tool from SAP for that?

Enter BCM-BSM functionality. To explain the abbreviations, it is Bank Communication Manager, Bank Statement Monitor functionality. It is a part of Financial Supply Chain Management module (FSCM). You may need to activate this component FIN-FSCM-BNK separately in the list of Business Functions (transaction SFW5). It is also advisable to implement SAP Note 1486308 if it is applicable to your system.

What does BSM allow you?

BCM-BSM functionality allows you to monitor bank statements for bank accounts. The way how you receive the statement and enter it into SAP is not important. The following parameters are checked:

  1. Bank statement arrived in time.
  2. Bank statement numbers are sequential. Last 5 bank statements for the bank account are checked.
  3. A difference between the bank statement and bank General Ledger account balances is within a tolerance.
  4. Bank statement is properly reconciled and all items are posted.

To call up Bank Statement Monitor, you need to run transaction FTE_BSM.

How is that configured?

The configuration of Bank Statement Monitor is simple. Of course, it is just an addition to the configuration of bank statement entry and processing, which is much more difficult task. Whole BSM configuration is kept in the IMG transaction FTE_BSM_CUST.

Here you list the bank accounts you need to see in BSM report. You enter Company Code, House Bank ID and House Bank Account ID for each bank account.

For each account you also need to tick checkboxes for the checking parameters available in FTE_BSM transaction. Please see them above. In addition to these checkboxes, you can configure specific parameters for some of the checking options.

First, you need to tell the system how often you receive the statement: daily, monthly, every 2 weeks and so on. If you only receive the statement on certain days, you may assign Factory Calendar here. It will ensure that the indicator responsible for timely bank statement receipt shows the correct information.

Separate field allows you to configure a tolerance between the bank statement and bank GL account balances, if these balances do not match. Usually this tolerance should be zero, but you can put your own value here. Tolerance is entered in the bank account currency.

If you need to see bank accounts in a specific order, you can enter the position in the list too.

Running the transaction

Once you configured the Bank Statement Monitor transaction, you can run transaction FTE_BSM. Selection screen of the report allows you to limit the set of company codes, house banks and house bank accounts. It also gives you the option to run the report for the specific key date. Current date is default.

FTE_BSM selection screen
FTE_BSM selection screen

The results will show you a list of house bank accounts according to selection parameters and configuration. For each bank account you will see bank statement opening and closing balance, debit and credit turnovers, GL account balance, a difference between the GL and closing balance and, of course, four traffic light indicators for each of four possible checking parameters. There is some technical information about the bank account, bank statement and its entry too.

FTE_BSM results
FTE_BSM results

Some of the report fields are underlined. Clicking it, you get details of the most recent statement for the bank account, or list of the bank GL account line items.

Background running of this transaction is not allowed, you so need to consider performance aspects when running the report too.

As you can see, the implementation of the Bank Statement Monitor is simple enough, but it gives users a powerful cockpit to monitor the bank statements process.

Do you have questions about BSM-BSM or any other FSCM-BCM components? Why not ask SAP Expert?

Related Posts

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

SAP Expert is in top 30 of SAP Blogs

Dmitry Kaglik

March 16, 2018

SAP

No Comment

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailSAP Expert blog is now about 5.5 years old. There are about 140 posts on this site, and there is a free e-book you can read to learn more about SAP Finance. It means that the inclusion of SAP Expert into Top 60 SAP Blogs by Feedspot is a well deserved award. Who […]

Read More

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