Skip to Content
author's profile photo Former Member
Former Member

BRS

Hi

Bank reconcialtion statement automatic How Dear's ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 29, 2008 at 02:44 PM

    Hi,

    Bank reconcialtion statement automatic means by using Electronic Bank Statement.bank will send you electronic files,like a text file.in USA Banks widely use BAI or BAI2 format.

    Here are configuration steps and user steps.

    Global Settings for Electronic Bank Statement

    You should carry out Customizing for the electronic bank statement as follows: In Customizing for Bank Accounting, choose Business Transactions  Payment Transactions  Electronic Bank Statement  Make Global Settings for Electronic Bank Statement.

    Create Account Symbols:

    In this step, you create account symbols. You will need these symbols at a later stage to define the posting specifications. Before the posting rules are used, the individual account symbols are replaced by the account to which items are to be posted.

    Account Text

    AUSG-UEBERW-AUS Foreign out. transf.

    AUSG-UEBERW-INL Domestic out. transf

    BANK Bank account

    BANKEINZUG Bank collection

    BANKGEBUEHREN Bank cost

    BARAUSZAHLUNG Cash payment

    BAREINZAHLUNG Cash deposit

    GELDEINGANG Cash receipt

    SCHECKAUSGANG Outgoing cheques

    SCHECKEINGANG Incoming cheques

    SCHECKVERRECHNG Cheque clearing acct

    SONSTIGE Other bank trans.

    TREASURYAUSGANG Treasury outg. trans

    TREASURYEINGANG Treasury inc. trans.

    ZINSAUFWAND Interest paid

    ZINSERTRAG Interest received

    Assign Accounts to Account Symbol:

    In this step, you define how accounts are determined for a particular account symbol. To avoid you having to define a separate account symbol for each individual house bank account (each with a different G/L account and separate bank clearing accounts), the G/L Acct field can contain a masked output.

    Act Symbol Acct Mod. Currency G/L Acct

    AUSG-UEBERW-AUS + + +++++++++3

    AUSG-UEBERW-INL + + +++++++++2

    BANK + + ++++++++++

    GELDAUSGANG + + +++++++++2

    GELDEINGANG + + +++++++++9

    KASSE + + ++++++++++

    SCHECKAUSGANG + + +++++++++1

    SCHECKEINGANG + + +++++++++8

    SCHECKVERRECHNUNG + + ++++++++17

    SONSTIGE + + ++++++++19

    SPESEN + + 479000

    Create Keys for Posting Rules:

    In this step, you create the descriptions for the required posting rules. Each posting rule represents the business transaction on the bank statement in the SAP system, such as a cheque received, a credit memo, or debit memo.

    Posting Rule Text

    001+ Cash inflow via interim account

    002 + Cheque credit memo through bank

    003- Cashed Cheque

    004- Domestic transfer

    005- Foreign transfer

    006- Other disbursements

    007+ Other receipts

    008- Cash payment

    009+ Cash receipt

    010+ Collection/direct debit

    011- Returns collection/direct debit

    012- Bank fee

    013+ Interest received

    014- Interest paid

    015+ Payment by credit card

    016- Vendor direct debit

    017+ Treasury receipts

    018- Treasury disbursements

    Define Posting Rules/Posting Specifications:

    In this step, you create posting specifications for each posting rule. The posting specifications enable you to define how a particular business transaction (such as a credit memo) is to be posted.

    Posting specifications comprise one or two posting records Debit  Credit. The first posting record is called posting area 1 and usually involves a G/L account posting (BANK ACCOUNT  CASH RECEIPT, for example). The second posting record, which is optional, is called posting area 2 (CASH RECEIPT  CUSTOMER, for example).

    Depending on whether a posting transaction affects bank accounting only, or affects both bank accounting and subledger accounting, you define posting rules either for the first posting area only, or for both the first and second posting areas.

    Pstg Rule PosAr PKey Acct (Debit) PKey Acct (Credit) Doc. Type Pst Ty

    Cash inflow via interim account 001+ 1 40 BANK 50 GELDEINGANG SA 1

    001+ 2 40 GELDEINGANG DZ 8

    Cheque credit memo through bank 002+ 1 40 BANK 50 SCHECK-EINGANG SA 1

    Cashed Cheque 003- 1 SCHECK-AUSGANG 50 BANK SA 4

    Domestic transfer 004- 1 AUSG-UEBERW-INL 50 BANK SA 4

    Foreign transfer 005- 1 AUSG-UEBERW-AUS 50 BANK SA 4

    Other disbursements 006- 1 40 SONSTIGE 50 BANK SA 1

    Other receipts 007+ 1 40 BANK 50 SONSTIGE SA 1

    Cash payment 008- 1 BARAUS-ZAHLUNG 50 BANK SA 4

    Cash receipt 009+ 1 40 BANK BAREIN-ZAHLUNG SA 5

    Collection/

    direct debit 010+ 1 40 BANK BANK-

    EINZUG SA 5

    Returns collection/

    direct debit 011- 1 40 SONSTIGE 50 BANK SA 1

    Bank fee 012- 1 40 BANKGEBUEHREN 50 BANK SA 1

    Interest received 013+ 1 40 BANK 50 ZINSERTRAG SA 1

    Interest paid 014- 1 40 ZINSAUFWAND 50 BANK SA 1

    Vendor direct debit 016- 1 40 AUSG-UEBERWSG INL 50 BANK SA 1

    2 50 AUSG-UEBERWSG INL KZ 7

    Treasury receipts 017+ 1 40 BANK TREASURY-EINGANG SA 5

    Treasury disbursements 018- 1 TREASURY-AUSGANG 50 BANK SA 4

    Returns collections/direct debits are posted to the account for other interim postings, since they need to be postprocessed.

    Create Transaction Type:

    In this step, you create the names and descriptions for the various transaction types required. House banks that use identical lists of business transaction codes (external transactions) can later be assigned to the same transaction type.

    Trans. Type Name

    MC MultiCash

    Assign External Transaction Types to Posting Rules:

    In this step, you assign (external) business transaction codes to a posting rule (internal), which enables you to use the same posting specifications for different business transaction codes.

    Ext Trans +/- Post. Rule Int Algthm

    001 - 003- 012 Outgoing cheque: cheque number same as payment doc. no.

    002 - 003- 012 Outgoing cheque: cheque number same as payment doc. no.

    004 - 016- 021 Reference document number search

    005 - 016- 021 Reference document number search

    009 - 011- 000 No interpretation

    020 - 004- 019 Reference no. (DME management)

    051 + 001+ 021 Reference document number search

    070 + 002+ 000 No interpretation

    071 + 010+ 019 Reference no. (DME management)

    082 + 009+ 001 Standard algorithm

    083 - 008- 001 Standard algorithm

    201 - 005- 019 Reference no. (DME management)

    202 + 001+ 021 Reference document number search

    206 - 005- 019 Reference no. (DME management)

    401 + 017+ 019 Reference no. (DME management)

    401 - 018- 019 Reference no. (DME management)

    402 + 017+ 019 Reference no. (DME management)

    402 - 018- 019 Reference no. (DME management)

    411 - 018- 019 Reference no. (DME management)

    412 + 017+ 019 Reference no. (DME management)

    413 - 018- 019 Reference no. (DME management)

    414 + 017+ 019 Reference no. (DME management)

    415 - 018- 019 Reference no. (DME management)

    416 + 017+ 019 Reference no. (DME management)

    417 - 018- 019 Reference no. (DME management)

    418 + 017+ 019 Reference no. (DME management)

    808 - 012- 000 No interpretation

    814 + 013+ 000 No interpretation

    814 - 014- 000 No interpretation

    833 + 017+ 001 Standard algorithm

    833 - 018- 001 Standard algorithm

    UNALLOCATED + 007+ 000

    UNALLOCATED - 006- 000

    To enable the bank statement to find the item to be cleared in the vendor direct debit transaction, the bank details must be maintained in the vendor master record. The bank statement finds the vendor using the bank details and the item using the value (if unique).

    For algorithm 012, the number interval of the document numbers must be entered in the import report. For algorithm 026, the number interval of the reference document numbers must be entered (SD number assignment = XBLNR in the FI document). For further information on searching for the reference document number, refer to SAP Note 0107592.

    The UNALLOCATED transaction results in the bank statement being imported, even if the external transaction code has not been created in Customizing. The transaction is posted to the interim account +++++5 (bank subaccount, depending on bank). Take a look at this interim account after the bank statement has been imported and post the items to the correct accounts where necessary. To ensure that the transaction is contained in the system the next time the statement is imported, define the new external transaction code in Customizing and assign an appropriate posting rule.

    Assign Bank Accounts to Transaction Types:

    In this step, you assign each of your bank accounts to a transaction type.

    Bank key Bank Account Transaction

    400500 XXXXXXXX MC

    5.5.3 Manual Bank Statement

    Create and Assign Business Transactions

    In this step, you define an indicator and assign a posting rule for each business transaction.

    Tran +- Post. Rule Acct Mod Int Algthm Text

    001+ + 001+ + 21 Cash inflow via interim account

    002+ + 002+ + Cheque credit memo through bank

    003- - 003- + 12 Cashed Cheque

    004- - 004- + 19 Domestic transfer

    005- - 005- + 19 Foreign transfer

    006- - 006- + Other disbursements

    007+ + 007+ + Other receipts

    008- - 008- + 1 Cash payment

    009+ + 009+ + 1 Cash receipt

    010+ + 010+ + 19 Collection/direct debit

    011- - 011- + Returns collection/direct debit

    012- - 012- + Bank fee

    013+ + 013+ + Interest received

    014- - 014- + Interest paid

    016- - 016- + 21 Vendor direct debit

    017+ + 017+ + 19 Treasury receipts

    018- - 018- + 19 Treasury disbursements

    019+ + 017+ + 1 Cash concentration - incoming

    020- - 018- + 1 Cash concentration - outgoing

    Define Posting Keys and Posting Rules for Manual Bank Statement

    The posting keys and rules have already been set up for the electronic bank statement. The posting keys and rules for the manual bank statement are the same as those used for the electronic bank statement.

    5.5.4 Cheque Management

    Create and Assign Business Transactions

    In this step, you define transaction codes for cheque deposits and assign them to a posting rule. You have to specify these transaction codes in the Tran (Transaction) field on the initial screen for cheque deposits.

    Tran +- Post. Rule Acct Mod Text

    CD01 + CD01 + Direct cheque deposit

    CD02 + CD02 + Cheque deposit via interim account

    Define Posting Rules and Posting Keys for Cheque Deposit

    Two posting rules have been created: Direct cheque deposit and Cheque deposit via interim account. These rules represent two ways of posting cheques in the system. If you only want to post the bank accounting item in the first step and then clear the open customer items, use the Cheque deposit via interim account transaction. This is of particular importance when you have a lot of cheques and you have to ensure that all the cheques in Bank Accounting are posted by 10:30 a.m., for example. Otherwise, you use the Direct cheque deposit transaction in which the customers are cleared immediately provided that clearing information is available.

    Procedure

    Create Account Symbols:

    In this step, you create account symbols. You will need these symbols at a later stage to define the posting specifications. Before the posting rules are used, the individual account symbols are replaced by the account to which items are to be posted.

    Symbol Description

    SCHECKEINGANG Incoming cheques

    SCHECKVERRECHNG Cheque clearing acct

    BANK Bank account

    Assign Accounts to Account Symbol:

    In this step, you define how accounts are determined for a particular account symbol. To avoid you having to define a separate account symbol for each individual house bank account (each with a different G/L account and separate bank clearing accounts), the G/L Acct field can contain a masked output.

    Act Symbol Acct Mod. Currency G/L Acct Acct Symb. Desc. (set automatically)

    SCHECKEINGANG + + +++++++++8 Incoming cheques

    SCHECKVERRECHNG + + ++++++++13 Cheque clearing acct

    SCHECKVERRECHNG + CHF ++++++++60 Cheque clearing acct

    SCHECKVERRECHNG + USD ++++++++50 Cheque clearing acct

    BANK + + ++++++++++ Bank account

    Create Keys for Posting Rules:

    In this step, you define a posting rule for cheque deposits. The key determines the posting rules for general ledger and subledger accounting. The posting rule represents the typical business transactions involved in cheque deposits.

    Posting Rule Text

    CD01 Direct cheque deposit

    CD02 Cheque deposit via interim account

    Define Posting Rules:

    In this step, you define the posting rules for cheque deposits and prepare account determination. Depending on whether a posting transaction affects general ledger accounting only, or affects both general ledger and subledger accounting, you define posting rules either for one or two posting areas. You only need one posting area if you post items directly “Bank to incoming cheques” rather than using clearing accounts, for example.

    Pstg Rule PosAr PKey (D) Acct (Debit) PKey (C) Account (Credit) Doc. Type PstTy

    CD01 2 40 SCHECK

    EINGANG DZ 8

    CD02 1 40 SCHECK

    EINGANG 50 SCHECKVER-RECHNUNG SA 1

    CD02 2 40 SCHECKVER-RECHNUNG DZ 8

    User transations..

    Bank Reconciliation Process:

    1) Input the electronic statement from the bank -- FF_5

    2) Acct statement - posting and clearing -- FEBP

    4) Post process manually for any missing items -- FEBA

    If this helps,please assign points.

    Thanks,

    Rau

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 02:59 PM

    Hi Dear,

    Sorry to bother u !

    My company retail, having 10 banks with different clearing acounts.

    Bank statement received in excel format.How can we upload ?

    Now we are configured for manual bank statement ,but they need automatic clearing with using of feba.reference is check no.Pls.tell how?

    Present we don't need any Electronic bank statement,because bankers send in excel format only

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.