Bank Data Import

Manage bank, credit card, and corporate card accounts online in NetSuite. You can import the following:

In either case, you can configure automatic or manual imports.

If your role has the Import Online Banking File permission, you can use the Statement File Import feature. For details, see Permissions for Banking Features.

The data source determines the number of transactions you can import. However, unless you are using the Bank Feeds SuiteApp or AMEX Corporate Card Integration SuiteApp, it is best practice not to exceed 10,000 transactions per import.

When importing data for bank or credit card reconciliation, the data source also determines the number of financial institution accounts you can link in a format profile. When configuring an automatic import without using the Bank Feeds SuiteApp, you should try to link no more than 500 accounts. For a manual import, you should try to link no more than 2,500 accounts.


There is no recommended limit for the number of employee accounts you can link when importing corporate card expense data for expense reporting.

If an import is going to exceed these suggested limits, you should configure multiple format profiles to facilitate parallel imports. Otherwise, you may start to see performance degradation.

Performance of an import for bank or credit card reconciliation can be impacted by the number of:

For information on how many banking transactions you can import and how many accounts you can link when using the Bank Feeds SuiteApp, see Limitations of Using the Bank Feeds SuiteApp.

For information on how many American Express corporate card transactions you can import when using the AMEX Credit Card Integration SuiteApp, see American Express Integration for Expense Reporting.

When data is imported for bank or credit card reconciliation, NetSuite uses reconciliation rules to automatically match your imported bank lines to account transactions in NetSuite. All imported bank lines that cannot be matched by the system are available for manual matching on the Match Bank Data page. You can reconcile matched transactions on the Reconcile Account Statement page. For more information, see Bank Data Matching and Reconciliation.


All imported bank lines with a positive amount also appear and can be processed on the Automated Cash Application page. The Automated Cash Application feature enables you to automatically generate a batch of customer payments in NetSuite and apply them to open invoices. The generated customer payments are then automatically matched and cleared in the system. For details, see Automated Cash Application.

When you import corporate card charges for expense reporting, NetSuite stores them in the Imported Employee Expenses list. Add your imported charges to expense reports. For more information, see Creating Expense Reports With Imported Transactions.

This section includes the following topics:

Related Topics

Permissions for Banking Features
Transferring Funds
Company Credit Cards
Financial Institution Records
Automated Cash Application
Bank Data Matching and Reconciliation
Bank Account Reconciliation and Reporting
Bank Feeds SuiteApp
Auto Bank Statement Import SuiteApp
Bank Statement Parsers SuiteApp

General Notices