Skip to main content
User Reconcilation is the most sophisticated reconcilation type on Recital, supporting even the most demanding worklow and giving you full control over the process.

​
User Reconciliation Flow

  • Ingestion of data via file upload (CSV/XLSX)
  • Entry of tailored matching and transformation rules, using a business-user friendly UI
  • Saving of these rules for later system/user re-use
  • Run Matching
  • Dashboard View and Reports on reconciliation outcome data

​
Create a New User Reconciliation

​

​
Sample Scenario 1: Transaction Reconciliation

Let’s assume we want to use Recital to perform transaction reconciliation on transaction data from different sources.
Transaction Data 1: TSS_Statement.xlsx - Internal Ledger Transaction File
Source: Internal; Format: XLSX; Frequency: Daily
Transaction Data 2: TSS_ATM.xlsx - External Transaction File
Source:External; Format: XLSX; Frequency: Daily
Assume for the transaction reconciliation, matching between the two data sources involves the following fields and definition.
Reconciliation rules leverage unique identifiers (RRN) and transaction amount to ensure high‑confidence match across theTSS_StatementandTSS_ATMfiles.
Assume for the transaction reconciliation the following normalization/transformation on the transaction files.
Rule 1: Normalization in tss_statement generates a unique concatenated key for full traceability down the line.
Rule 2: Normalization in tss_atm ensures that settlement impact considered are relevant, absolute values are considered, and unique concatenated keys are generated for easier traceability down the line.

​
Handling Sample Scenario 1

Creating a new user reconciliation to handle the transaction reconciliation is easy and straight forward.
1

Navigate to the Reconciliation Page

Use the left menu on Recital to navigate to the Reconciliation pageReconciliation Home Page
2

Start New Reconcliation Flow

  1. On the Reconcilation page, click on “New Reconciliation” button.
  2. Select the “User Reconciliation” from the pop-up menu. Reconciliation Recon Type Menu
3

Complete the Flow Set Up

Set up the new flow by filling User Recon Diablog.Do the following:
  1. Enter a representative name and description for the description
  2. Specify currency and transaction start and end date in your source files as the currency, start data and end date Reconciliation User Recon Set Up Dialog
  3. For each source column,
  • Specify the Reconciliation type as “Transaction” in this case,
  • Specify Source as “File upload” in this case),
  • Specify File Format as “Others” in this case),
  • Specify File Type as “XLSX” in this case
  • Upload the TSS_Statement.xlsx for Source 1 and TSS_ATM.xlsx for Source 2
  1. Click on “Set up”
The filled User Recon Set up should look like the following:Reconciliation User Recon Set Up FilledSet up time could vary depending on the size of the records in the source files, from a few seconds to minutes.
4

Matching Rules

On the “User Recons” Page, switch to the “Matching Tab”, and set up the matching rules for the transaction reconciliation using the sample matching rules specified above.Reconciliation User Recon Matching PageTo add matching rules to the user reconciliation flow, do the following:
  • Select Exact Match matching loic, and the “RRN” field in both source files for Rule 1
  • Select “Amount Match Absolute” logic, then “Transaction Amount” field for the TSS_Statement file, and “to “Settlement_Impact” for the TSS_ATM file for Rule 2.
  • Leave “And” as the default logic gate between the two rules entry fields. This implies a match will considered if and only if the RRN-to-RRN AND Transaction Amount-to-Settlement_Impact match in both transaction files. Reconciliation User Recon Matching Rule Filled
  • Save the rule for later re-use Reconciliation User Recon Matching Rule Save
5

Transformation Rules

On the “User Recons” Page, switch to the “Transformation” tab to set up the transformation rules.Reconciliation User Recon Matching PageLet’s start with the TSS_Statement file transformation. Do the following:
  • Select CONCAT on the “Apply Function” field. The Apply functions work similarly to excel functions that business users are already familiar with.
  • Next select the TSS_Statement.xlsx on the “From file” field
  • Then select the columns you want to concatenate in the order you want to them, e.g., for CONCAT(RRN, STAN, TerminalID+Transaction_Amount) normalization on the TSS_Statement file, select the RRN first, STAN second, TerminalID third, etc.
  • Specify a name for the new column to place the transformed value
  • And use the “with separator” and “operator text” to add a separator/prefix/suffix and the corresponding separator/prefix/suffix character
Next, let’s apply tjhe transformations rule on the TSS_ATM source data. Do the following:
  • Click on the plus button besides the first transformation rule to add a new transformation rule.
  • Add the CONCAT, ABS and FILTER transformations on the TSS_ATM files.
