Bank Reconciliation file

[Former Member]

Hi All,

Now i am working at the stage of reconciliation of bank statement (electronic).

bank already given BAI codes, where i have to configure this? is this create as posting rule or external transaction?

can anybody clarify where we configure? and also are we configure this in bank account and sub ledger account levels? or any one of this?

if you have any documents regarding this kindly send me.

Thanks and regards,

Raghav

[Former Member · Accepted solution]

i got strucked here, any help please..........

[Marssel700 · Accepted solution]

Hi,

I send it!

Regards

[Former Member · Accepted solution]

which mail id you send? bcoz some of the mails only i can check in office.

[Marssel700 · Accepted solution]

Raghav,

I sent "SDN - Bank Reconciliation file" because you ask for it in another trhead and is very usefull to solve this one.

Reward Points are the best way to thanks.

[Former Member]

Hi Raghav,

you create bank given transactions in transaction types and assign them to internal posting rules.

Soma

[Former Member]

hi

To set up Electronic Bank Statements (EBS)

1. Create House Bank and Account ID (FI12)

2. Setup EDI Partner Profile for FINSTA Message Type (WE20)

3. Configure Global Settings for EBS (IMG)

- Create Account Symbols

- Assign Accounts to Account Symbols

- Create Keys for Posting Rules

- Define Posting Rules

- Create Transaction Types

- Assign External Transaction Types to Posting Rules

- Assign Bank Accounts to Transaction Types

4. Define Search String for EBS(Optional)

- Search String Definition

- Search String Use

5. Define Program and Variant Selection

Additional information is also available in the SAP Library under:

Financial Accounting > Bank Accounting (FI-BL) > Electronic Bank Statement >

Electronic Account Statement Customizing.

Bank Reconcilliation Statement

The following are the steps for BRS:

Create Bank Master Data - This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account

2. Define House Bank

3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.

a. setup all co codes for payment transaction - Customer and vendors

b.setup paying co codes for payment transactions

c.setup payment method per country

d.setup payment method per co code for payment transaction

e.setup bank determination for payment transaction

Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/CheckManagement) and for void reasons FCHV. You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings/ManualBankStatement) . Don't forget to keep the opening Balance as zero. Use FBEA for post process.

All the steps together will lead to (FF67) Bank reconciliation statement.

nagesh