Bank Reco - Manual & Automatic

[Former Member]

Hi

I would like to know the config and process for Bank Reconciliation both manual & automatic. Kindly give your inputs.

Regards

[Former Member]

Hii

Manual Bank Statement

With this function, you can manually enter bank account statements you receive.

Activities

Statement entry is usually a two-step process:

• First, you enter the account line items in the system. Various tools are available to help you with this. You can vary the row format for entering individual transactions.

In addition, the system supports individual account determination and checks data consistency.

• The second step is to post the line items you have entered.

The account assignment variant can be changed at any time during processing. You can also enter more than one value in an account assignment field. The system highlights account assignment fields for which you do this.

When you enter your data, payment advices created in Cash Management using memo record entry can be automatically transferred to the bank statement.

There are various selection criteria for doing this. For example, you can select all payment advices entered within a certain planning period or on a specific statement date.

When you process the data, you can delete from the entry screen any memo records that do not match the bank account statement.

If you entered the wrong beginning or ending balance, you can correct it in the entry screen.

Posting Specifications

In the manual bank statement function, you can create up to two postings for each line item.

• A bank account posting (for example, debit bank account and credit bank clearing account)

• A subledger posting (for example, debit bank clearing account and credit customer account with clearing)

Please check this link

http://help.sap.com/saphelp_47x200/helpdata/en/40/fe8e35f2f5ae32e10000009b38f839/frameset.htm

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.

Regards,

Aakash