Manual reconciliations

In case there are transactions that do not cross each other, you can use the manual reconciliation functionality and see the records one by one to reconcile them manually.

What is manual reconciliation for?

In the reconciliation there may be inconsistencies for different reasons, including: operational duplicates, human errors in the information record, among others. With the Manual Reconciliation functionality, cross transactions one by one and leave comments on the reason for this correction to the information.

Create a manual reconciliation

Step 1 - Check the reconciliation results table

To initiate a manual 1-to-1 crossover, go to the reconciliation result table and click on Edit, manual reconciliation button.

The following window will be enabled, where you can view the unreconciled transactions from each source. On the right side the first source or Table A and on the left side the second source or Table B.

Step 2 - Select the records to reconcile manually

Choose the record or transaction you want to cross manually from the first source. Click on the record, you will see that the SKT_ID of the selected transaction will appear in the Reconciliation Result section.

Now, choose the record or transaction you want to cross manually from the second source. Click on the record and you will see that the SKT_ID of the selected transaction will appear in the Reconciliation Result section.

Step 3 - Select the columns to reconcile

In the Reconciliation Result section, click $ Column and select the column you want to manually reconcile from the first source.

In the Reconciliation Result section click on $ Column and select the column you want to reconcile manually from the second source.

Step 4 - Define the operations to execute

Once the columns are configured, you can define the type of operation you want to perform on the records that do not match. You can choose between adding or subtracting the difference.

Step 5 - Add a comment

To justify the manual crossing of these transactions you can leave a comment. This comment, as well as the new reconciliation status, will be reflected in the reconciliation result table. When you're done, click + Send Manual Reconciliation.

If you are an Administrator user, you will be able to create Tags with which your team can easily classify transactions that are manually reconciled.

To create one, place the cursor over the text box and type the name of the Tag you want to create and then select the Create Tag option. Other users will be able to sort the reconciled records manually with the tags from the drop-down list.

You will see the Adjustment Sent notice, which means that the reconciliation result table has been updated with the manually reconciled information. Click continue and continue reconciling.

Step 6 - Check the result

Go to the result table of your reconciliation and verify that the status of the manually reconciled transaction(s) has changed to RECONCILED. This means that the manual reconciliation was successfully executed. In this table you will also see reflected the Label that was assigned to each transaction and its corresponding comment.