Setting Up Standard Bank Statement Parsers

To set up standard bank statement parsers for your account, follow these steps:

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

  2. Next, create a format profile record. Follow steps 1- 8 in 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:

    You can't delete format profiles linked to a bank statement parser, but you can set the format profile to inactive if you don't want to use it anymore.

  3. Map bank data from your financial institution to the right GL accounts in NetSuite. Follow step 2 in 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 matching 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, standard SWIFT codes are included. Do this step only if your bank uses custom transaction codes or you want to override the standard mapping.

    To see which transaction codes each file format supports, read Supported Transaction Codes for Bank Statement Parsers SuiteApp.

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

    The configuration values and settings under the Parser Configuration subtab depend on the parser you select. Here's how the values are populated based on your parser:

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

    • OFX/QFX – No configuration required.

    • CSV – Configuration values become available and can be changed after you select 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 oin Importing Data Using a Financial Institution Record.

    Important:

    When naming a file for import, keep the file name, including extension, under 50 characters.

General Notices