Importing Data Using a Financial Institution Record

Follow this procedure if you want to download a financial statement file from your financial institution and then import it using settings configured within a financial institution record. Financial institution records enable you to configure imports for specific financial institutions from which you want to retrieve data. You can configure imports for bank reconciliation or corporate card expenses.

Important:

You must have financial institution records set up in NetSuite to do this procedure. If you have the Administrator role, you can create a financial institution record to configure an import. For details on creating and managing financial institution records, see Financial Institution Records. If you want to import data but do not have an Administrator role or configured financial institution records, contact your administrator.

You can also import data using NetSuite’s default parser functionality. See Importing Data Using Default Parsers.

Note:

If you are importing corporate card charges for expense reporting, you must follow this procedure. The other manual import methods are only applicable if you are importing bank or credit card data for reconciliation.

To import data using a financial institution record:

1. Ensure you complete the following prerequisites:

   1. Create and upload a custom parser built with the Financial Institution Parser Plug-in interface into NetSuite. For details about this plug-in, see Financial Institution Parser Plug-in Interface Overview.

      To create a script file for the plug-in, see Creating a Financial Institution Parser Plug-in Script File.

      For upload instructions, see Adding the Plug-in Implementation.

   2. Create a financial institution record to store your manual import configuration, including your parser plug-in implementation. See Creating Financial Institution Records.

      Note:

      If you do not have access to financial institution records, contact your administrator for assistance.

   3. Within the financial institution record, create a format profile with configuration settings necessary to manually import your data. You can configure an import of bank or credit card statement files for matching and reconciliation. In addition, you can configure an import of corporate card charges for expense reporting. See Creating Format Profiles for Bank Reconciliation and Creating Format Profiles for Expense Reporting.

2. Go to your financial institution website and download your financial statement in the appropriate file format.

   Choose the file format based on the transaction parser you are using to configure your import. For example, if you are using a BAI2 parser to retrieve your data, choose BAI2. If you have the Administrator role, you can determine the type of parser used by opening the appropriate financial institution record and viewing its configuration settings. See Financial Institution Records.

   If you do not have access to financial institution records, contact your administrator for assistance.

   Important:

   To ensure successful file import, do not modify the downloaded statement file.

3. Give the statement file a name. The limit for the file name length is 50 characters, which includes the extension.

4. Go to Transactions > Bank > Banking Import History > Upload File.

   NetSuite displays the Upload File page. The Manual Import subtab is open by default.

5. Click Choose File, or use the drag-and-drop functionality.

   Important:

   The limit for the file name length is 50 characters, which includes the extension.

6. Select the name of the file you want to import.

7. Under Import Options, choose Select a Financial Institution.

8. From the Financial Institution list, select a financial institution record.

9. From the Format Profile list, select a format profile record.

   A format profile is a record within a financial institution record that contains configuration settings for imports. Only format profiles configured for manual import appear in this list. If the selected financial institution record only has one format profile, NetSuite selects it by default.

   Note:

   Depending on your NetSuite role, you can create a new financial institution or format profile record by clicking each plus icon.

10. Click Import.

    Note:

    You do not have to wait on the page until the import is done. You can perform other actions such as a new import. The number of bulk imports you can perform at the same time is determined by your NetSuite Service Tier. For details, see NetSuite Service Tiers.

    NetSuite displays a progress message. To view the processing status of your import, click Track your status.

    NetSuite displays the Banking Import History page. For more information, see Banking Import History.

When the import process completes, do one of the following:

• If you are importing bank or credit card statement files for reconciliation, perform matching and reconciliation. 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 you are importing corporate card expense files for expensing reporting, add your imported charges to expense reports. See Creating Expense Reports With Imported Transactions.

Related Topics

Importing Data Using Default Parsers

Importing Data Using a Bank Connectivity Plug-in

Viewing Imported Banking Data

Deleting Imported Statements

General Notices