Skip to Content

Mt940 Issue

Dear All,

i have a client who receives bank statement in excel or pdf format.. which i need to convert in format which is supported by sap.. How can i do that?? any external software or through sap itself??? Please guide me ...

Thanks in advance


Regards

Abhay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 06:16 PM

    Hi Abhay,

    There's no direct way of converting your files to SAP readable formats but you can try to develop a VBA code/macro to convert your excel files to MT940/BAI format. You just need to analyze if the data in the excel file being sent by the bank has necessary information to put it in other formats.

    There are a lot of materials online about the formatting specifications of both MT940 or BAI.

    Hope this helps.

    Regards,

    Jayj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 28, 2014 at 05:24 AM

    Dear Abhay,

    I don't think if it possible to convert excel or Pdf statement into SAP compatible format.

    SAP is compatible with MT940 ( structure,unstructured, Multicash), BAI, BAI II and other formats.

    If you need to reconcile with excel or pdf, then you can suggest the option of manual reconciliation using FF67.

    If you need automatic recon, then you need to get the desired format from the bank and configure SAP based on the same.

    Hope this helps,

    Regards,

    M S Lokesh

    Add comment
    10|10000 characters needed characters exceeded