Skip to main content

​
Create a New Reconciliation Report

​
Prerequisites

  • Roles: Owner, Admin, Reconciliation Officer, Treasury Officer, or Chargeback Officer (any role with “Reporting:Create”).
  • Data Availability: At least one completed Run (for reconciliation outcomes) or active data sources (Transactions, Balances).
Reports are generated from normalized, reconciled, and versioned datasets to ensure auditability.

​
Steps

Creating a custom reconciliation report is a straight forward, self-service process.
Navigate to Reporting using the left menu on the Recital platform. Then click on the “New Report” button.
Under the “Configure” section, enter the report name and description
Use the “Filter” section to precisely specify the dataset you need to power your custom report.Data Point: Most finance ops, start with Reconciliation. Other available data point may include balances, transaction, etc.Type: The available type depends on the selected Data Point. For Reconciliation data point, the available types are User Recon, Manual Recon, Automated ReconAvailable TypesDate: For Reconciliation data point, this should be the date(s) of the reconciliation run. Select the same date for start and end date, if you want to only want reconciliation run outcome data within the same day. Select a date range for the start and end date, if you use the run outcome data for more than one day.Source: For Source, select the reconciliation name for the reconciliation you want to generate a custom report for.Runs: Choose the reconciliation run structured output data for your reportAnalysis Type Use Analysis type to select one or more files/data source in the selected reconciliation runs for your reportFilled New Report page on Recital's Custom Report Builder
Use the Metrics section to configure the specific values you want to see in your report.To add a Metric, simply the following:
  1. Ensure you have filled the configure and filter sections of the report
  2. Within the Metric section, click the “Add Metric” button
  3. Use the first drop down field to choose a metric logic, e.g., SUM, COUNT, Percentage or Expression
  4. Optionally, select a name for the metric to override the defaults
  5. Use the options field to select a data column to apply the select metric logic on
You can add as many metrics as possible. To add more metrics, simply do the following:
  1. Keep clicking on “Add Metric” to add more metrics
  2. Enter the metric logic, optional metric name and data column to apply the metric logic on
To remove a Metric, simply click on the delete icon beside the Metric.Also you can generate only one report or a separate report per selected file in the “Analysis Field”. To generate separate report per file, do the following:
  1. Ensure you have filled the configure, filter and metric sections of the report
  2. Check the “Compare” option, under the Metrics section,
  3. Use the File tab to specify the exact metrics you want to generate for each file for better comparison.
Recital Reporting Pivot UISupported Metric LogicCommon Data Columns for Reconciliation
Use the Pivot section to configure rows for crosstab/grouping views.To add a pivot,simply do the following:
  1. Under the Pivot section, click the “Add Pivot” button
  2. Specify the the column/field you want to use to slice/group the report
To add more Pivots, simply repeat the step above.To remove a Pivot, simply click on the delete icon beside the Pivot.Recital Reporting Pivot UI
Reports render automatically on view section as you add in the metrics and pivots.Validate totals against known checkpoints (e.g., daily GL totals, prior day balance). Fix filters or metrics or pivots if results look unexpected.
To export the data, simply click on the Download button, and choose the export format: Excel, PDF.Recital Report Export UI
Save Reports for later use.Saved reports appear on the Reporting home page, where they can be assessed and spooled again or edited.Recital Report Home Page, with Existing Report List

​
Sample Custom Reconciliation Report Output

File A File B

​
Best Practices

  • Name Reports clearly: Make reports easy to search and classify.
  • Lock Filters: Avoid accidental scope drift for recurring reports.
  • Version Awareness: Tie each report to a Runs Version when using reconciliation outcomes.
  • Validate Totals: Reconcile totals with GL or prior-day check figures.
  • Limit recipients: Reduce noise—send only to people who need it.
Use the same filters, metrics and pivots across scheduled reports to maintain comparability over time.

​
Troubleshooting