Preparing CSV Files for Import

Statement files in CSV format must adhere to the provided CSV template and constraints. The file needs to be UTF-8 encoded.

You can download the CSV template by going to Transactions > Bank > Banking Import History > Upload File, selecting Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053), and clicking Download the CSV template.

Or, you can create the file with the required columns and specifications.

If you're using Excel, ensure the file is UTF-8 encoded. Go to File > Save As, and then select CSV UTF-8 (Comma delimited) (*.csv) from the file format list.

Important:

The CSV file can only contain transactions that belong to a single account.

To ensure successful import, the column headings must be in the first row in the specified order as follows: Date (MM/DD/YYYY), Payor/Payee Name, Transaction ID, Transaction Type, Amount, Memo, NS Internal Customer ID, NS Customer Name, Invoice Number(s).

The following column data is required:

Note:

The Memo field is optional. The memo can't exceed 4000 characters or include any commas, semicolons or underscores.

Important:

If you exceed the character limit for any field, the import fails. If you use multibyte characters, the character limit may decrease.

If present, remove the following:

Related Topics

General Notices