Role Required: NetSuite A/P Clerk or Accountant
Match Bank Data
Navigate to Bank Connect→Match Bank Data→Match Bank Data.
On the Match Bank Data page, you can review NetSuite transactions (bill payments and other activity) in the right column. In the left column, you can view imported bank statement data (transaction details and account balance imported from the bank).
Bank accounts in NetSuite must be enabled for the Match Bank Data functionality to import statement data via Bank Connect. For more information, visit Configure Bank Accounts.
Review and Excluded Tabs
In NetSuite’s Match Bank Data page, transactions are organized into different tabs to help you identify their status.
- The Review tab shows transactions that still require your attention—these items have not yet been matched or confirmed and may need manual review or matching.
- The Excluded tab contains transactions that have been intentionally set aside, meaning they will not be considered for matching unless they are restored.
The most common cause of “missing” transactions in NetSuite is that they have already been automatically matched during the bank reconciliation process. Checking matched or excluded transactions can often help locate these items quickly.
Update Imported Bank Data
The Bank Connect plug-in handles your daily imports with no manual action required:
- Daily Sync: Automatically imports bank transactions from the previous business day.
- Error Handling: If an import fails, the system automatically retries 2 hours later (up to 3 retries per day).
You can also request a real-time update by clicking Update Imported Bank Data. This request can be made once per hour in NetSuite.
The Update Imported Bank Data feature updates statement data for a single account at a time. To update bank data for all accounts at once, navigate to Bank Connect→Information Reporting→Import Bank Data.