Reconciliation Report

​

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).

​

Steps

Start a New Report

Navigate to Reporting using the left menu on the Recital platform. Then click on the “New Report” button.

Add Report Configuration

Under the “Configure” section, enter the report name and description

Add Filter

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.

Data Point	Description	Typical Fields
Reconciliation	Results from completed runs (matched, partial, unreconciled)	unique_txn_id, amount, match_status, data
Transactions	Unified ledger across banks, PSPs, switches	txn_id, type, amount, currency, provider, created_at
Balances	Daily or intraday balances by institution/account	institution, account_id, provider, balance, currency, txn_date

Type: The available type depends on the selected Data Point. For Reconciliation data point, the available types are User Recon, Manual Recon, Automated ReconAvailable Types

Types	Description
User Recon	The reconciliation type where user uploads files, creates custom matching and transformation rules tailored to their reconciliation process
Manual Recon	The reconciliation type where you use a file on any file on any format, bank or provider data for reconciliation
Auto Recon	The reconciliation type where you schedule day and time intervals to connect your provider, bank or internal record and run reconciliation
Real-time Recon	Instantly match transactions across bank, provider, internal record, ERPs, payment gateways using accurate, up-to-date financial record

Date: 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 report

Pick Metrics

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.

Supported Metric Logic

Logic	Description	Example
Sum	Returns the sum of the data column selected with the options field	Sum(txn_amount)
Count	Returns the count of the data column selected with the options field	Count(unique_txn_ID)
Average	Returns the average of the data column selected with the options field	Average(txn_amount)
Expression	Returns the result of apply an expression, e.g., addition, subtraction or multiplication in an expression with data columns	txn_amount minus expression fees, returns net fees

Common Data Columns for Reconciliation

Dimension	Description
Unique_txn_Id	RRN
Account	Bank Account # or wallet ID
Currency	NGN, USD, etc.
Status	Reconciled, Partial, Unreconciled
Date	Day, Week, Month, Time

Add Pivot (optional)

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.

Preview & Validate Report

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.

Export Report

To export the data, simply click on the Download button, and choose the export format: Excel, PDF.

Save Report

Save Reports for later use.Saved reports appear on the Reporting home page, where they can be assessed and spooled again or edited.

​

Sample Custom Reconciliation Report Output

​

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.

​

Troubleshooting