RFEBKATX: An Implementation Tool for the Electronic Bank Statement

Description

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.

Background

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 possible.

The implementation phase, particularly customizing, mostly throws up two main obstacles to quick, efficient implementation:

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 place.

Solution/>

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.

Prerequisites

1. You must create a house bank account, for which the bank statements are to be generated, in your company code.
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.

Create customer

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
Example:
G/L account: 113100
Substitute account: 113119

Create G/L account

Note:
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 statement file:
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.

Program Settings

You can enter the following settings in the RFEBKATX selection screen:

1. File 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 files.
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 be generated.
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 displayed.
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 increased.
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 statement.
RFEBKA00 can use this information to find the relevant open item in the system.
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.

Program Output

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:

Account information
Details of the house bank account for which the statement files were generated.

Subledger postings
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.

Generated files
Here, you can see whether files were created and, if so, which ones.

Statement information
Here, you can obtain details on the banks statement generated, such as the statement number and date, opening and closing balances, and so on.