How to use Bank Reconciliation Account in Payment Program
SAP introduces a new G/L account type C (Cash Account), which has two sub types B (Bank Reconciliation Account) and S (Bank Subaccount).This new feature can help customer significantly reduce the numbers of G/L accounts.
In this blog post I’ll guide you how to implement the new feature in payment program step by step.
Error of G/L Account Determination
Once the new bank reconciliation account is used in the house bank account, it will impact on the G/L account determination in payment program.
If you schedule a payment run then, you get an error message FZ 314 “G/L account does not exist in company code” in the log of the payment program.
Before we know how to resolve this issue, I would like to introduce the new concept of the bank reconciliation account.
Bank Reconciliation Account
Traditionally, a bank account is represented with a set of G/L accounts often constructed in the following way:
Here, G/L subaccounts on a bank current account are just like “legs on a spider.” The system must provide a set of G/L subaccounts for every bank account, thus making the number of G/L accounts huge. In some extreme cases, 70% of G/L accounts are occupied by banks.
Why can’t we re-model the relationship between a bank account and a G/L account? Just let numbers of bank accounts use one special G/L account, that is a bank reconciliation account.
Then, we just need one set of subaccounts to manage different clearing methods.
The classic G/L account representation of a bank account and the new bank reconciliation account can run side by side. It just depends on what kind of G/L account is used in the house bank account.
The new model brings the following benefits:
- Simplify the bank account set-up process and reduce the number of G/L accounts.
- De-couple bank account from G/L account and production system settings from quality system ones.
- Open and close a bank account quickly.
Definition of Bank Reconciliation Accounts and Subaccounts
SAP introduces a new G/L account type C (Cash Account) and two sub types B (Bank Account) and S (Bank Subaccount):
|Bank Reconciliation Account||
A G/L account with attributes
GLACCOUNT_TYPE = “C” – Cash Account
GLACCOUNT_SUBTYPE = “B” – Bank Reconciliation Account
A G/L account with attributes
GLACCOUNT_TYPE = “C” – Cash Account
GLACCOUNT_SUBTYPE = “S” – Bank Subaccount
We can log in to the system to see the new functionality. If you are a G/L accountant, you can open the app “Manage G/L Account Master Data.” Below are screenshots of a bank reconciliation account and of a bank subaccount:
I will explain how to assign the house bank account to the reconciliation account in the next step.
Defining a House Bank Account
If you are a cash specialist, you can open the app “Manage Bank Account”, select a house bank account, and then go to House Bank Account Connectivity:
If you enter a bank reconciliation account, the property “Bank Reconciliation Account” will be populated automatically.
The question then is how to find out which subaccount should be used in the payment program.
Bank Account Determination
For the automatic payment program, we can use the SSCUI Set Up Bank Determination for Payment Transactions (1010045).
It’s still possible to config the bank subaccount as a classic bank G/L account just like the house bank account DEBK2/DEAC2 in the screenshot. However, once you set a house bank account to new bank reconciliation account, just like DEBK1/DEAC1 in the screenshot, the legacy configuration of bank subaccount becomes grayed out. If you’re trying to create a new config record for DEAC1, you will find that you can’t enter a bank subaccount any more.
The last question is how to find the subaccounts for different payment methods.
Configuration for account symbols reuses the functionality of Electronic Bank Statement.
Go to the configuration for Electronic Bank Statement via the SSCUI Make Global Settings for Electronic Bank Statement (101024). First, you need to create an account symbol and select the SIP (self-initiated payment) relevant checkbox.
Then, assign an overlaid rule to the account symbol.
You can now assign the account symbol to payment methods in the SSCUI Assign Account Symbol to Payment Methods (103557).
We can open the app “Manage Automatic Payments” to delete the proposal and re-run it.
The proposal and the payment document are generated on the sub G/L account successfully.
Call to Action
If you want to know more about the relevant master data and configuration maintenance, you can refer to the following links,
Defining House Bank Accounts
Define G/L Accounts for Payment Processes -> Use Bank Reconciliation Accounts
Assigning G/L Accounts to House Bank Accounts
Automatic Determination of Bank Subaccounts
In case of any further questions, please leave a comment below and I will try to answer you.
Excellent explanation. thanks.
One thing that needs to be added is the meaning of the GL account over laid rule "+++++++020".
One plus means one digit kept as same as the reconciliation account, here, leading seven + means keeping the leading 7 digits same as the reconciliation account.
For example, if the reconciliation account is "2011001000", then the leading '2011001' is kept, "020" added as suffix, then the subaccount is "2011001020".
In this article, the reconciliation account is '10101000', since it only has 8 digits, but it is equivalent to "0010101000", therefore, '0010101' with '020', the subaccount should be "0010101020", equivalent to "10101020".
Thank you, this is really helpful.
Thanks a lot, very helpful
For the column "Acct Mod" and "Currency" when you maintain "Assign Accounts to Account Symbol", just leave them as blank, or give a concrete currency code if you would like to specify a subaccount according to currency.
When you saved the blank value, it will display as plus('+'). However, it's just a display behavior designed for a long time, you do not need to enter '+' when you maintain it.
Thank you so much!!
Thank you so much for your effort on this informative article.
As I follow your instruction, I managed to finished the configuration.
However, I am wondering how can I validate the the result since currently the auto-payment is not valid to process this functionality.
Thank you again.
The configuration is just for the auto-payment program.
Well, I suggest you can just do the proposal run for the validation.
Thank you for your reply.
I am wondering in you example, do we need to create account 10101020 as a GL master data?
I managed to finished the payment run without error in our test system(best practice).
Thank you for replying so promptly!
Sorry I got another question, is it possible to have a reoprt to see the balances of all subaccounts of single bank reconciliation account?
Sorry, I don't know about this.
sir how is it possible to make the bank statement (FF67) using the new bank reconciliation in SAP S4hana 2020
Yes, if the house bank account is configured on the new bank reconciliation account.
Before running F110 - if you get error No GL in company code error- then implement below notes
3012746 - Payment run failed because G/L account does not exist in company code
3067578 - F110 & F-58: G/L Account Does Not Exist When Bank Reconciliation Account Is Used
these notes need to implement, else we will get the GL does not exit in company code error