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):
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.
-
System Rules – Default matching rules you can't change or remove. They automatically match imported bank lines to your account transactions. Default rules are listed in the System Rules list on the Reconciliation Rules page. For more information, see System Reconciliation Rules.
-
User Rules – Custom rules you can create and edit, and choose their order. They’re listed in the User Rules list on the Reconciliation Rules page, and include:
-
Matching rules – Rules that automatically match imported bank lines with account transactions if they meet the criteria you set. Matching rules are created and edited on the Reconciliation Rules page, and you can apply them to more than one account. For more information, see Creating User Transaction Matching Rules.
-
Auto-create rules – Rules that automatically create and match these types of transactions automatically:
-
Deposits and charges for general ledger bank accounts
-
Charges and refunds for general ledger credit card accounts
If a bank line matches the criteria in the rule, NetSuite creates an account transaction and matches it automatically. You can edit auto-create rules on the Reconciliation Rules page, but you make them from the Match Bank Data page, during a one-to-one match. You can only use each auto-create rule for one account. For details, see Generating Auto-Create Rules.
-
-
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.
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.