UrbanPro
true

Find the best tutors and institutes for SAP

Find Best SAP Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Electronic Bank Statement in SAP

Vinod Kumar
05/12/2019 0 1

Electronic Bank Statement in SAP

Medium to large scale businesses do thousands of transactions each day. Lot of these transactions are banking related. Reconciling bank balances with book balances manually is not possible.

Uploading manual bank statement in ERP system is a time consuming affair and prone to clerical errors due to manual intervention. Treasury staff in an organisation may end up spending lot of time usually at the end of month for reconciliation.

Electronic bank statement feature provided by SAP can save a lot of time and is error free. SAP will upload the file which is sent (FTP) by bank. Based upon SAP configurations financial postings will be done. This configuration will upload the statement automatically and at the same time will do the bank sub ledger postings and clearing postings.

 

Prerequisites

 

Following are the basic requirements for setting up EBS in SAP:

 

  • House Bank
  • Bank file in specified format
  • SAP Configurations for EBS
  • Set up connection between SAP and bank for file transfer mostly secured (sFTP)
  • SAP automated batch set up

SAP Configuration of electronic bank statement(EBS)

 

Financial Accounting –> Bank Accounting –> Business Transaction –> Payment Transactions –> Electronic bank statement

EBS is done at Chart of Account Level

1. Account symbol creation – Account symbols are specifications for general ledger accounts. These are posted with each possible transaction contained in bank statement.

2. Assign accounts to account symbol – GL accounts are mapped to account symbols in this step.

3. Create keys for posting rule – Description for the necessary posting rules is entered in this step. Each posting rule represents a business transaction.

 

4. Define posting rules – In this activity posting specifications for each posting rule is created. You specify how a certain business transaction is to be posted with which posting key, document type and posting type. 

5. Create transaction type – Transaction type contains the external transaction type. External transaction types are codes used by banks to specify the business transaction in bank file. Transaction types in turn  are link between External Transaction Types, Posting Rules and Interpretation Algorithms. Interpretation algorithm interprets the note to payee line in bank statement and accordingly clears the open items accordingly.

6. Assign bank account to transaction types – Last step involved is assigning bank accounts with transaction types as defined above. This step contains the list of external transaction which are valid for a house bank. Please note that assignment is of Bank account number and Bank Routing Number and not of GL account in this step.

0 Dislike
Follow 2

Please Enter a comment

Submit

Bobby S. | 09/03/2020

Nice information

0 0

Other Lessons for You


The Real Value of SAP in the World
The SAP is a standout amongst the most requested innovation in this day and age. SAP was established in the year 1972 going for creating enterprise asset solutions that upgrade information administration...

Procedure to Pay or P2P Process # SAP # AP
Procure to Pay or P2P Process # Business Process # SAP # AP ERP applications have simplified the Business Processes. In big companies, we have separate team for different business functions like Accounts...

Saurabh S. | 16/04/2018

0 0
0

Introduction To SAP R/3, ECC6 And S/4 HANA Over View And Basics Module
Introduciton: SAP (System Application and Product) is the name of the biggest European German Software company as well as the name of software itself. SAP is the fourth largest software company in the...

Emmanuel Bobby | 11/01/2018

1 0
0

SAP FICO Overview By Future Labs Technology
SAP FICO pertains to System Analysis and Program development Finance and Control. It is computer software intended for identifying financial details in a business organization. It is supposed for external...

Future | 12/01/2017

0 0
0
X

Looking for SAP Classes?

Find best tutors for SAP Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for SAP Classes?

Find best SAP Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more