Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 24, 2017 at 03:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jul 24, 2017 at 05:08 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2017 at 12:18 PM

    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

    Add comment
    10|10000 characters needed 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.