1. Administering Account Reconciliation
  2. Performing Common Actions in Account Reconciliation Cloud
  3. Using Reports
  4. Working with Predefined Reports in Transaction Matching
  5. Generating Predefined Reports in Transaction Matching

Generating Predefined Reports in Transaction Matching

To generate reports:

  1. From Home, select Reports.
  2. Select the report you want to generate. You can use the quick Search option to find a report under a selected group.
  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.

    Note:

    For more information on parameters, see Generate Report for Account Reconciliation in REST API for Enterprise Performance Management Cloud
  6. Click Generate.

    Note:

    • You can use the Back button to preserve the parameter values that you have selected and regenerate the report.
    • You can use the Reset button to clear the parameter values that you have selected and regenerate the report.
  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.