Pre-requisite of Electronic BRS

[Former Member]

Hi,

My client's requirement is to use electronic bank statement. For this I need to configure the steps as mentioned in SPRO for electronic bank statement.

I went through the posts in SDN forum. But i want to know the pre-requisites (like interface required for Electronic BRS, Multicash format from banks, etc) required for Electronic BRS.

My client does not have any interface or Mullticash format. It just downloads statement from internet and does manual BRS.

Please let me know if EBRS possible in such scenario

Edited by: Meenu_ND on May 5, 2011 9:58 AM

[Former Member]

Meenu-

Implementing Electronic Bank Statement is going to be quite a task:

1. First thing would be to ask your bank in which format they can provide you the statement. Lets say they provide you in BAI Format.

2. Then you would have to get a list of BAI Codes that will be used by your bank in their statements.

3. Get a list of bank accounts that you would be uploading electronically in SAP

4. Based on your company GL Account structure, create all the clearing accounts that are needed (cash receipt, cash disbursement, check receipt, check disbursement, clearing accounts etc).

5. Configure EBS in the system which includes creating BAI Codes, mapping accounts to bai codes, assigning your bank account numbers to company codes to BAI Structure.

Again, it all depends on what format you will be using. In US, we use BAI format and it is pretty straightforward task.

Hope this helps.

Shail

[Former Member]

But any interface is required with that bank or i can get statement without any interface.

[Former Member]

Hi,

You can ask the bank to either mail it or you can define a interface. In case of interface you can schedule the bank reco, in case of mail you need to run it manually.

Regards

[Former Member]

Hi,

You are doing it through MT940.

then you require the bank statement and their numocic codes. These codes need to be mapped in SAP through customisation.

One thing more, take the requirement from client aswell. Because in EBS the Bank charges are posted to one GL only with one cost center assigned to it. In case client wants to post the bank charges according to the different cost centre then there will be a porblem.

Regards

NS

[Former Member]

Hi NS

Where do we do the mapping in SAP, for example the bank sends file in a format which need mapping, my client uses a third party tool where the mapping is done and after which the file comes into SAP as an Idoc. let me know

regards

victor

[Former Member]

Hi Victor,

As per the forum guideline please post your question in separate post.

Regards

[Former Member]

Hi,

You can ask for two things from the bank-

1. Bank file in electronic format

2. Detail explanation of the fileds in the file. Every bank provides a information file which describe in detail the meaning of each field in the electronic file. Thi file forms the primary information basis for defining the electronic bank statement.

Regards

Milind Sonalkar