3646002 - Error When Uploading Bank Statement File Template in CSV Format

Attempt to upload a Bank Statement File Template in CSV format. However there are several errors upon uploading the Bank Statement as Inbound File. 

SAP Business ByDesign

1. Download the Bank Statement Import Template File.
2. Open it in Excel and fill in the Mandatory Fields as shown in the README tab.
3. Save the File as CSV File. 
4. Go to the Liquidity Management Work Center.
5. Navigate to the Inbound Files view.
6. Press New - Inbound File.
7. Choose Import Format as CSV.
8. Attach the Bank Statement File Template.
9. Press "Start File Upload".
10. Encounter Errors such as:

• No bank account active on YYMMDD for account number XYZ, national bank code ABC, and currency DEF found (where YYMMDD is the date, XYZ is the bank account number, ABC is the national bank code and DEF is the respective currency).
• Bank Account missing or cannot be determined.
• Bank Statement ID rejected.
• Character set UTF-8 not valid.
• Unsupported compression method or version.

1. The national Bank Code in the CSV file does not match the expected value in the system.
2. The file encoding is not correctly set to UTF-8.
3. In the Business Configuration Activity "Automatically Generated Bank Statements" an external Transaction Code for the import format "CSV in utf-8" is missing.
4. All mandatory fields in the Bank Statement Import Template need to be filled.

Refer to the README sheet in the SAP Bank Statement Import Template for the mandatory field mapping and ensure all required fields are correctly filled.

In the Business Configuration make sure that an external Transaction Code is maintained:

1. Go to the Business Configuration Work Center.
2. Navigate to the Overview view.
3. Search for the activity "Automatically Generated Bank Statements" and open it.
4. Click on Edit import formats for automatic generated Bank Statements.
5. Select the import format CSV in utf-8.
6. Press Add Row.
7. Maintain an External Transaction Code.
8. Click Save and Close.

Verify and update the national Bank Code in the CSV file and correct eventual calculation errors in the Closing Balance:

1. Open the CSV file and locate the national Bank Code field.
2. Replace the incorrect value ABC with the correct value DEF (where ABC is the incorrect national Bank Code and DEF is the correct one). 
3. Update the closing balance in the CSV file to reflect the correct amount based on the opening balance, debit, and credit amount.
4. Save the changes and re-upload the file.

Ensure the file encoding is correctly set to UTF-8:

1. Download and install the free tool Notepad++.
2. Open the CSV file in Notepad++.
3. Select the "Encoding" tab and click on "Convert to UTF-8".
4. Save the file and re-upload it to the system.

• Refer to: SAP Bank Statement Import Template Documentation.

bank statement upload, csv format, national bank code, closing balance calculation, No bank account active on for account number national bank code and currency found, Bank account missing or cannot be determined, Bank statement ID for bank account ID rejected, liquidity management, cash management, inbound file, Excel, SAP Bank Statement Import Template, transaction code mapping , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem