Clear reversal company transactions in advanced bank reconciliation
This article explains how to clear reversal company transactions in advanced bank reconciliation. As of Microsoft Dynamics 365 Finance version 10.0.39, the Modern bank reconciliation feature provides this functionality.
There might be payment journals that are reversed in the system, but that don't have any records at the bank. This feature lets users clear reversal company transactions in advanced bank reconciliation without matching them to bank statement transactions.
Prerequisites
- Turn on the Modern bank reconciliation feature in the Feature management workspace.
- Import a bank statement.
Clear reversal company transactions on the reconciliation worksheet
To manually clear reversal company transactions on the reconciliation worksheet, follow these steps.
- Go to Cash and bank management > Bank statement reconciliation > Bank reconciliation.
- Open or create a bank reconciliation worksheet.
- On the Unmatched transactions tab, select the company transactions to match. The total amount of the selected company transactions must be 0 (zero).
- Select Match.
Clear reversal company transactions by using matching rules
To use matching rules to automatically clear reversal company transactions, follow these steps.
Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rules.
Select New to create a matching rule.
Set the matching rule code and Name fields.
In the Action field, select Clear reversal company transaction.
On the Step 1: Find reversal company transactions FastTab, define the criteria.
On the Step 2: Find original company transactions FastTab, define the criteria. The following fields are available:
- Require manual matching when multiple original company transactions are found – Select this option to manually review and confirm the correct original company transaction that should be matched. Otherwise, the matching rule matches the first transaction that's found.
- Transaction type, Payment reference, and Document type – The value of these fields must match the reversal and original company transactions.
Select Save and then Activate.
Optional: You can include the matching rule in matching rule sets.
Go to Cash and bank management > Bank statement reconciliation > Bank reconciliation.
Open or create a bank reconciliation worksheet.
Select Run matching rules.
Select either the matching rule that you defined or a matching rule set that contains that matching rule.
Select OK to run the automatic matching.