Electronic Bank Statement - .CSV files

[Former Member]

Hi,

One of our client located in UK. They are using Electronc bank system.

Now they requested some changes as below:

NatWest Bank are discontinuing BAI files in favour of CSV.

We currently connect to Backline using a modem dial-up connection. All of our account transactions are downloaded into a text file called u2018BAI.txtu2019.

NatWest have informed us that they will be discontinuing the modem dial-up service in two weeks time, in favour of a web based version. This web based version doesn't produce BAI.txt files, which we import into SAP. Instead it produces CSV files that have a completely different format and so won't import into SAP without either SAP or the file being modified.

All of our over-seas accounts from Ulster Bank also get fed into the NatWest system and exported into the BAI.txt files so that they can be imported into SAP.

Could you please suggest me how to implement these changes.

Thanks in advance.

[Former Member]

Hi,

Is there any EDI team involved when transfering data from bank to your client. If so you can work along with them to convert the CSV file to BAI format wiht the required fields. Or the best thing would be to approach SAP Team for further assistance on this.

regards,

radhika

[Former Member]

Hi,

our client receive the file from bank, they will upload that file into t.codeFF.5. Till today they are receiving BAI file, now their bank(natwest bank) will send .csv files.

Could you pl let us know, is there anything to do from functional side? also let me know is there any guidence to be provided to technical team from functional.

Awaiting for your reply ...

thanks in advance

[Former Member]

currently that Natwest bank is extending the BAI File format for some time, in the mean time they told they would like to come up with some solution without effecting their exisitng customers.

so we have closed this call for the time being.

regards,

Prasad