Bank Data Import

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

Bank or credit card data for reconciliation and matching
Corporate card expense data for expense reporting

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

Automatic import – If you have the Administrator role, you can use the Format Profile page to set up daily automatic imports. For more information, see Automatic Bank Data Import.
Manual import – Download the financial statement file from your financial institution, and then import it into NetSuite from the Upload File page. You can import a file using the parser and configuration settings from an existing format profile. If you are importing data for reconciliation, you can also use NetSuite’s default parser functionality. See Manual Bank Data Import.

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.

Note:

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:

General ledger accounts
General ledger transactions
Active reconciliation rules

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.

Note:

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