Skip to Content
0

How to use Bank Statement in csv /Excel to upload in SAP ByD as Import bank statemet format is BAI2

Jul 23, 2017 at 05:36 PM

245

avatar image
Former Member

Hello All,

I am trying to use CVS /Excel file bank statement in SAP ByD as follows

Liquidity Management-New-inbound file-File type(bank statement)-

After selecting Bank ID,it populates Import Format as BAI2 US.

So how can i use CSV/Excel bank statement format in above step.

Please Guide.

Thank You.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

John Meadows
Jul 24, 2017 at 03:17 PM
0

Hi Nikitanikhil

It isn't clear from your question where exactly the problem lies.

Do you need to know how to assign your downloaded format to the correct format in ByD for your bank account?

Does the format not exist in ByD and are you trying to create a new Bank Statement format to accept the uploaded file?

Please supply some clarity and I will try to help you.

John Meadows

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello John,

Thanks for the reply.

Does the format not exist in ByD and are you trying to create a new Bank Statement format to accept the uploaded file?

Yes the bank statement is in excel file or csv file and SAP ByD accepts BAI2 format. I don't have BAI2 format available.

How do i convert my excel bank statement into BAI2 format?

Thanks

0
I understand, so you have an excel/csv file from you bank, which doesn't match the format expected in bydesign.

there are 2 solutions.

you can create your own input file format in the fine tune activity "Automatically Generated Bank Statements"

However if this doesn't work (due to data format, or special circumstances) you can build a bank statement file import process using the Cloud Application Studio Localisation toolkit (from help.sap.com)

John

0
Former Member

Hello John ,

Thank You for your response.I managed to get BAI2 file, but when i am uploading it gives me conversion error . Can you guide on this. Also Cloud Application Studio Localisation toolkit which you mention , is it free to download ?

Can i do modifications in standard reports like adding our company logo, adding more fields on selection screen .

Thanks,

Nikita

0

SAP doesn't support the BAI2 file format import, so will need to create the import routine via the Cloud Application studio. This is not free, so contact you partner business manager to get a contract in place. when you have that let me know and I can share the "how-to" documents,

Regards

John

0
Ramprasath Kannan Jul 24, 2017 at 05:08 AM
0

Hi,

you just have to upload the bank statement which you received it from the bank. the bank statement should have the below items

1. opening balance

2. closing balance

3. total debit balance (if any debit transaction mentioned in the bank statement)

4. total credit balance (if any credit transaction mentioned in the bank statement).

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Ramprasath,

Do i need to set up lockbox for it.

Thanks,

Nikita

0
Annapurna Vunnam
Jul 24, 2017 at 12:18 PM
0

Hi Nikitanikhil,

There is a Business configuration setting> Automatically Generated Bank Statements activity>Assign Import formats for bank statements and

here you can add extra formats for the respective company(ISO20022 is a standardized xml format). Hope this will meet your requirement.

Best Regards,

Annapurna

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Annapurna.

Yes but there is no format available for CSV or excel file bank statement. So got stuck there.

Thanks.

0