Generating Custom Reports

You can create custom reports in addition to using the predefined reports in Reconciliation Compliance or Transaction Matching.

Building custom reports in either Reconciliation Compliance or Transaction Matching involves these steps and can only be performed by a Service Administrator:

  • Create a query whose definition can then be exported as an XML file. For a Reconciliation Compliance or Transaction Matching query, see Creating a Query.

  • Create a template (which must be in RTF format) by importing the XML file into Word. See Creating a Template

  • Set up a report group to group individual reports. See Creating a Report Group

  • Optionally, set up the report definition. See Creating a Report Definition

  • Once a custom report has been built, the service administrator or other users given access can generate the report which uses both the query and the template you created. The report can be set with a default output of XLSX, HTML, PDF, CSV, or CSV (Formatted). See Generating the Report

    Note:

    PDF output will limit the number of columns it can display to the width of the paper size selected. If you have more columns that can fit on your selected paper size, we advise you to use another output format like html or xlsx.