Table of Contents
Electronic Bank statement Process Flow Chart ................................................................................................. 3
Electronic bank statement overview: .................................................................................................................. 3
Configuring the Electronic Bank Statement ........................................................................................................ 4
Create House Bank ......................................................................................................................................... 4
Electronic Bank Statement .............................................................................................................................. 5
Make Global Settings for Electronic Bank Statement ................................................................................................... 5
1. Create account symbols ........................................................................................................................................ 6
2. Assign accounts to account symbols ..................................................................................................................... 7
4. Create keys for posting rules ................................................................................................................................. 7
5. Define posting rules ............................................................................................................................................. 10
6. Create transaction types ...................................................................................................................................... 12
7. Assign external transaction codes to posting rules .............................................................................................. 12
8. Assign bank accounts to transaction types .......................................................................................................... 13
Import Electronic Bank Statement ................................................................................................................ 14
Details of description (MT942 Format) .......................................................................................................... 14
Uploading Bank Statement into SAP ............................................................................................................ 15
To view cleared documents .......................................................................................................................... 17
Checking of bank Statement (Transaction Code: - FF67) ............................................................................ 18
Double click on required statement to view the transaction details .............................................................. 19
Electronic Bank statement Process Flow Chart
Electronic bank statement overview:
1. It is an electronic document sent by the bank which gives details of the transactions done by the account holder.
2. The electronic document can be remitted by the bank in the following formats SWIFT, Multicash, BAI etc.
3. This statement is used in SAP to do an automatic reconciliation.
4. The statement is uploaded in SAP and it clears the various Bank clearing accounts such as the Check out, Check in account to the main bank account.
In our scenario we have the following bank GL codes (Sub accounts) for our Bank:-
330 SBT Bank – Main account a/c
332 SBT Check Issued Out
331 SBT Check Received
Checks issued out to vendors will be credited to GL code 332 SBT Check Issued Out which is a clearing account.
Similarly Checks Received from customer is debited to GL code 331 SBT Check Received which is a clearing account.
When the bank statement is uploaded in SAP the following will happen:-
For checks issued out – based on checks cleared in the bank account the following entry will be passed automatically.
GL code account description Debit /Credit
332 SBT Check Issued out Debit
330 SBT Bank – Main account a/c Credit
For Checks Received in – based on checks cleared in the bank account the following entry will be passed automatically.
GL code account description Debit /Credit
331 SBT Check Received Credit
330 SBT Bank – Main account a/c Debit
Thus after uploading the bank statement in the system, the Main bank account i.e. GL code 330 SBT Bank – Main account a/c will exactly match with the balance shown in the bank. All the clearing accounts having balances will be the reconciliation items.
Manual bank statement – In case the bank is not able to give an electronic statement then the statement can be manually entered in the manual bank statement and uploaded.
Configuring the Electronic Bank Statement
Create House Bank
Transaction Code FI12
In the SAP system, you use the bank ID and the account ID to specify bank details. These specifications are used, for example, for automatic payment transactions to determine the bank details for payment.
Define your house banks and the corresponding accounts in the system under a bank ID or an account ID.
Electronic Bank Statement
In the following activities you make all the settings necessary for electronic bank statements.
Make Global Settings for Electronic Bank Statement
IMG > FINANCIAL ACCOUNTING > BANK ACCOUNTING > BUSINESS TRANSACTION > PAYMENT TRANSACTION > ELECTRONIC BANK STATEMENT
In this activity you make the global settings for the account statement. There are four main steps to be carried out:
1. Create account symbol
Specify G/L accounts (such as bank, cash receipt, outgoing checks) to which postings are to be made from account statement.You assign account symbols to the G/L account numbers. These are required for the posting rules in step 2.
2. Assign accounts to account symbols
Define postings to be triggered by possible transactions in the account statement (such as bank transfer, debit memo).
In the posting specifications debit -> credit that you define here, use the account symbols from step 1, not the G/L account numbers. This prevents similar posting rules being defined several times, the only difference between them being the accounts to which postings are made.
3 Create keys for posting rules
Assign posting rules to possible transactions in account statement file. A list of assignments where one external transaction code is assigned to one posting rule is called a transaction type.
4 Create a transaction type
Assign bank details, for which the account statements are to be imported, to a transaction type. All the house bank accounts at a particular bank are usually assigned to the same transaction type.
1. Create account symbols
In this activity you create the account symbols that you later need for defining the posting specifications.
Before the posting rule is used, the account symbols are replaced with the relevant accounts to which posting is to be made.
Define an ID for each account symbol & enter a description in the text field.
Create the account symbols BANK and CASH RECEIPT so that you can later define a posting rule for cash receipt.
2. Assign accounts to account symbols
In this activity you define the account determination procedure for each individual account symbol.
Define postings to be triggered by possible transactions in the account statement (such as bank transfer, debit memo). In the posting specifications debit -> credit that you define here, use the account symbols from step 1, not the G/L account numbers. This prevents similar posting rules being defined several times, the only difference between them being the accounts to which postings are made.
3. Define G/L Accounts to Account Symbols
Electronic Bank statement Process Flow Chart ................................................................................................. 3
Electronic bank statement overview: .................................................................................................................. 3
Configuring the Electronic Bank Statement ........................................................................................................ 4
Create House Bank ......................................................................................................................................... 4
Electronic Bank Statement .............................................................................................................................. 5
Make Global Settings for Electronic Bank Statement ................................................................................................... 5
1. Create account symbols ........................................................................................................................................ 6
2. Assign accounts to account symbols ..................................................................................................................... 7
4. Create keys for posting rules ................................................................................................................................. 7
5. Define posting rules ............................................................................................................................................. 10
6. Create transaction types ...................................................................................................................................... 12
7. Assign external transaction codes to posting rules .............................................................................................. 12
8. Assign bank accounts to transaction types .......................................................................................................... 13
Import Electronic Bank Statement ................................................................................................................ 14
Details of description (MT942 Format) .......................................................................................................... 14
Uploading Bank Statement into SAP ............................................................................................................ 15
To view cleared documents .......................................................................................................................... 17
Checking of bank Statement (Transaction Code: - FF67) ............................................................................ 18
Double click on required statement to view the transaction details .............................................................. 19
Electronic Bank statement Process Flow Chart
Electronic bank statement overview:
1. It is an electronic document sent by the bank which gives details of the transactions done by the account holder.
2. The electronic document can be remitted by the bank in the following formats SWIFT, Multicash, BAI etc.
3. This statement is used in SAP to do an automatic reconciliation.
4. The statement is uploaded in SAP and it clears the various Bank clearing accounts such as the Check out, Check in account to the main bank account.
In our scenario we have the following bank GL codes (Sub accounts) for our Bank:-
330 SBT Bank – Main account a/c
332 SBT Check Issued Out
331 SBT Check Received
Checks issued out to vendors will be credited to GL code 332 SBT Check Issued Out which is a clearing account.
Similarly Checks Received from customer is debited to GL code 331 SBT Check Received which is a clearing account.
When the bank statement is uploaded in SAP the following will happen:-
For checks issued out – based on checks cleared in the bank account the following entry will be passed automatically.
GL code account description Debit /Credit
332 SBT Check Issued out Debit
330 SBT Bank – Main account a/c Credit
For Checks Received in – based on checks cleared in the bank account the following entry will be passed automatically.
GL code account description Debit /Credit
331 SBT Check Received Credit
330 SBT Bank – Main account a/c Debit
Thus after uploading the bank statement in the system, the Main bank account i.e. GL code 330 SBT Bank – Main account a/c will exactly match with the balance shown in the bank. All the clearing accounts having balances will be the reconciliation items.
Manual bank statement – In case the bank is not able to give an electronic statement then the statement can be manually entered in the manual bank statement and uploaded.
Configuring the Electronic Bank Statement
Create House Bank
Transaction Code FI12
In the SAP system, you use the bank ID and the account ID to specify bank details. These specifications are used, for example, for automatic payment transactions to determine the bank details for payment.
Define your house banks and the corresponding accounts in the system under a bank ID or an account ID.
Electronic Bank Statement
In the following activities you make all the settings necessary for electronic bank statements.
Make Global Settings for Electronic Bank Statement
IMG > FINANCIAL ACCOUNTING > BANK ACCOUNTING > BUSINESS TRANSACTION > PAYMENT TRANSACTION > ELECTRONIC BANK STATEMENT
In this activity you make the global settings for the account statement. There are four main steps to be carried out:
1. Create account symbol
Specify G/L accounts (such as bank, cash receipt, outgoing checks) to which postings are to be made from account statement.You assign account symbols to the G/L account numbers. These are required for the posting rules in step 2.
2. Assign accounts to account symbols
Define postings to be triggered by possible transactions in the account statement (such as bank transfer, debit memo).
In the posting specifications debit -> credit that you define here, use the account symbols from step 1, not the G/L account numbers. This prevents similar posting rules being defined several times, the only difference between them being the accounts to which postings are made.
3 Create keys for posting rules
Assign posting rules to possible transactions in account statement file. A list of assignments where one external transaction code is assigned to one posting rule is called a transaction type.
4 Create a transaction type
Assign bank details, for which the account statements are to be imported, to a transaction type. All the house bank accounts at a particular bank are usually assigned to the same transaction type.
In this activity you create the account symbols that you later need for defining the posting specifications.
Before the posting rule is used, the account symbols are replaced with the relevant accounts to which posting is to be made.
Define an ID for each account symbol & enter a description in the text field.
Create the account symbols BANK and CASH RECEIPT so that you can later define a posting rule for cash receipt.
In this activity you define the account determination procedure for each individual account symbol.
Define postings to be triggered by possible transactions in the account statement (such as bank transfer, debit memo). In the posting specifications debit -> credit that you define here, use the account symbols from step 1, not the G/L account numbers. This prevents similar posting rules being defined several times, the only difference between them being the accounts to which postings are made.
3. Define G/L Accounts to Account Symbols
