Automatic Bank Data Import
You can automate bank data imports by configuring format profiles, which are records that enable you to connect to financial institutions to retrieve financial data. If you have the Administrator role, you can automate bank or credit card data imports for matching and reconciliation. See Automating Imports for Bank Reconciliation.
If you are using the Expense Reports feature, you can automate imports of corporate card charges from American Express for expense reporting. See Automating Imports for Expense Reporting.
When you save a format profile configured for automatic import for the first time, NetSuite creates a daily import schedule.
If you have automatic import for bank reconciliation configured, you can initiate a manual update of your account data on the Match Bank Data page. You should only do this if your account does not contain the latest data, or if there was an import error. For details, see Updating Imported Bank Data.
If you have automatic import for expense reporting configured, NetSuite stores imported corporate card charges in the Imported Employee Expenses list. When new expenses are available, employees receive an email notification and a reminder in the Reminder portlet on the NetSuite Home page. For information on viewing expenses and creating expense reports, see Creating Expense Reports With Imported Transactions.
To see a list of all your imports of bank, credit card, and corporate card data, go to the Banking Import History page (Transactions > Bank > Banking Import History). See Viewing Imported Banking Data.
Reasons for automatic import include the following:
-
You have large data volumes.
-
You have frequent imports.
-
You want to save time by eliminating the need for manually importing data.
-
(If you are performing bank reconciliation) You want to automate the process of importing and matching data.
-
(If you are performing bank reconciliation) You want to receive daily up-to-date banking transactions and account balances.