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

The reports provided by Amazon and the clients’ reports often have different item details. Given that these conflicts exist between these two reports. We  cross-check every piece of information in the client’s OMS system with Amazon reports, showing any contradictions that may exist. This aids the client’s efforts to manage the data more precisely and address any Amazon faults.

The Reports needed are:
  • All Order
  • MTR Reports (B2B & B2C)
  • Disbursement Report
  • All Return
  • FBA Return
  • Order Level Reimbursement Report 
  • SKU master
  • Bank Statement 
  • 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:
Amazon MTR Report vs Increff Order Management System Report

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

  • Reconciled Orders:
    • These are those orders whose amounts match.
  • Less Payment recorded in OMS
    • The orders whose amount in the OMS is less than the amount in the Amazon MTR report.
  • More Payment recorded in OMS
    • The orders whose amount in the OMS is more than the amount in the Amazon MTR report.
  • Not Recorded in OMS
    • The Orders which are present in the Amazon MTR report but not reported in the OMS.
Amazon Disbursement Report vs Increff Order Management System Report

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

  • Reconciled Orders:
    • These are those orders whose amounts match.
  • Less Payment recorded in OMS
    • The orders whose amount in the OMS is less than the amount in the Amazon Payment report.
  • More Payment recorded in OMS
    • The orders whose amount in the OMS is more than the amount in the Amazon Payment report.
  • Not Recorded in OMS
    • The Orders which are present in the Amazon payment report but not reported in the OMS.
Increff – Amazon Reconciliation

The System checks all the data recorded in Amazon’s MTR report 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 Amazon
    • The orders whose amount in the Amazon Payment report is less than the amount in the OMS
  • More Payment recorded in Amazon
    • The orders whose amount in the Amazon Payment report is more than the amount in the OMS
  • Not Recorded in Amazon

The orders whose amount is in the Amazon Payment report is not found in the OMS.

Get started with Cointab!

Related Post