NetCash Automation Rules - Grouped GL Matching

Overview

NetCash supports grouped GL matching, which allows users to match one bank transaction to many NetSuite general ledger (GL) transactions, many bank transactions to one GL transaction, or many bank transactions to many GL transactions. For a grouped match to be found, the rule must include identifiable grouping criteria. NetCash will also group transactions by any matching criteria defined in the rule.

Grouped matches are displayed differently from one-to-one matches on the Confirm Rule Matches and Match History pages. Before confirming a match, users may remove individual transactions from a grouped match on the GL Match page.

Click here to view the walkthrough in full-screen.

Step-by-Step Process - Setup the Rule

  1. Navigate to NetCash > Setup > Automation Rules and select New
  2. On the new Automation Rule, enter desired Name and select the Type: GL Match
  3. Select the applicable Automation Rule Group, Amount Variance Limit, and Date Tolerance. For detailed descriptions of these fields, refer to NetCash Bank Automation Rules - Auto Matching | Support Site 
  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 tab
  6. On the Grouping tab, define the criteria by which GL and/or bank transactions will be grouped for this automation rule.
    1. Select New Grouping. For each grouping entry, specify the Source (either Bank Transactions or NetSuite Transactions) and the Field to group on. Multiple grouping criteria may be added. NetCash will group transactions that share the same value across all defined grouping fields.
    2. One of the most common Grouping field selections is Date.
  7. Update the Transaction Template tab as desired (optional)

Step by Step Process - Review Matches

  1. If the Automation Rule requires confirmation before matches are completed, navigate to NetCash > Bank > Confirm Rule Matches. Filter by Bank Account, Automation Rules, and any other applicable criteria to display pending grouped matches. 
  2. Grouped matches are identified by a Grouped label in the upper left corner of the match card. Select the expand arrow to view the individual transactions included in the group.
  3. To remove one or more transactions from a grouped match before confirming, select the pencil icon on the match card to open the match editor. Deselect any transactions that should be excluded, then save the updated match. 
  4. Once grouped matches have been approved or auto-confirmed, navigate to NetCash > Bank > Match History to review completed matches. Select More... on any match card to view additional details about the grouped transactions included in that match. 
Was this article helpful?

Knowledge Center