Automatic clearing Bank Statement Items

[Karim_OUBRAHAM_]

Dear Expert,

I need your help regarding the automatic clearing for Bank Statement Items.

When I upload a Bank statement, or create a new one manually, the system proceeds to clear the Bank Statement item automatically.

Knowing that, the posting rule used, for example is F007 with 02 steps, and the interpretation algorithm linked to the posing rule with its External transaction is 000: No Interpretation (No relevant)

What are the rules of automatic clearing that explains on what basis SAP chose the appropriate open item ?

How can we avoid this situation, i.e. when we upload a bank statement, the system let us to reprocess the bank statement item manually?

Best Regards,

Karim

[former_member132315 · Accepted solution]

Hi Karim,

Also I'm not sure if it helps, but you might check the following SAP documentation on the Interpretation Algorithms:

- https://help.sap.com/saphelp_me61/helpdata/en/4d/c5efb40c381c36e10000000a42189b/content.htm?no_cache...

So your question was:

"How can we avoid this situation, i.e. when we upload a bank statement, the system let us to reprocess the bank statement item manually?"

Well, if the algorithm does not match the with the criteria (for instance document number, reference, depending on the algorithm that you are using) then the system will not find the document to match leading to the post processing where you need to clear it manually.

You are using the 000 algorithm:

000 (No interpretation): You use this algorithm if you do not want to use the standard algorithms supplied by SAP. Instead, you use the algorithms you defined yourself, in conjunction with functional enhancements (user exits).

Hence how have you defined this?

Please let me know if I can further assist you on this and if you have any other further doubt!

Wish you a great week!

Stay safe!

All the best,

Gabriel.

[Aswathi_Menon]

Hi Karim,

These algorithms are defined for On-Premise systems as well. In On-Premise, customers can assign the interpretation algorithm 000 and can use User Exits instead of the standard algorithms provided by SAP. However in S4HC, we don't have the functionality to use user exits.

For automatic clearing of bank statement items, you can use the below algorithms in the link except 000 - No interpretation algorithm if there is a clearing involved.

https://help.sap.com/viewer/TEST/918bca53037f408f91a2295d04ac16bc/LATEST/en-US/4dc5efb40c381c36e1000...

Otherwise, if you wish to manually process the bank statement, you can assign the algorithm 000 and manually reprocess the bank statement item in the app "Reprocess Bank Statement Items".

You can find the details regarding Posting rules in the KBA 2854415 - Information on Bank Statement Posting Rules in SAP S/4HANA Cloud system.

Thanks & Regards,

Aswathi

[Eddie_Andia]

Hello Karim

Please refer to KBA 2854415 for information on Bank Statement Posting Rules in SAP S/4HANA Cloud system as it provides information on the topic of posting rules:

https://launchpad.support.sap.com/#/notes/2854415

Regards

Eddie

[former_member132363]

Here are some SAP resources you may review based on your topic "upload | of | clearing bank statement items | bank statement | bank statement item | interpretation | system proceeds | transaction"

Best Practices for SAP S/4HANA Cloud

Revenue associated with service contract items is recognized periodically based ... a unique Financial Statement Version (FSV) to support financial planning and analysis. ... Group Account Preparation for Financial Consolidation - This scope item ... between SAP S/4HANA Cloud Group Reporting and the external systems.

https://support.sap.com/en/product/best-practices-s4hana-cloud.html

2937668 - SAP Business ByDesign 2005 Hotfix Collection 2 ...

It can also be added into the reports based on Account Details report. ... You can now upload an old custom OData service XML file (downloaded prior to the ... ( Hotfix ID: 1000006839); While accessing the system using the system link received ... Origin Business Transaction Type (BTT) on Sales Order item has been fixed.

https://apps.support.sap.com/sap/support/knowledge/public/en/2937668

Finance ERP

These CSV files contain line item-level details about VAT and schedule tax ... KW -LOG: New Support package for Letter of Credit and Bank Guarantee ... For SAP ERP on-premise releases: Set up accounting systems to process transactions at ... the payment reference in the G/L account line must be ready for input in the FI?...

https://support.sap.com/en/product/globalization/fi-erp.html