Skip to main content

Unmatched Aging Dashboard [v26.1] 

The Unmatched Aging tab provides a consolidated view of carry-forward unmatched items across legal entities and accounts, aged by the number of months each item has remained unmatched.

 

Note: [v26.3]  Unmatched Aging data is displayed by Reconciliation. For each reconciliation, the aging bucket amounts are aggregated across all participating GL Accounts and Bank Accounts. Standard reconciliations are included [v26.3]; for Standard reconciliations, aging buckets include only Support Lines that have a Risk Category assigned.

To view unmatched items aging:

  1. Navigate to the Dashboard module.

  2. Click the Unmatched Aging tab. The aging table displays data byReconciliation. [v26.3] 

  3. Use the following controls to filter and manage the aging view:

    Control

    Function

    Currency View

    Toggles between currency display options:

    • Reporting Currency—Displays all amounts in a consolidated reporting currency for cross-entity comparison.

    • Functional Currency—Displays amounts in each legal entity’s own currency.

    Status Filter

    Filters reconciliation data included in the aging view:

    • Approved—Shows data for approved reconciliations only.

    • All—Shows data for all reconciliations regardless of status.

  4. Review unmatched items aging data in the table.

    Each row represents one reconciliation. For grouped reconciliations, the aging bucket amounts are aggregated across all participating GL Accounts and Bank Accounts.

    Column

    Description

    Type The reconciliation type badge: Bank Reconciliation or Standard Reconciliation, with the corresponding icon.
    Reconciliation The name of the reconciliation.

    Current Month

    Total unmatched amount and item count for the current month.

    1 to 5 Months

    Total unmatched amount and item count carried forward for 1 to 5 months, with a separate column for each month.

    5+ Months

    Total unmatched amount and item count carried forward for more than 5 months.

    Total

    Combined unmatched amount and item count across all aging buckets for the account.

    Note: Each cell displays the unmatched amount along with the item count in parentheses (e.g., “€23,599.23 (1)”). A dash (—) indicates no unmatched items for that aging period.

Account Reassignment and Aging [v26.3] 

When a GL Account or Bank Account is removed from a reconciliation and reassigned to a different reconciliation:

  • Historical unmatched items remain associated with the original reconciliation for the periods when the account belonged to that reconciliation.

  • Starting from the next reconciliation period after the change, unmatched items from the removed account are not carried forward into the new reconciliation.

  • Unmatched items appear in the new reconciliation only when they are added or uploaded as part of that reconciliation.

Standard Reconciliations in Aging [v26.3] 

For Standard reconciliations, the aging bucket amounts are calculated using only Support Lines that have a Risk Category assigned:

  • Support Lines with no Risk Category are excluded from all aging bucket calculations.

  • When a Support Line carries forward to subsequent periods, it continues to appear in the appropriate aging bucket only if it has a Risk Category assigned.

  • The aging of carried-forward Support Lines is preserved across periods.

Was this article helpful?

We're sorry to hear that.