If a business wants to grow it has to keep track of all the transactions that happen. For this to happen a business has to reconcile its transactions from time to time. As it helps keep a track of the entire process of a transaction, from the placement of orders through the timely and accurate receipt of all payments. Reconciliation is essential to an e-commerce business because of this. As it requires a lot of time for data management, cleaning, and organization, reconciliation is a particularly challenging task. The Cointab system is the essential instrument in this situation. This difficult process is made easy by the system. It accurately reconciles and checks the data between the OMS System reports and the Limeroad reports. After reconciliation, a customer can easily review the results to see if either report includes any errors.
Reports needed for reconciliation
- Limeroad All Order Report
- Limeroad Sales Report
- Limeroad Payout Report
- Reports from the client’s OMS (e.g., Increff, Unicommerce, Easy Ecom.).
The process of reconciliation starts by linking the above reports to the client OMS reports using a common identifier. After this process the system cross-checks every order detail from the item amount, fees applicable to the payment received and fees actually charged.
The results are then displayed in an easy-to-read manner which is very easy to analyze and is all available on a single dashboard.
The result is as follows:
Limeroad – OMS Reconciliation
The system verifies each item of data stored in the client’s OMS system and matches it with the Limeroad Invoice report. The orders are then differentiated and highlighted as follows:
- Reconciled Orders
- The transactions where the order amounts are equal.
- Less Amount recorded in ERP
- Orders amounts of these transactions are lower in the OMS as compared to what is recorded in the Limeroad Sales report.
- More Amounts recorded in ERP
- Orders for which the amount in the OMS exceeds the amount in the Limeroad Sales report.
- Missing in Limeroad
- The orders which are not present in the Limeroad reports but are recorded in the OMS system.
OMS– Limeroad Reconciliation
The System verifies each piece of data provided in Limeroad reports and compares it with the client’s ERP. The orders are then identified and highlighted as follows:
- Reconciled with Limeroad
- These are the transactions where the order amounts are the same in both reports.
- Less Amount recorded in Limeroad
- Orders in which the Limeroad Report amount is less than the OMS report amount.
- More Amounts recorded in Limeroad
- The Orders recorded here have their amount in the Limeroad Report exceeding the amount that was recorded in the OMS report.
- Missing in Limeroad
- The transactions which are missing in the Limeroad reports but are recorded in the OMS system.
Companies will no longer be able to remain competitive and relevant with inadequate reconciliation. Today’s business environment is becoming increasingly complex. Accurate verification is necessary for fast and accurate decision-making. The best way to achieve this is through Cointab’s extensive reconciliation system.
