UPI Reconciliation (Case Study)

Overview

UPI Reconciliation is a single platform that merges various banking services and features under one umbrella.

A UPI ID and PIN are sufficient to send and receive money. Real-time bank-to-bank payments can be made using a mobile number or virtual payment address (UPI ID).

Fund transfer through UPI is the one of famous digital payment modes in India.

Problem Statement

T+ 0 Reconciliation Required
0 Files To Decrypt Manually
0 Files To Upload & Reconcile Manually
Manual Reconciliation Success Rate
0%

Presently T+1 Reconciliation is Required for UPI.

As there are 44 files involved in reconciliation, it makes a very difficult job for the banks to upload all the files and process reconciliation.

Out of those 44 files from 8 different cycles, 32 files are received from NPCI which are in an encrypted format. Hence banks need to manually decrypt the files from tools provided by various vendors.

Once all of these files are decrypted, they have to upload all 44 files in an .xls file format for manual reconciliation.

As this is a manual process, there are chances of a few errors or total failure in the reconciliation process.

NPCI has instructed banks to upload all the failed transactions information on a daily basis at the NPCI portal before 4.00 pm.

If the bank fails to do so then they are liable for a penalty.

Solution Provided

Credentek has implemented a full automation solution for UPI reconciliation in the form of the AnyRecon platform.

This is a three-way reconciliation.

– Fetching input data files from NPCI and other SFTP server

Credentek has developed and deployed a new interface that fetches the input data files of the all-cycles from the NPCI SFTP server. After pulling the file the application decrypts the files that are in an encrypted format. After the decryption of the file, the files are moved further for the reconciliation process.

– Reconciliation Engine

The Reconciliation Engine is a part of the AnyRecon application which runs 24×7. For any new file received for reconciliation, the application picks up the records from the file and starts the reconciliation.

 

Results

– Removed manual intervention.

– No person dependency.

– Complete (E2E) Automated Solution (reduction of manpower).

– No need for manual decryption of the file.

– No need to copy files from the NPCI Portal for upload.

– No need to upload the file in .xls for reconciliation.

– Reduced file Processing time.

Conclusion

Presently we are processing all 44 files within one hour. The current volume processed by AnyRecon is around 4.5 to 5.0 lakhs records per day.

The Anyrecon Application has various reporting features which help users for analysis and reporting:

– BRS Report for account balance position.
– Transaction-wise status report.
– Response Code Wise Report (Rb Cases).
– Unmatched Transaction Report.
– Matched Transaction Report.