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:
-
To open the appropriate Format Profile page for the appropriate financial institution record:
-
Go to Setup > Accounting > Financial Institution > List.
NetSuite displays the Financial Institutions page.
-
Next to the appropriate financial institution record, click View.
NetSuite displays the Financial Institution page.
-
In the Format Profile: Configuration subtab, click Edit next to the appropriate format profile.
NetSuite displays the Format Profile page.
-
-
Click the Code Type Mapping subtab.
-
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.
-
In the Description column, enter a description to help you identify this bank transaction code.
-
From the Bank Data Type dropdown list, select the bank data type to which you want to map the bank transaction code.
-
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.
-
If you want 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” does not 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 do not count toward the number of imported transactions and do not appear in the Import Details page.
-
To inactivate the bank transaction code, check the Inactive box. By default, the system clears this box.
-
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 any plug-in implementations that are not enabled in your account, the import process and initiation of the daily import schedule does not 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 are 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.