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.
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:
- 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.
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.
To search for transactions in Transaction Matching:
- From Home, select Matching and then select Transactions.
The first time you access this, fields will be populated based on the first Match Type.
- You can use the Match Type drop down list to select a match type such as in the example shown.
Note that you can see the count of items displayed for this Match Type, Data Source, and Account ID on the right side.
To see all available columns, from Actions, choose Select Columns and you can select from any of these columns:
Table 8-1 Available Columns
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|
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.|
|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.|
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|
Required. All the match types having a data source and at least one attached profile are available. Only one can be selected.
Required. Data source for the match type selected. Only one can be selected.For example. GL or BANK.
Does Not Equal
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.
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