1. Accounting
  2. Banking
  3. Bank Statement Parsers SuiteApp
  4. Setting Up Standard Bank Statement Parsers

Setting Up Standard Bank Statement Parsers

To set up standard bank statement parsers for your account, perform the following tasks:

  1. Create a financial institution record. For details, see Creating Financial Institution Records.

  2. Next, create a format profile record. Follow steps 1-8 of Creating Format Profiles for Bank Reconciliation.

    In step 8, from the Transaction Parser list, select a parser plug-in provided by the Bank Statement Parsers SuiteApp.

    Note:

    Format profiles that are associated to a bank statement parser cannot be deleted. You can set the format profile to inactive if you no longer want to use it.

  3. Map bank data from your financial institution to corresponding GL accounts in NetSuite. Follow step 2 of Linking Accounts for Manual Import.

    For information about the mapping keys to use for bank statement parsers, see Identifying Unique Account IDs for Standard Bank Statement Parsers.

  4. (Optional) Map custom bank transaction codes to their corresponding bank data type or exclude standard transaction codes. For details, see Mapping Custom Bank Codes.

    Standard transaction codes are already mapped to the parsers. For MT940, for example, standard SWIFT codes are included in the parser. You must perform this step only if your bank is using custom transaction codes or if you want to override the standard transaction code mapping.

    To know which transaction codes are supported for each file format, read Supported Transaction Codes for Bank Statement Parsers SuiteApp.

  5. Configure standard bank transaction parsers. For details, see Configuring Standard Bank Transaction Parsers.

    The display of configuration values and settings under the Parser Configuration subtab depends on the transaction parser you selected. The following list describes how the Parser Configuration values are populated based on your parser selection.

    • BAI2, MT940, and CAMT.053 – During the initial setup, the configuration values appear only after the Format Profile record is saved. To change the default configuration values, you must click Save & Edit on the format profile.

    • OFX/QFX – No configuration required.

    • CSV – Configuration values becomes available and can be modified after selecting the parser.

  6. Save the Format Profile page.

  7. Go to Transactions > Bank > Banking Import History > Upload File page to import your data. Follow steps 3 – 9 of Importing Data Using a Financial Institution Record.

    Important:

    When naming a file for import, there is a limit of 50 characters for the file name length, including extension.

General Notices