Bank Statement CSV File Upload Failure Reason: Unexpected Error

Scenario

When importing CSV Bank Statement files using the default parsers, users receive an Unexpected Error. This might be due to the Memo column having commas, semicolons or underscores.

Solution

A Microsoft Excel CLEAN function can help to efficiently check and remove all the nonprintable characters from string in the Memo column. 

1. Open the Statement Files on CSV format.

2. On the file, since F2 is the first cell in the table that contains Memo, the formula should be =TRIM(CLEAN(F2))

3. Add this formula =TRIM(CLEAN(F2)) on an empty column.

4. Repeat the formula for the populated cells in Column F. Then copy the formula results and paste the special values to the populated cells in the column F.

5. Save the file and try to re-upload.