Tata Cliq Marketplace Reconciliation using Order Management Data
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.