Intelligent Transaction Matching for Bank Data

When bank data is imported into NetSuite or you manually run reconciliation rules, the Intelligent Transaction Matching feature automatically matches imported bank data with account transactions. For details on importing bank data, see Bank Data Import. For information about running rules against imported data, see Manually Running Reconciliation Rules.

Intelligent Transaction Matching uses two types of rules on new bank lines (except for in-transit payments):

Note:

Intelligent Transaction Matching does not run rules against account transactions. Any account transactions that are currently matched can't be matched again, regardless of their reconciliation state.

To see how NetSuite groups transactions with these rules, see Grouping Multiple Transactions.

To view automatically matched transactions, go to Transactions > Bank > Match Bank Data and then click Review.

Note:

If a rule finds two or more possible matches, NetSuite can’t choose one, so you need to pick and match the correct transaction yourself.

For example, say you import a $70 bank deposit dated 03/22/2023. NetSuite finds two possibilities: a $70 deposit from 02/14/2023 and another from 01/16/2023. Because both are the right amount and at or before the imported deposit’s date, the system can’t decide. You need to choose and match the right transaction yourself.

On the Review subtab, each line item is a group of matched transactions. By default, all line items are collapsed. To view the individual transactions in the group, expand the line item.

In-Transit Payment Matching

In-transit payments are non-posting and aren't eligible for matching using system or user rules. Instead, Intelligent Transaction Matching matches in-transit payments using a built-in rule that isn't visible to you. This rule requires the transaction number and amount of the in-transit payment to match those of the imported bank line. In addition, the imported bank line must be a Payment type.

For more information about in-transit payments, see In-Transit Payments.

To enable the In-Transit Payments feature, see Enabling the In-Transit Payments Feature.

Related Topics

General Notices