Bank Transaction Matching Types

The Intelligent Transaction Matching feature uses matching rules to automatically create matches through the system (default) or user matching rules. For any remaining unmatched transactions, you can manually create matches.

Note:

If a rule identifies two or more possible transactions in NetSuite to match, the system cannot perform a transaction match. The system is unable to know which transaction to match, so you need to manually match the appropriate transaction, instead.

Here’s an example where a manual match is needed: An imported bank deposit has an amount of $70 and a date of 03/22/2023. NetSuite contains two transactions that are possible match candidates: a $70 deposit with a date of 02/14/2023 and a $70 deposit with a date of 01/16/2023. Because the transactions have the same amount and are at or before the date of the imported bank deposit, both meet NetSuite's match criteria. Due to this ambiguity, the system cannot choose one transaction over the other. Instead, you need to determine the appropriate choice and perform a manual match.

NetSuite supports the following types of matches:

To enable NetSuite to automatically create account transactions from incoming transactions and match them, see Generating Auto-Create Rules.

Related Topics

Intelligent Transaction Matching for Bank Data
System Reconciliation Rules
Creating User Transaction Matching Rules
Rules for Automatically Creating Transactions
Manually Running Reconciliation Rules
Viewing Reconciliation Rules

General Notices