1. Accounting
  2. Banking
  3. Financial Institution Records
  4. Modifying Format Profiles

Modifying Format Profiles

To modify or add format profiles, the Financial Institution page must be in View mode.

To modify format profiles:

  1. Go to Setup > Accounting > Financial Institution > List.

    The Financial Institutions page appears.

  2. Next to the financial institution record that contains the format profile you want to modify, click View.

    The Financial Institution page appears.

  3. In the Format Profile: Configuration subtab, click the appropriate format profile.

    The Format Profile page appears.

  4. Click Edit.

  5. You can modify the following primary information about a format profile record:

    • Profile Name

    • Description

    • Inactive box

      Note:

      If this format profile is provisioned by a SuiteApp that has since been uninstalled, NetSuite checks this box. To clear this box, you need to select a parser plug-in.

      Additionally, if a format profile that uses a connectivity plug-in is inactive, you can't perform a manual request to update bank or expense data from it.

    • Connectivity Method

      If this format profile is provisioned by a SuiteApp that has been uninstalled, this field says Manual Import. If this format profile has a Bank Reconciliation profile type, you can set up automatic imports. For details, see Configuring a Connection to a Financial Institution (Without a SuiteApp).

    • Transaction Parser

      Note:

      If this format profile is provisioned by a SuiteApp that has been uninstalled, NetSuite clears this field. To reactivate this format profile, you need to select a parser plug-in. If you are modifying a format profile with a Bank Reconciliation profile type, see step 8 in Creating Format Profiles for Bank Reconciliation. If you are modifying a format profile with a Corporate Card Expenses profile type, see step 8 in Creating Format Profiles for Expense Reporting.

    • Notification Email

      Specify an email address to receive notifications about the status of bank statement imports that use this format profile. Failure or error notifications are always sent to this address. Success notifications are sent if the Send Success Messages option is enabled.

      Note:

      If no Notification Email is assigned, notifications may be sent to other recipients. These include the creator or last editor of the format profile (if their user notification preference is enabled) and the company's return email address (if enabled by the administrator). If both options are not enabled, the format profile creator or last editor will receive failure notifications as a fallback. This ensures that critical alerts are always delivered, even if no designated Notification Email is set.

    • Send Success Messages

      Check this box if you want the designated Notification Email recipient to receive an email when an automatic bank import using this format profile completes successfully. If this box is not checked, only failure or error notifications are sent to the Notification Email.

  6. On the Connectivity Configuration subtab:

  7. (Optional) Link your imported data to general ledger accounts or employee records, depending on your format profile type:

    • In a format profile with the Bank Reconciliation profile type, the Account Linking subtab appears. See Bank Account Linking.

    • In a format profile with the Corporate Card Expenses profile type, the Import Configuration subtab appears. See Linking Employee Accounts.

  8. (Optional) From the Import Schedule subtab, you can set an automated bank transaction import schedule. The subtab is only available for profiles with a Bank Reconciliation profile type. See Setting Up a Bank Import Schedule.

  9. (Optional) Map custom transaction codes to corresponding bank data types or map custom expense codes to expense categories in NetSuite, depending on your profile type.

    • In a format profile with the Bank Reconciliation profile type, the Code Type Mapping subtab appears. To map transaction codes to bank data types in NetSuite, see Mapping Custom Bank Codes.

    • In a format profile with the Corporate Card Expenses profile type, the Expense Code Mapping subtab appears. To map expense codes to expense categories in NetSuite, see Mapping Custom Expense Codes.

  10. (Optional) If the Parser Configuration subtab is visible, configure your selected parser plug-in. See Transaction Parser Configuration.

  11. Click Save.

    If successful and the format profile is configured to connect to a financial institution to retrieve data for reconciliation:

    • A progress message appears when the import starts. To check processing status, click Track your status.

    • NetSuite imports any new data from your existing accounts since the last successful import. For any new accounts mapped, NetSuite imports the last 60 calendar days of data (or from the Earliest Transaction Date for Import). For more information, see Automatic Bank Data Import.

      Note:

      There are cases where an import isn't initiated. For example, NetSuite can't import data from the same format profile twice within a 60-minute period.

    To match and reconcile your imported data, 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.

    If successful and the format profile is configured to connect to American Express, NetSuite applies the revised format profile configurations to the next import.

    If you've configured the format profile for manual import, go to the Upload File page to import data For details, see Manual Bank Data Import.

    Note:

    If your format profile contains any plug-in implementations not enabled in your account, manual and automatic import do not run. Select another plug-in or enable the selected plug-in. See Creating a New Plug-in Implementation.

Related Topics

General Notices