cancel
Showing results for 
Search instead for 
Did you mean: 

how to upload electronic bank statement

Former Member
0 Kudos

Dear All,

i need clarity in how to upload the electronic file given by bank.either by converting format given by bank into text file or do we need to run BDC using FB05.at what stage FF_5 comes into picture.

my requirement is to know the procedure in detail whatwe do before executing FF_5. (by what means we upload data).

it is critical requirement.please guide me.

the relevant answers will be rewarded points.

regards,

sai

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

Dear sai,

your bank has to tell you which file format it is offering. Until you do not know which file format is provided, it is fruitless to think about the importing strategy.

The best would be your bank provides MT940.

If you use RFEBKA96 inly the bank data storage is cleared. All postings remain. Importing the statement again could cause double postings. It is strongly recommended to use RFEBKA96 only in test environment.

Kind Regards

Matthias

Former Member
0 Kudos

Dear Friends,

We have uploaded a bank statement with current day incomplete data instead of uploading previous day data.

We have also successfully loaded previous days data subsequently

Issue

What is the procedure to delete current day INCOMPLETE data (data obtained during the day)?

As we are now ready with current day COMPLETE data (data obtained at the end of the day), I assume that manually reversing out the incomplete entries and reloading the COMPLETE data file would be an option.

Could anyone please let me know what would be the ideal way to treat the current scenario.

Thanks for your guidance in advance

Sai Venkat

Former Member
0 Kudos

Pleaase clear what the problems are you facing when you are uploading bank statement using tcode se38 and program RFEBKAT5 and then use t code ff.5. I think this is the way you can upload the bank statment.If it is lockbox file then use T code FLB2. If you have already run the bank statement reconciliation today, you have to delete the test data, as the program only allows you to run this once a day.to delete use se38 and program RFEBKA96.

I hope this will help.

Plz assign points if helpful.

Regards,

Manish

Former Member
0 Kudos

Hi Manish,

Is it that if the bank statement is uploaded twice & if I delete that duplicate statement using RFEBKA96 in SE38; will the postings made get reversed or not?

How do I revrese the accounting entries of bank statement upload, in casae the same statement is uploaded on next day. Is there any way to delete these entries.

Waiting for your reply

Thanks & Regards,

Raghava

Former Member
0 Kudos

Hi sai,

You can upload your file given by bank(BAI or BAI2 format) thr' T-Code FLB2 and it will clear the customer invoices.

Hope it will help.

Regards,

Manish

Former Member
0 Kudos

Hi Sai,

You have mentioned that you have a file to upload into EBS. Please ensure the following points :

- Type of file :

- Multicash

- SWIFT MT940 (Structured / Unstructured)

- ETEBAC (French)

- DTAUS (German)

- BAI Format

The file which has to be uploaded should be in one of the above formats. These formats should be as per the specifications as the respective Country. In TCode FF_5, you have to provide the path of the file and chose the parameter, either you want to directly post them or want to create a Batch input and later post them.

Hope this information helps you.

Suresh Jayanthi.

Former Member
0 Kudos

hi suersh jayanti,

thank you very much for u r answer.i have already assigned the relevant points to you.

i have some more queries.do we receive from banks in the prescribed format which is feasible to upload directly into sap from ff.5 or

do we need to inform to bank about the format what we want.

and

after receving statement from bank in the prescribed format shall we need to convert into text files UMSATZ.TXT and AUSZUG.TXT. or will we get them in text form directly from bank.

please give the information about the pre-process to import of data.

i will be helpful to me if u can share the info.

thanks

sairam (hemanth)

former_member256837
Contributor
0 Kudos

Hi Sairam,

When you go for electronic bank reconciliation in SAP, you have to use format MT940.

1. Yes, You need to inform your bank for this particular format MT940.

2. Your bank will provide you file of bank statement in this format and this file you can upload directly to SAP with FF.5 or FF_5.

3. You can directly upload file, no need to convert. bank will give you ready format.

Hope this clarifies your queries. Assign points if useful.

Regards,

Pritam