Contents

Unmatching Transactions

Caroline Buckland Updated by Caroline Buckland

Overview

The unmatching process allows users to reverse the reconciliation process for reconciled transactions. This functionality will be useful if a user has incorrectly matched transactions or perhaps, where a match has been made assuming a future bank adjustment, but a GL adjustment is required.

When reconciled, transactions are assigned a match id that is constant for all transactions that have been matched. During the unmatching process the transactions with the selected match id are flagged as unreconciled and any journals which may have created as a result of the initial matching, are reversed. If the original transaction has been sourced from the Accounts Payable system, the unmatching process will also flag the Accounts Payable transaction as unreconciled.

If during the initial matching process, a bank adjustment journal or GL adjustment journal was created, then reversing journals will be created and posted during the unmatching process. Matching initial and reversal bank reconciliation generated adjustment journals are flagged as reconciled, and will not appear as unreconciled items in the Bank Reconciliation reports and enquiries.

The Unmatching screen can be reached in two ways; from the Bank Reconciliation Process menu the user should select the Matched Transactions option :

Or from the Manual Reconciliation screen there is a button available:

The following details are required from the Matched Transactions option.

Company Enter a two character company code for which Bank Reconciliation Company Controls have been created. Current user company will default into this field.

Match ID From Optional field used to limit the number of transactions listed. Match ID is a number assigned to reconciled transactions. This number is constant for transactions that have been reconciled together.

Match ID To Optional field used to limit the number of transactions listed. Match ID is a number assigned to reconciled transactions. This number is constant for transactions that have been reconciled together.

If the Extended Selection option is chosen, using the options at the top of the screen, more detailed search options can be entered:

When entering a code where a range of values is required (e.g. Reconciliation Code), then both the from and to values should be entered, even if they are the same.

On selecting 'Search’ the user will be presented with the Manual Reconciliation Matched Transaction screen.

The user can then select a relevant transaction and select Edit: Unmatch Trans, which will take the user to the Manual Reconciliation Unmatched Transactions screen. All transactions with the same match id will be listed on this screen.

To cancel the process without unmatching the displayed items, click the ‘Return’ button.

To proceed with the unmatching selecting the ‘Save’ button.

If items to be unmatched include a GL or Bank adjustment journal, a window will appear identifying the posting date. This date will depend on how the Company Controls have been set. The options are to have the default as either the current date or the original posting date.

The user can accept or change the posting date of the reversal journal. Selecting Save to update.

All items will be unmatched and any associated journals (GL Adjustments/Bank Adjustments) that have been generated as a result of the original reconciliation transaction will be reversed. In addition to this as each transaction is in effect being ‘unreconciled’ it will have the reconciled flag removed as it is returned to the unreconciled items list

Was this article useful?

Bank Reconciliation Take-on

Contact