Skip to Content
author's profile photo Former Member
Former Member

Electronic Bank Statement Reco

Hello all

I need to configure Electronic Bank Reco for my client. Now, I am wondering what should be my starting point as I have not worked on this before. I have recieved a bank statement file from the client. I know that I need to first Create Transaction types and Assign External Transaction Types to Posting rules. I am wondering what these 2 mean. I am aware that the External Transaction Type is the code used by the bank to classify the transactions. E.g Cheque Payment might be MICR. But where do i find them, i mean I see the codes in the statement file. But am I looking at the right codes or these are something which are internal to the bank and we need to obtain them from the bank itself?

Second, do we need to obtain the format from the bank of the output file e.g Multicash, SWIFT etc?

Once this is done, we would need to upload the file. Or do we need to first convert the files?

Any help on this topic would be highly appreciated.

Thanks in advance

Hrishi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2008 at 07:16 AM

    Hi,

    This is the recommended order of steps in doing configurations of Electronic Bank Statement based on my experience:

    1. Define House Banks (if you haven't)

    2. Create Transaction Type (usually one transaction type per BANK)

    3. Assign Bank Accounts to Transaction Type

    4. Create Account Symbols (this will be you corresponding accounts that you will use during posting of electronic bank statement)

    5. Assign Account to Account Symbols

    6. Create Keys for Posting Rules (posting rules will define what postings are to be done based on the Transaction Code of the bank)

    7. Define Posting Rules

    8. Assign External Transactions (based on the Transction codes you get from the bank, you now map them to their correspongding posting rule created earlier)

    If you have any more questions, please feel free to ask forums.

    Hope this helps you in you config

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2008 at 06:27 AM

    Hi Hrishi,

    As u know SAP understands two formats for EBS one is MT940 and other is Multi Cash. Coming to the EBS generally now a days all the banks are giving statements in either of these formats, so u can ask your bank to send the statement in one of these formats.

    If the statement is coming in one of the above specified formats then u can directly import it into R/3 by T.Code FF_5. Later u need to run FEBA program for doing reconciliation.

    Coming To External Transaction Types as u know these are the transaction types which are coming from banks end, so before doing EBS configurations u need to get the list of all the external transaction types from your bank.

    Regards

    srikanth.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Yes, the statement file and the line item file will come from the bank. The naming of these files will depend per bank but the standard naming convention for these files are:

      AUSZUG.txt = Statement File

      UMSATZ.txt = Line Item File.

      You can try to search for SAP Note regarding format of these files.

  • Posted on Nov 12, 2008 at 02:12 PM

    In Multicash format, the bank gives the 2 files; in MT940, there is only 1 file: lets the second filename empty.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.