RFEBKATX: An Implementation Tool for the
Electronic Bank Statement
This program is designed to help you help you make the
customizing settings required when you implement the electronic
bank statement and to give you a feel for the options available in
the electronic bank statement.
The electronic bank statement is used to, among other things,
effect automatic assignment of payments into and out of house bank
accounts (bank transfers, checks, and so on) to the relevant open
items, which are already entered in the system in customer, vendor,
or clearing accounts, and to clear these open items if
The implementation phase, particularly customizing, mostly
throws up two main obstacles to quick, efficient
1. Creating the bank statement files
UMSATZ.TXT and AUSZUG.TXT is very difficult. Experience has shown
that many implementation errors arise from format errors in these
files. Using actual files from the bank is also difficult as these
are mostly very big.
2. The open items to be found and
cleared using the bank statement must usually be entered into the
(test) system manually. This information must also be available in
the individual figures from the file UMSATZ.TXT in the right
You can use program RFEBKATX to create open items in a company
code and the related (MULTICASH) bank statement files for a house
bank account in this company code. You can import these directly
using program RFEBKA00 and so test your customizing settings and
the general functions in program RFEBKA00.
1. You must create a house bank
account, for which the bank statements are to be generated, in your
Remember to maintain the G/L account (such as 113100) in the house
bank master record.
Create/maintain house bank account
1. Create the customers for whom you
want to create open items in this company code.
1. Create a substitute account for
the postings which lead to the creation of open items in customer
accounts. The number of this G/L account Stellvertreterkonto für
die Buchungen, die zur Erzeugung der offenen must be the same as
that of the G/L account for the house bank account, except that the
last two digits must be replaced with "19".f die
G/L account: 113100
Substitute account: 113119
Create G/L account
Running test program RFEBKATX creates
a payment on account labeled "Customer to substitute account" for
the purpose of creating open customer items. From the point of view
of accounting for invoice postings to a customer account, this is
not correct (-> revenue account).
However, the correct update of
customer invoices in revenue accounts is not the object of this
program, which you should only use in your test systems.
1. To generate open items in clearing
accounts, you must create G/L accounts for these clearing accounts.
The rule is similar to that applying to substitute accounts, so
that the end figures are as follows:
Outgoing checks: '01' (in our example: 113101)
Incoming checks: '08' (in our example: 113108)
Cash out: '09' (in our example: 113109)
Set the open item management and line item display indicators in
the master data for these accounts.
Create G/L account
Business Transaction Keys
The following business transaction keys are used in the bank
Bank transfer credit memo: 051
Outgoing check: 001
Incoming check: 070
Debit memo presentation: 071
You must use these transaction keys in customizing for the
electronic bank statement.
You can enter the following settings in the RFEBKATX selection
specifications: Here, you can determine whether the the
files to be produced should be stored in the application or
presentation server (PC) and stipulate the name and path for the
2. Account details:
Here, you can determine the company code, house bank, and house
bank accounts for which the open items and statement files are to
3. Statement data:
Here, you can determine the statement date and the invoice used in
generating the open items.
4. Posting method:
Here, you can determine whether the posting takes place wholly in
background processing or whether the posting screens should be
In the latter case, you can intervene in the posting and change the
content of the screen fields (such as posting text and account
number) or maintain required fields which the program does not
automatically supply with data. This option is recommended if
errors occur. nachliefern.
5. Creating Open Items -
Customers - : Here, you can enter the customers for whom
you want to create open items, and the total number of open items
to be created for all customers.
You can stipulate that the amount in the bank statmeent is one unit
to small in the relevant account currency (-> underpayment).
You can stipulate the amount of the first open item and whether and
by by how much the amount of the subsequent open items should be
You must stipulate the document type and posting key for the
on-account posting for customer open items.
You can stipulate whether a customer's bank details should appear
in the bank statement along with the bank transfer, provided you
have maintained the customer master record accordingly.
This enables the import program RFEBKA00 to identify the customer
who has made the payment.
You can stipulate whether the document number for the posting which
generated the open item should appear as a reference in the bank
RFEBKA00 can use this information to find the relevant open item in
6. Creating Open Items -
Clearing Accounts - : You can determine whether the
program is also to create open items in the clearing accounts. To
do this, you must enter a document type and the posting keys.
Having posted the open items and generated the two bank
statement files, the system displays a list, showing details of the
postings and open items generated, as follows:
Details of the house bank account for which the statement files
Here, you can see the customer for whom postings were to be made,
and the status of those postings.
G/L account postings:
Here, you can see the clearing account for which postings were to
be made, and the status of those postings.
Here, you can see whether files were created and, if so, which
Here, you can obtain details on the banks statement generated, such
as the statement number and date, opening and closing balances, and