Banking Import History
The Banking Import History page (previously called Imported Statement List) is a place to audit imports and to troubleshoot issues. The page displays a list of imported account statements, along with import statuses and error details. To see the Banking Import History page, go to Transactions > Bank > Banking Import History.
To access the Banking Import History page, your role requires the Import Online Banking File permission. For details, see Permissions for Banking Features.
There are no subsidiary restrictions for the Banking Import History page.
There is a filter region at the top where you can filter imports by import status, profile type, date range, or you can use the Search field.
Viewing Import Error Details
You can view import errors on the Banking Import History page.
To view import error details:
-
Go to Transactions > Bank > Banking Import History.
NetSuite displays the list of imported account statements, along with import statuses and error details.
-
To view the expanded details of an imported statement, click the plus icon next to an import status.
For bank and credit card data imports with a Failed or Partially Completed status, NetSuite displays account-specific errors.
An import for an account fails, for example, if the date of a transaction is improperly formatted (for example, a one–digit month is not preceded by a zero).
For corporate card charge imports with a Failed status, NetSuite displays generic import errors. For specific error information, consult the Execution Log for the plug-in implementation used for the import. Go to Customization > Plug-ins > Plug-in Implementations, select your implementation, and then click the Execution Log subtab.
To refresh the information for the imported statements, click the refresh icon above the table. Next to the icon, you can see the Last Refreshed date and time.
Import Details
Specific information provided on the Banking Import History page includes the following:
-
Import Status – The status of the data import. To filter the list by status, you can select one or more options from the Bank Import Status list in the filter region. The default value is All. NetSuite has six import statuses:
-
Completed – The import process completed successfully. If the statement has a problem and was manually imported, you can delete it. See Deleting Imported Statements.
-
Partially Completed – NetSuite successfully completed an import for some but not all bank or credit card accounts. The system indicates a Partially Completed import by using an orange exclamation mark icon. If you have the Import Online Banking File permission with create-level access, NetSuite displays a list of failure reasons and affected accounts in the expanded details. You cannot delete partially completed imports.
Note:The Partially Completed status only applies to imports with a Bank Reconciliation profile type. This status does not apply to corporate card charge imports.
-
Failed – The import process failed, which is indicated by a red exclamation mark icon.
If this import uses a Bank Reconciliation profile type and you have the Import Online Banking File permission with create-level access, NetSuite displays account-specific errors. In the expanded details, you can view all failure reasons for the import, along with the accounts affected for each error.
If this import uses a Corporate Card Expenses profile type, NetSuite displays a generic error. For specific error information, consult the Execution Log for the plug-in implementation used for the import. See Viewing Import Error Details.
-
Deleted – The imported statement was deleted.
-
Importing – NetSuite is currently importing the statement. In the expanded details, a status bar is displayed.
-
Matching – NetSuite is currently automatching the transactions in your imported statement. In the expanded details, a status bar appears.
-
-
Internal ID – The internal ID of the import record. You can enable internal IDs on the Set Preferences page (Home > Set Preferences). By default, NetSuite disables this field.
-
Data Source – The name of the imported statement file or the name of the Financial Institution Connectivity plug-in used to import data directly from a financial institution. This name is provided regardless of whether the import completed, partially completed, failed, or succeeded but was deleted.
-
Format Profile – If you have a financial institution record configured, this value specifies the format profile selected for the import, which stores the file format information. The format profile determines which parser reads the data, the method of retrieval, and the purpose of use. For details, see Format Profile Creation.
-
Profile Type – The configuration type of the format profile selected for the import. This value can be Bank Reconciliation or Corporate Card Expenses. A Bank Reconciliation format profile configures an import of bank or credit card data for reconciliation and matching. A Corporate Card Expenses format profile configures an import of corporate card charges for expense reporting. For details, see Format Profile Creation.
-
Date Submitted – The system date and time at which the statement was submitted for import.
-
Imported By – This value represents who imported the file. This can be a user’s email address or the system, if the import was system-generated.
To view a list of individual bank or credit card lines for your imported statements that require matching, see Viewing Data Imported for Reconciliation.
As of NetSuite 2020.2, the Import Details page is no longer supported. However, you can still access import details by adding the Bank Statement Import List portlet to the Home dashboard. To add a List portlet, see List Portlets.
To view a list of individual corporate card expense transactions for your imported statements, see Viewing Imported Corporate Card Expenses.
To import a bank, credit card, or corporate card statement, see Bank Data Import.