Jcurve Support Articles / Basic Accounting

Bank Statement CSV File Upload Failure Reason: Unexpected Error

Written by
John David Dy
Published on
March 11, 2023 at 4:00:32 AM PST March 11, 2023 at 4:00:32 AM PSTth, March 11, 2023 at 4:00:32 AM PST

Scenario

When importing CSV Bank Statement files using the default parsers, users receive an Unexpected Error. This might be due to theMemocolumn 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 to be imported 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. Savethe file and try to re-upload

#bank statement
#csv import
#unexpected error
#csv file
Jcurve Support Articles / Basic Accounting