Importing Data Using Default Parsers

If you don't have financial institution records set up, use NetSuite’s default parser functionality to import data for matching and reconciliation.

Note:

NetSuite’s default parsers can't be customized. Unless you have no financial institution records set up, use the standard parsers in the Bank Statement Parsers SuiteApp. For details, see Bank Statement Parsers SuiteApp.

Important:

Use this procedure only to configure 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:

  1. Download your bank or credit card statement from your financial institution’s website in one of the accepted file formats. See Supported File Formats for Default Parsers.

    If you're importing a CSV file, make sure it matches the provided CSV template and constraints. See Preparing CSV Files for Import.

    Important:

    To ensure a successful file import, do not modify the downloaded statement file.

  2. Give the statement file a name. The file name can be up to 50 characters, including the extension.

  3. Go to Transactions > Bank > Upload File.

    NetSuite displays the Upload File page. The Manual Import subtab is open by default.

  4. Click Choose File, or use the drag-and-drop functionality.

    Important:

    The file name can be up to 50 characters, including the extension.

  5. Select the name of the file you want to import.

  6. Under Import Options, choose Import with default parser (CSV, OFX, QFX, BAI2, or CAMT.053).

    Note:

    NetSuite displays a link to download the CSV template when you choose this option. For details, see Preparing CSV Files for Import.

  7. In the Account field, select the bank or credit card account for this import.

  8. If required, in the Character Encoding field, select the character encoding for the file.

    If character encoding isn't required for the file format (CAMT.053.001.06–formatted XML, BAI2–formatted TXT, or CSV), the field doesn't appear.

    • (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, make sure your file contains valid UTF-8 characters. You may need to use a third party editor to convert your file to UTF-8 before importing into NetSuite. Some editors append a BOM (Byte Order Marker) to indicating that the file is UTF-8 encoded.

      Note:

      If you're using the BAI2 format with UTF-8 encoding, this option works with these 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's 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 select ed.

    • (Western) MacRoman – MacRoman encoding is the basis for most popular 8-bit character sets including Windows-1252 and the first block of characters in Unico de.

  9. If you're uploading a QIF file, select a date format from the Date Format field.

    Note:

    The QIF file format isn't supported. Use one of the new supported formats instead.

  10. Click Import.

    Note:

    You don’t have to wait on the page for the import to finish. You can perform other actions, such as starting a new import. The number of concurrent bulk imports depends on your NetSuite Service Tier. For details, see NetSuite Service Tiers.

    NetSuite displays a progress message. To check your import status, click Track your status.

    NetSuite displays the Banking Import History page. For more information, see Banking Import History.

When the import process is complete, perform matching and reconciliation. See Bank Data Matching and Reconciliation.

To generate customer payments from imported bank lines, apply payments to invoices, and match and submit them for reconciliation, see Generating Customer Payments.

Related Topics

General Notices