Skip to Content

Auto clearing of bank open items via MT940 statements

Hi

I am currently working on a project for Electronic bank statement automation in SAP via MT940 , the idea is to automate bank statement upload via swift and then auto clear the entries into AR/ AP / General ledgers

I am struggling to find an efficient way to establish the existing GL mappings and BC codes used in current bank format which can then be used to link with Mt940 formats , please can some one help and share experience

regards

rinki

Add a comment
10|10000 characters needed characters exceeded

  • Hi Rinki,

    Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

    First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
    For example you:
    - can outline what steps you took to find answers (and why they weren't helpful)
    - can share screenshots of what you've seen/done
    - can use a descriptive subject line

    Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

    Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

    Best regards,
    Lena (SAP Community Moderator)

Related questions

3 Answers

  • Posted on Jul 25, 2020 at 05:26 AM

    Hello Rinki Agarwal

    The document provided by Narasimhulu Konnipati is a good starting point for setting up EBS for MT 940. In addition to the same, please pay specific attention to the rules you set up for customer incoming payments which can also clear customer postings automatically using EBS. The below blog should be very useful

    https://blogs.sap.com/2020/04/15/sap-electronic-bank-statement-customer-open-items-clearing/

    Another big help to set up auto clearing in EBS is the set up of search strings. The below blogs should be very helpful

    https://blogs.sap.com/2014/05/06/ebs-configuration-of-search-string-part-1/

    https://blogs.sap.com/2014/05/17/ebs-configuration-of-search-string-part-2/

    https://blogs.sap.com/2020/02/10/search-string-in-ebs-part-3-bank-charges/

    If you are already on S/4HANA 1709 or upwards there are innovations in cash applications which should be used as well using ML, where the open items can be cleared based on historical data using ML and without extensive configurations. The below blog could be your starting point:

    https://blogs.sap.com/2020/05/07/sap-s-4hana-cloud-intelligent-scenarios-in-finance-1-machine-learning/

    https://blogs.sap.com/2020/07/20/cash-application-with-machine-learning-summary-info/

    I would strongly recommend using the ML Application as it will make the life of a cash collection associate really easy !!

    Thanks & Regards

    Sanil Bhandari

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2020 at 04:57 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2020 at 03:55 PM

    Dear Rinki Agarwal, I have answered the similar question in the below link, hopefully this will help you to understand the logic for getting GL and mapping the GL for exiting accounts.

    https://answers.sap.com/questions/13101584/ebs-and-trm-setup-for-new-banks-accounts.html

    BR,

    Sandip Kurewar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.