Viewing Reconciliation Rules
NetSuite includes system transaction matching rules to automatically match imported bank lines with existing account transactions in NetSuite. These default matching rules run on all transactions. You can view these rules in the System Rules list (previously named Default Rules) on the Reconciliation Rules page (previously named Reconciliation Matching Rules). For descriptions of the rules, see Intelligent Transaction Matching for Bank Data.
In the User Rules list (previously named Custom Rules), 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 is not 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 (previously named Reconciliation Matching Rules) displays two sections: System Rules and User Rules. The system rules are in a list that you cannot reorder, 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.