1. Accounting
  2. Banking
  3. Bank Data Matching and Reconciliation
  4. Intelligent Transaction Matching for Bank Data
  5. Creating User Transaction Matching Rules

Creating User Transaction Matching Rules

You can add custom matching rules to match imported bank lines with account transactions in NetSuite. You can also choose the order NetSuite uses to run the rules.

The next time NetSuite imports bank data, or you run reconciliation rules manually, Intelligent Transaction Matching uses your new rules. Be sure to select one or more accounts for the custom rule to run on. NetSuite only uses the rule for imported bank lines from those selected accounts.

Note:

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.

For an example of a custom matching rule, see User Matching Rule Example.

For information about transaction types and matching types, see Transaction Types in Matching Rules and Bank Transaction Matching Types.

Note:

To make rules that run on the transaction number, match the Transaction ID from the imported bank line with the NetSuite Check Number. The NetSuite Check Number in the User Matching Rule window corresponds to the:

  • Check # on Bill Payments, Checks, Customer Payments, and Cash Sales.

  • Deposit # on Deposits.

  • Transfer # on Transfers.

  • Entry No. on Journal Entries.

  • Reference # on Credit Card Charges and Credit Card Refunds.

For details, see Transaction Types in Matching Rules.

To create a new matching rule:

  1. Go to Transactions > Bank > Reconciliation Rules.

  2. On the Reconciliation Rules page, under the User Rules heading, click New Rule.

    The Matching Rule window appears. The Accounts subtab is open by default.

  3. In the Rule Name field, type a name for your new matching rule. This is a required field.

  4. Filter the accounts in the list:

    • To switch from a list of all accounts to only the included accounts, click Show Included Only.

    • To filter by type, from the Account Type list, select an account type.

    • To search for an account, in the Search field, enter an account type, account name, description, or currency to search for.

    Note:

    The permissions on your user role determine which accounts you can view or edit. If you don’t have permission for an account, it doesn't appear in the list. For details, see Permissions for Banking Features.

  5. To include an account for your custom rule, check the box for the account.

    Tip:

    To include all accounts, check the box in the column header.

    You must include at least one account.

    NetSuite only runs the custom rule against transactions for the selected accounts.

  6. To specify the rule conditions, open the Conditions subtab.

  7. From the Transaction Type list, select the first transaction type for this rule condition.

    The list contains imported bank lines and account transactions in NetSuite. Your selection determines which options are available in the Primary Field and the other Transaction Type list. For example, if you choose an imported type, the other Transaction Type list displays only NetSuite types. The first selected Transaction Type for the first condition line restricts the available options for the subsequent condition rows. For information about choosing the appropriate transactions types, see Transaction Types in Matching Rules.

  8. From the Primary Field list, select the first field on which the system runs this matching rule condition.

    The options available in the list depend on the selected Transaction Type.

    Note:

    If you select the Memo option, the system matches on the Memo field in the Journal Entry or Check header. The rule doesn’t use memo values from transaction lines, and you can’t group transactions by memo.

  9. From the Operator list, select an operator for the matching rule.

    The selected Transaction Type and Primary Field determine which options are available in the list. Operators include:

    • Equals – Specifies that the selected fields must be equal. For example, the NetSuite date must equal the imported date.

    • Equals (Ignore Prefix) – Specifies that the selected fields must be equal, but ignores any alphabetic prefix or leading zeros on each transaction. For example, the Transaction ID 2134 still matches N2134.

    • Before – Specifies that the selected transaction type date can be before the other selected transaction type date. For example, the NetSuite date can be before the imported date.

    • After – Specifies that the selected transaction type date can be after the other selected transaction type date. For example, the NetSuite date can be after the imported date.

    • Within x Previous Days of – Specifies the number of days by which a date match can vary. A matching date can be the same as or up to the specified number of days before the other date.

  10. If you need to enter a value input (and the selected operator is Equals, Equals (Ignore Prefix), or Within x Previous Days of), in the Value field, enter the appropriate alphanumeric value.

  11. From the second Transaction Type list, select the second transaction type for this rule condition, if it is not already selected by default.

    The previously selected Transaction Type determines which options are available in the list. For example, if you chose an imported type first, this Transaction Type list displays only NetSuite types. For information about choosing the appropriate transactions types, see Transaction Types in Matching Rules.

  12. From the Compare Field list, select the other field the system runs this matching rule condition on, if it's not already selected by default.

    Make sure the compare field is the same data type as the primary field.

    Note:

    If you select the Memo option, the system matches on the Memo field in the Journal Entry or Check header. The rule doesn’t use memo values from transaction lines, and you can’t group transactions by memo.

  13. To add an extra condition, click the add icon.

    Note:

    To remove a condition, click the delete icon.

  14. To save and create your new custom rule, click Save.

    The new rule appears under the User Rules heading.

  15. To assign the order in which NetSuite runs the rules, use the icon to drag the rules into the desired order.

The next time bank data is imported, Intelligent Transaction Matching will use your new custom rules.

Related Topics

General Notices