cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

JohnMeadows
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Former Member
0 Kudos

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

JohnMeadows
Product and Topic Expert
Product and Topic Expert
0 Kudos
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

Former Member
0 Kudos

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

JohnMeadows
Product and Topic Expert
Product and Topic Expert
0 Kudos

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 Kudos

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

Former Member
0 Kudos

Thanks Annapurna.

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

Thanks.

ramprasath
Explorer
0 Kudos

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).

Former Member
0 Kudos

Hello Ramprasath,

Do i need to set up lockbox for it.

Thanks,

Nikita