Course Information
Course Overview
SAP FICO Electronic Bank Statement (EBS) + Lockbox + Partial Payment with Automatic Payment Program (F110) | With Docs
SAP Electronic Bank Statement EBS and Lockbox
Complete Practical Training with Real Time Scenarios and Interview Preparation
This course is designed for SAP FICO consultants, support professionals, and interview preparation candidates who want strong practical knowledge of Bank Accounting and Reconciliation in SAP.
Electronic Bank Statement EBS is one of the MOST IMPORTANT and FREQUENTLY ASKED topics in SAP FICO interviews
In real-time projects, companies rely heavily on automated bank reconciliation using EBS, Lockbox, and Automatic Payment Program F110.
This course provides end-to-end understanding from configuration to posting, clearing, testing, and troubleshooting.
IMPORTANT
Highly recommended for SAP FICO Interview Preparation and Bank Accounting Support Roles.
SECTION 1
ELECTRONIC BANK STATEMENT EBS – MOST IMPORTANT FOR INTERVIEW
Electronic Bank Statement automates reconciliation of bank transactions with SAP books by importing bank files and posting them using predefined rules.
You will learn:
Complete EBS Process Flow
Difference between Manual Bank Statement and Electronic Bank Statement
Understanding Bank Statement Formats
MT940 Format
BAI2 Format
CSV and XML Formats
Understanding Bank File Structure Received from Bank
EBS CONFIGURATION IN SAP – STEP BY STEP
House Bank Configuration using FI12
Linking Bank Account with GL Accounts
Determination of GL Accounts in EBS
Configuration of Account Symbols
Configuration of Posting Keys and Posting Rules
Business Transaction Codes
Assign External Transactions to Posting Rules using OT57
Define Posting Rules using OT83
Interpretation Algorithms Configuration
How SAP Reads and Interprets Bank Statement Text
EBS SEARCH STRINGS – HIGHLY IMPORTANT FOR INTERVIEW
What are Search Strings in EBS
Why Search Strings are Critical for Automation
Configuration of Search Strings
Identifying Invoice Numbers, References, Bank Charges
Mapping Text Patterns to Correct GL Accounts
Search Strings Unit Testing
How Search Strings Reduce Manual Reconciliation Effort
EBS PROCESS EXECUTION AND TESTING
Uploading Bank Statement using FF_5
Automatic Posting and Clearing
Understanding Accounting Entries Generated by EBS
Post Processing using FEBAN and FEBA
Handling Unprocessed Items in Suspense Accounts
Understanding Important EBS Tables
Format and Field Functionality in EBS
AFTER COMPLETING EBS SECTION YOU WILL BE ABLE TO ANSWER
What is EBS in SAP
How MT940 and BAI2 formats work
How Posting Rules are configured
What are Search Strings and how they improve automation
How Interpretation Algorithms function
How Automatic Clearing works
How to troubleshoot EBS errors in support projects
SECTION 2
LOCKBOX – IMPORTANT FOR INTERVIEW
Lockbox is widely used in customer collections process in large organizations.
You will learn:
Complete Lockbox Process Flow
Understanding Lockbox File Received from Bank
Lockbox Configuration
Understanding BAI2 Format in Lockbox
Post Processing of Lockbox File using FLB1
Use of FLB2 in Lockbox Process
Origin ID and Destination ID in Lockbox
Status of Lockbox Posting
Applied
On Account
Unapplied
Understanding Accounting Entries in Lockbox
Customer Master Data Requirements
Understanding Lockbox Tables
Understanding Lockbox BAI2 File
Structure FLB06
Structure FLB04
Format and Field Functionality in Lockbox
AFTER COMPLETING LOCKBOX SECTION YOU WILL BE ABLE TO ANSWER
What is Lockbox and how it differs from EBS
What is Origin ID and Destination ID
What are Applied, On Account and Unapplied statuses
How Lockbox postings are processed
How to troubleshoot Lockbox errors
SECTION 3
PARTIAL PAYMENT WITH AUTOMATIC PAYMENT PROGRAM F110 – Bonus Lecture
Partial payment through F110 is a common real-time business requirement and a favorite interview question.
This section covers:
Special GL Indicator P
How to process Partial Payment using F110
Role of Payment Request
Invoice blocking and unblocking for Partial Payment
Complete business scenario explanation
WHO SHOULD ENROLL
SAP FICO Consultants
Support Consultants
Interview Preparation Candidates
Finance professionals handling bank reconciliation
Working professionals moving into SAP
Anyone who wants strong practical knowledge of Bank Accounting and Automation
WHAT MAKES THIS COURSE DIFFERENT
Step-by-step configuration with real system logic
Strong focus on Search Strings and Automation
Real-time business scenarios
Interview-oriented coverage
Configuration to Testing approach
Clear explanation of Accounting Entries
Support project troubleshooting guidance
CAREER BENEFITS
After completing this course, you will:
Configure and Execute Electronic Bank Statement independently
Automate reconciliation using Search Strings
Handle Lockbox configuration and processing
Troubleshoot EBS and Lockbox issues confidently
Answer advanced SAP FICO interview questions clearly
Work effectively in SAP support and implementation projects
Disclaimer
This course is an independent training program and is not affiliated with, endorsed by, or authorized by SAP SE (formerly known as SAP AG).
All SAP-related product names, logos, and trademarks are the property of SAP SE.
Students are required to arrange their own SAP server access for hands-on practice.
Course Content
- 3 section(s)
- 12 lecture(s)
- Section 1 Understand SAP Electronic Bank Statement
- Section 2 Understand SAP Lockbox
- Section 3 Bonus Lecture on Partial Payment with Automatic Payment Program (F110)
What You’ll Learn
- SAP FICO EBS Configuration In Details, Testing Of SAP FICO EBS Configuration, SAP FICO Lockbox Configuration In Details, Testing of SAP FICO Lockbox Configuration, BAI2 File Format Used For SAP FICO EBS And Lockbox Files, Interview Preparation On SAP EBS and Lockbox Topics
Skills covered in this course
Reviews
-
NNishit Shah
Explanation is very good One request please use new Transactions like FB60, FB70 etc. It creates confusion when you use old Tcodes
-
CChristian M
Good
-
CCallum O’Neill
Good
-
RRakesh padhiary
I am able to understood the complete EBS process. Thanks