- SAP Managed Tags:
In latest versions of SAP S/4 HANA, SAP gives us the opportunity to use reconciliation bank accounts. This way, a single G/L account can be assigned to multiple bank accounts. This option definitely help us reduce the number of accounts we usually used for bank accounting.
Let's see this, in the past for each bank account we needed a G/L account and at least two auxiliary subaccounts, for example
- GL account 11001000 - balance sheet account (assigned to each house bank account)
- GL account 11001010 - clearing G/L accounts for income
- GL account 11001020 - clearing G/L accounts for expenses, of course we can have more clearing accounts if we wanted to separate by payment method, for example one for checks, etc.
So, if our client had 10 bank accounts, we had to create 30 GL accounts. Now, it is no longer necessary, we only need to use one set of GL accounts, for this example, only 3, for all the bank accounts we have in the same currency.
How is this? How does it work?
First of all, the definition of accounts in the Chart of accounts has a couple of additional settings to inform the system which our main account is(balance sheet account), and which the auxiliaries or subaccounts are (clearing accounts). You can see this, in the following images, the additional settings are G/L account type: C-Cash account, and G/L account subtype: B-Bank Reconciliation account.
Settings for our main bank account:
or S-Bank Subaccount, also you need to specify here its Reconciliation account (the main bank account).
This is our subaccount:
Now, how does the system know when I post an accounting document, which bank account I want to affect? or, when I want to see the balance of the reconciliation, which bank account is that balance from?
To control these type of G/L Accounts, all SAP fiori apps will require house bank and bank ID as mandatory fields when you use a Bank reconciliation account. In this way, if you post a manual payment, you must enter the GL account (main bank account), in addition to house bank and bank ID, this is the same if you want to clear one of the subaccounts or when you want to post bank statements. Look at the following pictures:
And what about the automatic payment configuration?
In the past we needed to specify the clearing G/L account for outgoing payments, not anymore. Now, we just need to specify the payment method, house bank and ID account, as you can see in the following image.
This is possible because, now we need 2 additional configurations to complete this process.
The first new configuration (in outgoing payments) is that instead of assigning the G/L account to the payment method, we need to assign an Account symbol, like this:
And the second customizing is that this Account symbol needs to be customized in Electronic bank statement customizing. There we assign the GL account to the account symbol. (see images)
Finally, with the creation of bank accounts, (master data) we will have the full scenario ready to use it in payments or Electronic bank statements.
Create bank accounts in Manage bank accounts fiori app. Here, we will need to specify, company code, bank, id, and the most important the connectivity to GL, here we will put the main GL account.
This is all for now.
"The most beautiful thing we can experience is the mysterious. It is the source of all true art and science". - Albert Einstein
Related links:
2 Comments
