Skip to Content

Bank statement upload error for luxumberg bank

Dear Expert,

We got MT940 file format (global) from bank based in Luxemburg. I converted into .txt format and then we are trying to upload then it is giving error,

"Bank statement file format not found for DE01 (Rosneft Deutschland GmbH), 1000190 (Bank GPB International S.A.), or country Luxembourg".

As this is MT940 global file format then system should accept this. Could you please let me know what is going wrong over here?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 01, 2017 at 01:34 PM

    Hi Sujeet,

    By Design directly supports below MT940 formats

    1. MT940 DE

    2. MT940 China

    3. MT940 DK

    4. MT940 NL

    5. MT940 SG

    6. MT940 UK

    7. MT940 ZA

    8. MT940 Austria

    9. MT940 Switzerland

    So you don't have to convert it into a .txt file.

    Please check the below help document.

    Automatically Generated Bank Statements — Configuration Guide

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 22, 2017 at 05:56 AM

    Hi Sujeet,

    As discussed with you, You are receiving error as have maintained the wrong information in the tag 25 as swift code.
    MT940 DE format calls for NBC (national bank code) and Bank Account in tag 25:

    Also, the file should be sent by bank for uploading in SAP ByDesign system.
    What is implemented in ByDesign is the standard specification for MT940, all this is already available on the SWIFT portal. If you upload a file that adheres to this, then it will work.

    As you need additional details regarding tags in MT940DE format:

    Tag 61, the logic is like it will take the data after NTRF till it found "//" and put it in memo lines.
    Tag 86 : You need to provide the data under respective tags which are mapped to memo lines like Tag ?00, ?21, etc.

    For ex: tage61: NTRF4120000077//3700031464

    so in this case it is picked 4120000077(as memo line) out of NTRF4120000077//3700031464 it is quite clear that what will be present in the memo line for Tag 61. In addition to above the data after "//" (3700031464) is not mapped to memo line data which is why it is not present in memo line.

    Best Regards,

    Annapurna V

    Add comment
    10|10000 characters needed characters exceeded