SAP Knowledge Base Article - Public

2985113 - Import and Export Bank Accounts: Invalid File


When using the App Manage Bank Accounts selecting the option Import and Export Bank Accounts and uploading the XML file, the system returns an error that says that the file is not valid: Invalid file.

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."




Reproducing the Issue

  1. Acces the App Manage Bank Accounts. 
  2. Click in Import and Export Bank Accounts.
  3. Click in Download XML Spreadsheet Template.
  4. In the Tab Import Bank Accounts.
  5. Click in Import.
  6. Select the file downloaded .
  7. Click in Open.
  8. Error is shown as: Invalid file.


The file conversion for uploading was not correctly done, hence when uploading the file the system displays error Invalid file.


Following are the resolution steps.

  1. You need to Open the Microsoft excel, go to File->Options, add Customize the  Ribbon->Developer, press “OK” button. To add customize ribbon.
    MS Excel_DeveloperOption.png

    The Developer tab will show up.

  2. Log on to the Fiori Launchpad.
    Choose Manage Bank Accounts.
    Choose “Import and Export Bank Accounts”

  3. Download the template file using "Download XML Spreadsheet Template".
  4. Open the exported template file using Microsoft Excel.
  5. Edit bank account and House Bank Account data with reference to the template file.
    You don't need to provide a real ACC_ID but the ACC_ID in all sheets for same bank account must be same.
  6. Export bank account data from the template file into an XML file.
  7. Click the export button in the developer tab to export the bank account data to xml.
  8. Press ‘Select File’ button to specify the file to upload.  Choose the xml file exported. We suggest you should use “Import with Test Run” first to check whether there are issues.
  9. Then choose “Import “to upload the bank account.


See Also

 Further information about the file upload can be found in Import And Export Bank Accounts.


Manage Bank Accounts, Bank Accounts, File, XML, Import, Export, Import and Export Bank Accounts, Invalid, Invalid File, Bank, Accounts, Cloud, S/4HANA Cloud, F1366A, Upload, Upload file, S4_PC, FIN-FSCM-CLM-BAM. , KBA , FIN-FSCM-CLM-BAM-2CL , Bank Account Management (Public Cloud) , FIN-FSCM-CLM-BAM , Bank Account Management , Problem


SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions


Import or export Bank Accounts..docx