Creation of crossover keys
A reconciliation occurs when information from 2 or more sources is compared to verify which transactions match between the sources and which do not.
Last updated
A reconciliation occurs when information from 2 or more sources is compared to verify which transactions match between the sources and which do not.
Last updated
Once you have finished the source preparation process, click on the Configure crossover icon.
In the following screen you'll find you can create the crossover keys by selecting or dragging the columns you want to compare from each source. You can create as many crossover keys as you wish. The keys you create will be saved as sweeps, which you can duplicate or organize.
To drag a column and save it as a crossover key, place the cursor over the column of source A and drag it to the reconciliation sweep section. Perform the same step with the column you want to compare from source B. Additionally you can choose different comparison criteria such as "equal", "greater than", "less than", among others.
If you want to select a column instead of dragging it, in the sweeps section, expand the list of columns and select the column of each source you want to compare.
Optional: If you need to create a second crossover key, click on the (+) sign to the right of the Tolerance field and repeat steps 3 and 4.
Once you have created the crossover keys, they will be saved as a sweep and will be used as a method to achieve the highest expected reconciliation levels automatically. This functionality allows the user to use different logic or crossover keys.
Ideally, create the first sweep with the most accurate keys you have, and then create new reconciliation sweeps that will run on the remaining transactions from the previous layer. These secondary sweeps are usually built with less strong logics than the primary ones, in order to obtain better reconciliation metrics.
Once you have finished configuring the crossover, click on Next to check your results.
You have successfully configured the crossover!
Pro Tips:
Before saving the reconciliation, validate that the format of the columns you are comparing is the same, i.e. dates with dates and amounts with amounts.
It is also important that you validate that the columns do not have information with spaces, for this, you can use a Transformation Column on the sources with the formula Spaces.
Once you save the reconciliation and the system reconciles the information, the first source will be shown as table A, and the second as table B.
The tables resulting from a reconciliation can be used as another source and will have almost all the characteristics of one, the only thing you will not be able to do is to change the format of the data, which will be inherited from the original source.
