Grouped Reconciliations [v26.3]
Grouped reconciliations allow multiple GL accounts and support sources to participate in a single reconciliation instance. Instead of creating separate reconciliations for related accounts, users can reconcile them together while maintaining visibility into the individual GL accounts and support sources that make up the reconciliation.
Grouped reconciliations provide a consolidated view of balances, transactions, supporting documentation, and workflow activity while preserving account-level visibility and traceability.
Traditionally, reconciliations followed a one-to-one model, where a single GL account was reconciled against a single support source. Grouped reconciliations extend this model by allowing multiple GL accounts and support sources to participate in the same reconciliation instance.
Grouped reconciliations help organizations:
Reconcile related accounts within a single workflow.
Consolidate balances and transactions across multiple accounts.
Reduce number of reconciliations that need to be managed.
Maintain visibility into the originating GL account or support source for every transaction.
Perform the reporting, analysis, and workflow activities at the reconciliation level.
Account Mapping
Account mapping defines the relationship between GL accounts and support sources within a reconciliation instance. The selected mapping determines the relationship between GL accounts and support sources, including how balances, transactions, reporting, and reconciliation processing are managed.
A reconciliation can use one of the following mapping types:
Mapping Type |
Description |
|---|---|
One-to-One (1:1) |
One-to-one mapping reconciles a single GL account against a single support source. This is the standard reconciliation model, where one account is matched directly to one supporting account or source.
|
One-to-Many (1:M) |
One-to-many mapping reconciles a single GL account against multiple support sources. Instead of creating separate reconciliations for each support source, users can reconcile all related support sources within a single reconciliation instance.
|
Many-to-One (M:1) |
Many-to-one mapping reconciles multiple GL accounts against a single support source. Instead of creating a separate reconciliation for each GL account, users can reconcile related GL accounts together within a single reconciliation instance.
|
Many-to-Many (M:M) |
Many-to-many mapping reconciles multiple GL accounts against multiple support sources. This enables related accounts and support sources to be reconciled together within a single reconciliation instance while maintaining visibility into the originating account or support source for each transaction.
|
Note: For Standard reconciliations, support sources are represented by support lines rather than bank accounts.
Managing Grouped Reconciliations
A grouped reconciliation combines multiple GL accounts and/or support sources into a single reconciliation instance.
Regardless of the mapping type:
The reconciliation appears as a single reconciliation in the reconciliation list.
Participating GL accounts and support sources are displayed within the reconciliation.
Balances are calculated across the accounts included in the reconciliation.
Transactions retain their originating GL account or support source.
Supporting documentation, comments, and workflow activity are managed within the reconciliation.
The following table summarizes the behavior of each reconciliation mapping type.
Feature |
One-to-One (1:1) |
One-to-Many (1:M) |
Many-to-One (M:1) |
Many-to-Many (M:M) |
|---|---|---|---|---|
GL Accounts |
1 |
1 |
Multiple |
Multiple |
Support Sources |
1 |
Multiple |
1 |
Multiple |
Reconciliation Display |
One GL account and one support source. |
One GL account and multiple support sources. |
Multiple GL accounts and one support source. |
Multiple GL accounts and multiple support sources. |
Balance Aggregation |
No aggregation required. |
Support balances are aggregated. |
GL balances are aggregated. |
GL and support balances are aggregated. |
Transaction Visibility |
Transactions originate from a single GL account and support source. |
Support transactions identify the originating support source. |
GL transactions identify the originating GL account. |
GL and support transactions identify their originating account or support source. |
Dashboard Reporting |
Reconciliation level. |
Reconciliation level. |
Reconciliation level. |
Reconciliation level. |
Reopen & Carry-Over Processing |
Applies to the reconciliation instance. |
Applies across all support sources in the reconciliation. |
Applies across all GL accounts in the reconciliation. |
Applies across all accounts and support sources in the reconciliation. |
Supporting Documentation |
Managed within the reconciliation. |
Managed within the reconciliation. |
Managed within the reconciliation. |
Managed within the reconciliation. |