Viewing Reconciliation Rules

NetSuite uses system rules to automatically match imported bank lines with account transactions. These default rules run on all transactions. You can find them in the System Rules list on the Reconciliation Rules page. For descriptions of the rules, see Intelligent Transaction Matching for Bank Data.

The User Rules section contains the Matching and Auto-Create groups. In the Matching group, you can add and edit your own custom matching rules and assign the order in which NetSuite runs them. In the Auto-Create group, you can edit auto-create rules but cannot reorder them.

Note:

NetSuite has a built-in rule for matching imported bank lines with in-transit payments, but it isn't visible to you. This rule is applied if the following criteria are met:

The transaction numbers exactly match.
The dollar amounts exactly match.
The imported bank line is a Payment type.

To view reconciliation rules:

Go to Transactions > Bank > Reconciliation Matching Rules.

The Reconciliation Rules page has two sections: System Rules and User Rules. The User Rules section contains the Matching and Auto-Create groups. You cannot reorder system rules, but you can inactivate them. You can reorder rules in the Matching group under User Rules. Auto-create rules cannot be reordered.
To create user matching rules, see Creating User Transaction Matching Rules. To generate auto-create rules, see Generating Auto-Create Rules.
To assign the order in which NetSuite runs user matching rules, use the icon to drag the rules in the Matching group under User Rules into the desired order.
To edit custom matching and auto-create rules, see Creating User Transaction Matching Rules and Editing Auto-Create Rules.
To delete a user rule, click the Delete icon.

To view reconciliation rules:

Related Topics