Bank Data Import

You can set up automatic or manual imports in either case.

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’re using the Bank Feeds SuiteApp or AMEX Corporate Card Integration SuiteApp, you should not 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 not link more than 2,500 accounts.

Note:

There is no suggested limit on 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 need to create multiple format profiles to make parallel imports easier. Otherwise, you may start to notice performance issues.

The number of the following can affect import performance for bank or credit card reconciliation:

To learn how many banking transactions you can import and how many accounts you can link with the Bank Feeds SuiteApp, see Limitations of Using the Bank Feeds SuiteApp.

To see how many American Express corporate card transactions you can import with the AMEX Credit Card Integration SuiteApp,see American Express Integration for Expense Reporting.

When you import data for bank or credit card reconciliation, NetSuite uses reconciliation rules to automatically match your imported bank lines to account transactions. All imported bank lines that can't 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.

Note:

All imported bank lines with a positive amount also appear and can be processed on the Automated Cash Application page. With the Automated Cash Application feature, you can automatically generate a batch of customer payments in NetSuite and apply them to open invoices. The system then automatically matches and clears the generated customer payments. 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

General Notices