Global Settings of Electronic Bank Statement

 Global Settings of Electronic Bank Statement

IMG => Financial Accounting => Bank Accounting => Business Transactions => Payment Transactions => Electronic Bank Statement => Make Global Settings for Electronic Bank Statement

 

Give your chart of Accounts

 

1. Create your account symbols

 

Create freely definable account symbols. Make sure that you are able to identify them when you are configuring in future steps.

 

2. Assigning Accounts to Account Symbols

 

Here you need to assign the account symbols to GL Accounts or you need to use masking logic. You must have designed your accounts in such a way that the end digits will work for posting the entries to FI. Account Modifier you use as + and use your local currency, if you do not have any foreign currency postings.

 

3. Create Posting Rules

 

Create freely definable posting rules.

 

4. Define Posting Rules (This is the most important configuration for your FI Postings / Clearings)

 

a) For all the payments you need to create the entries for posting area 1

b) For all the receipt you need to create the entries for posting area 1 and 2

c) Use the document type DZ in case if you want to clear the items. Use Posting type 8. If the invoice number is there in the reference field of bank statement, automatically the same will be selected by the system and cleared.

d) If you want just only entries to be posted use posting type 1.

e) If you want to clear the check, then use the posting type 4.

f) Configure according to the entries to be posted.

g) If you are going for clearing something the offsetting debit / offsetting credit (as the case may be) need not be given.

 

5. Create Transaction Type

 

Create freely definable Transaction Type

 

Select the transaction type and assign the external transactions to your posting rules.

 

For outgoing check use 13 as Interpretation Algorithm and 1 as the processing type.

Remaining all case use 1 (Standard algorithm) and 5 as the processing type.

 

Please also go through the below mentioned note in case if you are required to use further available interpretation algorithms or processing types.

 

6. Assign Bank Accounts to Transaction Types:

 

You need enter the Bank Key / Bank Account / Transaction type here.

 

You can get the the bank key and bank account details from table T012K (Go to SE16)

 

Further supplementary notes may be useful to you:

 

There are different programs to upload electronic bank statement.

FF.5 or FF_5.

I think your case Multicash format you are using.

 

You need have three files in FF.5 and two files in FF_5

 

You can prepare a Z program in order to truncate the electronic bank statement into two or three part files and save them on the application server.

 

1. Take all the external codes list from bank.

2. Take any available documentation from the Bank describing the relevance of the external codes.

3. Make sure that your Chart of Accounts (Bank Accounts) last digits logic is appropriate to meet the requirements.

4. Based on this decide the Account Symbols that are required to be created.

5. Make sure that the masking rules are configured properly.

6. Decide the posting rules that needs to be created.

7. Link up your external symbols provided by the bank with Posting rules and give proper algorithms for posting and clearing logic.

6. Concentrate on the posting areas to be posted while uploading the bank statement.

 

Further explanation would help you to understand the functionality when uploaded the electronic bank statement.

 

Main purpose of uploading the bank statement into SAP is to make your Bank Main Account and physical bank statement balance in sync.

 

You do not have any traditional Bank Reconciliation Statement (BRS) report in SAP.

 

SAP is normally you maintain bank main account and bank sub account. Whenever you make a payment through F-53 or F-58 or F110, the entry would be:

 

Vendor Account Dr

To Bank Sub Account

 

The ending digits of the sub-account would be important in configuring the masking rule. Based on this masking rule when you upload the bank statement the entry the system would pass is:

 

Bank Sub Account Dr

To Bank Main Account

 

It depends on the configuration, either the sub account will be cleared by the system automatically or you need to run F.13 to clear the sub accounts.

 

At the time of receipts, you have different accounting entries unlike payments. It needs to post to two posting areas. 1. GL Accounting 2. Sub-Ledger Accounting

 

The entries would system itself pass is:

 

Bank Main Account Dr

To Bank Sub Account

 

Bank Sub Account Dr

To Customer account.

 

Clearing logic mentioned for your posting rules and the alogrithm used for your external bank symbols will also play pivotal role in clearing the accounts.

 

Ideally you will use

 

FF67 / FF.5 / FF_5 for uploading manual or electronic bank statement

FEBA / FEBA_BANK_STATEMENT is used for further reprocessing