Performing a Purge of Transactions in Transaction Matching

Purging allows you to permanently remove transactions.

You can perform a purge of matched transactions in Transaction Matching that are no longer needed in your environment. Matched transactions include confirmed matches and confirmed one sided adjustments. The deletion on the Purge Transactions dialog is based on specifying the Match date, and then selecting the Match Type and Account IDs to be purged.

The purge of matched transactions also deletes all other associated objects such as adjustments, adjustment details, associated supporting details and audit history. Since this is powerful, we strongly recommend that you backup a snapshot of your application before performing the purge.

A Service Administrator can specify the batch size used when purging transactions by setting the Batch Size option in the Transaction Matching configuration settings.

Note:

We recommend as a best practice that you align your purge cycles between Transaction Matching and Reconciliation Compliance, but it is not required. Be aware that the drill-back from Reconciliation Compliance to Transaction Matching may not show some or all Transaction Matching transactions if you decide to purge Transaction Matching on a different schedule than Reconciliation Compliance.

To perform a purge of matched transactions:

  1. From Jobs, select the Transaction Matching tab.
  2. From Actions menu, select Purge Transactions.
    Purge Transactions option from Action menu
  3. On the Purge Transactions dialog, you enter the following information in order to narrow down the matched transactions you want to delete:
    1. In Delete matched transactions with Match Date older than or equal to the following number of days, enter the number of days counting back from the current date to start deleting matched transactions. The deletion will include the date you specify.

      For example, if you are requesting deletion of matched transactions that have a Match Date older than or equal to 180 days away from the current date of May 28, 2021, that would be November 29, 2020. Matched transactions that have a Match Date equal to or older than November 29, 2020 will be deleted. Note that 180 days is the default. You can enter any number between 0 and 99999.

      Here's a second example showing a request to delete matched transactions with a Match Date older than or equal to 10 days away from a current date of May 28, 2021, which would be May 18, 2021. Matched transactions that have a Match Date equal to May 18 or older than May 18th will be deleted.


      Example 2. Showing Purge Transactions with Match Date greater than 10 days away
    2. Select the Match Type (required) - select a Match Type from the drop down list.
    3. Select the Account IDs (optional) - use the drop down list of operators (Equals, Does not Equal, Starts With, Ends With, Contains, Does not Contain) to help filter the list of matched transactions to delete.
    4. Click Submit and then click Continue with Purge to confirm the submission.

      Note:

      It is strongly recommended that applications be backed up as a snapshot before you continue.
  4. You will see a Purge Transactions job on the Jobs dialog.
    Delete (Purge) Transaction job on Jobs dialog

What Happens During Purge Processing in Transaction Matching

  • The system will lock the Match Type during processing so other tasks like import transactions, auto match, and interactive matching cannot be performed during the delete process.

  • The system runs a validation check to ensure Profiles linked to Balance Comparison with Transaction Matching or Account Analysis with Transaction Matching have no matched transactions with an Accounting Date greater than the Locked Through Date that are going to be purged. There will be a log file message if any of the transactions (or adjustments) to be purged have at least one transaction (or adjustment) with an Accounting Date that is greater than the Locked Through date, and the purge for that Profile will be ignored.

  • The system does not update balances summaries after a purge.