SAP Knowledge Base Article - Public

2831944 - Error when importing the Excel file manually in "Manage Bank Statements" app


When importing the bank statements from an Excel file in "Manage Bank Statements" app, below error occurs:
"Could not import file: &&&.xlsx
Reason: Excel line &: Enter a valid Amount/Payment Amount (for example, 1.234.567,89)."



Reproducing the Issue

  1. Open "Manage Bank Statements" app.
  2. Click on "Create" button.
  3. Click on "Import" button.
  4. Select the Excel file to import manually, and the error occurs.


The error occurs due to the "Decimal Format" setting maintained in the "Maintain Business Users" app.
Select the CB user used, under "Regional Settings" section, the decimal format maintained should be same as the one in the Excel file.


  1. Change the "Decimal Format" setting maintained in the "Maintain Business Users" app.
  2. Or change the decimal format in the Excel file.


Manage Bank Statements, Create, Import, Maintain Business Users, Decimal Format, F1303, F1564, Amount/Payment Amount, Could not import file , KBA , FI-FIO-AR , Fiori UI for Accounts Receivable , FI-BL-PT-BA , bank statement , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem


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