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 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 Transactions are 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 Action menu. See Selecting Columns.
  • 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.
  • 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.
  • 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.

Restrictions

Here are some restrictions to note:

  • For now, there is a single select for data source and 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.

Searching Transactions

To search for transactions in Transaction Matching:

  1. From Home, select Matching and then select Transactions.
    Transaction search

    The first time you access this, fields will be populated based on the first Match Type.

  2. You can use the Match Type drop down list to select a match type such as in the example shown.
    Match Type drop down

    Note that you can see the count of items displayed for this Match Type, Data Source, and Account ID on the right side.
    Count of Items on Transaction Search

Selecting Columns

To see all available columns, from Actions, choose Select Columns and you can select from any of these columns:

Table 8-1 Available Columns

Column Name Filterable Description
Account ID Yes  
Adjusted Yes

Yes = Confirmed and has adjustment or Confirmed Adjust.

No = if not Confirmed (meaning Suggested or not yet matched)

Adjustment Type Yes Adjustment type used for the match with adjustment. Blank for unmatched transactions and exact matches.
Age Yes Number of days between today and Accounting Date. Age is calculated based on the Accounting Date.
Created Date Yes Imported date.
Edited Yes Yes = Transaction was ever Edited or Split. Otherwise, No.
Extract Status Yes Open or Closed. Relates to status of the transaction/adjustment journal export process.
Import Job ID Yes  
Journal Export Job ID Yes  
Match ID Yes

Blank = Unmatched Transactions

Link to view Match for both Data source and adjustments.

Match Process Name Yes

Blank = Unmatched Transactions

Matched Yes Yes = Transaction status is Confirmed or Confirmed Adjust. Otherwise, No.
Matched By Yes You cannot search by user since the system lists an automatic designation for some unmatched transactions.
Matched On Yes Date match performed. You cannot search by date.
Rule Name Yes Manual Match Rule for Manual match and actual rule name for other rules
Rule Type Yes Blank for manual and rule type for other rules
Source Yes The data sources available for the Match Type. One data source a time.
Status Yes
  • Suggested Match

  • Confirmed Match

  • Suggested Adjust

  • Confirmed Adjust

  • Supported

  • Unmatched

Support ID Yes Available if the transaction has support irrespective of the current status of the transaction. Support details display when you click Support ID.
Support Type Yes Support type used while creating Support. Blank for a transaction that does not have a support.
Transaction ID Yes System assigned value when transaction is loaded. Value is unique per data source.

Using Filters

Can use the filter bar and + Add a Filter. One Match Type and one Data Source must be selected.

You cannot change the Data Source and Account ID fields.

The filterable attributes are:

Table 8-2 Filter Bar Attributes and Supported Operands

Attribute Supported Operands for Filtering Description
Match Type Equals

Required. All the match types having a data source and at least one attached profile are available. Only one can be selected.

Data Source Equals

Required. Data source for the match type selected. Only one can be selected.

For example. GL or BANK.
Account ID

Equals

Does Not Equal

Contains

Starts With

Ends With

Is Blank

Is Not Blank

If you do not select an Account ID, all Account IDs are displayed.

All attributes in Available Columns   You can add any of the attributes listed here as filters. See Selecting Columns.

Note:

Selections available in filtering are not dependent on other filters that have already been selected. For example, if the filter is set to Match Process = "GL to Bank", the Match Rule filter will show the selections across all the Match Processes for that Match Type, not just GL to Bank Match Processes.

Actions you can perform relating to filters are:

  • Hide or unhide a filter

  • Clear a filter or clear all filters

  • Add a filter

  • Remove a Filter

Performing Other Actions from Transactions

There are several actions you can take directly on transactions from Transactions. These actions include:

  • Unmatch transactions - to Unmatch transactions right from Transactions, you can select one or more transactions and click Unmatch. You can see that you can Unmatch, either Confirmed or Suggested Matches.
  • Viewing Supporting Details - click the Support ID or Support Type column to open the Supporting details which is the same information you would see from the Unmatched dialog.
  • Viewing Current Matches - click the Match ID column to display the current matches and this shows you the transactions and adjustments involved.
  • View Transaction History -

    You can also see an audit trail or history of a transaction by clicking the Transaction ID.
    Transaction History

  • Export transactions to view offline -

    You can use the Export from the Actions menu to view a list of transactions offline in either csv or Excel (xlsx) format. See Exporting Transactions to CSV or Excel Format.

    Note:

    An export will use your filtered list of transactions, not selected or highlighted transactions.

Other Useful Links

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