Match Bank Data and Reconcile Statements in NetSuite 2026.1

TL;DR: Starting in NetSuite 2026.1, the Match Bank Data and Reconcile Account Statement features enhance banking functionality by automating transaction matching and streamlining reconciliations, significantly reducing manual effort.

What’s New in 2026.1?

This update introduces intelligent transaction matching capabilities for bank data, automating the reconciliation of transactions upon data import. This feature minimizes the manual steps required in matching bank lines with account transactions, improving efficiency and accuracy.

How Does the Intelligent Transaction Matching Work?

When bank data is imported into NetSuite, the Intelligent Transaction Matching feature automatically runs preset reconciliation rules to correlate imported bank lines with existing account transactions. This means that users can focus on exceptions that require manual matching rather than sorting through entire spreadsheets or external tools.

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. For details on this feature, refer to the relevant documentation.

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 and manage their inclusion in the reconciliation process, ensuring that reports reflect accurate records.

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.