Manual Bank Data Import
You can download a financial statement file from your financial institution and then manually import it into NetSuite for reconciliation or expense reporting. NetSuite encrypts financial data files during processing. Files are removed and not stored after processing.
For compliance reasons, NetSuite does not store statement files as of 2020.1. After the file is parsed, it is removed from the database and cannot be accessed or downloaded.
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.
The file format you can use when manually importing data for reconciliation depends on your setup. For file formats supported by the Bank Statement Parsers SuiteApp, see Bank Statement Parsers SuiteApp. For file formats supported by NetSuite’s default parser functionality, see Supported File Formats for Default Parsers.
If your file format is not supported by the Bank Statement Parsers SuiteApp or NetSuite’s default parser functionality, use a Financial Institution Parser Plug-in. See Financial Institution Parser Plug-in Interface Overview.
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.
Reasons for manual import include the following:
-
You have a small volume of data that you have already downloaded from a financial institution and have on your local machine.
-
You want to upload a single file.
You can manually import a file using the parser and configuration settings from an existing financial institution record. If you are importing data for reconciliation, you can also use NetSuite’s default parser functionality. For details, see the following procedural topics:
To avoid performance degradation, you should not configure an import that exceeds 10,000 transactions.
This video displays the NetSuite 2021.1 user interface.