Preparing CSV Parser Bank Statement Files for Import
To ensure a successful CSV bank statement file import, your file must adhere to the correct specifications and must be UTF-8 encoded.
Convert your CSV file to UTF-8 using any of the following:
-
If you are using Excel, convert the file by clicking Save As and then select CSV UTF-8 from the list.
-
If you are using Notepad, convert the file by clicking File > Save As and then select UTF-8 from the Encoding dropdown before clicking Save on the Save As popup window.
The SuiteApp provides a CSV template that you can download from the NetSuite File Cabinet or the Parser Configuration subtab of the Format Profile page. Alternatively, you can also create your CSV file with the required columns and specifications.
The CSV file can contain transactions that belong to a single or multiple account.
Take note of the following information when preparing your CSV column data:
Column Data |
Important Things to Note |
---|---|
Account Number |
There is a limit of 80 characters.
Important:
For compliance reasons, you cannot enter a credit card number. To ensure that the unique account ID does not contain a credit card number, NetSuite removes all non-numeric characters.
|
Date |
|
Amount |
|
Credit Amount |
Include this column data if the transaction amount displays as an absolute value and you have a separate column for debit and credit amount entry. Amount entry can also be a signed positive number. Example, +100. |
Debit Amount |
Include this column data if the transaction amount displays as an absolute value and you have a separate column for debit and credit amount entry. Amount entry can also be a signed negative value. Example, -100. |
Amount Indicator |
Include this column data if the transaction amount displays as an absolute value. |
Transaction Number |
Unique transaction or reference number. This can also be populated with the check number. |
Amount Currency |
|
Memo |
There is a limit of 4,000 characters. If the value in your Memo column exceeds the character limit, import will still be successful. However, the parsed data is truncated at 4,000 characters. |
Financial Institution ID |
Unique identifying number assigned to a financial institution transaction. |
Customer Name |
Refers to the NetSuite customer name. |
Customer ID |
Refers to the NetSuite internal customer ID. |
Invoice Numbers |
If a transaction line contains more than one invoice number, separate each invoice number using a comma. |
Account Closing Balance |
The system recognizes the last transaction line for each unique bank and credit card account. |
Closing Balance Date |
The system recognizes the last transaction line for each unique bank and credit card account. |
Remove the following:
-
Empty columns (containing no data) between other filled columns
-
Empty rows (containing no data) between other filled rows
-
Any columns not specified by the template or CSV Parser Configuration mapping fields
Any account summary located before the column title headers are automatically ignored by the system during import.