Manual Bank Reconciliation using manage bank statements

[nithin_pranesh]

In manage Bank statement, I will do BRS manually, Where i want to post in 1 step posting(Posting Area 1) and it needs to get cleared manually, instead of manual clearing.

For outgoing bank reconciliation, the journal entry needs to be like this

Outgoing bank Dr

Main Bank Cr

For Incoming bank reconciliation, the journal entry needs to be like this

Incoming Bank CR

Main Bank Dr

it can't be done using standard posting rule, So i need to create new processing rule using the tile "manage processing rule" How can i do it. Kindly suggest me a solution.

[Edrilan_Berisha]

Hi,

the answer will only be as good, as the question was raised. Your sentence is quite confusing to me:

"In manage Bank statement, I will do BRS manually, Where i want to post in 1 step posting(Posting Area 1) and it needs to get cleared manually, instead of manual clearing."

I do not really get the point here, and we have to be very precise. You want the clearing to happen automatically instead of manual clearing right? 

Furthermore where do you see two G/L accounts? When I create a Rule, I see one G/L Account:

Action Type is G/L Posting, now you go ahead and enter the G/L account which should be posted to, and then you automate this rule, and instead of picking Two-Step-Posting, for the procedure type, you go with one-step posting.

You need two processing rules, one for your outgoing payments, one for your incoming payments.

Best,

Edrilan Berisha

[nithin_pranesh]

Hi, @Edrilan_Berisha 

But Here it is posting in the same GL as credit and debit.

I want the Journal entry to be like this,

Outgoing bank Dr

All bank in Qatar-M Cr

This is what i did:

I've created the bank statement, in the memo line I've provided the document number and then posted it.

After that I've reprocessed it, the automatic processing rule worked out.

So my question here is, where should i provide the outgoing bank GL account? so that i can get the above desired journal entry.

Regards,

Nithin V

[Edrilan_Berisha]

Hi,

have you tried to achieve that by setting up the processing rule with a two-step procedure type instead of one-step?

Best,

Edrilan Berisha

Best,

Edrilan Berisha

[nithin_pranesh]

@Edrilan_Berisha No, I tried it with one step processing, I'm getting the desired journal entry If I provide the outgoing bank Gl instead of main.

For the company code JICA, I’ve posted the using the reprocessing rule, but it is not clearing automatically, Here is the automated rule

What I need to do to make it clear automatically?

[Anita_Ahmadpour]

Hi Nithin Pranesh, 

@nithin_pranesh 

You can easily create processing rules in the Manage Processing Rules - For Bank Statements app. For more information, see How to Create Processing Rules and Manage Processing Rules - For Bank Statements. If you'd like to set up processing rule with two posting steps, you need to automate the processing rule first. See also How to Automate Processing Rules. Furthermore, the following What's New document from the "SAP S/4HANA Cloud Public Edition" 2502 release (February release) provides you some hints on how to set a reconciliation account for AP/AR postings in your processing rules in the Manage Processing Rules app: Reconciliation Account in Processing Rules (this last link is only available for a few months, though). 

I hope the linked help pages are useful for you to set up your posting and processing process. 

Best regards,

Anita

[nithin_pranesh]

Dear Anita,

I saw those Links before, still i have some doubts like, when you choose G/L postings in Action type. 

In action tab, you need to enter two G/L accounts, I don't know which will credit and which will debit and more to that it only posts it won't clear.

So tell me clearly how it works and how to clear it in processing rule to achieve the journal entry I've mentioned above.

Regards,

Nithin