2. Configure your crossover

A reconciliation occurs when you compare information from 2 or more sources to verify which transactions match between the sources and which do not.

Step 1. Once you have finished the source preparation process, click on the Configure crossover icon.

Step 2.You will see the following screen, where 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.

Step 3.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 to", "greater than", "less than", among others.

Step 4.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.

Step 5. (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.

Step 6.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.

Step 7. Once you have finished configuring the crossover, click on Next to go to consult your results.

¡You have successfully configured the crossover!