Functionality of the Electronic Bank Statement

1.      There are different programs to upload electronic bank statement. FF.5 or FF_5.

2.      In case, if you are using Multicash format. You need to have three files in FF.5 and two files in FF_5

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

a.      Take all the external codes list from bank.

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

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

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

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

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

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

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

 

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

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

3.       In SAP normally you maintain bank main account and bank sub account.

4.      Whenever you make a payment through F-53 or F-58 or F110, the entry would be:

Vendor Account Dr

To Bank Sub Account

5.      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 the below journal entry:

Bank Sub Account Dr

To Bank Main Account

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

7.      At the time of receipts, you have different accounting entries unlike payments.

8.      It needs to post to two posting areas.

a.      GL Accounting

b.      Sub-Ledger Accounting

9.      The entries would system itself pass is:

Bank Main Account Dr

To Bank Sub Account

 

Bank Sub Account Dr

To Customer account.

 

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

11.   Ideally you will use FF67 / FF.5 / FF_5 for uploading manual or electronic bank statement FEBA / FEBA_BANK_STATEMENT is used for further processing.

12.   GO THROUGH SAP NOTE 48854 Please go through SAP Note. 48854. You will get an idea regarding the functionality of the algorithms. Though this note is in relevant to GB specific, you will find this very useful.

13.   Description follows below regarding the normal procedure for maintaining table T028G. Due to the different bank codes and posting rules, pre-Customizing is not possible at this point.

14.   The following processing types are available - unless stated otherwise, you should use the interpretation algorithm: '000 - No interpretation' in each case. 

a.      '00': There is no processing. The entry line is ignored.

b.      '01': A validation is made whether an entry exists for the transferred check number in the check table (PAYR). The check number and payment document number are transferred for further processing. Interpretation algorithm: outgoing check processing '011'-'013'; the update in the check file is via the interpretation algorithm.

c.       02': Transfer of the ending balance to the electronic bank statement

d.      '03': Transfer of the opening balance to the electronic bank statement

e.      '04': Clearing via the allocation number which is delivered with the bank statement. No interpretation algorithm.

f.       '05': Clearing of BACS payments or BACS bank collection. The reference text field is first read to ascertain whether it involves payments initiated by users or bank collection via BACS. Providing it does involve a cash transaction initiated by the user, the payment document numbers concerned are determined via the reference number and transferred as a reference to further processing. Interpretation algorithm: '000 - No interpretation' or '019 - Reference number DME'. Note To differentiate between the two procedures in table T028G, you have to maintain two separate entries. Example: the bank uses bank code '62' for cash receipts and for BACS bank collection. Ext. Transaction +/- sign Posting rule Int. Algorithm Processing type 62 + GB62 001 5 62 SAPBACS + GB63 000 5

g.      '06': Bank costs or interest revenues Recommended interpretation algorithm: '000 - No interpretation'

h.      '07': Total amount of cash disbursements

i.        '08': Total amount of cash receipts

j.       '09': Items not paid Recommended interpretation algorithm: '000 - No interpretation'

7 comments:

  1. This is very helpful

    Thanks M

    ReplyDelete
  2. Hi guys, thanks for this information, I need one more help regarding Electronic bank payment, suppose i receive a Electronic bank Statement of type MT490, Now my issue is how can i check that the payment received from the customer is related to which invoice..,

    Thanks in Advance
    Regards
    Ashish Sharma

    ReplyDelete
  3. this is very useful,really good one

    ReplyDelete
  4. Good explanation, specially on algorithm .

    ReplyDelete
  5. Nice documentation, my query is I would like to clear the my customer entries with respective of profit center when we are uploading the EBS Statement in SAP. is there any possibility to do like that?

    ReplyDelete