This Reconciliation Process is done using the client’s OMS Database

Data from Tata Cliq and cliental OMS data can differ greatly. because there are discrepancies between the two reports. We calculate all the data from payments to charges and refunds, check it against the Tata Cliq Reports, and display the variances between the numbers. Clients can more easily distinguish between orders, as well as between payments and fee levies, thanks to this.

Reports needed for reconciliation:
  • Tata Cliq GST Report
  • Tata Cliq Sales Report
  • Tata Cliq Payment Report
  • Reports from the client’s order management system. (e.g., Increff, Unicommerce, Shopify, etc.).

Once the reports are taken and the reconciliation process is done the result is showcased in a very systematic format.

The Result is as follows:
Tata Cliq Settlement Report vs OMS Report

The System checks all the data recorded in the client’s order management system (OMS) and compares the data with the Tata Cliq Settlement (Invoice) report. It then differentiates the orders and highlights them as follows:

  • Reconciled Orders:
    • These are those orders whose amounts match.
  • Less Settlement recorded in OMS
    • The orders whose amount in the OMS is less than the amount in the Tata Cliq Settlement report.
  • More settlements recorded in OMS
    • The orders whose amount in the OMS is more than the amount in the Tata Cliq Settlement report.
  • Not Recorded in OMS
    • The Orders which are present in the Tata Cliq Settlement report but not reported in the OMS.
OMS Report – Tata Cliq Settlement Report

The System checks all the data recorded in Tata Cliq’s reports and compares the data with the client’s order management system (OMS). It then differentiates the orders and highlights them as follows:

  • Reconciled Orders:
    • These are those orders whose amounts match.
  • Less Payment recorded in Tata Cliq
    • The orders whose amount in the Tata Cliq Payment report is less than the amount in the OMS
  • More Payment recorded in Tata Cliq
    • The orders whose amount in the Tata Cliq Payment report is more than the amount in the OMS
  • Payment Not Received from Tata Cliq
    • The orders whose amount is in the Tata Cliq Payment report but are not found in the OMS.

Related Post