Scribd Logo
Upload

Welcome to Scribd!

  • 704 views

    Ebs Sap

    Uploaded by

    Vignesh Kumar Voleti
    The document discusses electronic bank statements (EBS), which are electronic files sent by banks with transaction details that can be uploaded into SAP systems for automatic reconciliation; it outlines the various formats, process flow, configuration steps in SAP, and posting rules required to define and process EBS files from banks to reconcile transactions. The document provides technical details on how to set up EBS in SAP for automatic reconciliation of bank transactions from electronic statement files received from banks.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Ebs Sap

    Uploaded by

    Vignesh Kumar Voleti
    704 views3 pages
    The document discusses electronic bank statements (EBS), which are electronic files sent by banks with transaction details that can be uploaded into SAP systems for automatic reconciliation; it outlines the various formats, process flow, configuration steps in SAP, and posting rules required to define and process EBS files from banks to reconcile transactions. The document provides technical details on how to set up EBS in SAP for automatic reconciliation of bank transactions from electronic statement files received from banks.

    Original Description:

    ELECTRONIC BANK STATEMENT

    Original Title

    EBS SAP

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses electronic bank statements (EBS), which are electronic files sent by banks with transaction details that can be uploaded into SAP systems for automatic reconciliation; it outlines the various formats, process flow, configuration steps in SAP, and posting rules required to define and process EBS files from banks to reconcile transactions. The document provides technical details on how to set up EBS in SAP for automatic reconciliation of bank transactions from electronic statement files received from banks.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    704 views3 pages

    Ebs Sap

    Uploaded by

    Vignesh Kumar Voleti
    The document discusses electronic bank statements (EBS), which are electronic files sent by banks with transaction details that can be uploaded into SAP systems for automatic reconciliation; it outlines the various formats, process flow, configuration steps in SAP, and posting rules required to define and process EBS files from banks to reconcile transactions. The document provides technical details on how to set up EBS in SAP for automatic reconciliation of bank transactions from electronic statement files received from banks.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    of 3

    ELECTRONIC BANK STATEMENT (EBS)

    EBS is an electronic statement sent by the bank and has details of the
    transactions made on your account.
    It comes in different formats and you upload it into the system & do auto
    reconciliation-clears customer
    line items/other bank transactions.

    PURPOSE: To do Automatic Reconciliation of Transactions

    CONTENTS: 1) GENERAL INFORMATION OF HOUSE BANK


    2) LIST OF INDIVIDUAL LINE ITEMS

    FORMAT: The format used by the banks may vary from bank to bank. Main formats
    using in banking industry
    SWIFT MT940. MULTICASH, BAI, BAI2 ETC...

    TEAM : FICO CONSULTANTS


    ABAPERS
    BANK OFFICIALS
    SR. MANGERS FROM ENDUSERS SIDE

    PROCESS FLOW-CHART:
    _______________
    |MAIN BANK(SBI)|
    |______________|
    |
    |
    |
    {Receiving EBS (ex:MT940) from Bank}
    |
    |
    |
    [SAP CUSTOMER (COMPANY)]
    | {Tcode:FF_5 or FF.5}
    _________________________
    |__________>____________>_________________|UPLOADING
    INTO SAP SYSTEM|
    |_________________________|
    |
    |
    {To view bank statement:FF67
    G/L Balance :FBL3N}
    |
    __________________________________ |
    |View Bank Statement/ G/L Balances| < ____<_________<___|
    |_________________________________|

    WORKING:
    1) POST DOCUMENTS TO CLEARING ACCOUNTS
    2) POST AND CLEAR DOCUMENTS LOCATED IN CUSTOMERS ACCOUNTS(SUB-LEDGER POSTING)

    STEPS :

    > THE PROGRAM WILL FIND A TRANSACTION TYPE WHICH WILL DEFINE HOW POSTINGS
    WILL BE DONE
    > PROGRAM READS EACH LINE ITEM, SEARCHES THE POSTING RULE ASSOCIATED FOR
    SPECIFIC EXTERNAL TR
    > BY THE HELP OF A/C SYMBOLS, EACH POSTING RULE IS EXECUTED
    > THESE ACCOUNT SYMBOLS SPECIFIED DEFINE TO WHICH G/L ACCOUNTS THE POSTINGS
    WILL BE MADE
    > AS PER TRANSACTION TYPE, TWO LINE ITEMS ARE CREATED AND A DOC IS SAVED.
    > TO CLEAR LINE ITEMS , EBS MUST CONTAIN A NOTE-TO-PAYEE WHICH WILL BE
    INTERPRETED ACCORDING TO CERTAIN ALGORITHIMS
    THAT SAP PROVIDES

    CONFIGURATION:

    Pre requisites: open general ledger accounts as per the requirement -----
    (FS00)

    1) Bank check deposit clearing account


    2) Cheque Issue clearing account
    3) Check Dishonoured Clearing account
    4) Bank Charges & Expenses account`

    The following guides how to define Electronic Bank Statement (SAP EBS) step
    by step:

    IMG-FINANCIAL ACCOUNTING- BANK ACCOUNTING-BUSINESS TRANSACTIONS- PAYMENT


    TRANSACTIONS- ELECTRONIC BANK STATEMENT

    The Global settings for Electronic Bank statement are as follows:---------


    (OT83)

    1) Creation of Accounts Symbols

    2) Assign Accounts to Accounts symbols

    3) Create Keys for Posting Rules

    Posting rule: Posting rules are defined to process the various types of
    transactions in the bank accounting

    4) Define Posting Rules

    5) Create Transaction Type

    The transaction type consolidates all external transaction types used by the
    house banks
    while formatting the electronic statement by the banks

    5a) Assign External Transaction Types to Posting Rules:

    External transactions are supplied in the bank file

    +/- sign: indicates whether the particular transaction increases the bank
    account balance or reduce the bank balances

    6) Assign Bank Accounts to Transaction Types

    Interpretation algorithm: is used to identify or search the particular


    transactions

    NOTE-TO-PAYEE: INFORMATION THAT CAN ADDED TO AN EBS AND CONTAINS RELEVENT


    INFO FOR THE BUSINESS PARTNER
    7) Import the external file: FF.5

    PATH: Accounting-treasury- cash management-incomings-electronic bank


    statement-FF.5 import

    We need to import the file received from the bank in to our local file.

    Verify the details and confirm statement details.

    Display of import file: FF.6

    You might also like