...

SAP Electronic Bank Statement Tutorial

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

EBS business process

 

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

EBS

Bank Master Creation

Transaction Code: FI01 / FI02 / FI03

Bank master creation

House bank

Transaction code:  FI12

House Bank

  • 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

Bank fields update in GL account

SAP VIDEO TUTORIAL

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

Update Vendor master with its bank details

SAP  EBS : Configuration Steps

  1. Create Account Symbols
  2. Assign Account Symbols
  3. Create Keys for Posting Rules
  4. Define Posting Rules
  5. Configure Transaction Types
  6. Assign BAI Codes to Posting Rules
  7. 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

EBS- 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

EBS - Posting keys

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

EBS- Posting Rule

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

EBS- Assign External transaction type to posting rules

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

EBS- Assign Bank account to transaction type

 

SAP EBS Online Video Course

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

BAI2 Test 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
BAI2 test file

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
EBS BAI2 test file explanation

 

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 BAI2 test file explanation

 

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
EBS BAI2 test file

 

SAP Finance tutorials

SAP Treasury tutorials

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

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

Facebook
Twitter
LinkedIn

6 thoughts on “SAP Electronic Bank Statement Tutorial”

  1. Pingback: SAP Finance Enterprise Structure – SAP FINANCE and Treasury

  2. Pingback: SAP FSCM (Financial Supply Chain Management) – SAP FINANCE and Treasury

  3. Pingback: SAP Treasury Tutorials | AUMTECH Solutions-SAP Training

  4. Pingback: SAP Tutorials | AUMTECH Solutions-SAP Training

  5. Pingback: SAP FICO Interview Questions & Answers | AUMTECH Solutions-SAP Training

  6. Asifuddin Mohammed

    Thanks for explaining about EBS in detail. Provided very good information on configuration of EBS as well. Thank you.

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!
Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.