NetCash Bank Automation Rules - Unmatching

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. 

NetCash will also automatically unmatch transactions created by NetCash automation rules that have a balance or account change. Additionally, NetCash will update a completed reconciliation to a pending status if there is a date change, beyond the tolerance. The walkthrough below will show how unmatching in NetCash works. 

Click here to view this walkthrough in full screen

Setup - Date Tolerance

• NetCash will not automatically unmatch a transaction if only the date changes, instead it will update a corresponding reconciliation has already been completed if it contains a transaction with a date change
• To configure the date tolerance, navigate to NetCash > Setup > System Setup View full size
• On the General Tab under the Reconciliations Section enter the Balance Changed Date Variance as desired. NetCash will use this value to determine whether it should change the status of a previous reconciliation if a date was changed by more than this amount. View full size
• Once entered, select Save

Step by Step Process - Account/Amount Change

• Once a change has been made to the underlying transaction that will unmatch it from the bank transaction, these can be viewed by navigating to NetCash > Reports > All Reports View full size
• Select the report Unmatched Detail View full size
• This will show the list of GL activity that was unmatched and the reason that the match was removed View full size

Step by Step Process - Date Change

• If a transaction included in a reconciliation has a date change that is more than the tolerance configured above, the status on the reconciliations page will change to be marked as balance changed
• To view this navigate to NetCash > Reports > Reconciliations View full size
• The affected reconciliation will change from completed to needing to be submitted for review  View full size