1.    Upload Bank Statement in SAP:

Transaction Code

To upload the incoming bank statement T CODE – FF.5 or program RFEBKA00 is used and depending on your requirement select the selection screen parameters.

Formats

Uploading of Bank Statements into SAP can be done in various formats. It depends upon the client’s agreement with the respective bank. The formats can be Multi-cash, SWIFT, BAI, etc.

Menu Path

/wp-content/uploads/2013/10/1_294770.jpg

Figure 1

Screenshot Showing Input Details

/wp-content/uploads/2013/10/2_294771.jpg

Figure 2

Posting Parameters:

Uploading of Bank Statement can be done in either of the following two ways:


a) Do not post – If we select this option, the Bank Statement gets uploaded into the system but entries are not posted to the Bank GL Account. In order to post the entries, we have to use the T-code FEBP.

b) Post immediately – If we select this option, then the entries in Bank Statement get posted to the Bank GL Accounts the moment we upload the Bank Statement into the system.


Viewing of Uploaded Statement

We can view the uploaded Bank Statement via T-code FF.6 as shown below.


/wp-content/uploads/2013/10/3_294772.jpg

Figure 3

We can view the uploaded Bank Statement via T-code FF.6 as shown below.

The selection parameters to be given include Company Code/Application, House Bank ID, Account ID, Statement Number/ Dates.

Application means whether it is manual or Electronic Bank Statement.

001: Electronic and Manual bank statement

002: Check deposit transaction

003: Lock box

004: Account Balance


/wp-content/uploads/2013/10/4_294779.jpg

Figure 4

Tabular Reference

The uploaded bank details can be viewed from Table FEBKO (header data) and FEBEP (line item data).

/wp-content/uploads/2013/10/5_294780.jpg

Figure 5

/wp-content/uploads/2013/10/6_294781.jpg

Figure 6


2. Deletion of Bank Statement from SAP

Transaction Code

Program RFEBKA96 is used for deleting Bank Statement.

Introduction

Sometimes after uploading the Bank Statement, we come to know that the statement is bad / incomplete. In that case, we ask for a corrected / complete statement from the Bank. So, in order to avoid confusion and duplicate, we have to delete the previous statement which was incomplete.

Steps to be followed

The following steps needs to be followed for deleting Bank Statement:-

(a)  Go to T-Code FEBA. Identify the Bank statement ID which needs to be deleted, e.g., 01 in above scenario.

Information required

Statement Number

Statement Date

Account Number

Company Code

House Bank

Account ID

/wp-content/uploads/2013/10/7_294892.jpg

Figure 7

/wp-content/uploads/2013/10/8_294905.jpg

Figure 8

(b) Go to T-Code SE38 and give the program name i.e. RFEBKA96.

/wp-content/uploads/2013/10/9_294906.jpg

Figure 9


After entering in to the program, it asks for Application and ID.

For prior day statements, use Application ID = 0001 and for same day statements, use Application ID = 0004. It asks for Statement ID also.

/wp-content/uploads/2013/10/10_294907.jpg

Figure 10

Click the Delete Statements button.

/wp-content/uploads/2013/10/11_294908.jpg

Figure 11

/wp-content/uploads/2013/10/12_294909.jpg

Figure 12

(c) After deleting the Statement, we can check it in T-Code FEBA

/wp-content/uploads/2013/10/13_294910.jpg

Figure 13

/wp-content/uploads/2013/10/14_294911.jpg

Figure 14

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply