1. Reconciling Accounts with Account Reconciliation
  2. Reconciling Accounts in Transaction Matching
  3. Searching Transactions, Filtering, and Saving List Views
  4. Searching Transactions in Transaction Matching

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.

Note:

If a match rule was deleted, and there are existing matches based on the deleted match rule, the transaction search results do not show the rule information.

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 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. Profile attributes can be used when selecting columns and creating filters.

  • When searching for transactions, group attribute names are not displayed in Search. The individual member attributes are displayed and you can select one or more of these.

  • 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 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.
  • When using Actions > Export, the maximum number of transactions that can be exported is 5,000,000 for .csv format and 1,048,576 for Microsoft Excel. This includes the header row.