Unmatched Risk Dashboard [v26.2]
This feature is available for Enterprise License and Professional License users only. It is not available for Free License accounts, which operate with a single currency per legal entity and do not have reporting currency support.
Starting from version 26.2, the Dashboard includes a new Unmatched Risk tab that provides a portfolio-level view of unmatched items classified by risk level. Finance managers and reconciliation leads use this dashboard to identify high-risk unmatched items across all reconciliations for the selected period, monitor risk exposure by entity, and drill into specific items for resolution.
All user roles (Admin, Designer, Power User, and Viewer) can view the Unmatched Risk Dashboard.
To view the Unmatched Risk Dashboard:
- Navigate to the Dashboard module.
Click the Unmatched Risk tab.
The dashboard loads and displays data for the current period.
Use the following controls to filter the data:
Control Function Period Selects the period for which unmatched risk data is displayed. Status Filter Filters which reconciliations are included:
- Approved — Displays data for approved reconciliations only.
- All — Displays data for all reconciliations regardless of status.
- Review the unmatched risk data. The tab contains the following sections:
- KPI Cards — Four cards at the top: Total Open Items, High Risk Items, Medium Risk Items, and Low Risk Items. Each card displays the item count and total reporting amount for the selected period.
- Unmatched Items by Entity and Source Type — Displays unmatched items grouped by legal entity and reconciliation source type (Bank Account or Manual).
- Risk by Entity — Colour-coded chart showing the distribution of High (red), Medium (orange), and Low (green) risk items per legal entity.
- Top 10 Risk Items — Table listing the ten unmatched items with the highest risk scores for the selected period.
KPI Cards
The KPI cards display the following metrics for the selected period:
| Card | Description |
|---|---|
| Total Open Items | Total number of unmatched items across all reconciliations for the period, regardless of risk level. |
| High Risk Items | Total number of unmatched items classified as High risk, including items with no category assigned. |
| Medium Risk Items | Total number of unmatched items classified as Medium risk. |
| Low Risk Items | Total number of unmatched items classified as Low risk. |
Items with no category assigned are treated as High risk by default.
Top 10 Risk Items
The Top 10 Risk Items table lists the ten unmatched items with the highest risk scores for the selected period.
| Column | Description |
|---|---|
| Legal Entity | The legal entity the reconciliation belongs to. |
| Account Number | The GL account number for the reconciliation. |
| Category | The category assigned to the unmatched item. Blank if no category is assigned. |
| Risk | The risk classification: High, Medium, or Low. Items with no category assigned display as High. |
| Reporting Amount | The amount of the unmatched item in the configured reporting currency. |
| Risk Score | The calculated risk score for the item. See Risk Score Calculation below. |
| Age | The number of periods the item has remained unmatched. |
| Owner | The preparer assigned to the reconciliation. |
| Actions | View link — Navigates directly to the reconciliation detail page for the item. |
Risk Score Calculation
The risk score is calculated using the following formula:
Risk Score = (Item Amount ÷ Maximum Item Amount) × Risk Multiplier × (100 ÷ Risk Multiplier) × 100
| Variable | Description |
|---|---|
| Item Amount | The amount of the unmatched item. |
| Maximum Item Amount | The highest amount among all unmatched items in the period. |
| Risk Multiplier | 1 for Low, 2 for Medium, 3 for High. |
| Scaling Constant | 100 ÷ Risk Multiplier. For High: 33.3. For Medium: 50. For Low: 100. |
Example: An unmatched item of $7, where the highest item in the period is $10, classified as High risk:
Risk Score = (7 ÷ 10) × 3 × (100 ÷ 3) × 100 ÷ 100 = 9.9996 → rounded to 10
Scores are rounded using standard rounding (0.5 and above rounds up).
Currency Display
Amounts on the Unmatched Risk tab display in the configured reporting currency. If no reporting currency is configured, amounts display in each legal entity’s functional currency. To configure the reporting currency, see Managing Settings.