Table of Contents
SAP EBS
In this tutorial we will be discussing Electronic Bank statement in SAP. Below topics will be covered
- Electronic Bank Statement business process in SAP
- EBS Configuration in SAP
- Electronic Bank Statement file layout – BAI2, MT940
- Generate a test EBS BAI2 file in SAP using testing program
- Test out EBS configuration using the test file in SAP
- Post processing of EBS file
Electronic Bank Statement in SAP :EBS Business Process
In SAP bank statement has to be entered in SAP for reconciling with the company data. The bank statement can be manually entered in SAP or an electronic bank statement can be imported into and processed automatically in SAP.
In order to import the electronic bank statement in SAP, the bank statement should be available in specified bank formats such as BAI2, MT940 format
After importing the bank data, the system interprets the bank data based on the transaction types contained in the bank statement. Based on the rules defined for each bank transaction type the bank items are matched with the company data in SAP. On matching the bank transaction with the transaction in company books the item is marked as cleared in SAP and necessary accounting entry is passed to transfer the same from bank clearing account (Bank sub-account) to the bank main account. The items in bank statement which are not matched are available for processing manually. These items have to be processed manually and cleared with the relevant company data (Transaction code FEBAN)
After the process is completed, the bank main account in SAP will match with the bank statement and the other reconciliation items such as checks issued but not presented, bank charges debited by bank but not accounted in books etc. is available in bank clearing sub accounts for review.
In SAP for every Bank account of the company two set of GL accounts are maintained – Bank main account and Bank clearing sub-account.
The Bank clearing Sub-accounts ensure that all incoming and outgoing payments are only posted to the bank Main account when the transaction is debited /credited in the Bank statement. The entries from the bank sub-accounts to bank main account takes place in SAP when the bank statement (EBS) received from the bank is uploaded in SAP.
SAP EBS Accounting Entries
Accounting Entries – Payment to vendor (Outgoing)-F110
Vendor Account Dr
Bank Clearing Account Cr
Accounting Entries – Post Electronic Bank Statement in sap
Bank Clearing Account Dr
Bank Main Account Cr
Accounting Entries – Customer Payment Received (Incoming)
Bank Clearing Account Dr
Customer Account Cr
Accounting Entries – Post Electronic Bank Statement
Bank Main Account Dr
Bank Clearing Account Cr
Accounting Entries (Bank Charges) – Post Electronic Bank Statement
Bank Charges Account Dr
Bank Main Account Cr
Topics discussed in detail in this tutorial
|
SAP EBS : Tutorial 1 |
SAP EBS Configuration steps |
|
Bank Master Creation
|
Create House Bank |
|
Update Customer/ Vendor master with bank details |
|
|
Electronic Bank Statement Implementation |
Create Account Symbols |
|
Assign Account Symbols to GL accounts |
|
|
Create Keys for Posting Rule |
|
|
EBS Posting Rule |
|
|
Create Transaction Type |
|
|
Assign External Transaction Types to Posting Rules |
|
|
Assign Bank Account to Transaction Type |
SAP EBS Configuration
For detailed, step-by-step instructions on SAP EBS course follow along with my video tutorial below
Bank Master Creation
Transaction Code: FI01 / FI02 / FI03
House bank
Transaction code: FI12
- Bank Country: Identifies the country in which the bank is located
- House bank: Each bank is uniquely identified by a House bank. A house bank has one or more bank accounts (Current Account, Savings Acct, collection acct etc.). Combination of HB and Account ID uniquely identifies a bank account
- Account ID: Identifies the bank account in the HB
- Bank Account Number: Each Account ID has a unique Bank Account Number
- Control Key: In the USA, this field determines whether you are dealing with a savings or checking account (if you do not enter a value, then 01 is taken as the default):
- 01 Checking Account
- 02 Savings Accounts
- 03 Loans
- GL Account: G/L account to which the transaction figures are updated.
- Bank Key: Uniquely identifies the bank. Provided by the bank
Update Vendor master with its bank details
Define Vendor bank to which payment will be made in SAP Payment run (Transaction code #F110)
Where vendor has many banks, identify them with value in field BnkT and enter this in Vendor Invoice line item to identify the bank to which payment will be made
SAP EBS : Configuration Steps
- Create Account Symbols
- Assign Account Symbols
- Create Keys for Posting Rules
- Define Posting Rules
- Configure Transaction Types
- Assign BAI Codes to Posting Rules
- Assign Bank Accounts to Transaction Types
Create Account Symbols
Specify G/L accounts (such as bank, cash receipt, outgoing checks) to which postings are to be made from the account statement. You assign account symbols to the G/L account numbers
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings – Create Account Symbols
| Account Symbol | Account Symbol Description |
| Y0 | Master Account – 113020 |
| Y1 | Wires Out-113023 |
| Y2 | Wire In – 113027 |
| Y3 | ACH Out – 113028 |
| Y4 | ACH In – 113027 |
| Y5 | Check Out – 113025 |
| Y6 | Check In – 113022 |
| Y7 | ZBA Transfer – 113026 |
| Y12 | Bank Charges |
Assign Account Symbols to GL accounts
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings- Assign accounts to Account Symbols
Assign account symbols defined in step 1 to GL Accounts
Account Modification: With the help of this field, you can direct the posting to a differentiate bank subaccount instead of a standard one. Leave this field blank (or enter the mask “+”) if you do not want to use an account modification.
| Acct Symbols | Acct Mod. | Cur. | GL Account | Notes |
| Y0 | + | USD | ++++++++++ | Main Bank |
| Y1 | + | USD | 113023 | Wire Out |
| Y2 | + | USD | 113027 | Wire In |
| Y3 | + | USD | 113028 | ACH Out |
| Y4 | + | USD | 113027 | ACH In |
| Y5 | + | USD | 113025 | Check Out |
| Y6 | + | USD | 113022 | Check In |
| Y7 | + | USD | 113026 | ZBA Transfer |
| Y12 | + | USD | 660035 | Bank Charges |
Create Keys for EBS Posting Rule
Posting Rules carry out General Ledger and Sub-Ledger postings
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings- Create keys for posting rule
| Keys for Posting Rule | Text |
| Y02 | Debit Master, Credit Wire In |
| Y04 | Debit Master, Credit ACH In |
| Y06 | Debit Master, Credit Checks In |
| Y08 | Debit Master, Credit Other Transfer |
| Y10 | Debit Wire Out, Credit Master |
| Y30 | Debit ACH Out, Credit Master |
| Y50 | Debit Checks Out, Credit Master |
| Y80 | Debit Other Transfer, Credit Master |
Define EBS Posting Rule
Here you specify how a given business transaction is to be posted.
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings- Define Posting rules
Posting Area 1 is for Main Bank Accounting
Posting Area 2 is for Sub ledger Accounting
A posting type “option” is assigned to each rule
| Posting Type | Value |
| Post To G/L Only | 1 |
| Post to Sub-Ledger -DR | 2 |
| Post to Sub-Ledger -CR | 3 |
| Clear GL Account – DR | 4 |
| Clear GL Account – CR | 5 |
| Clear Sub ledger Account – DR | 7 |
| Clear Sub Ledger Account – CR | 8 |
| Posting Rule | Posting Area | PK | ACCT (DR) | PK | ACCT (CR) | DOC TYPE | Posting Type |
| Y02 | 1 | 40 | Y0 | 50 | Y2 | SA | 1 |
| Y02 | 2 | 40 | Y2 | – | – | DZ | 8 |
| Y04 | 1 | 40 | Y0 | 50 | Y4 | SA | 1 |
| Y04 | 2 | 40 | Y4 | – | – | DZ | 8 |
| Y06 | 1 | 40 | Y0 | – | Y6 | SA | 5 |
| Y08 | 1 | 40 | Y0 | – | Y8 | SA | 5 |
| Y10 | 1 | – | Y1 | 50 | Y0 | SA | 4 |
| Y30 | 1 | – | Y3 | 50 | Y0 | SA | 4 |
| Y50 | 1 | – | Y5 | 50 | Y0 | SA | 4 |
| Y80 | 1 | – | Y8 | 50 | Y0 | SA | 4 |
Create Transaction Type
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings – Create Transaction Type
Transaction types are assigned to bank account. This will determine what posting rules are used for a specific BAI code in that bank account
| Transaction Type | Name |
| BAI | Bank Administrative Institute |
Assign External Transaction Types to Posting Rules in SAP EBS
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings -Assign External Transaction type to Posting rule
Assign External Transaction types to Posting Rules so that R/3 knows what to do with incoming EBS transactions
Choose + or – depending on whether the transaction increases (+) (deposit) or decreases (-) (withdrawal) the bank account balance
Assign Bank Account to Transaction Type
Assign the bank accounts to a transaction type, for which the account statements are to be imported
IMG Path: Financial Accounting- Bank Accounting – Business Transactions – Payment Transactions – Electronic Bank Statement – Global Settings-Assign Bank accounts to Transaction types
SAP EBS : Tutorial 2
- BAI2 File format explanation
- File Header record
- Group header record
- Account Header and summary
- Detail Transaction records
- Continuation records
- Account Trailer
- Generate BAI2 file for testing in SAP
- Upload Electronic Bank statement in SAP
- Display Bank Statement
- Key SAP transactions used in EBS
Bank File Format in SAP – BAI2 File
EBS File Header record (Type 01)
| BAI Field | Description |
| Record ID | Always 01 |
| Sender ID | Wells Fargo Routing number (121000248) |
| Receiver ID | Alphanumeric customer ID assigned by Bank |
| File Creation Date | File Creation date (YYMMDD) |
| File Creation Time | File creation time (HHMM) |
| File ID | Two-digit counter 01 |
| Physical record length | Always 080 |
| Block Size | Null (blank) |
| Version Number | Always 2 |
Group Header record (Type 02)
| BAI Field | Description |
| Record ID | Always 02 |
| Ultimate Receiver ID | Alphanumeric customer ID assigned by Wells Fargo / Bank |
| Originator ID | Routing Transit number or Bank identifier code |
| Group status | Always 1 |
| As of Date | YYMMDD |
| As of time | Null |
| Currency Code | Null |
| As of Date modifier | Null |
Account Header and summary status (Type 03)
| BAI Field | Description |
| Record ID | Always 03 |
| Account Number | Bank account number |
| Currency Code | 3-character currency code |
| Type Code | Three-digit BAI type code |
| Amount | Value associated with the BAI type code. Variable length up to 15 digits. Format is $CC ( No decimal point, last two digits indicate cents). Amounts can be signed + or -. If unsigned, value is positive |
| Item count | Total count of items used to determine the amount field |
| Funds type | Null |
EBS File Detail Transaction Record (Type 16)
| BAI Field | Description |
| Record ID | Always 16 |
| Type Code | Three-digit BAI type code |
| Amount | Value associated with the BAI type code. Variable length up to 15 digits. Format is $CC ( No decimal point, last two digits indicate cents). Amounts can be signed + or -. If unsigned, value is positive |
| Funds Type | Optional field to indicate value date information 0 – Immediate 1- 1 day float 2 – 2+ day float S- Distributed availability (0/1/2+ day) V – Effective date different than As of date in record type 02 Z- Unknown Blank – No float / value date |
| Fund Type -detail 1 | Only included if Fund type is S or V |
| Fund Type -detail 2 | Only included if Fund type is S or V |
| Fund Type -detail 3 | Only included if Fund type is S or V |
| Bank Reference Number | Report customer location number. Can be blank |
| Text | Not used |
Continuation Record (Type 88)
| BAI Field | Description |
| Record ID | Always 88 |
| Text | Continuation of Record type 03, 16 or other records in some cases |
Account Trailer Record (Record Type 49)
| BAI Field | Description |
| Record ID | Always 49 |
| Account Control total | Sum of all amount fields in record type 03, 16, 88. |
| Number of Records | Total number of records for the account |
File Trailer Record (Record type 98)
| BAI Field | Description |
| Record ID | Always 98 |
| File Control total | Sum of all group control total fields in all 98 records in the file |
| Number of groups | Total number of 02 records in the file |
| Number of records | Total number of all records in the file, including 99 record |
Please visit SAP EBS video Course for step by step guidance on EBS business Process, Configuration, Testing: SAP EBS Video Course
Test EBS in SAP
Generate BAI2 file for testing
Transaction code: SE38
SAP program to create a EBS test file# RFEBKAT5
Upload Electronic Bank Statement file in SAP
Transaction code: FF_5 / FF.5
Display Bank Statement in SAP
Transaction code: FF_6 or FF.6
SAP Transaction codes used in Electronic Banking
| S No. | Transaction | T. Code | Input | Output |
| 1 | Upload of Bank Statement | FF_5 | Input File in BAI2 Format | Bank Data Uploaded |
| 2 | Force Match Option | FEBA | Company Code, Payment Details | Open documents are cleared |
| 3 | Display of Document | FB03 | Company Code, Document Number, Fiscal Year | Display of uploaded document |
| 4 | Bank GL balance | FBL3N / FAGLB03 | Display of GL Account | Reconciled Bank GL accounts are cleared |
This complete our discussion on Electronic Bank statement business process and SAP configuration.
For detailed, step-by-step instructions on SAP ACH, Wire, business process, configuration and development follow along with my video tutorial below : SAP ACH, DMEE Training
Please refer SAP FICO Questions & Answers repository for interview training
Pingback: SAP Finance Enterprise Structure – SAP FINANCE and Treasury
Pingback: SAP FSCM (Financial Supply Chain Management) – SAP FINANCE and Treasury
Pingback: SAP Treasury Tutorials | AUMTECH Solutions-SAP Training
Pingback: SAP Tutorials | AUMTECH Solutions-SAP Training
Pingback: SAP FICO Interview Questions & Answers | AUMTECH Solutions-SAP Training
Thanks for explaining about EBS in detail. Provided very good information on configuration of EBS as well. Thank you.