Match Bank Data and Reconcile Statements in NetSuite 2026.1

TL;DR: Starting in NetSuite 2026.2, the Match Bank Data and Reconcile Account Statement features enhance banking functionality by automating transaction matching and streamlining reconciliations, significantly reducing manual effort. As part of this release, users must ensure proper permissions are assigned to access these features.

What’s New in 2026.2?

This update continues to improve the Intelligent Transaction Matching capabilities for bank data, allowing users to automatically match transactions upon data import. Users must have the appropriate permissions assigned to their roles to access the Match Bank Data and Reconcile Account Statement pages. For details, see Permissions for Banking Features. If you want to use these pages for an existing account, check the Use Match Bank Data and Reconcile Account Statement Pages box on the Edit Account page—this box is automatically checked for any new accounts. For details, see Editing Accounts to Use the Match Bank Data and Reconcile Account Statement Pages.

When bank data is imported into NetSuite, the Intelligent Transaction Matching feature runs reconciliation rules to automatically match imported bank lines to corresponding transactions. You can manually match exceptions and reconcile transactions, without requiring spreadsheets or third-party tools. If importing bank data is difficult or not possible, you can mark the corresponding account transactions as cleared in NetSuite without importing the matching bank lines.

How Does the Intelligent Transaction Matching Work?

The Intelligent Transaction Matching feature matches imported bank data with account transactions when bank data is imported into NetSuite or when you manually run reconciliation rules. When bank data is imported into NetSuite, the Intelligent Transaction Matching feature runs reconciliation rules to correlate imported bank lines with existing account transactions. You can manually match exceptions and reconcile transactions, without requiring spreadsheets or third-party tools. If importing bank data is difficult or not possible, you can mark the corresponding account transactions as cleared in NetSuite without importing the matching bank lines.

User Interface Improvements

The Match Bank Data page shows side-by-side grids of:

• Imported bank lines
• Account transactions

The following user actions are available on this page:

• Match account transactions directly.
• Mark transactions as cleared when they have no corresponding bank line.
• Exclude specific bank lines from consideration.
• Review matched and user-cleared transactions.
• Submit transactions to finalize records in the system.

Working with Automated Cash Applications

Before proceeding with manual matches, users are encouraged to utilize the Automated Cash Application feature. This feature allows the automatic generation of matching customer payments in NetSuite from imported bank lines, streamlining both the matching and clearing processes. Important: Customer payments generated, matched, and cleared using the Automated Cash Application feature appear on the Reconcile Account Statement page. For more details on this feature, refer to the relevant documentation on Automated Cash Application.

Reconciliation Steps

Once transaction matching or clearing is complete, users can submit their changes and navigate to the Reconcile Account Statement page. Here, they can review the submitted transactions, manage their inclusion or exclusion in the reconciliation process, and ensure that reports reflect accurate records. To reconcile custom transactions, go to Accounting Preferences and check the Show All Transaction Types In Reconciliation box. See General Accounting Preferences.

Who This Affects

This update impacts:

• Accountants: By reducing manual reconciliation effort.
• Finance Teams: Through improved automation and accuracy in transaction matching.
• Administrators: Who configure and oversee banking functionalities in NetSuite.

Key Takeaways

• The Match Bank Data and Reconcile Account Statement features automate transaction matching for easier reconciliation.
• Users can handle exceptions manually without relying on spreadsheets.
• The Automated Cash Application feature maximizes efficiency by generating customer payments automatically.
• Enhanced user interface provides greater visibility into transactions across banking and accounting functions.
• Proper permissions must be configured to access these banking features.

Information about bank data matching and reconciliation in this topic includes:

• Intelligent Transaction Matching for Bank Data
• Reconciling Bank and Credit Card Statements
• Account Reconciliation Reports