When the NetSuite dev team adds modules/functional...
# accounting
g
When the NetSuite dev team adds modules/functionality they are often fragile/finicky. Seems to be the case for sure with Online Banking Data Import. The new release coming soon is supposed to offer improvements, we'll see. ~ In your Google sheet, somehow the comma is still present in that one memo field. ~ When you download that sheet as CSV, the Google Sheet notices that the memo has a comma in it and so wraps the entire memo in double quotes so that the comma is not treated as a column delimiter. ~ This is an accepted standard practice for the CSV file format. And notice when you open the CSV back again in Sheets or Excel then the columns work fine and the memo still has a comma in it. ~ However it appears that the NS Online Banking Data import does not support values being wrapped in quotes. ~ See the screenshot of the text editor view of your CSV. ~ I tried to upload the CSV after just removing the comma (step 1) and it failed ~ When I also removed the double quotes (step 2) and tried again, the upload succeeded.