Bank Data Import
-
Bank or credit card data for reconciliation and matching
-
Corporate card expense data for expense reporting
You can set up automatic or manual imports in either case.
-
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’re 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’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.
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:
-
General ledger accounts
-
General ledger transactions
-
Active reconciliation rules
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.
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
- Permissions for Banking Features
- Deposits
- Checking
- 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