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.
In the User Rules list, you can add and edit your own custom matching rules, as well as edit auto-create rules. You can assign the order in which NetSuite runs user matching and auto-create rules.
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. You cannot reorder system rules, but you can inactivate them.
-
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 the user matching and auto-create rules, use the icon to drag the 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.