Bank Statement File Import
There are two ways to enable the system to import your bank statement files into NetSuite using the Auto Bank Statement Import (ABSI) SuiteApp:
-
Automatic import – Use the Format Profile page to set up your daily bank statement file imports. For more information, see Automatic Bank Statement File Import.
-
Manual import request – Manually request for the system to import your latest bank statement flies from your financial institution sever for an updated account balance. For more information, see Updating Imported Bank Statement Files.
The SuiteApp uses the file name pattern defined on your SFTP connectivity configuration to identify which bank statement files will be imported into NetSuite. To know more about how the system imports your bank statement files according to certain scenarios, see Bank Statement File Name Import Matching.
Details of each imported bank data through SFTP connectivity are available on the Imported Statement List and SFTP Connectivity File Import List pages. For more information about how you can manage your bank statement file imports, see Managing SFTP Connectivity File Imports.
When your bank statement files are imported, the parser plug-in reads the content and then extracts the transaction information into NetSuite. The system automatically matches your data to account transactions in NetSuite on the Match Bank Data page. After the bank data import process is complete, you can also match any unmatched transactions on the Match Bank Data page. For more information, see Matching Bank Data.
After submitting the transactions so they are cleared in the system, reconcile transactions on the Reconcile Account Statement page. For details, see Bank Data Matching and Reconciliation.