Business Need
Solution Overview
To eliminate the effort associated with manually creating bank statements, our team developed a custom RAP (RESTful Application Programming) application in SAP S/4HANA Cloud as a cost-effective alternative to a Host-to-Host (H2H) integration, supporting the customer's custom bank statement formats while avoiding the additional API development and integration costs associated with H2H.
The solution provides a simple and flexible upload mechanism that enables finance users to upload an entire month's bank statement transactions using predefined Excel or CSV templates. Uploaded data is automatically validated and processed based on predefined business rules before the corresponding bank statements are created in SAP S/4HANA Public Cloud using standard SAP APIs.
By automating the entire process, the solution significantly reduces manual effort, improves processing accuracy, and accelerates month-end bank reconciliation activities.
Excel / CSV Upload
As the first step in the process, the client uploads the bank statement data through the custom application, which provides a user-friendly interface for importing files using a predefined Excel or CSV template.
To support the different formats used across banks and business units, the solution accommodates four file formats—two CSV formats and two Excel templates—each with its own structure and layout. During upload, the user selects the applicable file format, enabling the application to correctly interpret and process the file.
Statement Grouping and Processing
Once the file is uploaded, the application automatically validates the data, groups transaction line items using predefined business rules based on attributes such as bank account, currency, and statement date, and creates the corresponding bank statements in SAP S/4HANA Public Cloud through standard SAP APIs, significantly reducing manual effort while improving processing efficiency.
During processing, the application simultaneously records the status and results in a log table. If an issue occurs for a particular bank account—such as an invalid account reference, missing mapping, or an API error—processing is halted only for the statements associated with that bank account.
Error details are captured in the log table, allowing the finance team to quickly identify and resolve issues before reprocessing only the affected statements. This ensures that statements for other bank accounts continue to be processed without interruption, improving reliability and preventing a single error from delaying the entire upload process.
Bank Statement Creation through Developer Extensibility
After the statements are grouped, the RAP application invokes the standard Bank Statement – Post (BankStatementPost_In) API through SAP S/4HANA Cloud Developer Extensibility to create the bank statements. This standard SAP API is specifically designed for posting bank statements and performs the necessary validations before creating the statements in the system.
Because the bank statements are created using SAP standard APIs, they fully align with standard SAP financial processes and can be used seamlessly for reconciliation, clearing, posting, and reporting activities.
Mapping Management
To accurately create bank statements in SAP, the solution includes configurable mapping applications that translate bank-specific values from the uploaded files into the corresponding SAP values required during processing. Separate mappings are maintained for currencies and bank accounts, allowing the upload process to interpret different bank formats without requiring changes to the application.
Currency Mapping
The bank statement files received from different banks may contain currency references that differ from SAP standard currency codes. To address this, a custom RAP-based currency mapping application maintains the relationship between bank-specific currency references and SAP currency codes.
During processing, the upload application automatically converts the incoming currency reference to the corresponding SAP currency code before creating the bank statement.
Bank Account Mapping
Similarly, bank account references contained in uploaded files may not directly correspond to the SAP House Bank and Account ID required for processing. A dedicated RAP-based mapping application is therefore used to maintain these relationships.
During processing, the solution automatically identifies the correct House Bank and Account ID based on the uploaded bank account reference.
Separate maintenance applications are provided for both currency and bank account mappings, enabling the finance or configuration team to manage mappings independently without requiring development support.
Processing Log and Error Tracking
To provide complete visibility into every upload, the application records processing results in a centralized log table. The log captures both successful and failed bank statement creation attempts, enabling the finance team to monitor processing outcomes efficiently.
For successfully created bank statements, the log stores key details such as the statement reference number, bank account, statement date, amount, and unique bank statement ID. For failed records, the log captures the corresponding error message, helping users quickly identify and resolve issues before reprocessing.
This centralized logging mechanism provides clear traceability across the entire process, allowing the finance team to easily track what was created successfully, what failed, and the reason behind each failure.
Creation Node – View Created Bank Statements
The application includes a dedicated Creation Node that provides a consolidated view of all bank statements created from a specific uploaded Excel or CSV file.
Each upload generates its own Creation Node entry, allowing finance users to review and validate the bank statements associated with that upload. The view displays key information such as statement reference numbers, bank accounts, statement dates, and opening and closing balances, providing complete visibility into the results of each upload run.
Custom Report – Bank Statement Display
In addition to the Creation Node, a custom report has been developed to provide a structured view of all bank statements created across all uploaded files. The report serves as a reference and audit tool, enabling the finance team to review created bank statements based on selected criteria such as bank account or reporting period.
By consolidating statement information in a report format, the solution helps users verify that all expected bank statements have been created successfully and provides supporting information for month-end review and audit activities.
Key Benefits of the Solution
- Reduced manual effort by eliminating repetitive bank statement entry activities.
- Accelerated month-end processing by enabling bulk creation of bank statements through a single upload.
- Support for multiple bank file formats through flexible Excel and CSV template handling.
- Improved data accuracy through automated currency and bank account mapping.
- Enhanced visibility and traceability through centralized logging, status tracking, and reporting.
- Preservation of SAP standard processes through API-based bank statement creation.
- Simplified maintenance through business-managed mapping applications.
Flow Diagram
Conclusion
The custom RAP-based solution transformed a manual and time-intensive bank statement creation process into a streamlined and scalable operation within SAP S/4HANA Cloud.
By combining bulk file uploads, automated mappings, SAP standard API integration, and comprehensive monitoring capabilities, the solution enables finance teams to process large volumes of bank statement data efficiently while maintaining accuracy, traceability, and compliance with SAP standard processes.
The result is a flexible and sustainable approach that accelerates month-end reconciliation activities, improves operational control, and reduces the effort traditionally associated with bank statement processing.
