Modifying Format Profiles
To modify or add format profiles, the Financial Institution page must be in View mode.
To modify format profiles:
-
Go to Setup > Accounting > Financial Institution > List.
NetSuite displays the Financial Institutions page.
-
Next to the financial institution record that contains the format profile you want to modify, click View.
NetSuite displays the Financial Institution page.
-
In the Format Profile: Configuration subtab, click the appropriate format profile.
NetSuite displays the Format Profile page.
-
Click Edit.
-
You can modify the following primary information on 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.
-
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.
-
-
On the Connectivity Configuration subtab:
-
(Optional) If the profile type is Bank Reconciliation, configure a connection to a financial institution. See Configuring a Connection to a Financial Institution (Without a SuiteApp).
-
(Optional) If the profile type is Corporate Card Expenses, configure a connection to American Express. See American Express Integration for Expense Reporting.
-
-
(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.
-
-
(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.
-
-
(Optional) If the Parser Configuration subtab is visible, configure your selected parser plug-in. See Transaction Parser Configuration.
-
Click Save.
If successful and the format profile is configured to connect to a financial institution to retrieve data for reconciliation:
-
NetSuite displays a progress message that an import process has started. To view the processing status of your import, 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. For more information, see Automatic Bank Data Import.
Note:There are cases where an import is not initiated. For example, NetSuite cannot 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 have configured the format profile for manual import, you must 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.
-