Electronic bank statement process and format

[Former Member]

Hi,

I have gone through the documentation of electronic bank bank statement..but it did not give me clear picture how it works.

Expecting answer from this discussion with a clear view.

which EBS format we use for Indian banks and the details of format?

Thanks,

Ranjan.

[Former Member]

Hi Ranjan,

the purpose of Bank reconciliation is to reconcile all the receipts and payments based on encashment or clearing at the bank. below example gives an understanding of how bank reconciliation works. ( In this example, t-codes are given for manual BRS) .

Here we are using intermediary or clearing accounts for the purpose of reconciliation. when the bank statement is uploaded in FF_5, the clearing account will become zero and amounts will be transferred to main bank account.

When coming to formats,  BAI2, MT940 are popular formats among others.

For configuration, you can go through the below links :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d2f203-4959-2e10-239f-bce48eef8...

http://srilogix.com/casesWhitepapers/Electronic%20Bank%20Statement.pdf

Br,

Venkat

[former_member219221]

Hi Venkat,

Nice doc & reply.

I need manual bank statement BRS configuration steps(either in screen shots or video tutorials) with minimum of 2banks(2 or More) setting in same company code.  I am confusing about this.  Hence, my request you provide configuration settings for the same.

Thanks in advance,

Singh

[Former Member]

Hi Singh,

Please go through the below document and let me know if any questions.

Br,

Venkat

[former_member219221]

Hi Venkat,

I am very much thankful to you for giving very nice information regarding MBRS with screen shots.  But still i have some doubts and i am unable(often confusing) to configure MBRS settings for 2 or more banks in same company code.  Here, my doubt is how many GL A/cs are required for Main Bank A/c&etc., and shall we use different main bank a/cs, same check issue/deposit GL A/c for 2 or more banks in same company code.

Kindly solve my doubt.

Thanks with Regards

Singh

[Former Member]

Hi Singh,

You need not do the configuration again in case of 2 bank accounts.

what you can do is mask the GL accounts in step 2 assign accounts to account symbols ( as given below )and create GL account in second company code and ensure the last digits are same like 200170, 200180 for main bank, 200171, 200181 for check issue, 200172, 200182 checks deposit respectively for company code 1 and 2. then you can use the configuration for second company code also.

+++++0  Main bank 

+++++1  Check Issue account

+++++2 Check Deposit account

Br,

Venkat

[Former Member]

Hi Venkat,

Thank you for your explanation.

If you have, can you share a bank statement in MT940 format and how SAP understands this process.

Any configuration is required which will process the MT940 format statement in SAP?

Regards,

Venkat

[Former Member]

Hi Ranjan

Have you understood the EBS config steps? its requirement ? Hope u r well aware of MBRS process and just go through te cofig steps clearly then u will understand the process it will work and which is the format your bank can provide on time to time basis and how you can map the same to SAP  with help of ABAPer/XI 's  etc.....

Pls check the  link given by CS as above...

T&R

maalik

[former_member198032]

Hi Ranjan,

Have you check this note?

106121     Electronic bank statement formats

also check these links:

http://scn.sap.com/thread/1370696

http://scn.sap.com/thread/2109148

http://scn.sap.com/thread/846819

Best regards,

Cristiano