NetCash Automation Rules - Auto Unmatching
Overview
In NetCash, users can manually unmatch transactions and delete or void the corresponding NetCash-created transaction, if applicable.
Additionally, NetCash will 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
- 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.
- 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
- Select the report Unmatched Detail
- This will show the list of GL activity that was unmatched and the reason that the match was removed
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
- The affected reconciliation will change from completed to needing to be submitted for review
