Importing Data Using Default Parsers
If you do not have financial institution records set up, import data for matching and reconciliation with NetSuite’s default parser functionality.
NetSuite’s default parsers are not customizable. Therefore, unless you have no financial institution records configured, you should use the standard parsers available through the Bank Statement Parsers SuiteApp. For details, see Bank Statement Parsers SuiteApp.
The following procedure is only applicable if you are configuring a manual import for bank or credit card reconciliation. To configure a manual import for expense reporting, see Importing Data Using a Financial Institution Record.
To import a statement using default parsers:
-
Go to your financial institution website and download your bank or credit card statement in one of the accepted file formats. See Supported File Formats for Default Parsers.
If you are importing a CSV file, the file must adhere to the provided CSV template and constraints. See Preparing CSV Files for Import.
Important:To ensure successful file import, do not modify the downloaded statement file.
-
Give the statement file a name. The limit for the file name length is 50 characters, which includes the extension.
-
Go to Transactions > Bank > Upload File.
NetSuite displays the Upload File page. The Manual Import subtab is open by default.
-
Click Choose File, or use the drag-and-drop functionality.
Important:The limit for the file name length is 50 characters, which includes the extension.
-
Select the name of the file you want to import.
-
Under Import Options, choose Import with default parser (CSV, OFX, QFX, BAI2, or CAMT.053).
Note:When you choose this option, NetSuite displays the link to download the CSV template. For details, see Preparing CSV Files for Import.
-
In the Account field, select the bank or credit card account for this import.
-
If required, in the Character Encoding field, select the method of character encoding associated with the file.
If character encoding is not required for the file format (CAMT.053.001.06–formatted XML, BAI2–formatted TXT, or CSV), NetSuite does not display this field.
-
(Unicode) UTF-8 encoding – UTF-8 character encoding is a variable-width encoding that can represent every character in the Unicode character set and has become the dominant character encoding.
If you intend to use this format, ensure your file contains valid UTF-8 characters. You may have to use a third party editor to convert your file to UTF-8 prior to the import into NetSuite. Some editors append the BOM (Byte Order Marker) to the beginning of the file indicating that it is UTF-8 encoded.
Note:If you are using the BAI2 format with UTF-8 encoding, you can use the following banks: TD, Wells Fargo, US Bank, JP Morgan Chase, and Bank of America Merrill Lynch.
-
Western (Windows 1252) encoding – Windows 1252 encoding is a character encoding of the Latin alphabet, used by default in the legacy components of Windows in English and some other Western languages.
-
Western (ISO-8859-1) encoding – ISO-8859-1 encodes what is commonly referred to as “Latin alphabet no. 1,” consisting of 191 characters from the Latin script. This character encoding is used throughout the Americas, Western Europe, Oceania, and much of Africa. It is also commonly used in most standard romanizations of East Asian languages.
-
Chinese Simplified (GB18030) – GB18030 is the registered Internet name for the official character set of the People's Republic of China (PRC), superseding GB2312. This character set is formally called “Chinese National Standard GB 18030-2005: Information technology -- Chinese coded character set.” GB abbreviates Guójiā Biāozhun, which means national standard in Chinese. (This description is cited from Wikipedia.) This option is the default when the Chinese language preference has been selected.
-
Japanese (Shift-JIS) encoding – Shift-JIS character encoding is the most widely used format for supporting the Japanese language. This option is the default for the Japanese edition and when the Japanese language preference has been selected.
-
(Western) MacRoman – MacRoman encoding is the basis for most popular 8-bit character sets including Windows-1252 and the first block of characters in Unicode.
-
-
If you are uploading a QIF file, select a date from the Date Format field.
Note:The QIF file format is no longer supported. Switch to one of the new supported formats.
-
Click Import.
Note:You do not have to wait on the page until the import is done. You can perform other actions such as a new import. The number of bulk imports you can perform at the same time is determined by your NetSuite Service Tier. For details, see NetSuite Service Tiers.
NetSuite displays a progress message. To view the processing status of your import, click Track your status.
NetSuite displays the Banking Import History page. For more information, see Banking Import History.
When the import process completes, you can perform matching and reconciliation. See Bank Data Matching and Reconciliation.
To automatically generate customer payments from imported bank lines, apply the payments to invoices, and match and submit the payments for reconciliation, see Generating Customer Payments.