Electronic bank statement

[Former Member]

Helo all,

Client receives a file from the bank in the excel format with the following details.

A/c number

Customer name

Branch name

Currency

Posting date

Value date

Naration1

Naration 2

Naration 3

Debit (amt)

Credit(Amt)

Balance

CR/DR indicator.

Is it possible to process the above file with the electronic bank statement in SAP.

What will system look at when processing the electronic bank statement. Is it worth investing our time in developing a Z program with the above details.

Please let us knoe.

Thanks

Aravind

[Former Member]

Hi Aravind,

You will need to develop a preprocessing program to convert the file into an SAP acceptable format (BAI, multi cash etc.). Also you will need to complete the configuration for electronic bank statement processing. Before you develop the program check with the bank if they can provide these information in any SAP acceptable format.

SAP will use the bank acount number from the file to find the G/L account it needs to post to. One thing I am missing on the file is the information about what kind of transaction is it. SAP need that information to figure out what the offsetting entry will be.

Your question whether it is worth it, depends on how much time now users spend on making these manual postings. Developing the program will take some time and effort but once the it is done thes postings can be set up to post automatically.

[Former Member]

Hi,

Thanks for the reply.

In the narration 1 column mentioned above, I have various descriptions like

Inward Clg Cheque

Transfer

Merchant Settlement

TRADE FINANCE CREDIT

Cash Deposit

Inward RTGS-ACH Pymt

Outward RTGS-ACH Pymt

Cash Withdrawal-Cheque

Int Pyt Time Dep No.

PD Interest Debit

Standing Order

Debit Interest

Will the above info would be sufficient?. Also, do you have an idea as how to convert the above file to SAP acceptable format. Where would I get the SAP acceptable file formats and would we able to read the file with proper interpretation.

Thanks

Aravind

[Former Member]

Hi Aravind

These information will help you to build your configuration in SAP, for example Inward clg check should debit the master cash and credit may be the incoming check clearing account. You will need to assign a posting code to each transaction types and configure the posting rule configuration in SAP.

Here is a sample BAI format

01,121000358,ABC,070512,0221,1,80,1,2/

02,STANDARD,BOFAGB22,1,070511,2359,,/

03,600835136010,GBP,fab1,1344217,,V,070514,0000/

88,fab2,5495,,V,070515,0000,fab3,5495,,V,070516,0000/

88,fab4,5495,,V,070517,0000,fab5,5495,,V,070518,0000/

88,010,91917,,,015,35195,,,045,2504723,,,100,1300000,,/

88,400,1356722,,/

16,208,1300000,V,070511,0000,6008131LFL27,/

88,ABC INTERNATIONAL INC

88,TRF/REF 6008AQS131LFL27

88,/IVD-11 MAY

Follow this link to get an idea about explanation of each of the field in the file.

https://businessonline.huntington.com/common/cms/help/BAI1Technical%20Ref%20Manual.pdf

If the bank cannot provide the file in the BAI format, you will need to convert the current file into the above format.

[Former Member]

Hi,

Thanks again.

Regards

Aravind