Linking Accounts for Manual Import

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

Important:

To avoid performance degradation, don’t link 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.

      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. In the Account Linking subtab, In each row, link an account from the imported bank statement to the 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 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.

    4. Check the Inactive box to inactivate the unique account ID. 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’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’re using the Automated Cash Application feature, you can automatically generate customer payments from your imported data and apply them to invoices. These 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