Importing Data Using a Financial Institution Record
Use this procedure to download a financial statement file from your financial institution and import it using settings in a financial institution record. Financial institution records let you configure imports for each financial institution you want to retrieve data from. You can configure imports for bank reconciliation or corporate card expenses.
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 about 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.
If you're importing corporate card charges for expense reporting, follow this procedure. Use the other manual import methods only for importing bank or credit card data for reconciliation.
To import data using a financial institution record:
-
Ensure you complete the following prerequisites:
-
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.
-
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.
-
Within the financial institution record, create a format profile with the settings needed to manually import your data. You can configure an import for bank or credit card statement files for matching and reconciliation, or import corporate card charges for expense reporting. See Creating Format Profiles for Bank Reconciliation and Creating Format Profiles for Expense Reporting.
-
-
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 selected for your import. For example, if you're using a BAI2 parser, choose BAI2. If you have the Administrator role, you can check the parser type by opening the financial institution record and viewing its settings. See Financial Institution Records.
If you do not have access to financial institution records, contact your administrator.
Important:To ensure successful file import, do not modify the downloaded statement file.
-
Give the statement file a name. The file name can be up to 50 characters, including the extension.
-
Go to Transactions > Bank > Banking Import History > Upload File.
NetSuite displays the Upload File page. The Manual Import subtab is open by default.
-
Click Choose File, or use the drag-and-drop functionality.
Important:The file name can be up to 50 characters, including the extension.
-
Select the name of the file you want to import.
-
Under Import Options, choose Select a Financial Institution.
-
From the Financial Institution list, select a financial institution record.
-
From the Format Profile list, select a format profile record.
A format profile is a record within a financial institution record with import configuration settings. Only format profiles set up for manual import appear in this list. If the financial institution record has only one format profile, NetSuite selects it by default.
Note:Depending on your NetSuite role, you can create a new financial institution or format profile by clicking the plus icon.
-
Click Import.
Note:You don’t have to wait on the page while the import runs. You can work on other actions, such as starting a new import. The number of concurrent bulk imports depends on 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're 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're importing corporate card expense files for expense reporting, add the imported charges to expense reports. See Creating Expense Reports With Imported Transactions.