Manual Bank Data Import
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 aren't stored after processing.
For compliance reasons, NetSuite does not store statement files. After parsing, the file is removed from the database and can't be accessed or downloaded.
NetSuite uses reconciliation rules to automatically match imported bank lines to account transactions during bank or credit card reconciliation. 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. The Automated Cash Application feature lets you automatically generate a batch of customer payments in NetSuite and apply them to open invoices. NetSuite then automatically matches and clears the generated customer payments. For details, see Automated Cash Application.
The file format you can use for manual data import depends on your setup. For information about file formats supported by the Bank Statement Parsers SuiteApp, see Bank Statement Parsers SuiteApp. For information about 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, where you can add them 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're importing data for reconciliation, you can also use NetSuite’s default parser functionality. For details, see the following procedural topics:
To avoid performance issues, you should not configure an import that exceeds 10,000 transactions.
This video displays the NetSuite 2021.1 user interface.