SAP - FI AR BK: Electronic Bank Reconciliation

The EBS is used to automatically assign incoming and outgoing payments to house bank accounts when they relate to items already posted in the system to customer/vendor/clearing accounts and, where appropriate, the clearing of them.
Each uploaded electronic bank statement will be assigned with a unique no. in SAP and can be printed retrospectively.

 

Steps in Electronic Bank Reconciliation:

1. Electronic Bank Statement file (in SWIFT MT940 format) is extracted from BANK
2. Data (SWIFT MT940 for BANK) is imported into a temporary dataset in SAP
3. Batch input sessions are generated (per bank statement: one session for G/L Accounting and one for Subledgers- AR/ AP).  Bank accounting and subledger accounting batch session can be executed separately or jointly
4. Posting rules and account determination are defined in TR-CM customization
5. As an electronic bank statement is being imported, the system identifies the transactions in it and determines how they are posted. 
6. The note-to-payee fields in the electronic bank statement contain various information relevant to open item clearing.  Note to payee fields can be interpreted by document number or reference document number for the clearing transaction (example: standard algorithm).  If the algorithms we deliver are not sufficient, it is possible to program a user exit tailored to your business (e.g. change the posting rule; influence account determination by means of account modification).
7. Post-processing for posting proposals(line items) which cannot be cleared

Note:
Electronic Bank Statement format SWIFT MT940 is compactable with SAP TR-CM.  Standard algorithm for clearing documents is available in the predefined form in SAP.  Customisation, as stated in point 6 above, will be needed to cope with AAA specific requirements on Bank Reconciliation.  The review task will be performed on the Detail Design Phase, detail of which will be incorporated into the respective customisation functional specifications.