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 Manual Import

Linking Accounts for Manual Import

Link accounts from the imported bank statement to corresponding accounts in NetSuite.

Important:

To avoid performance degradation, you should link no more than 2,500 accounts.

To do this procedure, you need to create a format profile and complete some initial setup. For details, see steps 1– 8 of Creating Format Profiles for Bank Reconciliation.

To link bank accounts for manual import:

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

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

      NetSuite displays the Financial Institutions page.

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

      NetSuite displays the Financial Institution page.

    3. In the Format Profile: Configuration subtab, click Edit next to the format profile in which you want to link accounts.

      NetSuite displays the Format Profile page.

  2. In the Account Linking subtab, in each row, link an account from the imported bank statement to a corresponding account in NetSuite:

    1. In the Unique Account ID column (previously called Account Mapping Key), enter a unique account ID from the statement file for this format profile.

      If you selected a standard parser plug-in available through the Bank Statement Parsers SuiteApp, the unique account ID you need to enter depends on the file format to be parsed. See Identifying Unique Account IDs for Standard Bank Statement Parsers.

      If you selected a custom parser plug-in, the plug-in will have its own logic about how to determine the unique account ID you need to enter.

      There is a limit of 80 characters.

      Important:

      For compliance reasons, you cannot enter a credit card number. To ensure that the unique account ID does not contain a credit card number, NetSuite removes all non-numeric characters.

      • If the remaining string is less than 13 characters or greater than 20 characters, NetSuite accepts the unique account ID.

      • If the remaining string is greater than 12 characters and less than 21 characters, NetSuite performs a Luhn check. If the check passes, NetSuite blocks you from using the unique account ID. If the check fails, NetSuite accepts the unique account ID.

    2. In the Description column, enter a description to help you identify this unique account ID.

    3. From the Linked GL Account dropdown list, select the bank or credit card account in NetSuite to which you want to link the unique account ID from the statement.

      Note:

      The accounts available in the list are not restricted by any classifications, including subsidiaries, departments, locations, and classes. Any restriction preferences do not apply to the dropdown list.

      Important:

      To avoid an inaccurate or inconsistent balances on the Match Bank Data page, perform one-to-one account linking only. Do not link more than one bank account to the same account in NetSuite.

    4. To inactivate the unique account ID, check the Inactive box. By default, the system clears this box.

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

To import bank data using this format profile record, go to Transactions > Bank > Banking Import History > Upload File. 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.

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.

For details on the bank reconciliation process, see Bank Data Matching and Reconciliation. For information on the automated cash application process, see Automated Cash Application.

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

Related Topics

General Notices