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)."

SAP S/4HANA Cloud Public Edition

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 may occur due to the following two reasons:

1. The "Decimal Format" setting maintained in the "Maintain Business Users" app is different from the decimal format in Excel.
2. The format of the amount in the imported Excel file is incorrect.

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 "Regional Settings" section of "Maintain Business Users" app.
   Or change the user decimal setting by clicking the profile in the top right corner, then selecting 'Settings', and checking under 'Language and Region' tab.
   Or change the decimal format in the Excel file.
2. Re-download a standard Excel template in "Manage Bank Statements" app and re-enter the data.

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