Cumulative groupings

This functionality is a complementto improve the adaptability of thegroupings to the different usecases you may have in yourreconciliation process.

Types of groupings:

ACCUMULATIVE: Is where all records are dynamically grouped together as files are uploaded to the source and can be reconciled again, regardless of whether any previous versions are reconciled.

NON-CUMULATIVE: Where records from the original source will only be part of a single grouping that becomes immutable once reconciled.

The behavior of cumulative groupings is to continue accumulating items in a grouping even though it is already reconciled, while in the case of non-cumulative groupings the behavior is the opposite, an item can only belong to one line of the grouping.

When creating a grouping you must consider the following improvements that were added in the creation process

• The reconcilable group will be chosen by default (all source).

• The name of the grouping will be generated by default: Grouping dd/mm/yyyy

• The cumulative grouping toggle will be disabled, therefore all groupings will be born as non-cumulative)

Step 1. When creating a grouping you will be able to select the behavior you want your grouping to have through the toggle located at the top right.

Behavior in Editing

When a grouping of any type is used in a reconciliation and once the reconciliation becomes "finished", the possibility of making changes to the structure of this grouping will be blocked. Therefore, when editing a reconciliation you must take into account the following restrictions:

• Modify the grouping criteria (neither delete nor add new ones).

• Delete value fields or modify the arithmetic operation applied on them. Only new value columns can be added.

• Modify the Reconcilable Group

• Modify the accumulable toggle.

It shall be allowed:

• Modify the name of the grouping

• Add transformation column and new value columns

• Hide columns

Important notice

• Once a grouping has been used in a reconciliation, it can no longer be activated or deactivated in the "Cumulative" option.

• A grouping of any type can only be used in a single reconciliation. Once the grouping is set to " finished " status, the possibility to make changes to the structure of the grouping will be blocked.

• You will not be able to generate a reconciliation between two cumulative groupings, as they are of type "N:N", i.e. many to many.

Note: An N:N reconciliation is a reconciliation under which its configuration will allow you to reconcile many items of counterparty A against many items of a counterparty B. This type of configuration is very useful when you need to compare a record against a product catalog where you may have the same record associated to one or more products. So you will have N records as many products as you have associated.

• When one of the sources to be reconciled is a cumulative grouping, deleting a file from any of the reconciled sources will not delete the records from the reconciliation.