Preparing CSV Files for Import

Statement files in CSV format must adhere to the provided CSV template and constraints. The file must 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.

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

If you are 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 must not exceed 4000 characters and must not 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 become less.

If present, remove the following:

Related Topics

General Notices