The completed transformation rule should look like this:Reconciliation User Recon Matching Rule Filled
  • Save the transformation rule for later re-use Reconciliation User Recon Transformation Rule Save
6

Run Reconcilation

Reconciliation User Recon Matching Rule FilledClick the Run button on the User Recon Flow Page to Run the reconciliation after entering the matching and transformation rules.
7

Reconciliation Outcome Data Review

After running a reconciliation, users are re-directed to the reconciliation flow list page.Reconciliation Flow ListTo navigate to the Reconciliation Run Summary data page, do the following:
  1. Select your reconciliation flow name on the list. Reconciliation Run List
  2. On the reconciliation run list page, select the corresponding run or last run to see the associate reconcilation outcome data
  3. On the Reconciliation Outcome summary page, you can view indepth data about the outcome of the reconciliation run.
  • You can switch between File tabs, Reconciliation Run Summary Page File 1 Reconciliation Run Summary Page File 2
  • View the match/un-matched status of each record in a file Reconciliation Run Summary Page File 1 Unmatached
  • While on a particular file, you can switch between Transaction Match and Un-Matched report with the top right drop down button.
8

Export Report

To download reconciliation reports, do the following:
  1. Navigate to the Reconciliation Run List : Reconcilation Page > Select Reonciliation Flow > Reconciliation Runs List Page Reconciliation Run List Page
  2. Click download button beside the corresponding run Reconciliation Run List Page Data Export
For the reconciliation reports, you get one file, with 4 sheets: #2 sheets for each files reconciled and unreconciled items

​
Sample Scenario 2: Settlement Reconciliation

Let’s assume we want to use Recital to perform settlement reconciliation between reconcilled transaction data from the Sample scenario 1 above and a settlement file.
Reconcilled TSS_Statement.xlsx - Output Data from Sample Scenario 1Settlement Data from an External Source

​
Handling Sample Scenario 2

Creating a new user reconciliation to handle the settlement reconciliation is easy and straight forward.
1

Navigate to the Reconciliation Flow Page

  1. Use the left menu on Recital to navigate to the Reconciliation page
  2. Select the reconcliation name you want to work on from the flow list Reconciliation Home Page
2

Start New Settlement Reconciliation Run

To set up a Settlement Reconciiliation run,
  • Switch to the Settlement Tab on the Reconciliation runs list
  • Select “Run Settelement” Reconciliation Home Page
3

Settlement Reconciliation Run Set up

On the run settlement pop-up menu,
  • Select the reconcileed transaction run that you want to run the settlement reconciliation against
  • Select the transaction file that has all the transactions: TSS_Statement.xlsx in this case
  • Specify the type of settlement file you are uploading – “Interswitch Computation Report” in this case. Recital recognizes the format of different types of settlement files from various providers/switches.
  • Specify the file format - xlsx, and select the settelemnt file to be uploaded
  • Click on “Upload Files”
4

Grouping

To match the transaction file to the settlement file, we need to select the correct column to use for grouping. On the Settlement Reconciliation page,
  1. Switch to the Grouping tab
  2. Select the “description” column on TSS_Statement since it contains the different types of transaction, and “settlement category” on the Settlement file. 3.Click on “Save Group”, so that you can re-use the group logic later. Settlement Reconciliation Grouping Page
5

Transformation

To accurately parse and group transactions in the transaction file, we need to specify the amount and date columns. On the Settlement Reconciliation page,
  1. Switch to the Transformation tab
  2. Click on More Actions Drop Down on the top menu and select transform columns
  3. Select the date column in the transaction file, select “Date” as the Data Type, and select a date format. You can use “MDY”
  4. Select the amount column in the transaction file – Transaction Amount for TSS_Statement. Check the Expected box
  5. Save the transformation rule
  6. Click on Transform. Settlement Reconciliation Transformation uUle Page
6

Run Settlement Reconciliation

Click on Run Settlement.After running a settlement, users are redirected to the Settlement Reconciliation runs list page
7

Reconciliation Outcome Data Review

Select the last settlement run you just completed to see the outcome data once you see “completed” on the grid.The run outcome data page shows how each of transaction categories was reconcilled between the transaction and settlement files. E.g. We can see the POS transaction was partially reconcilled, and that of the 43,150 total amount in the settlement file, 16,200 was matched and 26,950 was un-matched to the transaction file.Settlement Reconciliation Transformation Outcome Data PageSettlement Reconciliation Transformation Outcome Data Page
8

Export Data

Click on the Export button on the run uutcome data page to export the result of your settlement reconciliation