Skip to Content

Electronic Bank Statement in SAP - How to setup configuration for Foreign Currency Transactions

I am configuring Electronic Bank Statement Functionality for one of my clients and using BA12 format.. The Main Bank GL and the Sub accounts for clearing in Canadian Dollar and US Dollar are setup as follows in the Chart of Accounts. They only have transactions in CAD and USD. CAD is the local currency



Main Bank CAD - 1001101,

Main Bank USD - 1001102,

Cheque Clearing CAD - 1001111,

Cheque Clearing USD - 1001112,

ACH clearing CAD - 1001121,

ACH Clearing USD - 1001122,

Wires Clearing CAD - 1001131,

Wires Clearing USD - 1001132.

How can I do the configuration with this setup? Can I use masking if I want to? If so how?

I tried to setup Account Symbols and Posting Rules for CAD and USD but the problem is that the external transaction type code from the bank is only one for each transaction type. For example 475 is for cheques outgoing and SAP does not allow me to use 475 for CAD and USD both. It says entry already exists.

Any Guidance/Input would be greatly appreciated

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Nov 02 at 02:25 PM

    Hi Arun,

    You have two options here:

    Option 1- go for masking

    Step 1: Account symbols: Main Bank +++++++

    Chec Clearing +++++1+

    ACH Clearning +++++2+ etc..

    Step 2: Posting rules: PRCK- Check Dr

    Main Bank Cr

    Step 3: Assign posting rule to BTC in transaction type (TTYP)

    475-PRCK

    Step 4: Assign Bank accounts to transaction types:

    Bank Key1-USD Account - TTYP (transaction type)

    Bank Key1-CAD Account - TTYP (Transaction type)

    That's the best way can do it. in the BAI2 statement you receive you will Account number, Currency, based on that system can take care of everything.

    Option 2- without masking

    Step 1: Account symbols:

    Main Bank USA-1001102

    Check USA-1001112

    Main bank cad-1001101

    check cad-1001111

    Step 2: posting rules:

    PR1 - Check USA Dr to Main Bank usd Cr

    pr2: check cad Dr to Maint bank cad Cr

    Step 3: Assign posting rule to BTC in transaction type

    475-PR1 in TTYP1

    475-PR2 in TTYP2

    Step 4:

    Assign Bank accounts to transaction types:

    Bank Key1-USD Account - TTYP1 (transaction type)

    Bank Key1-CAD Account - TTYP2 (Transaction type)

    I would go with Option 1.

    Please appreciate my answer without fail, it took me almost 30 minutes to just compose this for you :P

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31 at 07:08 PM

    Your scenario bit resembles with my scenario. In my scenario, EBS was implemented 1 year after the implementation. We normally follow the that Main Bank GL will end with 01 series and 02 and 03 for sub account so we can use masking for other company code GL account's but for 5 company code have different main bank and sub bank account and none of them are identical so I can't use the masking funda. I thought to use BADI but later I realize you can adjust this with the simple trick by creating new account symbols for every company code. Assign each every account symbols to different GL. Remaining all the configuration will be the same, no need to worry about external transaction type because other accounts symbols will also use the same external transaction type :)

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Srinivasalu,

    Greatly appreciate your response. We are still testing them out and I did not have any luck as yet. Please advise about the clearing. How do we take care of Cheque/ACH and Wires Clearing? Some of my coworkers told me that EBS only posts to the clearing account as an open item but does not clear open items. How do I do this? Do I need to use any algorithm or search string? If so, how can they be used in this scenario?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Arun,

    I will explain check clearing:

    at the time of payment you post an entry

    Vendor Dr

    Check clearing account Cr

    now when your check is en cashed, the entry would be

    Check Clearing account Dr

    Main Bank Cr

    1. Now when you are defining your posting rule do the following:

    select - 4 for Post Type, this means you are trying post a 'Debit clearing posting' using the posting rule.

    2. when assigning External transaction type to posting rule:

    select 11 for 'Interpretation algorithm'

    Note: when testing

    1. make sure you already have "Check clearing account Cr" entry for equal amount before posting your EBS "check clearing account Dr"

    2. check number you used in payment document has to come in the EBS bank statement in the 'Notes" field.

    Clearing while posting entries using EBS is absolutely possible.

    Thank you,

    Sree.

    Add comment
    10|10000 characters needed characters exceeded

  • Thanks so much Sree for your detailed explanation. I am very clear about the accounting entries. My question is what triggers the clearing? Is it using 4 for post type triggers clearing? So I have defined posting rule as:

    Posting Rule 0201 for cheque clearing - Posting Area 1, Debit - I have maintained only the account symbol 02 which is Cheques Clearing Sub Account, Credit I have maintained Posting Key 50 and Acct Symbol -01 which is main bank account. Document Type ZV, Posting Type 4 and posting on acct key-40. I have maintained algorithm number 11

    Is this correct?

    Also, we are using the BAI2 file format for EBS. The cheque number comes like this in the file. Cheque Number here is 250040

    16,475,63866,V,180731,,250040,250040/

    88,FR:CHEQUES PD,ENCODED

    88,ENDT:20180801

    88,TRID:250040

    My question - When we upload the EBS file into SAP, How does the system know how to clear this cheque? Where will it match the cheque number and clear it?

    Once I have this working, I will ask you how to clear ACH and Wires. Hope the logic is same!

    Thanks

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • One more question Sree - transaction FB01 is blocked in our company and EBS job invokes FB01 to post SA document type (like a Journal Entry). If we want to post bank charges, then FB01 is used by EBS job (FF_5) to post directly to bank charges G/L Debit and Main Bank Account G/L Credit. Since this is blocked, no user is able to use this transaction. Can we change the FF_5 program to use any other transaction instead of FB01?Is there a way this can be resolved? because if any user executed FF_5, the bank charge and all those transactions will not post because there is no authorization for FB01.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • 1. yes that posting type in the definition of posting rule is what specifies clearing. here in your case you should use Debit clearing posting type in posting rule. meaning you want to post both debit and clearing entry on your check sub account. And if I remember it correctly, I don't think you would be able to give posting key in the posting rule on clearing account, system automatically determines it.

    2. the interpretation algorithm says you clearing is based on what? if you choose 11 as your interpretation algorithm it takes check number from your EBS notes and tries to find the corresponding credit entry from check clearing account which has the same check number in it.

    3. and also while posting in FF_5 screen, you would need to enter the BELNR and XBLNR range for the automatic clearing to work.

    4. your EBS file looks good to me as per check number. for ach and other methods you can try the same.

    5. if FB01 is blocked for use and cant' be unblocked then take ABAP team help and try to trigger different t-code than FB01 from EBS program. but remember it may be a cumbersome process.

    Thank you,

    Sree.

    Add comment
    10|10000 characters needed characters exceeded