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.
Pro tips:
In order to create a reconciliation percentage board it is necessary that the sources that compose the reconciliation have the correct formats, it means, that the two sources have a date type column and a column of values or amounts of money to compare and that these are number type.
All summary tables can be downloaded in: .xlsx, .xls or .csv.
You will be able to apply filters to the dashboard to see the results by specific dates. Transactions that do not have a date or have not been configured with date format will not be reflected in these percentages.
Last updated