NetCash Bank Automation Rules - Grouped Auto-Matching

Overview

NetCash has the ability to create grouped auto-matches for situations where a user wants to match one bank transaction to many NetSuite general ledger (GL) transactions, many bank transactions to one Netsuite GL transaction, or many bank transactions to many NetSuite GL transactions. For a match to be found, you must have identifiable information that you want to group on. NetCash will also group transactions by any matching criteria included in the rule. 

Grouped matches will be displayed differently from one-to-one matches on the Auto Match and Review Matches page. Users can also remove transactions from a grouped match on the Auto Match page before confirming the match.  

The walkthrough below explains how to create an auto-match rule with grouping and the changes to the Auto Match and Review Matches page. 

Click here to view the walkthrough in full-screen.

Step by Step Process - Setup

  1. Navigate to NetCash > Setup > Automation Rules and select New
  2. On the new Automation Rule, enter desired Name and select the Type: Auto-Match
  3. Select the applicable Automation Rule Group, Amount Variance Limit, and Date Tolerance (for more information on these fields, review the article NetCash Bank Automation Rules - Auto-Matching) 
  4. Enter any relevant filters on the Filter tab to limit the scope of what will be matched
  5. Enter relevant matching criteria on the Match Criteria
  6. On the Grouping tab, dictate how to group the GL and/or bank transactions for this automation rule
    1. To do so, select New Grouping and then select the source and field that should be grouped on
  7. Update the Transaction Template tab as desired

Step by Step Process - Review

  1. If Grouped Matches require approval, navigate to NetCash > Bank > Auto Match Bank Transactions and select the applicable Bank Account, Automation Rules, etc. 
  2. Grouped automations will be noted in the upper left hand corner and can be expanded to see the underlying transactions
  3. If transactions should be removed from the group match, select the pencil to edit the match
  4. If grouped matches have been approved or do not require approval, navigate to NetCash > Bank < Review Bank Matches to review, more information on the match can be seen by selecting the "More..." button
Was this article helpful?