🎇Tips

In this space you will find some tips that will help you to get familiar with our tool while you learn how to use it perfectly.

Sources

File upload: All files to be uploaded in the same source must have the same format.

Prepare sources: When uploading sources, matching must be performed to ensure which data types in each column are the ones we need.

Alarms: The creation of a source will always generate an alarm associated with it.

Reconciliation

Prepare sources: If you do not change the name of the reconciliation it will be named with the date and time of creation and it will be more difficult to identify it later, we recommend adding a recognizable name to your reconciliation to be able to identify it more easily.

Configure crossover: Until you prepare the columns the system will not enable the "Configure crossover" button.

Alarms: The creation of a reconciliation always generates an alarm associated to it.

Configure rules

• It is recommended that in the reconciliation sweeps, mainly in the first sweep, there is always a very strong key, this is usually a unique transaction identifier.

• I can have as many sweeps and reconciliation rules within each sweep as I want. The more rules the better.

• You should always set the strongest reconciliation sweeps from the first sweep down.

Example:

Sweep 1: Largest number of keys without tolerances.

Sweep 2: Same number of keys as sweep 1 but with tolerances.

Sweep 3: One less rule without tolerances and so on.

• The order of the reconciliation rules within a sweep does not affect the result, but the order of the sweeps is important.

• The rules or crossover keys work within each sweep as an "Y".

• For the rules to work correctly it is important that you align the data type of the columns being compared

• Duplicates column: In order to avoid duplicates in your reconciliation you should generate a uniqueness column that includes the keys of each sweep.

Prepare columns: If you do not have an amount field in the sources that are part of a reconciliation it is important to know that any numeric field can be selected.

Reconciliation percentage: The reconciled transactions from both sources should match, if not, you have duplicates. This is not necessarily a bad thing, but we do recommend that you check it.

Reconciliation confirmation: When a change is made to an already confirmed reconciliation, those changes will be applied only to the items that are in "unreconciled" status.

Reconcilable groups • When you add a reconciliation group, the crossing keys are deleted and must be reconfigured. • If you delete a reconciliation group, the reconciliations you have created from this reconciliation group will also be deleted.

Reconciliation percentage: The reconciled transactions from both sources should match, if they don't, you have duplicates. This is not necessarily a bad thing, but we do recommend that you check it.