🇬🇧
Simetrik Academy (EN)
  • 🏡Simetrik Academy
  • 📺Youtube • Simetrik
  • 🚀What's new
    • Transformations improvement
    • Groupings
      • Cumulative groupings
    • Crossover rules
    • Link to Quicksight
    • Archive reconciliations
  • 🦮Quick guide
    • Create your first reconciliation
    • Accounts and workspaces
      • Account creation
      • Auth0 Guardian Authentication
    • 1. Prepare your sources
    • 2. Configure your crossover
    • Glossary
    • Folder manager for sources, reconciliations and dashboards
    • 3.Check your results
  • 📄Sources
    • Uploading TXT files
    • Sources management
    • Updating sources
    • What can you find in your source?
      • Automatic duplicates column
      • Automatic columns
      • Applying Filters
      • Reconcilable Groups
      • Groupings
      • Transformation columns
      • Duplicate columns
    • Deleting multiple files
    • Automatic columns
    • Join of sources
  • 🔁Reconciliations
    • Creation of crossover keys
    • Collisions
    • Modification of crossover keys
    • Reconciliation sweeps
    • Sweep robustness
    • Tolerance and non-equal keys
    • Edit reconciliation
    • Manual reconciliations
    • Crossover Types Configuration
    • Chained reconciliation
    • Reconciliation tables
    • VLookUp column
    • Validation of amounts in Manual Reconciliation
    • Record adjustment
    • Archive reconciliations
    • Multiple manual reconciliations
    • Reconciliation Folders
    • Status of a reconciliation
  • 📊Dashboards
    • Dashboards name edition
    • Reconciliation Percentage
    • Custom dashboard
    • Pivot table
    • Delete Dashboard
  • 🔔Alarms
    • Alarms and notifications
  • 🔌Integrations
    • What is an integration?
    • Types of input integration
      • SFTP
  • Training session
    • Training of Trainers
  • FAQ & Tips
    • ❔FAQ
    • 🎇Tips
Powered by GitBook
On this page
  • How to create a reconciliation?
  • Step 1 - Create your reconciliation
  • Step 2 - Create or select your sources
  • Step 3 - Configure Crossover Rules
  • Step 4 - Configure columns (optional)
  • Step 5 - Confirm your reconciliation

Was this helpful?

  1. Quick guide

Create your first reconciliation

The new flow has been designed to offer more speed and control to the user when creating a reconciliation and viewing the results.

PreviousQuick guideNextAccounts and workspaces

Last updated 2 years ago

Was this helpful?

How to create a reconciliation?

Step 1 - Create your reconciliation

Go to the Reconciliation section by clicking on the sidebar menu. Once you are there, click the +Create New Reconciliation button located on the upper right corner.

Step 2 - Create or select your sources

Once you are on the dashboard of your new reconciliation, you will be able to choose a source from the dropdown menu or to create a new one as your Source A.

You can upload files in .xlsx, .csv or .txt format by dragging them from your computer or choosing them from the file explorer using the Upload files button.

When your Source A is created or selected, repeat the same process for your Source B.

Once your sources are ready, the option to continue will be enabled, allowing you to move on to the next step.

Step 3 - Configure Crossover Rules

From this menu you can configure the number of sweeps, the crossover rules and the tolerance that you consider necessary to complete the reconciliation.

As soon as you have finished configuring all your rules and sweeps, you can click Save in the lower right corner, this way the configuration you created will be saved and the reconciliation will be executed.

After the reconciliation finishes its initial run, you will be taken to the menu where you selected your sources. Here you will see a summary dashboard of the reconciliation’s results.

Step 4 - Configure columns (optional)

Once you see the dashboard with the reconciliation results, we recommend to select the date and value columns that are going to be measured in the dashboard. To do so, you can click on the Configure Columns button.

By clicking this button, a small window will open where you can select the columns that will be used to calculate and/or filter the results of your reconciliation.

Once you finish configuring the columns, click on Save changes. This will update the dashboard to display the results based on the columns you selected.

Remember

  • These columns will be reused in future reconciliations where the same sources are involved.

Step 5 - Confirm your reconciliation

Once you checked the results of your reconciliation and you agree with them, click on Confirm Reconciliation in the lower right corner.

An alert will appear asking if you are sure to confirm this setting. Click on the Confirm option, so the reconciliation can be executed and after is completed, it will take you to the reconciliation table.

Keep in mind

If you confirm this setting, the records that meet the crossover rules will have a RECONCILED status permanently and any future change on the crossover rules will be applied only to the records with an UNRECONCILED status.

To configure the crossover with the rules you want to include, start by clicking on Configure Crossover

The changes performed on the columns configuration after creating the dashboard of results, are not going to be reflected there. To update your preferences, you must do it from the option Edit on the .

🦮
dashboard of results
Reconciliation menu
Create a new reconciliation
Select Source A
Select Source B
Configure crossover
Configure crossover
Save the crossover rules
Configure columns
Save changes
Confirm reconciliation
Alert
Reconciliation Table
How to do your first reconciliation?