You are using a non-English language as your preferred language in the NetSuite user interface, or your bank statement file contains special characters. Example, .

Using the Bank Statement Parsers SuiteApp, you imported a bank statement file using the CSV transaction parser. Then, a failed bank data import occurred. The failure reason shows the error message and a link to a generated CSV error file.

After downloading and opening the generated CSV file, you noticed that the special characters are not displaying correctly.

Microsoft Excel does not save CSV files in UTF-8. Even if the encoding set is UTF-8, Excel will always save the file as ANSI which then breaks the characters. To resolve this, you must edit the file in Excel to display the characters correctly.

To resolve this, perform the following steps:

1. Open a new Excel spreadsheet
2. Click theDatatab
3. ClickFrom Text/CSV
4. Select the CSV File with Errors file that you downloaded
5. ClickImport
6. On theFile Originfield of the new window, selectUnicode (UTF-8)
7. ClickLoad