1. Accounting
  2. Banking
  3. Financial Institution Records
  4. Format Profile Creation
  5. Creating Format Profiles for Bank Reconciliation
  6. Bank Account Linking
  7. Linking Accounts for Financial Institution Connectivity

Linking Accounts for Financial Institution Connectivity

Link data from financial institutions to corresponding accounts in NetSuite.

Important:

To avoid performance degradation:

  • If you’re using a format profile provisioned by the Bank Feeds SuiteApp, you can link up to 20 accounts. See Limitations of Using the Bank Feeds SuiteApp.

  • If you’re not using a format profile provisioned by the Bank Feeds SuiteApp, link no more than 500 accounts.

The Account Linking subtab is populated with information from the financial institution accounts for which you have a configured connection. If you are configuring a manual import, see Linking Accounts for Manual Import.

To do this procedure, you need to create a format profile and complete some initial setup, including configuring a direct connection to a financial institution. For details, see steps 1 – 5 of Configuring a Connection to a Financial Institution (Without a SuiteApp).

To link bank accounts for financial institution connectivity:

To troubleshoot account linking issues, see Troubleshooting Account Linking Issues for Automatic Import.

  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 format profile in which you want to link accounts.

      The Format Profile page appears.

  2. Click the Account Linking subtab.

    NetSuite displays the following:

    • A list of the financial institution accounts you’ve configured a connection for.

    • The name of the financial institution each account belongs to.

      If no financial institution is identified for an account, No Financial Institution Found appears.

  3. Click the Account Linking subtab.

  4. From each Linked GL Account list, select a bank or credit card account in NetSuite to link to the adjacent accounts.

    Note:

    The accounts available in the list aren’t restricted by classifications like subsidiaries, departments, locations, or classes. Restriction preferences don’t apply to the dropdown list.

    Important:

    To avoid inaccurate or inconsistent balances on the Match Bank Data page, only perform one-to-one account linking. Don’t link more than one bank account to the same NetSuite account.

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

    If you’ve configured the format profile correctly and save is successful:

    • A progress message appears when the import begins. To check 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 one. See Creating a New Plug-in Implementation.

    • 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.

    • 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.

Related Topics

General Notices