Searching Transactions in Transaction Matching

When you load transactions across different profiles, transactions are either suggested matches, matched, or unmatched. With a large volume, it can be difficult to find a particular transaction in a given status. The Transactions tab under the Matching card has a centralized search of transactions and adjustments for a given match type across all statuses making finding what you are looking for much easier.

The Match Type selection drives the loading of the page and what you see. The first 5000 transactions for this match type, data source and Account ID are displayed.

The default columns the first time you use Transaction Matching are Data Source, Transaction ID, Balancing Attribute (Amount), Accounting Date, Match ID, and Status. Then once you change the list view, it will default to last view used.

Features

Some useful features of transaction searching:

  • You can select the columns from the Actions menu. See Selecting Columns While Searching Transactions in Transaction Matching.
  • You can sort the columns one at a time. If no sort order is specified, then the default sort order will be Transaction ID and Account ID.
  • You can use filters from the Filter Bar to narrow your list. See Using Filters When Searching Transactions in Transaction Matching.
  • The columns and filters you set are retained
  • You can save your view to reuse it, and it appears in the Saved List drop down list next to the search field. The Saved list is by user and retains the:
    • Filter selected

    • Columns Selected

    • Sort Order

  • You can view the current matches by clicking on Match ID.
  • You can view the transaction history for audit trail purposes by clicking on Transaction ID.
  • For adjustments, Transaction ID displays the Adjustment ID, Accounting Date displays the Accounting Date of the Adjustment, and Amount displays the variance or amount of the adjustment.
  • You can perform an Unmatch of Confirmed or Suggested matches from Transactions.
  • You can view supporting details by clicking on Support ID or Support Type.
  • To view a list of transactions in csv or Excel format offline, use Export from the Actions menu.
  • If your search times out, you can use Cancel and you will see an error message to review your filtering criteria.
  • You can specify a search mode to use while searching for transactions. A Service Administrator can configure the search mode in the Transaction Matching configuration settings.
  • You can create an alert for one or more transactions, add an existing alert to one or more transactions, or remove an alert's association with a transaction.

Restrictions

Here are some restrictions to note:

  • For now, there is a single select for Account ID. This will change to allow multiple select in an upcoming release.

  • You cannot search by date.
  • If you use the Matched By column, you only see the user for manual matches since the system lists an automatic designation for Auto Matched transactions.

Other Useful Links

For more information on filtering, searching, and saved views, see Searching Transactions, Filtering, and Saving List Views