cancel
Showing results for 
Search instead for 
Did you mean: 

How to set up Electronic Bank Statement for ZBA / Cash Concentration transactions in Cloud

JamesM
Explorer
0 Kudos
1,530

Hello, 

Many companies take part in cash pooling / cash sweeping / zero balance accounts, where each day at the end of the day the bank automatically moves the balances of accounts into another account for a variety of reasons (interest earning, security, etc.). 

In S/4HANA Cloud Essentials the number of posting rules which are available are limited. 

In practice each day the bank automatically makes postings to the accounts. 
For example there are two accounts:
Account 1 is the ZBA account with an ending balance of $250
Account 2 is the Pooling Account. 

At close of business the bank posts a cash movement to the accounts showing and out flow on the bank statement of Account 1 for $250, and posts a cash movement as an inflow on Account 2 for $250. 

In an on-prem world there are two options for this, both with custom posting rules. 

Option 1: Common clearing account
Account 1 - Posting Area 1 - Debit Tech, Credit Main Bank
Account 1 - Posting Area 2 - Debit Common ZBA Clearing Account, Credit. Tech.

Account 2 - Posting Area 1 - Debit Main Bank, Credit Tech
Account 2 - Posting Area 2 - Debit Tech, Credit. Common ZBA Clearing Account

Then run automatic clearing on Common ZBA Clearing Account. 

Option 2: Post to other bank account
Account 1 - Posting Area 1 - Debit Tech, Credit Main Bank

Account 2 - Posting Area 1 - Debit Main Bank, Credit Tech
Account 2 - Posting Area 2 - Debit Tech, Credit. Account 1 Tech account.

Has someone developed a way to re-use the standard posting rules to accommodate such a scenario? 

The closest I have thought of is using a single GL account for OTHERTRANSF or DIRECTDEBIT for all bank accounts, however since the posting type on the related transactions always has clearing (either 7 or 😎 then it doesn't work without manual intervention. 

Accepted Solutions (1)

Accepted Solutions (1)

joerg_rolapp
Advisor
Advisor
0 Kudos

Hi Jmoss,

Is my understanding correct that you want to post automatically on a GL Account (ZBA Clearing Account)

You may explore bank statement reprocessing rules:

https://help.sap.com/viewer/918bca53037f408f91a2295d04ac16bc/LATEST/en-US/d6fe6526b26f46e59d9d1dd0f7...

This should cover your requirements.

Kind Regards, Joerg Rolapp

Answers (2)

Answers (2)

Anita_Ahmadpour
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Jmoss,

these links can also be helpful for you:

- What's New in SAP S/4HANA Cloud 2011: https://help.sap.com/viewer/085edb30fb3d413da552832f3d5c01c0/2011.500/en-US/86370946c6a14c078d35998d...

- Bank Statement Processing on the Help Portal: https://help.sap.com/viewer/918bca53037f408f91a2295d04ac16bc/2011.500/en-US/e042e6cb0bae4718ba0e0258...

Best regards,

Anita

JamesM
Explorer
0 Kudos

Thank you Joerg,

I was hoping there was a solution to process this scenario during initial posting of the EBS without requiring the Cash Application license for the automated reprocessing rules, but I will see what can be done with running the rules manually for now.

-James.

joerg_rolapp
Advisor
Advisor
0 Kudos

Hi James,

please see Anita's comment regarding the new Scope Item....

Best Regards, Joerg Rolapp