Mapping Custom Bank Codes

(Optional) In a Bank Reconciliation format profile, map custom bank codes to corresponding bank data types in NetSuite.

To map custom bank transaction codes:

  1. To open the appropriate Format Profile page for the appropriate financial institution record:

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

      The Financial Institutions page appears.

    2. Next to the appropriate financial institution record, click View.

      The Financial Institution page appears.

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

      The Format Profile page appears.

  2. Click the Code Type Mapping subtab.

  3. In the Bank Transaction Code column, enter a custom bank transaction code from your financial institution.

    For a list of custom bank transaction codes, contact your financial institution.

    There is a limit of 80 characters for the code.

  4. In the Description column, enter a description to help you identify this bank transaction code.

  5. From the Bank Data Type dropdown list, select the bank data type to which you want to map the bank transaction code.

  6. If you are using a parser that has unsigned amount values (for example, BAI2 or MT940 file format), from the Debit/Credit dropdown list, select Debit or Credit for the bank transaction code. Otherwise, select N/A.

    Note:

    The Debit or Credit value you set in a format profile overrides the value in the bank data NetSuite imports. For example, if the bank code type is a credit value but you select a debit value in your format profile, NetSuite imports the data as a debit.

  7. If you’d like to exclude the bank transaction code from transaction processing so that NetSuite ignores all transactions containing the code, check the Exclude box. By default, the system clears this box.

    Some formats contain codes you want to exclude. For example, in the BAI2 format, the bank transaction code “890” doesn’t contain useful monetary information for imported transactions. However, the “890” code is already excluded from the core parsers and parser plug-ins for BAI2.

    Excluded transactions don’t count toward the number of imported transactions and don’t appear on the Import Details page.

  8. Check the Inactive box to inactivate the bank transaction code. By default, the system clears this box.

  9. Click Save to save the format profile, or Save & New to save the current format profile and create a new one.

    If you configured the format profile to connect to a financial institution and the save is successful:

    • NetSuite displays a progress message that an import process has begun. To view the processing status of your import, click Track your status. See Banking Import History.

    • For any newly-linked accounts, NetSuite imports the last 60 calendar days of data. For any existing accounts, NetSuite imports any new data since the last successful import. If you are saving this format profile for the first time, NetSuite creates a daily import schedule. For more information, see Automatic Bank Data Import.

      Note:

      If your format profile contains plug-in implementations that aren’t enabled in your account, the import process and initiation of the daily import schedule won’t run. Select another plug-in or enable the selected plug-in. See Creating a New Plug-in Implementation.

    If you have configured the format profile for manual import, you must go to Transactions > Bank > Banking Import History > Upload File to import data. For details, see Manual Bank Data Import.

If you’re using the Intelligent Transaction Matching feature, NetSuite uses reconciliation rules to automatically match your imported data to account transactions. To view automatically-matched transactions, see Viewing Transactions To Be Submitted. To match imported bank lines that require manual matching, see Matching Bank Data.

For details on the bank reconciliation process, see Bank Data Matching and Reconciliation. F

For details on banking-related permissions, see Permissions for Banking Features.

Related Topics

General Notices