Statement Import with MBC
The section describes how to handle the bank statement in SAP S/4HANA Cloud applications. There are three means to import Bank Statements to SAP S/4HANA Cloud:
- Import electronic bank statement file using SAP Multi-Bank Connectivity (MBC).
- If the system is connected to SAP Multi-Bank Connectivity (MBC), the electronic bank statement file provided by bank is stored in an SFTP folder, MBC retrieves the electronic bank statement file from SFTP, and then does validation and mapping. This process integrates with the scope item Bank Integration with SAP Multi-Bank Connectivity (16R).
- For banks with a Multi-Bank Connectivity (MBC) connection, bank statements are handled by MBC. MBC maps from the local bank statement format to an ISO CAMT.053 format, and SAP S/4HANA Cloud pulls the ISO CAMT.053 bank statement from MBC and imports it automatically. The SAP S/4HANA Cloud software schedules a background job every 10 minutes to retrieve the bank statement file from MBC, and the file is automatically imported into the SAP S/4HANA Cloud system.
After the CAMT.053 bank statement is pulled from Multi-Bank Connectivity (MBC), the postings in bank accounting and subledger accounting are be performed. Since MBC maps the local bank statement formats to a CAMT.053 format, there is only one set of posting rules for the electronic bank statement.
When importing bank statements to SAP S/4HANA Cloud, several programs are used to read out statement information, to interpret this information, and finally come to a conclusion on how to post the interpreted data.
Fundamentally, the steps are similar for the bank statement import via SAP Multi-Bank Connectivity and the electronic bank statement version. Depending on the import method of the manual process there could be a difference in the interpretation and posting logic.
At this point in time, the electronic bank statement reaches SAP S/4HANA Cloud, the note to payee information is analyzed. Here the customer would normally provide some kind of reference information about the invoice, customer number, and so on. In the system configuration, the interpretation algorithm is defined. Based on that, the system uses no algorithm a standard algorithm or, for example, the document number to assign the note to payee information to internal business partner related transactions.
If the system is able to find a match - for example, based on the document number provided in the bank statement - it performs the subledger accounting posting and thereby clears the open item of the business partner. If there is no match possible the reprocessing of items is needed.
You can use the app Manage Bank Statements to manage manual and electronic bank statements. The app provides an overview of all bank statements for all house bank accounts. You can also view detailed information for each bank statement.
Set the filter value to electronic bank statement items to see all the automatically imported statement items. Search for bank statements using search criteria, such as house bank account, bank statement date, bank statement status, and bank statement number. From the app, you also see the details of a bank statement such as line items, dates and processing status.
From the app Manage Bank Statements, it is also feasible to delete a bank statement. However, only bank statements in status Received, Saved, or Aborted can be deleted. An already completed item can not be deleted from the system anymore. In such a case, you need to reverse the transaction.
By contrast, a Saved item is not yet posted to the database. Since there is no document flow associated this statement, it can be deleted.
You can reverse imported, or manually created, bank statements in SAP S/4HANA Cloud applications. In order to do this, go to the app Manage Bank Statements. Pick the item to be reversed to see the details of the transaction.
After clicking the Reverse button you are prompted for the reversal reason and the posting date. After the confirmation, you can see from the reversal log which bankledger and subledger items are reversed, meaning the clearing of the open item is taken back and the posting on the bank account as well. After that you might want to check the statement content and re-import the statement or clear the items manually.