Generating Predefined Reports in Transaction Matching

Predefined reports (listed below) 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.

Additionally, you can create custom reports. See Generating Custom Reports

Note:

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

Table 14-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 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, 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, 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.

To generate reports:

  1. From Home, select Reports.
  2. Select the reports.
  3. For Output Format, select one of the following:
    • XLSX - not supported for graphs.
    • HTML - not supported for graphs and charts.
    • PDF
    • CSV - does not use template and is better at faster data retrieval.

      Note:

      For reports that contain more than 10,000 records, it is recommended to use the CSV format.
    • CSV (Formatted) - is best suited for a simple data table with formatted data and does not support images, graphics, or styling in the template.

      Note:

      The CSV (Formatted) format takes additional time to generate the report to honor template formatting when compared to the CSV format. Therefore, you can select CSV to generate the data quickly or CSV (Formatted) to generate formatted template based data.

  4. Click Generate.
  5. For each parameter, select the value.
  6. Click Generate.
  7. Select Open or Save File to save the ZIP file.

The report generation process uses a backend job framework that runs report jobs in the background. If the report has an error, for example, if the size is greater than the recommended size, you see a message stating the error in the Generate Report dialog before the report is generated. For reports with very large number of records, it is recommended to use filtering to break the report down to lesser records.