Configuring a Connection to a Financial Institution (Without a SuiteApp)

In a Bank Reconciliation format profile, you can configure a connection to a financial institution to automatically retrieve bank or credit card data, without using a SuiteApp. To accomplish this, create and configure your own financial institution record and a corresponding format profile that uses custom transaction parser and connectivity plug-in implementations.

The following procedure outlines how to configure a connection using custom plug-in implementations. To configure a connection using the Bank Feeds or Auto Bank Statement Import SuiteApps, see Setting Up Bank Feeds Integration and Setting Up Auto Bank Statement Import. For details on these SuiteApps, see Bank Feeds SuiteApp and Auto Bank Statement Import SuiteApp.

To configure direct connectivity to a financial institution, without using a SuiteApp:

Go to Setup > Accounting > Financial Institution > List.

NetSuite displays the Financial Institutions page.
Next to the financial institution record for which you want to add a format profile, click View.

If you do not have a financial institution record, you need to create one. See Creating Financial Institution Records.

NetSuite displays the Financial Institution page.
In the Format Profile: Configuration subtab, click Add.

Important:
You must be in View mode to enable the Add button. The button is not available in Edit mode.

NetSuite displays the Format Profile page.
Enter the primary information for the format profile.

Note:
In an automatically provisioned record, the primary information is populated and cannot be changed.
1. In the Profile Name field, enter a name for your format profile.
2. In the Description field, enter a description to help you identify this format profile.
3. In the Profile Type field, select Bank Reconciliation. This profile type is the default.
4. From the Connectivity Method dropdown list, select a custom Financial Institution Connectivity Plug-in.
  
  For a plug-in to be available, you must create and upload one to NetSuite. For details, see Financial Institution Connectivity Plug-in Interface Overview.
  
  Alternatively, if you have installed the Auto Bank Statement Import (ABSI) SuiteApp, you can use the SFTP Connectivity Plug-in available in the list. For details about the SuiteApp, see Auto Bank Statement Import SuiteApp.
  
  Important:
  If the list contains a plug-in provisioned by the Bank Feeds SuiteApp, do not select it. If you try to select such a plug-in on a custom format profile, an error occurs when you try to save it.
5. From the Transaction Parser list, select a custom parser plug-in.
  
  The Transaction Parser field is required. For a plug-in to be available, you must either create and upload one to NetSuite or have the Bank Feeds or Auto Bank Statement Import SuiteApps installed.
  
  Important:
  If the list contains a plug-in provisioned by the Bank Feeds SuiteApp, do not select it. If you try to select such a plug-in on a custom format profile, an error occurs when you try to save it.
  
  For details on parser configuration, see Transaction Parser Configuration.
On the Connectivity Configuration subtab, configure a connection to a financial institution.

The configuration steps required depend on the configuration of the connectivity plug-in selected.

If you are using a custom plug-in, the configuration steps required depend on the plug-in’s initial implementation.

Important:
Configuration for a financial institution depends entirely on what the plug-in requires for the connection. However, the general steps typically involve authenticating your bank connection (providing login credentials) and giving NetSuite access to your accounts. The end result is always the same for all plug-ins. After configuration is complete, NetSuite has access to the user's bank accounts, and later, the user's transactions.

If you are using the SFTP Connectivity plug-in, see Configuring SFTP Connection for Auto Bank Statement Import.

After you configure a connection to a financial institution or institutions, the Account Linking subtab is populated with information.
On the Account Linking subtab, link the financial institution accounts to corresponding accounts in NetSuite. For details, see Linking Accounts for Financial Institution Connectivity.
(Optional) Map custom bank codes to corresponding bank data types in NetSuite. For details, see Mapping Custom Bank Codes.
Click Save.

If you configured the format profile correctly 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 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.
- If you are using the Automated Cash Application feature, you can automatically generate customer payments from your imported data and apply them to invoices. These generated payments are automatically matched and cleared in the system. See Generating Customer Payments.

To configure direct connectivity to a financial institution, without using a SuiteApp:

Related Topics