How to Upload the Balance of Bank Accounts in the SAP ERP System into SAP S/4HANA Finance for Cash Management

  • by Chirag Chokshi, Solution Architect, SAP Financials
  • October 10, 2017
Learn the process, configuration, and file format required to upload the opening balance in SAP S/4HANA Finance for cash management for a bank account maintained in a remote ERP system.
Learning Objectives

Reading this article, you will learn:

  • Important master data fields for a bank account in an SAP S/4HANA system
  • How to create and assign business partners with bank accounts using the Manage Bank Accounts SAP Fiori app
  • Configuration of One Exposure to populate cash management tables in an SAP S/4HANA system with  opening balances as well as for future bank or cash transactions
  • The transaction and the file format for importing an opening balance of a bank account into an SAP S/4HANA system
Key Concept
SAP S/4HANA Finance for cash management benefits an organization by providing access to new business processes related to bank account management and cash operations, availability of web-based SAP Fiori apps, and enhanced reporting with a single source of data through the One Exposure central storage hub. When an organization deploys SAP S/4HANA Finance for cash management while using SAP ERP for order-to-cash or procure-to-pay processes, it necessitates the creation of house bank data in both systems as well as bidirectional data flow between the ERP systems. Synchronized house bank master data and the opening balance of house bank accounts are keys to successful deployment of SAP S/4HANA Finance for cash management. The first important step for such deployment is to import or upload the balance of bank accounts in the SAP ERP system into SAP S/4HANA Finance for cash management. This requires specific configuration, master data, and a balance upload transaction using an Excel file in a specified format.

SAP S/4HANA Finance for cash management has been revamped to include many new business processes as well as web-based SAP Fiori apps that run on SAP HANA. In addition, with the advent of SAP S/4HANA, SAP has simplified the data structure that contains financial accounting documents posted in the system and introduced the single source of truth concept. The single source of truth is also introduced into SAP S/4HANA Finance for cash management through One Exposure, which provides central storage of cash and liquidity management transactions. The cash management transactions are stored in several database tables with the earlier versions of SAP ERP, and hence, an earlier version of cash management (aka classic cash management) is made obsolete with SAP S/4HANA. To reap the benefits of SAP S/4HANA Finance for cash management, many organizations deploy SAP S/4HANA for cash management business processes while traditional order-to-cash and procure-to-pay business processes are performed in the existing SAP ERP system.

Figure 1 shows one of the possible deployment scenarios in which an SAP ERP system is used for traditional order-to-cash and procure-to-pay processes while an SAP S/4HANA system is deployed for SAP S/4HANA Finance for cash management processes. In such a deployment, there is a bidirectional data flow between two systems for the bank or cash-relevant transactions posted in respective systems. This feature keeps the bank balance for house bank accounts in sync among both the systems. Keeping balance in both systems in sync is essential to ensuring data integrity as well as for making correct decisions related to cash operations or liquidity management. Importing the opening balance of the house bank accounts from SAP ERP into an SAP S/4HANA system is a first step toward the successful deployment of SAP S/4HANA for cash management while retaining other business processes in legacy SAP ERP systems.

Figure 1
A deployment scenario for SAP S/4HANA Finance for cash management

I explain how to upload the opening balance into the SAP S/4HANA system for the house bank account located in other SAP ERP or non-SAP systems. The article is divided into the following sections:

  • Important fields of bank account master data
  • Create a business partner and assign it to a bank or bank account
  • Configuration of One Exposure from operations
  • The file format of the upload file
  • Execute the upload program in a test run

Chirag Chokshi

Chirag Chokshi is a solution architect for SAP Financials. He has worked on SAP Financials since 2001 and specializes in implementing the Financial Accounting (FI) and Controlling (CO) modules along with their integrated areas for companies in industries such as consumer products, the chemical process industry, pharmaceuticals, the public sector, industrial machinery, and component manufacturing. He has worked on various complex projects, including global rollouts, greenfield implementations, and SAP system upgrades. In addition, he has developed various preconfigured solutions with a focus on SAP Financials. 


See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.