Skip to Content
Product Information
Author's profile photo Xiangdong Wang

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.

Error%20log%20of%20payment%20program

Error log of 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:

Bank%20GL%20logic%20at%20SAP

Bank GL logic at SAP

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):

Term Definition
Bank Reconciliation Account

A G/L account with attributes

GLACCOUNT_TYPE = “C” – Cash Account

AND

GLACCOUNT_SUBTYPE = “B” – Bank Reconciliation Account

Bank Subaccount

A G/L account with attributes

GLACCOUNT_TYPE = “C” – Cash Account

AND

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:

Bank%20Reconciliation%20Account

Bank Reconciliation Account

Bank%20Sub%20GL%20Account

Bank Sub GL Account

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:

House%20Bank%20Account%20Data

House Bank Account Data

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).

Bank%20Determination

Bank Determination

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.

Account Symbols

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

https://help.sap.com/viewer/186460fdc35a4b64a713da9bb00deb1e/2011.500/en-US/579e2d551c03bc06e10000000a441470.html

Define G/L Accounts for Payment Processes -> Use Bank Reconciliation Accounts

https://help.sap.com/viewer/186460fdc35a4b64a713da9bb00deb1e/2011.500/en-US/5c1eb2ea64bb425abd373c98c96db0c1.html

Assigning G/L Accounts to House Bank Accounts

https://help.sap.com/viewer/186460fdc35a4b64a713da9bb00deb1e/2011.500/en-US/3247e8093a34431ab7423653835a1d8f.html

Automatic Determination of Bank Subaccounts

https://help.sap.com/viewer/031c345485b84c8c94265be9ef61d3a8/2011.500/en-US/72f6dbff22504808ba732b13ce591f1e.html

In case of any further questions, please leave a comment below and I will try to answer you.

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Imtiaz Hussain
      Imtiaz Hussain

      Excellent explanation. thanks.

      Author's profile photo Xiangdong Wang
      Xiangdong Wang
      Blog Post Author

      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".

      Thanks.

      Author's profile photo Advait Kulkarni
      Advait Kulkarni

      Thank you, this is really helpful.

      Advait

      Author's profile photo Carolina Borda
      Carolina Borda

      Thanks a lot, very helpful

      Author's profile photo Xiangdong Wang
      Xiangdong Wang
      Blog Post Author

      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.

      Author's profile photo Reenu Yadav
      Reenu Yadav

      Thank you so much!!

      Wonderful explanation!

      Author's profile photo Peichi Chen
      Peichi Chen

      Hi Xiangdong,

       

      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.

      Peichi

      Author's profile photo Xiangdong Wang
      Xiangdong Wang
      Blog Post Author

      Hi Peichi,

      The configuration is just for the auto-payment program.

      Well, I suggest you can just do the proposal run for the validation.

      Thanks.

       

      Author's profile photo Peichi Chen
      Peichi Chen

      Hi Xiangdong,

       

      Thank you for your reply.

      I am wondering in you example, do we need to create account 10101020 as a GL master data?

       

      BR,

      PeiChi

      Author's profile photo Xiangdong Wang
      Xiangdong Wang
      Blog Post Author

      Yes

      Author's profile photo Peichi Chen
      Peichi Chen

      Hi Xiangdong,

       

      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?

       

      Kind Regards,

      PeiChi

      Author's profile photo karim Hallal
      karim Hallal

      sir how is it possible to make the bank statement (FF67) using the new bank reconciliation in SAP S4hana 2020