NetCash Bank Automation Rules - Transaction Creation
Overview
NetCash seeks to make bank reconciliations as easy and automated as possible. To assist with this, NetCash has automation rules to perform matching without manual processes. There are three types of automation rules offered in NetCash: Auto-Matching, Transaction Creation, and Auto Transfers.
This article will go over in detail how to setup Transaction Creation. For information on the other automation rules types reference the NetCash Automation Rules article.
Navigating to Automation Rules
- Navigate to NetCash > Setup > Automation Rules.
- This is a list of all automation rules that have been created. To create a new rule select New +.
Setup
- On the Automation Rule record select the Type as a Create Transaction type. This will cause the page to refresh and change the visible fields to only those that relate to this rule type.
| Field Name | Required | Field Description | Example |
|---|---|---|---|
| Name | Yes | This is a descriptive name to help identify which accounts this transfer rule relates to. | Transfer Rule |
| Group | Yes | This field is where the user would select the group/groups this rule relates to. This article explains Automation Groups. | All Banks |
- Once the fields are set, select Create and select the subtab titled Filters.
- Two new subtabs will appear: Filters and Transaction Template
- Rule Filters allow users to specify which transactions should be filtered out of the automation rule. There can be as many filters as desired for the automation rule.
- Select New Filter at the bottom of the Automation Rule record.
- Fill out the below information for each desired filter:
| Field Name | Field Description |
| Source | This field is where the user can specify which transactions they want the filter to apply to (Bank Transactions). |
| Field | This is where the user can specify which field they want the filter to look at. |
| Operator | This is the comparison operator that is used to evaluate the fields "Field" and "Value". |
| Value | This is where the user can specify the value that should be filtered out of this automation rule. |
- For example, if only transactions with a Category of Fee should be included in this automation rule then the "Source" field would be "Bank Transactions", the "Field" would be "Category", "Operator" would be "Is" and "Value" would be "Fee".
All filters will be applied to the transactions. If either of two filters can result in the transaction creation, two different transaction creation rules will need to be created.
- Once the filters are set, select the subtab titled Transaction Template
- When auto creating a transaction, it is necessary to specify which offset GL account and segmentations should be used.
- For a "Create Transaction" type, the system will default to using the Bank Account and Offset Account information from the corresponding Bank Account records. The information from those records is what will be used when the transaction is created.
- If this information is not correct for this specific rule, click the pencil icon to the right and correct the applicable fields.
- Once all the necessary information has been filled out, it is time to test the automation rule.
Automation Rule Testing
- Testing required creating/watching for transactions that are expected to meet the transaction creation criteria, then going to the Review Matches page to make sure the transaction was created and matched correctly.
- Transaction auto-creation runs every morning. However, there is a script available titled "NetCash | Bank - Automate - Create | MR" that can be deployed in order to test the automation rule immediately.
- Once the automation rule has been ran, navigate to the Review Matches page by going to NetCash > Bank > Review Bank Matches.
- On this page, change the "Matched By" filter to be "Auto Match" and the "Automation Rule" filter to be the newly created create transaction rule.
- This will bring up a list of all transaction that were created by the automation rule.
- If the rule is not creating the correct transaction, simply click the Unmatch button. An error message will appear asking if you want to delete the transaction NetCash created which allows you to select Delete.
- Then go back to the Create Transaction rule and make the necessary adjustments.
- If everything looks correct, then there is nothing additional needed for your transaction creation rule.