Bank Reconciliation in SAP S/4 HANA

Manual Bank Reconciliation in SAP

Manual bank statement reconciliation involves selecting bank statement lines and system transactions to be reconciled together. During reconciliation if a system transaction hasn't been cleared the reconciliation process clears the transaction first, and then reconciles it.

1:-House Banks (Fi12)

Click on position and Enter Your company Code

Select Your company code and Click on House Banks 

Select house bank and click on bank account.

Bank Account details

2:-Create GLs 

·         Main bank Account

·         Incoming Account

·         Outgoing

Account Control data tab, Account management right tick Open Item management.

Field status group G001 General and save

3:- Create and Assign Business Transaction (OT52)  

In this step you store an indicator for each business transaction and allocate a posting rule to each business transaction. Several business transactions usually refer to the same posting rule.

Example:- To differentiate business transaction, you assign to the “Credit memo, domestic” transaction an indicator different from the one for “credit memo, foreign” or” credit memo, rent”. Since posting is the same for these transactions, you can allocate all three to one posting rule (credit memo).

4:- Define posting keys and posting rules for manual bank statement

Path:-Simg, Financial Accounting, Bank Accounting, Business Transactions, Payment Transactions, Manual Bank Statement, Define Posting Keys and Posting Rules for Manual Bank Statement.

Enter your Chart Of Account 

Create Account Symbols

Click on New Entries

Assign Accounts to Account Symbol

 Click on New Entries 

Create Keys for Posting Rules

Click on New Entries

Define Posting Rules

Click on New Entries

• BMW1, Posting key 40, Account DR(bmw4) :-main bank account, Account CR (BMW1) Incoming Receipts

• BMW2, Account DR bmw2 Outgoing Receipts, Posting key 50, Account CR bmw4 main bank account.
  

5:-Define variants for manual bank statement (OT43) 

In this step you can create separate account assignment variants for the manual bank statement in order to adapt the arrangement and/or the selection of account assignment fields to your company specific requirement.

One variant is delivered as a default. It connote be modified.

If you do not want to work with the standard variant, you can deactivate. New variants must be activated after you create them.

Activities

1.      To create a new variant, choose variant > New variant > Create…

2.      In the pop-up window enter the variant ID, description and the number of account assignment lines.

6:-Posted document  Display Document (FB03) 

Enter document number (incoming)

Enter

 Outgoing  

Enter

7:-Manual Bank statement (FF67)

Click on Settings enter specification and select your variant.

Add bank details and add closing bank balance and Click on post statement

  Statement/list save

 Mis match balance