SAP FICO Advanced – Cash Mgt

Electronic Bank Statement (EBS) and LockBox:





  • Customers remit their invoice payments at lock boxes.
  • Lock boxes are special depository accounts set up at Bank for SAP customer company.
  • Customers deposit their payment against their invoices at bank via checks, cash or electronic money transfer.
  • When the bank receives a check from customer with remittance information it sends it in Lockbox file.
  • After the process at LockBox the posting will look like:
  • Capture4
  • After Check is cleared in the bank, it will upload the information as an electronic bank statement (EBS) into the SAP customer system (to upload the file into SAP T code: FF_5).
  • EBS is an electronic file (such as SWIFT, MT940, BAI or BAI2), which gives details of the transactions done by the account holder (customer) so that SAP system can clear the various Bank clearing accounts such as the Check out, Check in account to the main bank account and clear the corresponding customer account (to view the Bank statement T Code: FF67 and to view the G/L balance T Code: FBL3N).The account entry would look like below after the EBS process.



EBS PROCESS FLOW (in Schematic View)



Electronic Bank Statement Configuration Steps:


Step 1. Define House Bank, Bank Account Details(GL, Currency, Bank Key, Bank Name)- T code FI12
Step 2. EBS Framework T code: OT83

(a). Create Account Symbols
(b). Assign Accounts to Account Symbols
(c). Create Keys for Posting Rules
(d). Define Posting Rules
(e). Create Transaction Type
(f). Assign External Transaction types to Posting Rules
(g). Assign Bank Accounts to Transaction types.

Step 3. Import EBS T code: FF_5


LOCK BOX Processing


LOCK BOX Process Configuration:

Step 1: Define House Banks (T Code: FI12)





Then Double click on Bank Accounts folder



Step 2: Define Lockbox Accounts for House Banks



Select Define Lockbox Accounts at House Banks



In New Entries enter the following information



Step 3: Define Control Parameters (T Code: OBAY)



Control parameters are maintained by default. If not, we have to maintain as follows

Click New entries then enter the following information (yellow boxes)



Step 4: Define Posting Data (T Code: OBAX)



Click New entries and enter following information (yellow boxes are required)



Here you store information that needed to process particular Lockbox data and generate Postings.

The Destination and Origin are routing information and defined by your bank. For every unique destination/origin, posting information is needed to create the following postings:

G/L posting – Debit bank account (incoming checks/cash) and credit payment clearing account

A/R posting – Debit payment clearing account and credit customer account.

(Create these two accounts in G/L Master)

These are the basic settings to process lockbox data.


In addition, we have to make sure that Tolerance Groups for Employees (T Code: OBA4), Tolerance for Customers/Vendors (T Code: OBA3), and Accounts for Overpayments/Underpayments (T Code: OBXL) are defined.

User End Settings

Step 1: Maintain Customer Master (T Code: FD02)

In order to identify the customer, we need to maintain bank details in the customer master



Step 2: Customer Invoice posting (T Code: FB70)



Open the Invoice (T Code: FB03) (Document display)





Customer open line item display (T Code: FBL5N)



We have created an A/R open item with document number 400009. Now we will clear this open item through Lockbox process.

Lockbox File Processing

Step 1: Import BAI2 file (T Code: FLB2)

(For BAI2 file format and how to read the file please check at the bottom of this page)



Then press Execute button

Once you process lockbox BAI2 file system generates either of following four statuses for each of 6 record types (6 record contains customer details such as Invoice amount, Bank key, Bank account etc.).

  1. Applied
  2. Partially Applied
  3. On Account
  4. Unprocessed.


The above Transaction shows that the system has created two accounting documents. Financial document 43 for G/L posting while financial document 700009 for sub-ledger posting.

The status indicates ‘Applied’ that means the system has identified the customer, and able to locate AR open items, and Incoming payment matches with Open AR after taking account employee and customer tolerances in consideration.

We can see additional information on lockbox processing by clicking on back button two times.

In below screen figure we can see system has selected the right customer by matching MICR (Magnetic Ink Character Recognition) number.

Based on document number information system has identified the relevant AR open item.



After successful lock box processing, we can see that customer open line item has been cleared as shown below by document number 700009

Display Document (T Code: FB03)




Customer Document clearing report (T Code: FBL5N)



Accounting document 700009 was posted to Account 200119 by crediting customer 600004.

To Check the G/L Account 200119 (T Code: FBL3N)


To see further details of Lockbox (T Code: FLB1)

We can see all the processed Lockbox files which are arranged in date and time.



Click on other display


Sample BAI2 file (good for exactly $1200)

6001002000012000002100008955566677 77990023






T Code: SE38

To Generate BAI2 format: Use Lockbox Generation Program RFEBLBT2
To generate IDOC format: Use Program RFEBLBT3.
To delete the loaded BAI2 file: Use program RFEBKA96 (then execute, Choose lockbox (003), define destination and origin, date and execute to delete the loaded file)

source: &


104 Industrial Blvd, Suite P,
Sugar Land, TX, 77479

We are located close to Hwy 59 and
Hwy 90 in Sugar Land , TX


Phone : 419 408 3178

Back to Top