How to automate clearing status of Bank Items when posting manual bank statements?

[Melle1028]

Dear Experts,

I would like to know how to automate the clearing status of Bank items when posting manually created bank statements in the SAP S4Hana public cloud system?

I plan to use only the manual transactions, F005 (Other Disbursements) and F006 (Other Receipts) regardless of the type of payment used (eg., check, cash, transfer). Also, will be using the Assignment field as the reference for auto-clearing. Is my procedure okay? 

I don't know how to set the processing rules for bank statements wherein, upon posting of the bank statement, the system will automatically create a journal entry to close the clearing account and change its status to cleared. 

My initial set up in the system for automated processing rule is, 

this setup only post a journal entry and still an open item, need to manually clear. What I need is to automate the clearing process given the Amount and the reference in the Assignment field for auto-clearing. 

Currently using the SAP S4hana cloud, Public version 2502 system.

Thank You

Best regards,

Meri

[Naveenk_S42024]

Hi @Melle1028,

I read the post and understood that you wanted to clear the AP and AR open items while doing the Manual Bank Statement.

Firstly you have selected wrong Manual transactions: F005 and F006 won't work in this case as SAP predefines they accounting entries. Please check below SS

Instead of this you can use F022 and F023 for clearing the open items. Please check below SS for accounting entries

Secondly, while maintaining the Manual Bank Statement under Bank Statement Items you need to enter invoice number in Customer Reference Number field.

This should work and resolve your issue. Please let me know if you have any questions.

[Melle1028]

Hi @Naveenk_S42024

I tried what you said but accounts were not cleared. They are still open. I did setup the Rules for bank statement using the F023 and F022 as manual transaction but it is still the same. 

highlighted items should be automatically cleared under the outgoing clearing account. 

Regards,

Melle