🇬🇧
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

Was this helpful?

  1. Reconciliations

Reconciliation tables

Once the configuration of the crossing is ready, Simetrik automatically generates a table with the result of the reconciliation we will explain the columns of this table.

First part: Seven (7) columns generated by the system:

  1. SKT_ID: All reconciled transactions, like new transactions, generate a new unique identifier, this means that Simetrik gives a new identifier to the union of two transactions or to the reconciled transactions.

  2. Ruleset name: Indicates in which rule group each transaction was reconciled.

  3. Reconciliation date: Indicates the day on which each transaction was reconciled.

  4. Status: Indicates the status of the transaction, if it was reconciled or not.

  5. Comment: Indicates the comments that a user can make on specific transactions in the manual reconciliation module.

  6. User: Indicates the user who made the comment about a transaction.

  7. Tag: Corresponds to the tag that can be generated on manually reconciled transactions.

Second part. It contains columns corresponding to the first source (Table A) that was added to the reconciliation. All the columns will have the name of the column, the name of the table they came from and the name of the column they had previously.

Third part. Corresponds to the columns of the second reconciled table (Table B)

PreviousChained reconciliationNextVLookUp column

Last updated 3 years ago

Was this helpful?

🔁