3.Check your results
Reconciliation percentage dashboards give you quick visibility into the reconciliation results for each source in both number of transactions and amounts.
Step 1.Once you configure your sources and crossover keys, Simetrik will automatically generate the reconciliation results and these will be visible in a dashboard that consists of 4 elements: overall reconciliation percentages, a summary table with all transactions, a table with the transactions that reconciled and two tables with the transactions that did not reconcile from each source.
Step 2.Once you verify the data generated by the system, you must confirm if the configuration corresponds to the expected result. If so, save the configuration.
Once the reconciliation is created, Simetrik generates a table with three components:
The first part corresponds to 4 columns generated by the system:
A new SKT_ID column, since all reconciled transactions, as well as new transactions, generate a new identifier, i.e. Simetrik gives a new identifier to the union of two transactions or reconciled transactions.
Ruleset name: Indicates in which ruleset each transaction was reconciled.
Reconciliation date: Indicates the day on which each transaction was reconciled.
Status: Indicates the status of the transaction, whether it was reconciled or not.
Comment: Indicates the comments that a user can make on specific transactions in the manual reconciliation module.
User: Indicates the user who made the comment on a transaction.
Tag: Corresponds to the tag that can be generated on manually reconciled transactions.
2. The second part contains columns corresponding to the first base (Table A) that was added to the reconciliation. Now all the columns will have in the column name the name of the table they come from and the name of the column they had previously.
3. The third part corresponds to the columns of the second reconciled table (Table B).
You are done! You have successfully completed the conciliation process.
Last updated
Was this helpful?