Preview Reconciliation Rules

Test reconciliation rules before making changes

Reconciliation rule previews help you understand the impact of changes to reconciliation rules without recording the results. It helps you verify that the updated set of rules will yield more automatically reconciled records while minimizing errors.

From the Reconciliation Rules page, you can make one or more changes your rules, for example, adding new rules, changing rule priority or conditions, or deactivating rules. From here, you can preview, save, or cancel the changes.

You can select the date range of the transactions analyzed in the preview. The latest 250 Transactions from those dates will be evaluated against all of the Expected Payments during that period. Preview results are returned in real-time to allow you to refine and iterate rules as needed.

You can understand the performance of your proposed rules using statistics as well as the underlying data. The statistics include the match rate, which is the percentage of transactions reconciled by the proposed rules. You can also view a table with the raw transaction data. You can filter the data by status and reconciliation rule to find interesting transactions, for example:

  • New matches: Transactions reconciled by the proposed rules and not by the current rules are likely intended improvements to reconciliation (except in the case of false positives).
  • Lost matches: Transactions reconciled by the current rules but not reconciled by the proposed rules are likely unintended regressions (except in the case of reducing false positives).
  • Unreconciled items: Transactions not reconciled by the current or proposed rules are interesting examples to look at for future automation opportunities.

Once rule changes are saved, future reconciliation attempts will use the new rules. This includes when new Transactions and Expected Payments are created. Additionally, all unreconciled transactions in the selected date range of the preview will also be immediately scheduled for reconciliation.