Conciliation Step (Turbo AI processes)
The Conciliation step of Turbo AI processes creates a transaction conciliation analysis from the data prepared in the process. This is the conciliation used in Turbo AI processes. Configuration has been simplified and features artificial intelligence support for defining rules, which reduces manual effort and configuration errors. Once configured, the step generates an analysis to execute and review in the new conciliation screen, where you investigate, adjust, and validate results.
Which conciliation is this: this article covers conciliation for Turbo AI processes, supported by artificial intelligence (Turbo AI). Standard processes use the "Conciliation Step (Standard processes)", which exports data for analysis on the traditional screen. Both remain active.
Before you begin
Conciliation is the output of a data preparation flow. Before configuring the step, complete the preparation of the sources that will enter the analysis. You will also decide which database is Side A (main reference database) and which is Side B (database compared with Side A). The two databases are compared during the analysis.
Step configuration
Add the step: with the preparation flow completed, add the Conciliation step to the process.
Connect sources: link the data sources that will be part of the conciliation and define which is Side A and which is Side B.
Open configuration: double-click the Conciliation step to access the Conciliation Configuration screen.
Fill in the fields and click Save to complete the initial configuration.
The initial configuration fields are:
Name (required): identifies the conciliation step. It is editable and can be defined by you.
Code (required): unique identification code for the conciliation. Once saved, it cannot be changed.
Side A: description that identifies the database defined as Side A.
Side B: description that identifies the database defined as Side B.
Identify relationship
In this step, the platform identifies how Side A records relate to Side B records. These relationships are the basis for creating conciliation rules. Choose one of the options:
Automatic identification: Dattos' artificial intelligence analyzes data from Side A and Side B and automatically identifies the corresponding fields between the two databases. Afterward, you can edit or add relationships.
Manual registration: you define the Side A field and the corresponding Side B field. Manual relationships complement or replace those identified automatically.
Two types of fields organize the analysis:
Analysis fields: used in the analysis to create comparison rules.
Totalizer fields: numeric fields, such as monetary values or quantities, that can be summed and used in the conciliation.
Totals in analysis: when highlighting a relationship, the field total is displayed in filters, quantitative indicators, and dashboards of the transaction conciliation analysis.
To proceed to the next step, you must have at least one relationship defined for analysis fields and at least one for totalizer fields. If the types of the related fields are different between sides (for example, date on one side and alphanumeric on the other), the platform indicates that it is necessary to adjust the field type before proceeding. When the configuration is correct, the Next step button is enabled.
Row identifiers
On the Relationship and Rules screen, you can define row identifiers:
Click the row identification icon.
Select the fields that uniquely identify each record.
Row identifiers allow data to be updated in new runs without deleting the analysis history, ensuring continuity and traceability of information. To understand the platform's behavior with and without a row identifier, refer to the article "Import types".
Conciliation rules
Based on the configured relationships, Dattos' artificial intelligence analyzes the data and generates the matching rules. After generation, you can:
Accept suggestions and move on to the next step.
Adjust rule settings according to the process requirements.
Create additional rules when necessary.
Two actions are available at this step:
Reprocess: enabled whenever a rule is changed or the order of rules is modified. Reapplies configured rules according to the changes.
Rediscover rules: triggers the platform to analyze data again and generate a new set of rules.
Rediscovering rules discards manual adjustments: upon confirmation, all manual changes to the rules (additions or edits) are discarded, and rules are recreated automatically.
When the configuration is correct, the Next step button is enabled.
Analysis review
The result of applying the rules appears on the review screen, where you validate configurations before finalizing the analysis. The platform presents, in a single table, the records that will be automatically reconciled according to the defined rules.
Filters and visualization. You can filter data in two ways: directly through the table or via the left side panel, using the conciliation statuses.
Show analysis columns only. By enabling this option, the Matching ID, Status, Rule, Structure, and Rows A and B fields are hidden. Only analysis data remains visible, facilitating reading and validation.
View details. By clicking View details, you see the full data for Side A and Side B records and identify which key rule fields were used to reconcile the records.
Edit columns. In this option, you customize the analysis view:
Reorganize the order of columns displayed.
Change data display type, choosing between grouping Side A and Side B data into a single column (when records are reconciled) or displaying them side-by-side in separate columns (even when reconciled).
Add value difference column, showing the difference between Side A and Side B values.
Single side, to display only Side A columns or only Side B columns.
When everything is correct, click Finish to complete the analysis configuration and proceed with execution.
Related articles
Conciliation Step (Standard processes)
Import types