Indian Railway Catering and Tourism Corporation (IRCTC) is an Indian public sector undertaking that provides ticketing, catering, and tourism services for the Indian Railways. For a business that helps customers book train tickets, it is necessary to be able to keep a track of every transaction and to make sure that all payments, refunds, and cancellations are accurately recorded. Doing so is a tedious task as it requires spending laborious hours on cleaning and extracting data from every report. The number of transactions daily is so vast that it is close to impossible to do such a task manually. This is where the software made by Cointab comes into the picture. Cointab does the Reconciliation of website orders with IRCTC in a seamless manner. The software offers the feature of automation with which loading data can be done automatically, and reconciliation can be scheduled. The software then cleans and extracts this data quickly to make reconciliation easy. The data is then linked and verified as needed and the results are produced in a very easy-to-analyze format. This result can be exported in any format and can be used to raise disputes if any.
Reports needed for reconciliation are:
All the train bookings are present in this report with each and every detail.
In the instance of a train booking being canceled, every detail of this canceled order is recorded in this report.
For every cancellation, the transaction that is in the process of refund is recorded here.
For a Business doing the bookings, all the train bookings and cancellations via the client company are present in this report.
The reconciliation process is done by linking all these reports to match and verify the bookings, cancellations, payments, and refunds. This is done so the client company can keep an accurate track of every transaction and the entire summary to make sure it avoids any unnecessary loss.
When the data in the IRCTC report matches the data in the Internal report it is reconciled.
Payments recorded in the IRCTC report are less than the payments recorded in the Internal report.
The IRCTC report recorded payments more than what is recorded in the internal report.
Data in the IRCTC reports are matching the data in the internal booking reports.
The amount in the internal train bookings is less than the amount in the IRCTC reports.
The internal train bookings report recorded a higher amount than the IRCT reports.
The IRCTC refunds are matching the refunds in the Internal report.
The refund given by the IRCTC is less than the refund expected in the internal report.
When the refund given by IRCTC is more than the refund expected by the internal report.
The data recorded in the internal cancellation report matches the data in the IRCTC report.
The amount in the internal cancellation report is less than what is recorded in the IRCTC report.
When the amount in the internal cancellation report is more than what is recorded in the IRCTC report
Observing the above results, we can see how easily the software does the reconciliation of website orders with IRCTC. The software automatically loads data and the data can be in any format, due to this a business can save a lot of time on manual effort. The software cleans and extracts the data and then links the data using configured logic. The results as shown above are very easy to read and the labels are customizable. Since the results are all displayed on a universal dashboard it makes analysis very easy and then the same can be downloaded in any format. These results can be used to raise disputes in case a business is suffering losses due to any errors by IRCTC. This can help a business keep accurate track of all the transactions while saving time and money.