Auto clearing of bank open items via MT940 statements

[former_member692985]

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

[lenastodal]

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)

[sanilbhandari]

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

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

[sandip_kurewar]

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

[narasimhulu_konnipati]

Hi,

Please go through the below blog.

https://archive.sap.com/kmuuid2/20d2f203-4959-2e10-239f-bce48eef858d/Electronic%20Bank%20Statement-M...

Thanks,

NSK