Step-by-Step Procedure for Customizing an Electronic Bank Reconciliation Statement

To set up Electronic Bank Statements (EBS) 

Processing in SAP for most customers in North America. 

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.

SAP FI Tips by: Ramesh

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.

SAP FI Tips by: Rajiv Jain

SAP FI/CO Tips

Fast Links:
Steps to configure SPL
Configuration for Special Purpose Ledger

Get help for your SAP FI/CO problems
SAP FICO Forum - Do you have a SAP FI/CO Question?

SAP Books
SAP FICO Books  - Certification, Interview Questions and Configuration

SAP FICO Tips
SAP FI/CO Tips and Financial Accounting/Controlling Discussion Forum

Main Index
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.