Scenario
User encountered an error when uploading a bank statement using CSV file.
Solution
Ensure that there are no line breaks on any of the CSV file columns:
- Date (MM/DD/YYYY)
- Payer/Payee Name
- Transaction ID
- Transaction Type
- Amount
- Memo
- NS Internal Customer ID
- NS Customer Name
- Invoice Number(s)
PayeeCompany
Change the format to the following to resolve the error message:
Payee Company
After making the correction in the CSV file, re-upload the file:
- Navigate to Transactions > Bank > Banking Import History > Upload File
- Select the CSV file
- Select Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053)
- Click Download the CSV template if needed
- Account: Select the Account
- Click Import