Steps to Check Reconciliation Reports

1.      Login to your Account.

2.     Under Reconciliation -> Payment reconciliation.

3.     Select the appropriate date range-> submit.

4.       On clicking submit, you will see the summary for each month which includes all the marketplaces which the seller has integrated with EasyEcom. The terms are explained below. 

Ø  Gross sales - Includes shipped invoices, completed returns but excludes canceled orders.

Ø  Net sales - Includes only shipped invoices(i.e, Net sales= Gross sales- total invoice amount of completed returns)

Ø  Completed Returns -The returns which the seller has received physically and confirms the same from EasyEcom panel.

Ø  Payment Received - It is the payment received for that particular month of orders till date.

Ø  Total Orders / Total invoices - It contains the total number of orders including completed returns but excludes canceled orders.

 

     

     5.       On clicking the particular month, break-ups will be shown Marketplace-Wise including five tabs i.e, Completed Returns, Pending Returns, Extra MP Deductions, Unsettled Orders and Cancelled orders.

    

Ø  Completed Returns  - The returns which the seller has received physically and confirms the same EasyEcom panel. Once the seller clicks on completed returns, there is an export button given at the left corner where you can export the list of completed returns for that particular month.

Ø  Pending Returns – There will be many statuses for returns( completed returns, return requested, return picked etc.)in the Marketplace. All these returns will be brought to EasyEcom as pending returns.

Ø  Extra MP Deductions – Marketplace will be deducting the amount from the sellers based on so many criteria’s like Commissions, Logistic charges, Payment gateway etc. So if the Marketplace is deducting more than what is supposed to be deducted, those orders will be shown under Extra MP Deduction. ( Sellers will avail this report only on updating the weights of each SKU’s, setting the rate card, setting the payment gateway, Updating Commissions which are explained in the Insert Product charges section)

Ø  Unsettled Orders – Three kinds of orders will be shown under Unsettled Orders.

           1) Those orders for which Marketplace has done any settlement yet.

           2) Those orders for which there are negative transactions( most of them will return orders) and if they are not entered as completed Returns.

           3) Those orders for which the settlement value is less than Minimum Payout Threshold. By default,

Minimum Payout threshold will be 10% on the invoice amount but the seller that change the value which is explained in Appendix.

Ø  Cancelled Orders – There will be two types of cancellations done in every marketplace. One will be canceled before the manifest is generated and the other one will be canceled after the generation of the manifest. We are showing only the first type of canceled order in this tab whereas the later one will be delivered back to the seller as returns.

     6.       Show Active Invoices – Will show all the orders excluding completed and canceled orders. Break-ups will also be shown by just clicking in the Invoice Number.

     

      

7.      Click on Export CSV will give you the whole reconciliation report which also contains the Marketplace deduction for each and every order.

• Related Articles

• Inventory Ledger Report / Inventory Reconciliation

  What is inventory ledger report ? The Inventory Ledger report is like a bank statement for a warehouse inventory. It provides end-to-end inventory reconciliation capability by showing your starting inventory balance, received Inventory, customer ...

• Generating Margin Reports (P/L Reports)

  Step 1:- In order to view the Margin report, please make sure that the cost price is updated for all your SKU. Step 2:- If Step 1 is completed, go to Reconciliation→ Margin Reports. Step 3:- On Margin reports page, select the date range, company ...

• MAssist – EasyEcom Go Live Steps

  To integrate EasyEcom with MAssist, please follow the following steps- Step 1- Navigate to the EasyEcom tab in your MAssist CRM dashboard. Step 2- Go to Settings>> Account configuration. Step 3- In the EasyEcom Username field, fill in your EasyEcom ...

• Outbound Quality Check (QC)

  What is Outbound QC? Outbound QC is a quality check process through which you can inspect every Unit before shipment to verify that each Unit complies. If any or all Units are not in compliance, you can immediately replace the non-conforming units ...

• Steps to set or update B2C and B2B Orders Invoice Series

  Steps to Set Invoice Series for B2C and B2B Orders Step 1: On the dashboard, click on the “Three dots aka meatball menu”   Step 2: Click on the “Account Settings” option Once you click on the meatball menu, you will see the following fly-out menu: ​ ...