Analysis

Analysis contains pivot information for transactions loaded in the selected Time Period by data set and matches made during the Time Period by rule, variances, or comments and attachments based on a selected Time Period.

The Time Period dropdown includes the following options:

• Periodic

• YTD

• Trailing 12 Months

NOTE: Periodic is the default time period.

The following operational reports are available from the Analysis page based on the user’s transaction access:

• Transactions by Data Set displays totals for each data set as well as grand totals for Unmatched, Suspended, Manual, Suggested, and Automatic matches. Each row also shows the percentage matched.

• Matches by Rule displays totals for Matches, Transactions, Pending, and Unapproved for each rule included in the workflow. The information is also displayed in percentage form for Accepted and Approved and provides the Last Match Date.

• Matches with Variance lists matches containing a variance that can be filtered and/or sorted by Status or Approval detail, Reason Code, amount information, or Transaction by data source

• Matches with Comments or Attachments lists matches that contain comments or attachments

Select a row in any of the above grids and click Details to view the complete Match Details.

To create custom reports for Transaction Matching, the following tables and views are useful:

• txm.Transactions

• txm.vAllTransactions

• txm.vMatchedTransactions

• txm.vNonMatchedTransactions

If you have a large volume of data, use a large data pivot grid.

The data can be reviewed further by utilizing the following functions:

Maximize a section

Minimize a section

Inspect data

Export data