The file could not be imported due to an incorrect number of CSV columns in the header, specifically 7. This error arose from missing fields that are expected by NetSuite. The upload file must include all the headers as specified in the template provided by NetSuite.
Solution:
- navigate to the Upload File page of bank data import
- Select ‘import with a default parser option
- Download the upload template
- Add all the headers as mentioned in the template even if there are no values to be mapped