Product Information
S/4HANA 2020 changes in FINANCE – Payments and Minimizing GL Accounts
S/4HANA 2020 changes in FINANCE – Payments
Major changes and simplifications to mapping GL for Payments / outbound:
- Minimize the GL accounts for Banking (Payment / Collections / Reconciliations etc (Single set of GL’s)
- How to Create/Setup Bank relevant GL master Records.
- Additional payment method setting configuration steps.
- End user process.
Introduction:
The S/4HANA (2020 on-premise release) new release came up with simplified solution to minimizing the bank GL accounts and introducing additional configurations for the payments.
Existing approach: –
Until now we have been creating separate bank GL’s for each house bank account like.
- Ending with “0” Main Bank GL
- Ending with “1” Collection / Receiving GL
- Ending with “2” Payment GL
- Ending with “4” LockBox GL Etc
Example:1
If we have two house banks and one house bank has one account and another one having 2 account, then we used to have GL mapping like below.
House Bank | Bank Account | GL Mapping |
HSBC | 123456 | XXXXXXX100 |
CITY | 98765 | XXXXXXX110 |
CITY | 123987 | XXXXXXX120 |
GL accounts are required to create in system for the above house banks.
Main Bank GL | Receiving GL | Payment GL |
XXXXXXX100 | XXXXXXX101 | XXXXXXX102 |
XXXXXXX110 | XXXXXXX111 | XXXXXXX112 |
XXXXXXX120 | XXXXXXX121 | XXXXXXX122 |
House Bank Accounts V/S GL Mapping:
Existing design Bank Account v/s GL Mapping
Simplified Design:
The GL Account type: C-Cash Account has been introduced, and It should be a Balance sheet accounts that are specifically used for payment processes.
Underneath, Cash accounts must have one of the following GL Account subtype assigned:
- Bank Reconciliation Account (B)
- Bank Subaccount (S)
- Petty Cash (P)
For all house banks and account id’s in the system, we can create single set of GL accounts in the following combination.
GL Account Type | GL Account Subtype | Usage | Connecting to Main Account |
C | B | Main – Main GL Account which matches with Stmt Balance by House bank and Account Id. | No |
C | S | Sub Accounts-Clearing accounts for the Incoming, outgoing payments. | Yes |
C | P | Petty Cash – Cash in hand and Cash journal. | No |
The house bank and account ID will be populated for all bank postings including bank reconciliation transactions. This will enable bank or cash reports by using single set of GL’s.
Example:2 with simplified solution
If we have two house banks (comparing with Example:1) and one house bank has one account and another one having 2 account, then we used to have GL mapping like below with in simplified solution.
House Bank | Bank Account | GL Mapping |
HSBC | 123456 | XXXXXXX100 |
CITY | 98765 | XXXXXXX100 |
CITY | 123987 | XXXXXXX100 |
GL accounts are required to create in system for the above house banks (Single set of the GL accounts only).
Main Bank GL | Receiving GL | Payment GL |
XXXXXXX100 | XXXXXXX101 | XXXXXXX102 |
XXXXXXX100 | XXXXXXX101 | XXXXXXX102 |
XXXXXXX100 | XXXXXXX101 | XXXXXXX102 |
Simplified Design Bank Accounts v/s GL Mapping (Single set of GL for All House bank accounts)
Note:
Here you see the examples and come to know the how many GL’s are required in both cases.
- Earlier design, we used to create multiple GL accounts (Main & Clearing GL’s) for different house bank accounts. (as per above example 9 GL accounts for 3 Bank accounts)
- In the new design, we will be using single set of GL accounts (Main & Clearing GL’s) for different house bank accounts. (as per above example 3 GL accounts for 3 Bank accounts)
Pre- Requisites:
- The main Bank GL must be creating with GL Account type “C-Cash” under COA level.
- GL sub-type muse be B/S/P
- B-Main Bank (Ending with “0”)
- S- Bank Sub Account (Ending with “1 / 2 etc”)
- P- Petty Cash (Ending with “Any”)
3. If Sub type “s” then must be entering the main bank GL account as a “Reconciliation Accnt”.
4. Make sure while creating bank account and assign main bank GL under the Connectivity path the status must be Reconciliation Account “Yes”, if not then the process will work as per old design.
- Setup Master Data:
A. Main Bank GL Account.
FIORI Screen:
GUI Screen:
Note:
- Main Bank Account create as Reconciliation account under COA Level and it should not be a open item management account.
- GL account does not have Currency field in Control data tab. (this is the certification question, what are the GL master fields which we will not able control from the GL account group, the answer would be the GL currency and FSG “By design those are required fields, but now what is the answer?
B. Bank Sub GL Account.
FIORI Screen:
GUI Screen:
C. Create / Display Bank Account:
- Configuration:
A. Payment method setup (Bank Determination “Bank accounts – Enhanced”).
Note:
- FBZP settings remain same, except the GL assignment.
- No need to maintain Bank Sub GL Account in setting Bank Accounts Enhanced. However, we should maintain other details as like below, Maintain GL is not relevant for payments / Direct debit Collections (FIORI-Manage Automatic Payment / GUI Transaction: F110). No other implications if at all maintain here.
B. Create and Assign Accounts to Account Symbol. (S_P00_07000249)
SPRO > Financial Accounting > Bank Accounting > Business Transactions > Payment Transactions > Electronic Bank Statement > Make Global Settings for Electronic Bank Statement
- GL should be a payment / Direct debit collection GL (Open item management).
- Must be select SIP Relev Check Box.
- System will take Payment or Direct Debit collection GL account “Bank sub Account GL” from this assignment.
- Configuration update in table “T033I & T033G”
C. Assign Account Symbol to Payment Methods (S_ER9_11001586)
SPRO > Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for Payment Program > Assign Account Symbol to Payment Methods
- End user: Run Automatic Payment – F110 / FIORI: Management Automatic Payment:
Report: Journal Entry analyzer:
Useful Links (SAP Help):
Error Message:
if we are missing the above configuration then we will get the error message “No bank account entered in table T042I for pmnt method “C” curr. XXXX “FZ314 / FZ661.
Take Away points:
- N:1 Bank Accounts and GL mapping.
- House bank and account id is mandatory while posting the transaction for all the Bank GL’s (Created under GL Account type “C”).
- System fetch the clearing GL account wile running automatic payment from the Electronic Bank Statement settings not from FBZP.
- Main Bank GL should not be an open item management.
- Business Benifit and time taking decession – Minimizing the Bank GL accounts and Banking team no more depending on GL team.
- Bank Sub account postings always carry House bank and Account ID.
Good one Viswa
Thanks Vamsi for the inputs provided.
Hi, can you explain how to do configuration on S4 Cloud also?
Hi Chang-Hee Kim,
please go through the link given below and however the steps remain the same for cloud too (instead of SPRO settings we do have FIORI app (Assign the account symbol to the payment method.) to do the necessary assignments.
https://help.sap.com/viewer/085edb30fb3d413da552832f3d5c01c0/2008.500/en-US/9c02122bef3c482aa2d8640d89ba85eb.html?q=Bank%20Reconciliation%20Account
Valuable inputs , thanks for bringing it to us!
Thank Viswa, Good Explanation
Regards,
Muhammad Hasan Mufid
Great Piece, thanks Viswa
Hi Viswa, Very nice and detailed explanation of the functionality which was much awaited and will change the way we create the Bank GLs today.
Hi Viswa,
Good blog with explanation. Valuable inputs. Hats Off!
Thanks for sharing.
Hi Vishwa,
Nice explanation 👍
That means all sub GL account type S should be created as account symbol with SIP activated right? in old approach we normally used to do general masking to derive sub GL -clearing account from main GL account.
Thanks
Pankaj
yes, you are correct
Hi Viswanath,
Great content.. specially, screenshots were helpful in understanding. Do you have any idea what approach will be used to for maintaining the currencies in the reconciliation account and the main bank account?
Thanks,
Anjana
Hi Viswa,
The explanation is really nice. Regarding GL account maintenance in S4 HANA 2020, only one Main bank GL account can be used for all house banks.
The question is how can we show all bank gl balance in the Financial statement, whereas GL line item we can segregate by house bank but the main concern in the final Financial statement.
Could you please clarify this.
Regards,
Ramana.
Hi,
Nice explanation Viswa Anna, Great job!
As house bank and account ID are mandatory to post these bank GL accounts, we can display GL balances by inserting these two values in dynamic selections. Financial statements extraction through standard Fiori app 'Balance sheet/Income statement' we will not get details at house bank level until S/4 Hana OP 2020 version. But, Trial balance fiori app gives details at house bank level as all data gets stored in ACDOCA. There might be some issues in terms of maintaining default profit center for bank GL accounts. S/4 Hana 2021 version will address all these queries.
Regards,
Gopi
Hi Viswa,
Nice explanation,
I notice by using this setup, it become mandatory to enter HBANK and ACCOUNT ID in transaction for every Bank GL Account.
Somehow it got error when you run EBS because the HBANK and ACCOUNT ID is blank, is there any additional setup for EBS ?
Thank you.
Hi @ramadazkia
Were you able to get the answer for EBS HBANK and Account ID blank error?
Yes, there is note 3023814
But in the end we don't implement this new bank ledger concept because there is another issue in revaluation for this bank GL.
Hi Viswa,
Very well articulated.
i'm getting the below error after running the proposal in F110, after maintaining all the settings
"BTE 00001820 is active (see long text)
G/L account does not exist in company code"
Have you come across this error and i'm running for FB60 KR docs, where i haven't selected any bank information and is it mandatory to select in the vendor invoices.
Thanks/ Venkatesh
Hi Venkatesh,
Did you find the solution to solve the error message " G/L account does not exist in company code" ?
Thanks, Nicolas
Hi,
Thanks for your detailed Blog and explanations, really nice !!
I just have a question for you. We are trying to do a prototype of this solution to reduce our number of GLs in the CoA and we are running into some issues ...
Do you know if with Bank Subledger you can have 1 House Bank with Multiple Account IDs / Bank Accounts inside it ? Also some of these Account IDs on different currencies ?
The system is not allowing us to create more than 1 Account ID inside the same House Bank. Does it mean that we need as many House Banks as Account IDs we have ? Even if then we manage all with the same GL accounts.
Thanks in advance for your help !
Adrian
Dear all
After all the new functionality is activated I see that I can do a manual journal to my new Bank recon account. In addition, App: "Post outgoing Payments" also allow me to use the main bank account to pay out instead of the new sub account.
Any comments is welcome please.
Lelani
Dear ,
where to assign PROFIT CENTER against house bank & account id.As i am unable to find a field anywhere.
Thanks in advance.