Unmatched Risk Dashboard [v26.2]
Note: 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.
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.
Note: The Unmatched Risk Dashboard displays data by Reconciliation and includes both Bank Account and Standard reconciliations. The Top 10 Risk Items section is organized into GL Accounts, Bank Accounts, and Support Lines (Standard Reconciliations) categories.
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. |
Note: Items with no category assigned are treated as High risk by default.
Unmatched Items by Reconciliation [v26.3]
The Unmatched Items by Reconciliation chart displays unmatched items grouped by reconciliation, showing the distribution of High (red), Medium (orange), and Low (green) risk items for each reconciliation.
Sort order:
Primary: Total number of High risk items (descending).
Tie-break: Weighted score calculated as (High × 3) + (Medium × 2) + (Low × 1).
This ensures that reconciliations with more high-risk items rank higher, regardless of total volume.
Display:
The chart displays the Top 10 high-risk reconciliations by default.
Numbers are shown in black text (no heat-map colour coding based on item volume).
Top 10 Risk Items [v26.3]
The Top 10 Risk Items section lists the ten unmatched items with the highest risk scores for the selected period. Items are separated into three categories using a toggle control:
GL Accounts — Risk items grouped by reconciliation and linked to their source GL Account.
Bank Accounts — Risk items grouped by reconciliation and linked to their source Bank Account.
Support Lines (Standard Reconciliations) — Risk items from Standard reconciliations, grouped by reconciliation only (not linked to a specific GL Account or Bank Account).
Note: For Support Lines, only items with a Risk Category assigned are included in the Unmatched Risk Dashboard. Support Lines with no Risk Category are excluded from all Unmatched Risk calculations and visualizations.
The table columns are:
Column |
Description |
|---|---|
|
Reconciliation [v26.3] |
The reconciliation the risk item belongs to. |
|
GL Account / Bank Account [v26.3] |
The source account for the risk item. Shows the GL Account (for GL Accounts view) or Bank Account (for Bank Accounts view). Not shown for Support Lines. |
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. |
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.