About Predefined Reports in Transaction Matching

Predefined reports for Transaction Matching are available to Service Administrators for most of your reporting needs and are a useful starting point for report creation.

These reports are available whether you are using the sample application or create a new application. You are able to review the query used to create the report and see the parameters. The advantage of using the reports using the sample application is that you can see how the report comes out with data in it and whether that report works for your needs.

Note:

To avoid report errors, you must enter the required parameters.

Table 23-4 Report Descriptions and Required Parameters

Report	Description	Required Parameters
Reconciliation Configuration	Displays the list of reconciliations and the configuration assigned to each. Fields on this report include: reconciliation ID, name and match type name, preparer name, and description.	Name––The name of the generated report zip file. Account ID-Optional:the identifier associated with this reconciliation Match Type––Optional:Choose a match type from the drop-down list of values. Optional: Preparer––Optionally select a preparer.
Match Type Configuration	Displays the list of match types and the configuration assigned to each. Fields on this report include: match type ID, name, and description, calendar name, status, number of match processes, number of data sources, source systems and sub systems, format name, and count of rules. If multiple data sources are used as source systems and sub systems, all will be listed.	Name––The name of the generated report zip file. Status––Choose a status from the list of valid values (i.e. Approved or Pending).
Closed Adjustments	Displays the list of adjustments with a status of Closed. Fields displayed on report include transaction type, id and description, source, created date, accounting date, and amount.	Name––The name of the generated report zip file. Account ID––An identifier for a reconciliation. Match Type––Choose a match type from the list of valid values.
Open Adjustments	Displays the list of adjustments with a status of Open. Fields displayed on report include transaction type, id, name, description, source, created date, accounting date, and amount.	Name––The name of the generated report zip file. Account ID––An identifier for a reconciliation. Match Type––Choose a match type from the list of valid values.
Reconciliation Status	Displays the status of reconciliations, in terms of count of unmatched transactions, count of supported transactions, and count of open adjustments. Note: The unmatched transactions, supported transactions, and open adjustments are from all sources irrespective of match process.	Name––The name of the generated report zip file. Account ID––An identifier for a reconciliation. Match Type––Choose a match type from the list of valid values.
Supported Transactions	Displays the list of reconciliations that have supported transactions. Fields include: reconciliation ID, name, transaction type, transaction ID, name, and description, source, amount, and number of transactions.	Name––The name of the generated report zip file. Account ID––An identifier for a reconciliation. Match Type––Choose a match type from the list of valid values.
Match Type Data Source Configuration	Displays the configuration settings for all data sources in a match type. Fields displayed on the report include match type name, match type status, data source ID, and details of the data source attributes.	Name––The name of the generated report zip file. Match Type - Choose a match type from the list of valid values.
Match Type Rule Configuration	Displays the configuration settings for all match rules in a match type. Fields displayed on the report include the name of the match type name, match type process, number of data sources, source system’s data source, subsystem’s data source, and details of the rules.	Name––The name of the generated report zip file. Match Type - Choose a match type from the list of valid values.