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

[former_member594341]

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

[polaggari · Accepted solution]

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 😛