In the past few posts, I focused on the various BAPIs that allow us to post the normal as well as the clearing accounting documents. Starting from today, I will focus on bank accounting. If you remember, I posted a tutorial on the creation of bank keys last year. A bank key is basically a bank master data where you assign the bank address & communication details. Today, I will show you how to create a house bank in SAP using t-code FI12 or FI12_HBANK.
A house bank is a bank that deals with all the bank transactions for a company. It is assigned at a company code level and is identified as a 5-digit alphanumeric code. Within a house bank, you can create an Account ID for each bank account. For example, if you have 2 bank accounts in Axis Bank, then Axis Bank can be created as a house bank. And, both the bank accounts should be created as separate account IDs.
As you know, that we need to assign a bank GL account for each account ID. When you try to use this account ID for bank posting, this bank GL account is automatically picked for posting the accounting entry. In ECC, assigning a bank GL account was straightforward. But in S/4 HANA, the creation of account ID & assignment of GL takes place in the t-code NWBC.
Let’s quickly jump to the main process of house banks!!!
Table of Contents
Step 1: Creation of Bank Key in FI01
The pre-requisite to the creation of a house bank is the bank key. You need to create a bank key first. If you missed my tutorial on how to create a bank key, then I suggest you go through it first using this link.
Step 2: Execute FI12 to create a House Bank in SAP
Once you have the bank key ready, you can execute the transaction code FI12 to set up the house bank. You can see all the company codes on the selection screen. To create a new house bank, you need to first select the company code for which you want to create it, and then click on the HOUSE BANKS folder under the Dialog Structure section.
For example, I’m using the company code 1234. There are a couple of house banks already existing for this company code. I’ll proceed with the creation of a new house bank for Axis Bank. Click on the ‘New Entries‘ button to proceed further.
In the next step, You need to assign the 5-digit house bank ID. It can be alphanumeric. I have given the new house bank ID as 99999. You also need to provide the bank country and bank key. Since my bank account is in India, I have specified the bank country as IN. I have also provided the bank key that I created using FI01.
If you navigate to the Address section, you would notice that the address details like bank name, Street, etc. are automatically picked from the bank key master.
The next step is to create the account ID for this house bank. Select this house bank & click on the ‘Bank Account‘ folder given on the left hand side.
Step 3: Create the Bank Account Master Data
After you navigate to the bank account folder, you can see the ‘Create Bank Account‘ button given in the navigation bar. Click on this button and the system will automatically open a new browser window. This browser window can also be opened using t-code NWBC.
In the browser window, you need to enter all the required details. I have entered the bank account opening date as the opening date. You need to assign the company code as well as provide the Account Holder Name. If the bank account is in your name, you can enter your name in the Account Holder name field.
In the Account Details section, you need to maintain the bank country, bank key, currency in which this bank account is maintained, and the bank account number.
Next up, you need to provide the account description. For example, I have given the account description as Axis Bank – Branch ABC. Also, choose the appropriate account type ID. For each type of bank account like savings, deposit, current, etc., there is a separate account type.
Step 4: Create an Account ID & Assign Bank GL Account for House Bank in SAP
The last step in this process is to create the Bank Account ID and assign the Bank GL account. Navigate to the ‘House Bank Account Connectivity‘ tab and click on the ‘Add‘ button.
Enter the Bank Account ID in the House Bank Account field. For example, I have entered 67628 as my Account ID. This Account ID will help me in identifying the bank account number for which the transaction is going to process. Next, assign the bank GL account and click on the ‘Save‘ button to create the bank account.
You will receive a notification ‘Bank Account Created‘ after clicking the Save button.
That concludes this tutorial on House Bank in SAP. I hope you liked it!!! In case of any queries, please feel free to drop a comment and stay tuned for more tutorials coming your way!!!