Electronic – BRS (Bank Reconciliation) Configuration in SAP

Electronic – BRS (Bank Reconciliation) Configuration in SAP, using T code: OT83.

Understanding: “We make payments to vendors through our outgoing bank in SAP, which generates a DME (Data Medium Exchange) file. The bank then processes the payments to vendors and subsequently sends an Electronic Bank Statement (EBS) to reconcile the outgoing bank transactions with our main bank.”

Now with this blog you can understand, BRS configuration.

1. Create Account Symbols

SPRO Path -> Reference IMG -> Financial Accounting -> Bank Accounting -> Business Transactions -> Payment Transactions -> Electronic Bank Statement – Click on Execute.

Popup will come, give the Chart of Account and click on the continue button.

Account symbol is an unique identifier, which represents the single GL account or masking of multiple GL accounts.

Click on New Entries button.

Give Account Symbol name with description and press enter.

After that, click on the save button.

Customizing request popup will come, select your request and click on continue.

2. Assign Accounts to Account Symbol

Click on New Entries.

Now Assign the GL account to the Account symbols.

• Main Bank GL Account: 0001
• Outgoing Bank GL Account: 0005
• Incoming Bank GL Account: 0006
• Bank Charges GL Account: 4003

Or else you can assign the masking of GL accounts like below (By mentioning the GL Account number ends with a specific number) to Account symbol.

Click on Save button.

3. Create Keys for Posting Rules

Click on New Entries

Now just create the keys for Posting rules and also maintain description.

Click on Save button.

4. Define Posting Rules

Click on New Entries.

Posting rule for Outgoing payment (Ex: Check Issue)

Accounting entry:

• Outgoing bank  Acc    Dr
• Main Bank  Acc    Cr

So we need to clear the debit line item.

Posting rule for Incoming payment (Ex: Check Deposit).

Accounting entry:

• Main Bank  Acc    Dr
• Incoming Bank  Acc    Cr

So we need to clear the Credit line item

Posting rule for Bank Charges

Accounting entry:

• Bank Charges  Acc    Dr
• Main Bank  Acc    Cr

Click on Save Button.

This is posting rules maintained at glance.

5. Create Transaction Type

Click on New entries.

Just give a Transaction type name and description.

6. Assign External Transaction types to Posting rule

Select the Transaction type and double click on “Assign External Transaction types to Posting rule“.

Click on New entries.

Now under Transaction type, maintain the external transaction types and link with Posting rule plus Interpretation Algorithm.

External Transaction Type helps us to find the exact open item to clear.

• NCHG – Z003(Bank Charges, – sign)
• NMSC – Z005(Outgoing payment, – Sign)
• NMCT – Z006(Incoming payment, +sign)

7. Assign Bank Accounts to Transaction Types

Click on New entries.

Enter the details like below

And then click on save.

Other contents you may like in SAP:

• How to Define Bank Key in SAP: Click here
• Creation of House Bank in SAP: Click here
• Creation of Account ID/Bank Account in SAP: Click here
• Creation of Account ID/Bank Account in S4 HANA: Click here
• How to Create Main Bank GL Account in SAP: Click here
• How to Create Outgoing Bank GL Account in SAP: Click here
• How to Create Incoming Bank GL Account in SAP: Click here
• How to Create a Check Lot in SAP: Click here
• How to Issue Check (FCH5) in SAP: Click here

SAP FICO Configuration topics:

• SAP Finance Enterprise structure: Click here
• SAP Finance GL Accounting: Click here
• SAP Finance Accounts Payable: Click here
• SAP Finance Accounts Receivable: Click here
• SAP Finance Bank Accounting: Click here
• SAP Finance New Asset Accounting: Click here
• How to Create a Controlling area in SAP: Click here
• SAP Controlling – Cost Element Accounting: Click here
• SAP Controlling – Cost Center Accounting: Click here

Explained: Electronic – BRS (Bank Reconciliation) Configuration in SAP.